User Configurable Shape Dependent System Variables
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 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
|