mysql cpu参数_MySQL 内存和CPU优化相关的参数

mysql> SHOW GLOBAL STATUS LIKE 'innodb%read%';

+---------------------------------------+---------+

| Variable_name | Value |

+---------------------------------------+---------+

| Innodb_buffer_pool_read_ahead_rnd | 0 |

| Innodb_buffer_pool_read_ahead | 0 |

| Innodb_buffer_pool_read_ahead_evicted | 0 |

| Innodb_buffer_pool_read_requests | 612 |

| Innodb_buffer_pool_reads | 179 |

| Innodb_data_pending_reads | 0 |

| Innodb_data_read | 5115904 |

| Innodb_data_reads | 189 |

| Innodb_pages_read | 178 |

| Innodb_rows_read | 0 |

+---------------------------------------+---------+

10 rows in set (0.00 sec)

#多核CPU

innodb_read_io_threads

innodb_write_io_threads

#内存

缓冲池命中率=

Innodb_buffer_pool_read_requests/(

Innodb_buffer_pool_read_requests+Innodb_buffer_pool_read_ahead+Innodb_buffer_pool_reads)

平均每次读取字节数

Innodb_data_read/Innodb_data_reads

Innodb_data_reads:表示从物理磁盘读取页的次数

Innodb_buffer_pool_read_ahead：预读的次数

Innodb_buffer_pool_read_ahead_evicted：预读的页，但是没有被读取就从缓冲池中被替换的页的数量，一般用来判断预读的频率

Innodb_buffer_pool_read_requests：从缓冲池中读取页的次数

Innodb_data_read：一共读取的字节数

Innodb_data_reads：发起读取请求的次数，每次读取可能需要读取多个页