MYSQLÒѾ­ÉúЧµÄÉèÖúÍ״̬²éѯÃüÁî

ÒÔÏÂÃüÁî¿ÉÒÔÔÚÈκÎÒѾ­Á¬½ÓÉÏMYSQL·þÎñÆ÷µÄ¿Í»§¶ËÉÏÖ´ÐС£
show full processlist ;
kill 57725;#ɱµôÉÏÃæ²éµ½µÄij¸öµ¼ÖÂ×èÈûµÄÁ¬½Ó
SELECT @@profiling;
SET profiling = 1;
SHOW PROFILES;
SHOW PROFILE for QUERY 1;
#ϵͳÉèÖÃ
show variables like '%key%';
show variables like '%key%';
show variables like '%max%';
show variables like '%char%';
show variables like '%coll%';
show variables like '%buffer%';
#ÔËÐÐ״̬
show status like '%thread%';
show status like 'Qcache%';
show status like 'Open%tables';
show status like '%lock%';
show status like '%key%';
show status like '%buffer%';
show global status ;
show master status;
show slave status;
show slave hosts;
show binlog events;