Shape dependent global system variables are linked to, and tuned for, a specific MySQL shape. See Supported Shapes. Configure the following variables with the MySQL HeatWave Console. See Section 3.3, “Creating a MySQL Configuration”.
innodb_buffer_pool_instances
,
innodb_buffer_pool_size
,
max_connections
, and
max_prepared_stmt_count
have
different default, minimum and maximum values for each shape and
for HeatWave support.
thread_pool_max_transactions_limit
and
thread_pool_query_threads_per_group
have different default values for each shape.
Table 13.3 innodb_buffer_pool_instances
Shape | Supports HeatWave | Default | Minimum | Maximum |
---|---|---|---|---|
MySQL.2.16GB | No | 4 |
1 |
64 |
MySQL.2.16GB | Yes | 4 |
1 |
64 |
MySQL.4.32GB | No | 4 |
1 |
64 |
MySQL.4.32GB | Yes | 4 |
1 |
64 |
MySQL.8.64GB | No | 4 |
1 |
64 |
MySQL.8.64GB | Yes | 4 |
1 |
64 |
MySQL.32.256GB | No | 8 |
1 |
64 |
MySQL.32.256GB | Yes | 4 |
1 |
64 |
Table 13.4 innodb_buffer_pool_size
Shape | Supports HeatWave | Default | Minimum | Maximum |
---|---|---|---|---|
MySQL.2.16GB | No | 10737418240 |
5242880 |
10737418240 |
MySQL.2.16GB | Yes | 5368709120 |
5242880 |
5368709120 |
MySQL.4.32GB | No | 21474836480 |
5242880 |
21474836480 |
MySQL.4.32GB | Yes | 16106127360 |
5242880 |
16106127360 |
MySQL.8.64GB | No | 51539607552 |
5242880 |
61203283968 |
MySQL.8.64GB | Yes | 45097156608 |
5242880 |
45097156608 |
MySQL.32.256GB | No | 206158430208 |
5242880 |
246960619520 |
MySQL.32.256GB | Yes | 21474836480 |
5242880 |
21474836480 |
Table 13.5 max_connections
Shape | Supports HeatWave | Default | Minimum | Maximum |
---|---|---|---|---|
MySQL.2.16GB | No | 1000 |
1 |
100000 |
MySQL.2.16GB | Yes | 1000 |
1 |
100000 |
MySQL.4.32GB | No | 2000 |
1 |
100000 |
MySQL.4.32GB | Yes | 2000 |
1 |
100000 |
MySQL.8.64GB | No | 4000 |
1 |
100000 |
MySQL.8.64GB | Yes | 4000 |
1 |
100000 |
MySQL.32.256GB | No | 8000 |
1 |
100000 |
MySQL.32.256GB | Yes | 2000 |
1 |
100000 |
Table 13.6 max_prepared_stmt_count
Shape | Supports HeatWave | Default | Minimum | Maximum |
---|---|---|---|---|
MySQL.2.16GB | No | 16382 |
16382 |
20000 |
MySQL.2.16GB | Yes | 16382 |
16382 |
20000 |
MySQL.4.32GB | No | 16382 |
16382 |
40000 |
MySQL.4.32GB | Yes | 16382 |
16382 |
40000 |
MySQL.8.64GB | No | 16382 |
16382 |
80000 |
MySQL.8.64GB | Yes | 16382 |
16382 |
80000 |
MySQL.32.256GB | No | 16382 |
16382 |
160000 |
MySQL.32.256GB | Yes | 16382 |
16382 |
40000 |
Table 13.7 thread_pool_max_transactions_limit
Shape | Default | Minimum | Maximum |
---|---|---|---|
MySQL.2.16GB | 8 |
0 |
100000 |
MySQL.4.32GB | 16 |
0 |
100000 |
MySQL.8.64GB | 32 |
0 |
100000 |
MySQL.32.256GB | 512 |
0 |
100000 |
Table 13.8 thread_pool_query_threads_per_group
Shape | Default | Minimum | Maximum |
---|---|---|---|
MySQL.2.16GB | 16 |
1 |
4096 |
MySQL.4.32GB | 16 |
1 |
4096 |
MySQL.8.64GB | 16 |
1 |
4096 |
MySQL.32.256GB | 16 |
1 |
4096 |