HeatWave on AWS  /  Configuration  /  User-Configurable System Variables

18.5 User-Configurable System Variables

Configure the following global system variables with the HeatWave Console. See Creating a MySQL Configuration and Copying a MySQL Configuration.

Table 18-6 User-Configurable System Variables

Name Default Value
audit_log_disable ON
autocommit ON
big_tables OFF
binlog_expire_logs_seconds 3600
binlog-row-metadata MINIMAL
binlog_row_value_options PARTIAL_JSON
binlog_transaction_compression OFF
completion_type NO_CHAIN
connect_timeout 10
connection_memory_chunk_size 8912
connection_memory_limit 9223372036854775807
cte_max_recursion_depth 1000
default_authentication_plugin CACHING_SHA2_PASSWORD
foreign_key_checks ON
global_connection_memory_limit 9223372036854775807
global_connection_memory_tracking OFF
group_replication_consistency EVENTUAL
information_schema_stats_expiry 86400
innodb_buffer_pool_dump_pct 25
innodb_buffer_pool_instances Shape dependent, see User-Configurable Shape-Dependent System Variables
innodb_buffer_pool_size Shape dependent, see User-Configurable Shape-Dependent System Variables
innodb_ddl_buffer_size 1048576
innodb_ddl_threads 4
innodb_ft_enable_stopword ON
innodb_ft_max_token_size 84
innodb_ft_min_token_size 3
innodb_ft_num_word_optimize 2000
innodb_ft_result_cache_limit 2000000000
innodb_ft_server_stopword_table NULL
innodb_lock_wait_timeout 50
innodb_log_writer_threads ON
innodb_max_purge_lag_delay 300000
innodb_max_purge_lag 0
innodb_stats_persistent_sample_pages 20
innodb_stats_transient_sample_pages 8
interactive_timeout 28800
--local-infile OFF
mandatory_roles Empty string
max_allowed_packet 67108864
max_binlog_cache_size 4294967296
max_connect_errors 18,446,744,073,709,551,615
max_connections Shape dependent, see User-Configurable Shape-Dependent System Variables
max_execution_time 0
max_heap_table_size 16777216
max_prepared_stmt_count Shape dependent, see User-Configurable Shape-Dependent System Variables
mysql_firewall_mode ON
mysqlx_connect_timeout 30
mysqlx_deflate_default_compression_level 3
mysqlx_deflate_max_client_compression_level 5
mysqlx_interactive_timeout 28800
mysqlx_lz4_default_compression_level 2
mysqlx_lz4_max_client_compression_level 8
mysqlx_max_allowed_packet 67108864
mysqlx_read_timeout 28800
mysqlx_wait_timeout 28800
mysqlx_write_timeout 60
mysqlx_zstd_default_compression_level 3
mysqlx_zstd_max_client_compression_level 11
net_read_timeout 30
net_write_timeout 60
parser_max_mem_size 18446744073709551615
regexp_time_limit 32
sort_buffer_size 262144
sql_mode ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES
sql_require_primary_key OFF
sql_warnings OFF
telemetry_log_disable OFF
thread_pool_dedicated_listeners OFF
thread_pool_max_transactions_limit Shape dependent, see User-Configurable Shape-Dependent System Variables
thread_pool_query_threads_per_group Shape dependent, see User-Configurable Shape-Dependent System Variables
time_zone UTC
tmp_table_size 16777216
transaction_isolation REPEATABLE-READ
wait_timeout 28800