1、提前准备好目录
mkdir /usr/yuri/mysql/log/
vim slow.log
chmod 777 /usr/yuri/mysql/log/* //设置读写权限,否在下面会没权限
2、开启
show variables like 'slow_query_log%';
set global slow_query_log='ON';
set global slow_query_log_file='/usr/yuri/mysql/log/slow.log';
set global slow_query_log=1 // 记录超过1s的sql
3、测试
sql:
> SELECT SLEEP(5)
日志:
# Time: 2020-03-07T00:36:04.930785Z
# User@Host: root[root] @ [114.102.184.144] Id: 287
# Query_time: 5.000241 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
SET timestamp=1583541364;
SELECT SLEEP(5);
4、成功!