mysql常用命令

SHOW ENGINE INNODB STATUS; 

SHOW VARIABLES LIKE 'key_buffer_size';

SHOW FULL PROCESSLIST;

SELECT * FROM `information_schema`.`PROCESSLIST` WHERE command='Query';