mysql 性能排查_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';