PDF (US Ltr)
- 0.9Mb
18.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 18-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 18-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 18-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 18-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
|
Parent topic: Configuration