/opt/homebrew/etc/my.cnf.d/charset.cnf[mysqld] # 基础设置 character-set-server = utf8mb4 collation-server = utf8mb4_general_ci # 关...

阅读全文...

查询执行时间超长的进程SELECT * FROM information_schema.PROCESSLIST WHERE command != 'Sleep' ORDER BY time DESC列出要结束的进程select concat('kill ...

阅读全文...

删除指定目录下N天以前的日志文件find /path -name "*.log" -type f -mtime +210 -exec rm -f {} \;

阅读全文...

#!/bin/bash #登录账号 user=`whoami` #运行环境 env="debug"; if [[ $user = "root" ]]; then echo $user; env=&q...

阅读全文...

统计指定URL访问次数awk '$7 ~ "/url"' file.log | wc -l统计指定状态码次数awk '$9 == "404"' file.log | wc -l最大并发量awk '{ print $...

阅读全文...