Linux,查看mysql执行sql时资源占用

打开profiling 功能:set profiling = 1;
执行要分析的sql;

show profiles;  
SHOW profile CPU,BLOCK IO io FOR query Query_ID;  

当前查询

show processlist;  

所有

show full processlist;  

Grizzly

Never say never!