MySQL慢查询优化_MySQL慢查询排查_MySQL慢查询设置配置

引言

MySQL慢查询使用之查看慢查询相关参数

show variables like 'slow_query%';

mysql> show variables like 'slow_query%';
+---------------------------+----------------------------------+
| Variable_name             | Value                            |
+---------------------------+----------------------------------+
| slow_query_log            | OFF                              |
| slow_query_log_file       | /mysql/data/localhost-slow.log   |
+---------------------------+----------------------------------+

mysql> show variables like 'long_query_time';
+-----------------+-----------+
| Variable_name   | Value     |
+-----------------+-----------+
| long_query_time | 10.000000 |
+-----------------+-----------+

MySQL慢查询使用之配置相关参数

#设置日志存放路径
set global slow_query_log_file='/usr/local/mysql/data/slow.log';
#设置启用（ON）/停用日志（OFF）
set global slow_query_log='ON'; 
#设置慢查询阈值时间；下面是超过1秒就记录
set global long_query_time=1;

[mysqld]
slow_query_log = ON
slow_query_log_file = /usr/local/mysql/data/slow.log
long_query_time = 1

select sleep(2);

cat /usr/local/mysql/data/slow.log

mysql mysql调优

https://blog.xqlee.com/article/358.html