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”.

Table 13.9 Service Specific Global System Variables

Name	Default Value
generated_random_password_length	20
mysqlx_document_id_unique_prefix	0
mysqlx_enable_hello_notice	ON
mysqlx_idle_worker_thread_timeout	60
mysqlx_min_worker_threads	2
query_alloc_block_size	8192
query_prealloc_size	8192

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%';