----------------------------------------------------------------------------------------------------------------
1
#开启慢查询日志
#MySQL8.0 默认关闭
slow_query_log=on
重启mysql服务
service mysql restart
show variables like '%slow%';
+---------------------------+------------------------------------+
| Variable_name | Value |
+---------------------------+------------------------------------+
| log_slow_admin_statements | OFF |
| log_slow_slave_statements | OFF |
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_log_file | /var/lib/mysql/LoSingSang-slow.log |
+---------------------------+------------------------------------+
5 rows in set (0.02 sec)
pt-query-digest --since=24h /var/lib/mysql/LoSingSang-slow.log > query.log
----------------------------------------------------------------------------------------------------------------