SHOW OPEN TABLES WHERE In_use > 0; SHOW FULL PROCESSLIST; KILL 53678; USE table1; SET profiling = 1; SHOW PROFILES; SET profiling = 0; SHOW TABLES; SHOW PROFILES; SHOW PROFILE FOR QUERY 188; SHOW PROFILE block io,cpu FOR QUERY 2; SELECT VERSION(); SHOW VARIABLES LIKE ‘%pro%‘; SELECT @@profiling;
原文：http://www.cnblogs.com/xachary/p/4253262.html