Hexo

PHP安装voyager基础项目 测试安装的环境为PHP 7.2.6+MySQL 5.7.22 PHP环境安装1234567# 下载PHP的安装包(zip版),PHP版本要7以上# 在环境变量中加入PHP的环境变量# 下载安装composer# 在php.ini打开pdo和fileinfo和GD的扩展extension=fileinfoextension=pdo_mysqlextensio... 阅读全文…

SQL编码优化单条记录查询优化1LIMIT 0,1 NOT EXIST 和 NOT IN 优化12# NOT IN 和 NOT EXIST在SQL查询中性能比较差,可以用LEFT JOIN链接两个表,然后通过IS NOT NULL获取值mysql> SELECT SP.permissionId, permissionName FROM system_permission SP LEFT... 阅读全文…

SpringBoot IDEA热部署pom.xml的dependency123456<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-devtools</artifactId> <!--<scope... 阅读全文…

Tomcat项目简单部署Tomcat安装12345678# 解压安装 jdk, tomcat, 配置环境变量shell> tar zxvf jdk-VERSION-linux-x64.tar.gz -C /usr/local/shell> ln -s /usr/local/jdkVERSION /usr/local/javashell> tar zxvf apache-to... 阅读全文…

Python Registry文件代码12345678910111213141516171819202122232425262728293031323334353637383940import sys from _winreg import * # tweak as necessaryversion = sys.version[:3]installpath = sys.prefix r... 阅读全文…

Redis InstallRedis Install1234567891011121314# 上传redis安装包shell> tar zxvf redis-4.0.5.tar.gz -C /usr/local/shell> cd /usr/localshell> ln -s /usr/local/redis-4.0.5/ /usr/local/redisshell>... 阅读全文…

php-laravel-project-deploy系统环境123System: Linux CentOS 6.9 x86_64DB: MySQL 5.7, MongoDB 3.4EVN: nignx, PHP MySQL数据库环境安装1234567891011121314151617181920212223# 上传或者下载MySQL程序包shell> tar zxvf mysql-V... 阅读全文…

MySQL常用状态查看查看本次MySQL服务运行时间(单位:秒)1mysql> show status like 'uptime'; 查看SELECT执行次数1mysql> show [global] status like 'com_select'; 查看INSERT执行次数1mysql> show [global] status like 'com_insert'; 查... 阅读全文…

nginx log segmentation 正常安装nginx服务 编写脚本12345678910111213LOGS_PATH="/home/log/nginx/logs"ARCHIVE_YEAR=$(date -d "yesterday" "+%Y")ARCHIVE_MONTH=$(date -d "yesterday" "+%m")if [ -r /opt/nginx/nginx.... 阅读全文…

simple-vsftpdvsftpd安装123456shell> yum install vsftpd -yshell> chkconfig vsftpd onshell> vi /etc/vsftpd/vsftpd.conf # 修改配置如下shell> useradd -d /home/ftp -s /sbin/nologin ftpusershell> ... 阅读全文…