MySQL HeatWave on AWS  /  Configuration  /  Service Specific System Variables

13.4 Service Specific System Variables

MySQL HeatWave on AWS defines the following global system variables. It is not possible to edit them.

generated_random_password_length, query_alloc_block_size, and query_prealloc_size are also session variables. See Section 13.6, “Session Variables”.


The SHOW VARIABLES statement with the GLOBAL modifier displays global system variable values:

mysql> SHOW GLOBAL VARIABLES;

To obtain the value for a specific variable, use a LIKE clause as shown:

mysql> SHOW GLOBAL VARIABLES LIKE 'max_join_size';

To get a list of variables whose name match a pattern, use the % wildcard character in a LIKE clause:

mysql> SHOW GLOBAL VARIABLES LIKE '%size%';