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';