Mysql InnoDB 7 Large threads with 3 large memory in the background

A: a master thread (InnoDB almost all functions on this thread)

B: A lock monitoring thread

C: An error monitoring thread

D: Four IO threads (insert buffer thread\log thread\write thread\read thread)

The number of IO threads can be increased by the Innodb_file_io_threads parameter under the Windows platform. But it's also outdated.

We can now pass Innodb_read_io_threads | Innodb_write_io_threads to control the number of IO threads.

-----------------------------------------------------------------------------------------

Memory:

A:

Buffer pool, the most memory part, used to store various data cache (index page, data page, undo page, insert buffer, Adaptive Hash Index, lock information)

INNODB_BUFFER_POOL_SIZE Specifies the size of the buffer pool.

The AWE feature can be turned on under the 32-bit system INNODB_BUFFER_POOL_AWE_MEM_MB. However, the Adaptive hash index is automatically disabled once the AWE system is turned on.

B:

Redo the log buffer pool (redo log buffer), log buffering puts the redo log information into the buffer and then flushes it to the Redo log file at a certain frequency. This value is generally not set to a large

Because the redo log buffers are flushed to the log file every second, we only have to ensure that the amount of transactions generated per second is within this buffer size.

C: Additional memory pool (additional)

　　

Mysql InnoDB 7 Large threads with 3 large memory in the background