mysql 开启慢日志查询

mysql 开启慢日志查询

查看慢日志是否开启
mysql> show variables like 'slow_query_log';
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| slow_query_log | OFF   |
+----------------+-------+
1 row in set (0.00 sec)
2.  查看需要开启的配置参数 
mysql> show variables like '%log%';
| log_queries_not_using_indexes           | ON                                 |
| slow_query_log_file                     |/var/lib/mysql/mysql-host-slow.log |
| slow_query_log                             | ON    

设置参数查询一秒以上的查询 
mysql> set global long_query_time=1;
开启慢日志查询
mysql> set global log_queries_not_using_indexes=on;
mysql> set global slow_query_log=on;
慢查询的日志位置
| slow_query_log_file                     |/var/lib/mysql/mysql-host-slow.log |
3. 复制会话 查看 信息
root@99c29b69a52d:/# more /var/lib/mysql/99c29b69a52d-slow.log 
注意在 docker 环境下 需要先进去 mysql     
[root@iZbp12y6fwj9mtmywtpwddZ ~]# docker exec -it  e_mysql /bin/bash 

[root@mysql_data]# mysqldumpslow slow-query.log
Reading mysql slow query log fromslow-query.log
Count: 2 Time=11.00s (22s) Lock=0.00s (0s)Rows=1.0 (2), root[root]@mysql
select count(N) from t_user;