HeatWave on AWS  /  Configuration  /  User-Configurable Shape-Dependent System Variables

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