1、获取慢日志的信息
2、复制慢日志的路径,在C盘中搜索
3、慢日志分析
# Time: 2019-08-01T01:52:44.249356Z
# User@Host: root[root] @ localhost [127.0.0.1] Id: 4043
# Query_time: 11.743046 Lock_time: 0.000049 Rows_sent: 240000 Rows_examined: 240000
use ds_6;
SET timestamp=1564624364;
SELECT * FROM `ue_rsrp_1`;
# Time: 2019-08-01T01:53:43.952697Z
# User@Host: root[root] @ localhost [127.0.0.1] Id: 4046
# Query_time: 12.103581 Lock_time: 0.000051 Rows_sent: 240000 Rows_examined: 240000
SET timestamp=1564624423;
SELECT * FROM `ue_snr_1`;
4、可以看到用户、查询时间、和查询的SQL语句。这样我们可以针对性的处理导致查询慢的原因。