PDF (US Ltr)
- 1.2Mb
PDF (A4)
- 1.2Mb
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 |