mysql 当前运行状态分析
mysql> show status;
+-----------------------------------+------------+
| Variable_name | Value |
+-----------------------------------+------------+
| Aborted_clients | 0 | 
| Aborted_connects | 0 | 
| Binlog_cache_disk_use | 0 | 
| Binlog_cache_use | 0 | 
| Bytes_received | 93 | 
| Bytes_sent | 216 | 
| 
| 
|
| Compression | OFF | 
| Connections | 28478 | 
| Created_tmp_disk_tables | 0 | 
| Created_tmp_files | 5 | 
| Created_tmp_tables | 2 | 
| Delayed_errors | 0 | 
| Delayed_insert_threads | 0 | 
| Delayed_writes | 0 | 
| Flush_commands | 1 | 
| Handler_commit | 0 | 
| Handler_delete | 0 | 
| Handler_discover | 0 | 
| Handler_prepare | 0 | 
| Handler_read_first | 0 | 
| Handler_read_key | 0 | 
| Handler_read_next | 0 | 
| Handler_read_prev | 0 | 
| Handler_read_rnd | 0 | 
| Handler_read_rnd_next | 2 | 
| Handler_rollback | 0 | 
| Handler_savepoint | 0 | 
| Handler_savepoint_rollback | 0 | 
| Handler_update | 0 | 
| Handler_write | 131 | 
| Innodb_buffer_pool_pages_data | 1151 | 
| Innodb_buffer_pool_pages_dirty | 0 | 
| Innodb_buffer_pool_pages_flushed | 243639 | 
| Innodb_buffer_pool_pages_free | 890 | 
| Innodb_buffer_pool_pages_latched | 0 | 
| Innodb_buffer_pool_pages_misc | 7 | 
| Innodb_buffer_pool_pages_total | 2048 | 
| Innodb_buffer_pool_read_ahead_rnd | 2 | 
| Innodb_buffer_pool_read_ahead_seq | 0 | 
| Innodb_buffer_pool_read_requests | 17667654 | 
| Innodb_buffer_pool_reads | 925 | 
| Innodb_buffer_pool_wait_free | 0 | 
| Innodb_buffer_pool_write_requests | 6318397 | 
| Innodb_data_fsyncs | 187115 | 
| Innodb_data_pending_fsyncs | 0 | 
| Innodb_data_pending_reads | 0 | 
| Innodb_data_pending_writes | 0 | 
| Innodb_data_read | 18386944 | 
| Innodb_data_reads | 945 | 
| Innodb_data_writes | 358325 | 
| Innodb_data_written | 4058085376 | 
| Innodb_dblwr_pages_written | 243639 | 
| Innodb_dblwr_writes | 10994 | 
| Innodb_log_waits | 0 | 
| Innodb_log_write_requests | 612186 | 
| Innodb_log_writes | 158006 | 
| Innodb_os_log_fsyncs | 165043 | 
| Innodb_os_log_pending_fsyncs | 0 | 
| Innodb_os_log_pending_writes | 0 | 
| Innodb_os_log_written