15.8 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.

Note:

innodb_parallel_read_threads is also a session variable. See: Session Variables.

Table 15-15 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 > 0	4
temptable_max_ram	1073741824
thread_pool_size	8

Table 15-16 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 > 0	8
temptable_max_ram	1073741824
thread_pool_size	16

Table 15-17 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 > 0	16
temptable_max_ram	2147483648
thread_pool_size	32

Table 15-18 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 > 0	16
temptable_max_ram	1073741824
thread_pool_size	32