11.3 Shape-Dependent Global System Variables

Shape-dependent global system variables are linked to, and tuned for, a specific MySQL shape. Global system variables cannot be modified. For information about shapes, see Supported Shapes.

Table 11.2 Shape-Dependent Global System Variables

Variable Name	Default Value
back_log	Dependent on shape. The default values per shape are: MySQL.2.16GB - 1000 MySQL.4.32GB - 2000 MySQL.8.64GB - 4000 MySQL.32.256GB - 2000
innodb_buffer_pool_size	Dependent on the amount of RAM provisioned by the shape. The default values are: MySQL.2.16GB - 5368709120 (5GB) MySQL.4.32GB - 10737418240 (10 GB) MySQL.8.64GB - 30064771072 (28 GB) MySQL.32.256GB - 21474836480 (20 GB)
innodb_log_files_in_group	Dependent on shape. The default values per shape are: MySQL.2.16GB - 2 MySQL.4.32GB - 4 MySQL.8.64GB - 8 MySQL.32.256GB - 8
innodb_page_cleaners	Dependent on shape. The default values per shape are: MySQL.2.16GB - 4 MySQL.4.32GB - 4 MySQL.8.64GB - 4 MySQL.32.256GB - 4
innodb_parallel_read_threads	Dependent on shape. The global value cannot be modified, but the corresponding session variable can be modified for the current session. See Section 11.1, “User-Settable Session Variables”. The default global values per shape are: MySQL.2.16GB - 1 MySQL.4.32GB - 2 MySQL.8.64GB - 4 MySQL.32.256GB - 32
innodb_read_io_threads	Dependent on shape. The default values per shape are: MySQL.2.16GB - 1 MySQL.4.32GB - 2 MySQL.8.64GB - 4 MySQL.32.256GB - 2
max_connections	Dependent on shape. The default values per shape are: MySQL.2.16GB - 1000 MySQL.4.32GB - 2000 MySQL.8.64GB - 4000 MySQL.32.256GB - 2000
max_prepared_stmt_count	Dependent on shape. The maximum values per shape are: MySQL.2.16GB - 20000 MySQL.4.32GB - 40000 MySQL.8.64GB - 80000 MySQL.32.256GB - 40000
slave_parallel_workers	Dependent on shape. The default values per shape are: MySQL.2.16GB - 4 MySQL.4.32GB - 8 MySQL.8.64GB - 16 MySQL.32.256GB - 16
temptable_max_ram	Dependent on shape. The default values per shape are: MySQL.2.16GB - 1GB MySQL.4.32GB - 1GB MySQL.8.64GB - 2GB MySQL.32.256GB - 1GB
thread_pool_size	Dependent on shape. The default values per shape are: MySQL.2.16GB - 8 MySQL.4.32GB - 16 MySQL.8.64GB - 32 MySQL.32.256GB - 32