查询执行时间超长的进程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 $...

阅读全文...

SELECT id,field1,COUNT(field2) as total FROM table_name GROUP BY field1 HAVING total > 1

阅读全文...