Mysql慢查询配置

//慢查询时间阈值
> show variables like '%long_query_time%';

//查看慢查询配置情况
> show status like '%slow_queries%';

// 查看慢日志路径
> show variables like '%slow%';

> set global slow_query_log=On;
> set global long_query_time=1; //设置查看时间超过1秒的查询被记录到日志
> select sleep(10)

> mysqldumpslow -s c -t 10  /var/lib/mysql/ap1azrap472-slow.log

> mysqldumpslow -s r -t 10 /var/lib/mysql/ap1azrap472-slow.log

> mysqldumpslow -s t -t 10 -g 'left join' /var/lib/mysql/ap1azrap472-slow.log

> vim /etc/my.cnf

[mysqld]
slow_query_log=On
slow_query_log_file=/var/log/mysql/slow.log
# 单位是秒
long_query_time=2 

> service mysqld restart