2开启慢日志配置输出php-fpm慢日志,阀值为2秒:request_slowlog_timeout = 2slowlog = log/$pool.log.slow利用sort/uniq命令分析汇总php-fpm慢日志:[[email protected] log]# grep -v "^$" www.log.slow.tmp | cut -d " " -f 3,2 | sort | uniq -c | sort -k1,1nr | head -n 505181 run() /www/test.net/framework/web/filters/CFilter.php:415156 filter() /www/test.net/framework/web/filters/CFilterChain.php:1312670 = /www/test.net/index.php2636 run() /www/test.net/application/controllers/survey/index.php:6652630 action() /www/test.net/application/controllers/survey/index.php:182625 run() /www/test.net/framework/web/actions/CAction.php:752605 runWithParams() /www/test.net/framework/web/CController.php:3092604 runAction() /www/test.net/framework/web/filters/CFilterChain.php:1342538 run() /www/test.net/framework/web/CController.php:2922484 runActionWithFilters() /www/test.net/framework/web/CController.php:2662251 run() /www/test.net/framework/web/CWebApplication.php:2761799 translate() /www/test.net/application/libraries/Limesurvey_lang.php:1181786 load_tables() /www/test.net/application/third_party/php-gettext/gettext.php:2541447 runController() /www/test.net/framework/web/CWebApplication.php:135参数解释:sort: 对单词进行排序uniq -c: 显示唯一的行,并在每行行首加上本行在文件中出现的次数sort -k1,1nr: 按照第一个字段,数值排序,且为逆序head -10: 取前10行数据
php怎么检测慢查询,PHP慢日子查询
最新推荐文章于 2021-09-26 20:58:29 发布