13.5 Shape Dependent System Variables

Shape dependent global system variables are linked to, and tuned for, a specific MySQL shape. See Supported Shapes. It is not possible to edit them.

innodb_parallel_read_threads is also a session variable. See: Section 13.6, “Session Variables”.

Table 13.10 MySQL.2.16GB Global System Variables

Name	Default Value
back_log	1000
innodb_page_cleaners	4
innodb_parallel_read_threads	1
innodb_read_io_threads	1
innodb_redo_log_capacity	2
replica_parallel_workers	4
temptable_max_ram	1073741824
thread_pool_size	8

Table 13.11 MySQL.4.32GB Global System Variables

Name	Default Value
back_log	2000
innodb_page_cleaners	4
innodb_parallel_read_threads	2
innodb_read_io_threads	2
innodb_redo_log_capacity	4
replica_parallel_workers	8
temptable_max_ram	1073741824
thread_pool_size	16

Table 13.12 MySQL.8.64GB Global System Variables

Name	Default Value
back_log	4000
innodb_page_cleaners	4
innodb_parallel_read_threads	4
innodb_read_io_threads	4
innodb_redo_log_capacity	8
replica_parallel_workers	16
temptable_max_ram	2147483648
thread_pool_size	32

Table 13.13 MySQL.32.256GB Global System Variables

Name	Default Value
back_log	2000
innodb_page_cleaners	8
innodb_parallel_read_threads	32
innodb_read_io_threads	2
innodb_redo_log_capacity	8
replica_parallel_workers	16
temptable_max_ram	1073741824
thread_pool_size	32