PDF (US Ltr)
- 0.9Mb
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:
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 > 0
|
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 > 0
|
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 > 0
|
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 > 0
|
16
|
temptable_max_ram
|
1073741824
|
thread_pool_size
|
32
|