立即学习:https://edu.csdn.net/course/play/27328/362514?utm_source=blogtoedu
增删改只要响应慢也会存在慢查询日志中
查看是否开启慢查询日志:
show variables like 'slow%';
+---------------------+--------------------------+
| Variable_name | Value |
+---------------------+--------------------------+
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_log_file | DESKTOP-D6D37DM-slow.log |
+---------------------+--------------------------+
开启慢查询日志:
set global slow_query_log='ON';
查看阈值(默认10S):
show variables like '%long%';
改成1S;
set long_query_time=1;
慢查询日志文件所在位置:
show variables like '%datadir%';
+---------------+---------------------------------------------+
| Variable_name | Value |
+---------------+---------------------------------------------+
| datadir | C:\ProgramData\MySQL\MySQL Server 8.0\Data\ |
+---------------+---------------------------------------------+