18.6 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 HeatWave Console. See Creating a MySQL Configuration and Copying a MySQL Configuration.
Note:
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 18-8 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 18-9 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
|
51539607552
|
MySQL.8.64GB | Yes |
46170898432
|
5242880
|
46170898432
|
MySQL.32.256GB | No |
206158430208
|
5242880
|
206158430208
|
MySQL.32.256GB | Yes |
21474836480
|
5242880
|
21474836480
|
Table 18-10 max_connections
Shape | Supports HeatWave | Default | Minimum | Maximum |
---|---|---|---|---|
MySQL.2.16GB | No |
1000
|
1
|
1000
|
MySQL.2.16GB | Yes |
1000
|
1
|
1000
|
MySQL.4.32GB | No |
2000
|
1
|
2000
|
MySQL.4.32GB | Yes |
2000
|
1
|
2000
|
MySQL.8.64GB | No |
4000
|
1
|
4000
|
MySQL.8.64GB | Yes |
4000
|
1
|
4000
|
MySQL.32.256GB | No |
8000
|
1
|
16000
|
MySQL.32.256GB | Yes |
2000
|
1
|
16000
|
Table 18-11 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 18-12 thread_pool_max_transactions_limit
Shape | Default | Minimum | Maximum |
---|---|---|---|
MySQL.2.16GB |
32
|
0
|
100000
|
MySQL.4.32GB |
64
|
0
|
100000
|
MySQL.8.64GB |
128
|
0
|
100000
|
MySQL.32.256GB |
512
|
0
|
100000
|
Table 18-13 thread_pool_query_threads_per_group
Shape | Default | Minimum | Maximum |
---|---|---|---|
MySQL.2.16GB |
2
|
1
|
4096
|
MySQL.4.32GB |
2
|
1
|
4096
|
MySQL.8.64GB |
2
|
1
|
4096
|
MySQL.32.256GB |
2
|
1
|
4096
|
Parent topic: Configuration