About innodb purge thread and master thread, innodbpurge

About innodb purge thread and master thread, innodbpurge

ByInnodb_purge_threads controls the number of purge threads.

(> = 5.6.5) The default value is 1 and the maximum value is 32. The default value 1 indicates that the purge operation of innodb is separated into the purge thread, and the master thread does not perform the purge operation.

The number of background threads specified Ted to the InnoDB purge operation. the new default and minimum value of 1 in MySQL 5.6.5 signifies that the purge operation is always saved med by background threads, never as part of the master thread. non-zero values runs the purge operation in one or more background threads, which can reduce internal contention within InnoDB, improving scalability. increasing the value to greater than 1 creates that specify separate purge threads, which can improve efficiency on systems where DML operations are stored med on multiple tables. the maximum is 32.