mysql开启慢日志查询slow.log

加入mysql ```bash mysql -h127.0.0.1 -uroot -p ``` 查询状态 ```bash mysql> show variables like 'slow%'; ``` 可以看到日志状态是关闭的 (`slow_query_log=OFF`)，同时我们还可以看到日志保存的文件路径 ```bash +---------------------+-------------------------------+ | Variable_name | Value | +---------------------+-------------------------------+ | slow_launch_time | 2 | -- 超时时间 | slow_query_log | OFF | -- NO=开启，OFF=关闭 | slow_query_log_file | /var/log/mysql/mysql-slow.log | -- 日志路径 +---------------------+-------------------------------+ 3 rows in set (0.00 sec) ``` `开启` ```bash mysql> set global slow_query_log=ON; Query OK, 0 rows affected (0.00 sec) ``` 再次查询状态 ```bash mysql> show variables like 'slow%'; +---------------------+-------------------------------+ | Variable_name | Value | +---------------------+-------------------------------+ | slow_launch_time | 2 | | slow_query_log | ON | | slow_query_log_file | /var/log/mysql/mysql-slow.log | +---------------------+-------------------------------+ 3 rows in set (0.00 sec) ``` 监控日志 ```bash tail -f /var/log/mysql/mysql-slow.log ```