mysql慢查询

1.查看是否开启慢查询
#show variables like “%slow_query%”;

2.开启慢查询
vi /etc/my.cnf
slow_query_log = ON
slow_query_log_file = /var/lib/mysql/mysql_slow.log
long_query_time = 2

systemctl restart mysqld

3.查看慢查询信息
*慢查询次数
show status like ‘slow_quer%’;

*慢查询日志
#mysqldumpslow
Reading mysql slow query log from /var/lib/mysql/slow.log

Count: 1 Time=4.06s (4s) Lock=0.00s (0s) Rows_sent=1413647.0 (1413647), Rows_examined=1413647.0 (1413647), root[root]@localhost
select * from TBL_*****_20191107