13.3 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 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