thread_pool_sched_affinity_log_writer

Support CLI: Yes

Support configuration file: Yes

Support dynamic modification: Yes

Scope: global

Parameter type: string

Default: empty value, indicating that this type of threads is scheduled by the OS, that is, this parameter is not used.

Possible values: empty value, or a character string consisting of digits representing core IDs. Core IDs can be separated by commas (,) and the value range can be represented by a minus sign (-).

For example, the following lists valid values of CPU cores:

• Empty value
• 5
• 0,5,7
• 0,2-5,7

This parameter is used to specify the CPU cores available to the MySQL log_writer thread. You are advised to bind background threads to cores of the same NUMA node.