mysql简单性能排查

 

mysql> show variables;  

mysql> show processlist;

mysql> show status;

mysql> show global status;

mysql> show variables like '%slow%';

mysql> show global status like '%slow%';

mysql> show status like 'Slow_queries';

mysql> show status like 'Threads_created'; 

mysql> show engine innodb status\G; 

mysql> show global status like 'table_locks%';

mysql> show status like '%lock%'; 

===================================

mysql> show global status like 'open_files';  

mysql> show variables like 'open_files_limit';  

mysql> show status like 'key%';

mysql> show status like 'innodb_buffer_pool_read%';

==================================

mysql> show status like 'Slave_running';

mysql> show status like 'Threads_connected';

mysql> show status like 'Threads_running';

mysql> show status like 'Aborted_clients';

mysql> show status like 'Questions';

mysql> show status like 'Handler_%';

mysql> show status like 'Opened_tables';

mysql> show status like 'Select_full_join';

mysql> show status like 'Create_tmp%';

mysql> show status like 'Binlog_cache%';

mysql> show status like 'innodb_log_waits';