MySQL memory and CPU optimization related parameters

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) #多核CPUinnodb_read_io_threadsinnodb_wr ite_io_threads# memory buffer pool hit ratio =innodb_buffer_pool_read_requests/(Innodb_buffer_pool_read_requests+innodb_buffer_pool_ Read_ahead+innodb_buffer_pool_reads) The average number of bytes per read Innodb_data_read/innOdb_data_readsinnodb_data_reads: Indicates the number of pages read from the physical disk Innodb_buffer_pool_read_ahead: number of read-ahead Innodb_buffer_pool_read_ahead_ Evicted: Read-ahead page, but the number of pages that have been replaced from the buffer pool without being read, is generally used to determine the frequency of read-ahead Innodb_buffer_pool_read_requests: The number of pages read from the buffer pool Innodb_data_ READ: Total number of bytes read innodb_data_reads: Number of times the read request was initiated, each read may require multiple pages to be read

　　

MySQL memory and CPU optimization related parameters