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
auto_increment_increment	1
auto_increment_offset	1
big_tables	OFF
binlog_expire_logs_seconds	3600
binlog_group_commit_sync_delay	0
binlog_group_commit_sync_no_delay_count	0
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
explicit_defaults_for_timestamp	ON
foreign_key_checks	ON
global_connection_memory_limit	9223372036854775807
global_connection_memory_tracking	OFF
group_replication_consistency	EVENTUAL
information_schema_stats_expiry	86400
innodb_autoinc_lock_mode	2
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_numa_interleave	ON
innodb_online_alter_log_max_size	134217728
innodb_rollback_on_timeout	OFF
innodb_sort_buffer_size	1048576
innodb_stats_persistent_sample_pages	20
innodb_stats_transient_sample_pages	8
innodb_write_io_threads	4
interactive_timeout	28800
join_buffer_size	262144
long_query_time	10
--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
max_seeks_for_key	18446744073709551615
max_user_connections	0
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
optimizer_switch	batched_key_access=off,block_nested_loop=on,condition_fanout_filter=on,derived_condition_pushdown=on,derived_merge=on,duplicateweedout=on,engine_condition_pushdown=on,firstmatch=on,hash_join=on,hash_set_operations=on,hypergraph_optimizer=off,index_condition_pushdown=on,index_merge=on,index_merge_intersection=on,index_merge_sort_union=on,index_merge_union=on,loosescan=on,materialization=on,mrr=on,mrr_cost_based=on,prefer_ordering_index=on,semijoin=on,skip_scan=on,subquery_materialization_cost_based=on,subquery_to_derived=off,use_index_extensions=on,use_invisible_indexes=off
parser_max_mem_size	18446744073709551615
range_optimizer_max_mem_size	8388608
regexp_time_limit	32
skip_name_resolve	OFF
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
table_definition_cache	AUTOSIZED
table_open_cache	4000
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

Parent topic: Configuration