进入mysql控制台,使用命令查看慢sql,进行定位分析:
image.png
set profiling=1;
show profiles;
use test;
select * from a;
show profiles;
show profile for query 2;
进入mysql控制台,使用命令查看慢sql,进行定位分析:
set profiling=1;
show profiles;
use test;
select * from a;
show profiles;
show profile for query 2;
本文标题:mysql慢查询 --- 2021-10-28
本文链接:https://www.haomeiwen.com/subject/aaamaltx.html
网友评论