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 |
+-----------------------------------+---------------+
那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 |
+-----------------------------------+---------------+
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货