打开profiling 功能:set profiling = 1;
执行要分析的sql;
show profiles;
SHOW profile CPU,BLOCK IO io FOR query Query_ID;
当前查询
show processlist;
所有
show full processlist;
打开profiling 功能:set profiling = 1;
执行要分析的sql;
show profiles;
SHOW profile CPU,BLOCK IO io FOR query Query_ID;
当前查询
show processlist;
所有
show full processlist;