1.key_buffer_size只对MyISAM
那innodb_buffer_pool_size是否就是只对innodb2.key_reads / key_read_requests应该尽可能的低,可以通过调整key_buffer_size来控制
那innodb的中是否也有innodb_buffer_pool_size大小的判断标准?用这两个?
| Innodb_buffer_pool_read_requests  | 8711714742    | 
| Innodb_buffer_pool_reads          | 458175238     | 3.如下是我db的status哪位大虾帮忙指点一二。16G内存
mysql> SHOW STATUS like '%Innodb%';
+-----------------------------------+---------------+
| Variable_name                     | Value         |
+-----------------------------------+---------------+
| Innodb_buffer_pool_pages_data     | 64978         | 
| Innodb_buffer_pool_pages_dirty    | 2844          | 
| Innodb_buffer_pool_pages_flushed  | 161851994     | 
| Innodb_buffer_pool_pages_free     | 0             | 
| Innodb_buffer_pool_pages_latched  | 0             | 
| Innodb_buffer_pool_pages_misc     | 558           | 
| Innodb_buffer_pool_pages_total    | 65536         | 
| Innodb_buffer_pool_read_ahead_rnd | 125426        | 
| Innodb_buffer_pool_read_ahead_seq | 63181         | 
| Innodb_buffer_pool_read_requests  | 8711714742    | 
| Innodb_buffer_pool_reads          | 458175238     | 
| Innodb_buffer_pool_wait_free      | 0             | 
| Innodb_buffer_pool_write_requests | 1759428315    | 
| Innodb_data_fsyncs                | 366689802     | 
| Innodb_data_pending_fsyncs        | 0             | 
| Innodb_data_pending_reads         | 0             | 
| Innodb_data_pending_writes        | 0             | 
| Innodb_data_read                  | 7728660008960 | 
| Innodb_data_reads                 | 465394712     | 
| Innodb_data_writes                | 510469454     | 
| Innodb_data_written               | 5621915930112 | 
| Innodb_dblwr_pages_written        | 161851994     | 
| Innodb_dblwr_writes               | 1867752       | 
| Innodb_log_waits                  | 51            | 
| Innodb_log_write_requests         | 311328059     | 
| Innodb_log_writes                 | 360866519     | 
| Innodb_os_log_fsyncs              | 361520093     | 
| Innodb_os_log_pending_fsyncs      | 0             | 
| Innodb_os_log_pending_writes      | 0             | 
| Innodb_os_log_written             | 318094263296  | 
| Innodb_page_size                  | 16384         | 
| Innodb_pages_created              | 1277152       | 
| Innodb_pages_read                 | 471720087     | 
| Innodb_pages_written              | 161851994     | 
| Innodb_row_lock_current_waits     | 0             | 
| Innodb_row_lock_time              | 8314948       | 
| Innodb_row_lock_time_avg          | 107           | 
| Innodb_row_lock_time_max          | 20302         | 
| Innodb_row_lock_waits             | 77212         | 
| Innodb_rows_deleted               | 11474319      | 
| Innodb_rows_inserted              | 52557765      | 
| Innodb_rows_read                  | 1500887238    | 
| Innodb_rows_updated               | 130660860     | 
+-----------------------------------+---------------+