首页 > 代码库 > MySql 跟踪命令

MySql 跟踪命令

 

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;

 

MySql 跟踪命令