19.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 MySQL HeatWave Console. See Creating a MySQL Configuration and Copying a MySQL Configuration.

Note:

innodb_buffer_pool_instances , innodb_buffer_pool_size , innodb_read_io_threads , max_connections , and max_prepared_stmt_count have different default, minimum and maximum values for each shape and for MySQL HeatWave support.

thread_pool_max_transactions_limit and thread_pool_query_threads_per_group have different default values for each shape.

Table 19-8 innodb_buffer_pool_instances

Shape	Supports MySQL 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 19-9 innodb_buffer_pool_size

Shape	Supports MySQL 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	206158430208

Table 19-10 innodb_read_io_threads

Shape	Supports MySQL HeatWave	Default	Minimum	Maximum
MySQL.2.16GB	No	4	1	64
MySQL.2.16GB	Yes	32	1	64
MySQL.4.32GB	No	4	1	64
MySQL.4.32GB	Yes	32	1	64
MySQL.8.64GB	No	4	1	64
MySQL.8.64GB	Yes	32	1	64
MySQL.32.256GB	No	16	1	64
MySQL.32.256GB	Yes	32	1	64

Table 19-11 max_connections

Shape	Supports MySQL 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 19-12 max_prepared_stmt_count

Shape	Supports MySQL 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 19-13 replica_parallel_workers

Shape	Supports MySQL HeatWave	Default	Minimum	Maximum
MySQL.2.16GB	No	48	1	1024
MySQL.2.16GB	Yes	48	1	1024
MySQL.4.32GB	No	48	1	1024
MySQL.4.32GB	Yes	48	1	1024
MySQL.8.64GB	No	64	1	1024
MySQL.8.64GB	Yes	64	1	1024
MySQL.32.256GB	No	256	1	1024
MySQL.32.256GB	Yes	16	1	1024

Table 19-14 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 19-15 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