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

14.4 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 14-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 14-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 14-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 14-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 14-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 14-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