User-Configurable System Variables

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

Note:

Click on the name of a system varuable in Table 19-7 to see its description in the MySQL Reference Manual. Notice that variable's Default Value for HeatWave on AWS, which is given in the table, might be different from the value given in the MySQL Reference Manual,

Table 19-7 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`	For MySQL 9.3.1 and later: index_merge_sort_union=on, index_merge_intersection=on, engine_condition_pushdown=on, index_condition_pushdown=on, mrr=on, mrr_cost_based=on, block_nested_loop=on, batched_key_access=off, materialization=on, semijoin=on, loosescan=on, firstmatch=on, duplicateweedout=on, subquery_materialization_cost_based=on, use_index_extensions=on, condition_fanout_filter=on, derived_merge=on, use_invisible_indexes=off, skip_scan=on, hash_join=on, subquery_to_derived=off, prefer_ordering_index=on, hypergraph_optimizer=on, derived_condition_pushdown=on For MySQL 9.3.0 and earlier: index_merge_sort_union=on, index_merge_intersection=on, engine_condition_pushdown=on, index_condition_pushdown=on, mrr=on, mrr_cost_based=on, block_nested_loop=on, batched_key_access=off, materialization=on, semijoin=on, loosescan=on, firstmatch=on, duplicateweedout=on, subquery_materialization_cost_based=on, use_index_extensions=on, condition_fanout_filter=on, derived_merge=on, use_invisible_indexes=off, skip_scan=on, hash_join=on, subquery_to_derived=off, prefer_ordering_index=on, hypergraph_optimizer=off, derived_condition_pushdown=on
`parser_max_mem_size`	`18446744073709551615`
`range_optimizer_max_mem_size`	`8388608`
`regexp_time_limit`	`32`
`replica_pending_jobs_size_max`	`134217728`
`replica_type_conversions`	Empty string
`require_secure_transport`	`ON`. Secure transport can be disabled only for private connections over PrivateLink. If your DB System allows public access, you need to update the network configuration to disable it before you can set this variable to `OFF`.
`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