MySQL worry parameter

The following parameters are used in mysql-5.6.27, and may not be the same as the MySQL version.

1. Thread Parameters

Innodb_read_io_threads=6--INNODB Storage Engine reads the number of threads for the client to read data, the default value is 4

Innodb_read_io_threads=7--innodb The number of write threads for the storage engine for the client to write data to, the default value is 4

innodb_purge_threads=2--innodb Storage Engine recycles purge page thread, empties dirty data, default value is 1

2. Buffer pool Parameters

INNODB_BUFFER_POOL_SIZE=2G--innodb Storage Engine buffer pool includes data page, index page, insert buffer, adaptive ha Index, data dictionary, lock information. MyISAM cache only index files. The default value is 134217728 bytes (128M).

Innodb_buffer_pool_instances=8--innodb buffer pool number, used in conjunction with Innodb_buffer_pool_size

INNODB_OLD_BLOCKS_PCT=37--Using the LRU (least recent algorithm) algorithm to calculate the buffer pool, the buffer pool front 63% is the most active data, 63% is the historical data, the most active data hit ratio is high.

INNODB_OLD_BLOCKS_TIME=100--100s is added to the most active buffer pool after data is read

innodb_log_buffer_size=8m-Redo Log buffer size, should not be set too large, master thread is synchronized to disk per second, the thing commits to disk, redo log space remaining 1/2 is also synchronized to disk, the default is 8M

This article is from the "Days Together" blog, please be sure to keep this source http://tongcheng.blog.51cto.com/6214144/1710265

MySQL worry parameter