Easy MySQL Tuner Documentation
MySQL Configuration Variables
Configure your MySQL server for optimal performance
Category: InnoDB
The size in bytes of the InnoDB buffer pool.
Category: Connections
The maximum number of simultaneous client connections allowed.
Category: Logging
The path to the error log file.
Category: Binary Log
The binary logging format.
Category: Character Set
The default character set for the server.
Category: Logging
Enables or disables the general query log.
Category: InnoDB
Controls the strictness of ACID compliance for InnoDB transactions.
Category: Query Cache
The amount of memory allocated for the query cache.
Category: Connections
The number of seconds the mysqld server waits for a connect packet before responding with Bad handshake.
Category: Temporary Tables
The maximum size of in-memory temporary tables.
Category: General
back_log
Category: General
basedir
Category: General
big_tables
Category: General
bind_address
Category: General
binlog_cache_size
Category: General
binlog_checksum
Category: General
binlog_direct_non_transactional_updates
Category: General
binlog_encryption
Category: General
binlog_error_action
Category: General
binlog_expire_logs_auto_purge
Category: General
binlog_expire_logs_seconds
Category: General
binlog_format
Category: General
binlog_group_commit_sync_delay
Category: General
binlog_group_commit_sync_no_delay_count
Category: General
binlog_gtid_simple_recovery
Category: General
binlog_max_flush_queue_time
Category: General
binlog_order_commits
Category: General
binlog_rotate_encryption_master_key_at_startup
Category: General
binlog_row_event_max_size
Category: General
binlog_row_image
Category: General
binlog_row_metadata
Category: General
binlog_rows_query_log_events
Category: General
binlog_stmt_cache_size
Category: General
binlog_transaction_compression
Category: General
binlog_transaction_compression_level_zstd
Category: General
binlog_transaction_dependency_history_size
Category: General
binlog_transaction_dependency_tracking
Category: General
block_encryption_mode
Category: General
build_id
Category: MyISAM
MyISAM uses a special tree-like cache to make bulk inserts faster for INSERT ... SELECT, INSERT ... VALUES (...), (...), ..., and LOAD DATA when adding data to nonempty tables. This variable limits the size of the cache tree in bytes per thread. Setting it to 0 disables this optimization.
Category: General
caching_sha2_password_auto_generate_rsa_keys
Category: General
caching_sha2_password_digest_rounds
Category: General
caching_sha2_password_private_key_path
Category: General
caching_sha2_password_public_key_path
Category: General
character_set_client
Category: General
character_set_connection
Category: General
character_set_database
Category: General
character_set_filesystem
Category: General
character_set_results
Category: General
character_set_server
Category: General
character_set_system
Category: General
character_sets_dir
Category: General
check_proxy_users
Category: General
collation_connection
Category: General
collation_database
Category: General
collation_server
Category: General
completion_type
Category: MyISAM
f AUTO (the default), MySQL permits INSERT and SELECT statements to run concurrently for MyISAM tables that have no free blocks in the middle of the data file. This variable can take the values shown in the following table. The variable can be assigned using either the name values or corresponding integer values.
Category: General
connect_timeout
Category: General
connection_memory_chunk_size
Category: General
connection_memory_limit
Category: General
core_file
Category: General
create_admin_listener_thread
Category: General
cte_max_recursion_depth
Category: General
datadir
Category: General
default_authentication_plugin
Category: General
default_collation_for_utf8mb4
Category: General
default_password_lifetime
Category: General
default_storage_engine
Category: General
default_table_encryption
Category: General
default_tmp_storage_engine
Category: General
default_week_format
Category: MyISAM
This variable specifies how to use delayed key writes. It applies only to MyISAM tables. Delayed key writing causes key buffers not to be flushed between writes.
Category: General
disconnect_on_expired_password
Category: General
div_precision_increment
Category: General
end_markers_in_json
Category: General
enforce_gtid_consistency
Category: General
eq_range_index_dive_limit
Category: General
error_count
Category: General
event_scheduler
Category: General
expire_logs_days
Category: General
explain_format
Category: General
explicit_defaults_for_timestamp
Category: MyISAM
f ON, the server flushes (synchronizes) all changes to disk after each SQL statement. Normally, MySQL does a write of all changes to disk only after each SQL statement and lets the operating system handle the synchronizing to disk.
Category: MyISAM
If this is set to a nonzero value, all tables are closed every flush_time seconds to free up resources and synchronize unflushed data to disk. This option is best used only on systems with minimal resources.
Category: General
If set to 1 (the default), foreign key constraints are checked. If set to 0, foreign key constraints are ignored, with a couple of exceptions. When re-creating a table that was dropped, an error is returned if the table definition does not conform to the foreign key constraints referencing the table. Likewise, an ALTER TABLE operation returns an error if a foreign key definition is incorrectly formed.
Category: General
ft_boolean_syntax
Category: General
ft_max_word_len
Category: General
ft_min_word_len
Category: General
ft_query_expansion_limit
Category: General
ft_stopword_file
Category: General
general_log
Category: General
general_log_file
Category: General
generated_random_password_length
Category: General
global_connection_memory_limit
Category: General
global_connection_memory_tracking
Category: General
group_concat_max_len
Category: General
group_replication_consistency
Category: General
gtid_executed_compression_period
Category: General
gtid_mode
Category: General
gtid_next
Category: General
have_compress
Category: General
have_dynamic_loading
Category: General
have_geometry
Category: General
have_openssl
Category: General
have_profiling
Category: General
have_query_cache
Category: General
have_rtree_keys
Category: General
have_ssl
Category: General
have_statement_timeout
Category: General
have_symlink
Category: General
histogram_generation_max_mem_size
Category: General
host_cache_size
Category: General
hostname
Category: General
identity
Category: General
immediate_server_version
Category: General
information_schema_stats_expiry
Category: General
innodb_adaptive_flushing
Category: General
innodb_adaptive_flushing_lwm
Category: General
innodb_adaptive_hash_index
Category: General
innodb_adaptive_hash_index_parts
Category: General
innodb_adaptive_max_sleep_delay
Category: General
innodb_api_bk_commit_interval
Category: General
innodb_api_disable_rowlock
Category: General
innodb_api_enable_binlog
Category: General
innodb_api_enable_mdl
Category: General
innodb_api_trx_level
Category: General
innodb_autoextend_increment
Category: General
innodb_autoinc_lock_mode
Category: General
Defines the chunk size for InnoDB buffer pool resizing operations. To avoid copying all buffer pool pages during resizing operations, the operation is performed in “chunks”.
Category: General
innodb_buffer_pool_dump_at_shutdown
Category: General
innodb_buffer_pool_dump_now
Category: General
innodb_buffer_pool_dump_pct
Category: General
innodb_buffer_pool_filename
Category: General
innodb_buffer_pool_in_core_file
Category: General
innodb_buffer_pool_instances
Category: General
innodb_buffer_pool_load_abort
Category: General
innodb_buffer_pool_load_at_startup
Category: General
innodb_buffer_pool_load_now
Category: General
innodb_change_buffer_max_size
Category: General
innodb_change_buffering
Category: General
innodb_checksum_algorithm
Category: General
innodb_cmp_per_index_enabled
Category: General
innodb_commit_concurrency
Category: General
innodb_compression_failure_threshold_pct
Category: General
innodb_compression_level
Category: General
innodb_compression_pad_pct_max
Category: General
innodb_concurrency_tickets
Category: General
innodb_data_file_path
Category: General
innodb_ddl_buffer_size
Category: General
innodb_ddl_threads
Category: General
innodb_deadlock_detect
Category: General
innodb_dedicated_server
Category: General
innodb_default_row_format
Category: General
innodb_disable_sort_file_cache
Category: General
innodb_doublewrite
Category: General
innodb_doublewrite_batch_size
Category: General
innodb_doublewrite_files
Category: General
innodb_doublewrite_pages
Category: General
innodb_extend_and_initialize
Category: General
innodb_fast_shutdown
Category: General
innodb_file_per_table
Category: General
innodb_fill_factor
Category: General
innodb_flush_log_at_timeout
Category: General
innodb_flush_log_at_trx_commit
Category: General
innodb_flush_method
Category: General
innodb_flush_neighbors
Category: General
innodb_flush_sync
Category: General
innodb_flushing_avg_loops
Category: General
innodb_force_load_corrupted
Category: General
innodb_force_recovery
Category: General
innodb_fsync_threshold
Category: General
innodb_ft_cache_size
Category: General
innodb_ft_enable_diag_print
Category: General
innodb_ft_enable_stopword
Category: General
innodb_ft_max_token_size
Category: General
innodb_ft_min_token_size
Category: General
innodb_ft_num_word_optimize
Category: General
innodb_ft_result_cache_limit
Category: General
innodb_ft_sort_pll_degree
Category: General
innodb_ft_total_cache_size
Category: General
innodb_idle_flush_pct
Category: General
innodb_io_capacity
Category: General
innodb_io_capacity_max
Category: General
The length of time in seconds an InnoDB transaction waits for a row lock before giving up. The default value is 50 seconds. A transaction that tries to access a row that is locked by another InnoDB transaction waits at most this many seconds for write access to the row before issuing an error
Category: General
innodb_log_buffer_size
Category: General
innodb_log_checksums
Category: General
innodb_log_compressed_pages
Category: General
innodb_log_file_size
Category: General
innodb_log_files_in_group
Category: General
innodb_log_group_home_dir
Category: General
innodb_log_spin_cpu_abs_lwm
Category: General
innodb_log_spin_cpu_pct_hwm
Category: General
innodb_log_wait_for_flush_spin_hwm
Category: General
innodb_log_write_ahead_size
Category: General
innodb_log_writer_threads
Category: General
innodb_lru_scan_depth
Category: General
innodb_max_dirty_pages_pct
Category: General
innodb_max_dirty_pages_pct_lwm
Category: General
innodb_max_purge_lag
Category: General
innodb_max_purge_lag_delay
Category: General
innodb_max_undo_log_size
Category: General
innodb_numa_interleave
Category: General
innodb_old_blocks_pct
Category: General
innodb_old_blocks_time
Category: General
innodb_online_alter_log_max_size
Category: General
innodb_open_files
Category: General
innodb_optimize_fulltext_only
Category: General
innodb_page_cleaners
Category: General
innodb_page_size
Category: General
innodb_parallel_read_threads
Category: General
innodb_print_all_deadlocks
Category: General
innodb_print_ddl_logs
Category: General
innodb_purge_batch_size
Category: General
innodb_purge_rseg_truncate_frequency
Category: General
innodb_purge_threads
Category: General
innodb_random_read_ahead
Category: General
innodb_read_ahead_threshold
Category: General
innodb_read_io_threads
Category: General
innodb_read_only
Category: General
innodb_redo_log_capacity
Category: General
innodb_redo_log_encrypt
Category: General
innodb_replication_delay
Category: General
innodb_rollback_on_timeout
Category: General
innodb_rollback_segments
Category: General
innodb_segment_reserve_factor
Category: General
innodb_sort_buffer_size
Category: General
innodb_spin_wait_delay
Category: General
innodb_spin_wait_pause_multiplier
Category: General
innodb_stats_auto_recalc
Category: General
innodb_stats_include_delete_marked
Category: General
innodb_stats_method
Category: General
innodb_stats_on_metadata
Category: General
innodb_stats_persistent
Category: General
innodb_stats_persistent_sample_pages
Category: General
innodb_stats_transient_sample_pages
Category: General
innodb_status_output
Category: General
innodb_status_output_locks
Category: General
innodb_strict_mode
Category: General
innodb_sync_array_size
Category: General
innodb_sync_spin_loops
Category: General
innodb_table_locks
Category: General
innodb_temp_data_file_path
Category: General
innodb_temp_tablespaces_dir
Category: General
innodb_thread_concurrency
Category: General
innodb_thread_sleep_delay
Category: General
innodb_undo_directory
Category: General
innodb_undo_log_encrypt
Category: General
innodb_undo_log_truncate
Category: General
innodb_undo_tablespaces
Category: General
innodb_use_fdatasync
Category: General
innodb_use_native_aio
Category: General
innodb_validate_tablespace_paths
Category: General
innodb_version
Category: General
innodb_write_io_threads
Category: General
insert_id
Category: General
interactive_timeout
Category: General
internal_tmp_mem_storage_engine
Category: General
join_buffer_size
Category: General
If a MyISAM table is created with no DATA DIRECTORY option, the .MYD file is created in the database directory. By default, if MyISAM finds an existing .MYD file in this case, it overwrites it. The same applies to .MYI files for tables created with no INDEX DIRECTORY option. To suppress this behavior, set the keep_files_on_create variable to ON (1), in which case MyISAM does not overwrite existing files and returns an error instead. The default value is OFF (0). If a MyISAM table is created with a DATA DIRECTORY or INDEX DIRECTORY option and an existing .MYD or .MYI file is found, MyISAM always returns an error. It does not overwrite a file in the specified directory.
Category: MyISAM
Index blocks for MyISAM tables are buffered and are shared by all threads. key_buffer_size is the size of the buffer used for index blocks. The key buffer is also known as the key cache. The minimum permissible setting is 0, but you cannot set key_buffer_size to 0 dynamically. A setting of 0 drops the key cache, which is not permitted at runtime. Setting key_buffer_size to 0 is permitted only at startup, in which case the key cache is not initialized. Changing the key_buffer_size setting at runtime from a value of 0 to a permitted non-zero value initializes the key cache. key_buffer_size can be increased or decreased only in increments or multiples of 4096 bytes. Increasing or decreasing the setting by a nonconforming value produces a warning and truncates the setting to a conforming value.
Category: MyISAM
This value controls the demotion of buffers from the hot sublist of a key cache to the warm sublist. Lower values cause demotion to happen more quickly. The minimum value is 100.
Category: MyISAM
The size in bytes of blocks in the key cache.
Category: MyISAM
The division point between the hot and warm sublists of the key cache buffer list. The value is the percentage of the buffer list to use for the warm sublist. Permissible values range from 1 to 100.
Category: General
keyring_operations
Category: General
large_files_support
Category: General
large_page_size
Category: General
large_pages
Category: General
last_insert_id
Category: General
lc_messages
Category: General
lc_messages_dir
Category: General
lc_time_names
Category: General
license
Category: General
local_infile
Category: General
lock_wait_timeout
Category: General
locked_in_memory
Category: General
log_bin
Category: General
log_bin_basename
Category: General
log_bin_index
Category: General
log_bin_trust_function_creators
Category: General
log_bin_use_v1_row_events
Category: General
log_error
Category: General
log_error_services
Category: General
log_error_verbosity
Category: General
log_output
Category: General
log_queries_not_using_indexes
Category: General
log_raw
Category: General
log_replica_updates
Category: General
log_slave_updates
Category: General
log_slow_admin_statements
Category: General
log_slow_extra
Category: General
log_slow_replica_statements
Category: General
log_slow_slave_statements
Category: General
log_statements_unsafe_for_binlog
Category: General
log_throttle_queries_not_using_indexes
Category: General
log_timestamps
Category: General
long_query_time
Category: General
low_priority_updates
Category: General
lower_case_file_system
Category: General
lower_case_table_names
Category: General
master_info_repository
Category: General
master_verify_checksum
Category: General
max_allowed_packet
Category: General
max_binlog_cache_size
Category: General
max_binlog_size
Category: General
max_binlog_stmt_cache_size
Category: General
max_connect_errors
Category: General
max_connections
Category: General
max_delayed_threads
Category: General
max_digest_length
Category: General
max_error_count
Category: General
max_execution_time
Category: General
This variable sets the maximum size to which user-created MEMORY tables are permitted to grow. The value of the variable is used to calculate MEMORY table MAX_ROWS values.
Category: General
max_insert_delayed_threads
Category: General
max_join_size
Category: General
max_length_for_sort_data
Category: General
max_points_in_geometry
Category: General
max_prepared_stmt_count
Category: General
max_relay_log_size
Category: General
max_seeks_for_key
Category: General
max_sort_length
Category: General
max_sp_recursion_depth
Category: General
max_user_connections
Category: General
max_write_lock_count
Category: General
min_examined_row_limit
Category: General
myisam_data_pointer_size
Category: General
myisam_max_sort_file_size
Category: General
myisam_mmap_size
Category: General
myisam_recover_options
Category: General
myisam_sort_buffer_size
Category: General
myisam_stats_method
Category: General
myisam_use_mmap
Category: General
mysql_native_password_proxy_users
Category: General
mysqlx_bind_address
Category: General
mysqlx_compression_algorithms
Category: General
mysqlx_connect_timeout
Category: General
mysqlx_deflate_default_compression_level
Category: General
mysqlx_deflate_max_client_compression_level
Category: General
mysqlx_document_id_unique_prefix
Category: General
mysqlx_enable_hello_notice
Category: General
mysqlx_idle_worker_thread_timeout
Category: General
mysqlx_interactive_timeout
Category: General
mysqlx_lz4_default_compression_level
Category: General
mysqlx_lz4_max_client_compression_level
Category: General
mysqlx_max_allowed_packet
Category: General
mysqlx_max_connections
Category: General
mysqlx_min_worker_threads
Category: General
mysqlx_port
Category: General
mysqlx_port_open_timeout
Category: General
mysqlx_read_timeout
Category: General
mysqlx_socket
Category: General
mysqlx_wait_timeout
Category: General
mysqlx_write_timeout
Category: General
mysqlx_zstd_default_compression_level
Category: General
mysqlx_zstd_max_client_compression_level
Category: General
net_buffer_length
Category: General
net_read_timeout
Category: General
net_retry_count
Category: General
net_write_timeout
Category: General
new
Category: General
ngram_token_size
Category: General
offline_mode
Category: General
old
Category: General
old_alter_table
Category: General
open_files_limit
Category: General
optimizer_max_subgraph_pairs
Category: General
optimizer_prune_level
Category: General
optimizer_search_depth
Category: General
optimizer_switch
Category: General
optimizer_trace
Category: General
optimizer_trace_features
Category: General
optimizer_trace_limit
Category: General
optimizer_trace_max_mem_size
Category: General
optimizer_trace_offset
Category: General
original_commit_timestamp
Category: General
original_server_version
Category: General
parser_max_mem_size
Category: General
partial_revokes
Category: General
password_history
Category: General
password_require_current
Category: General
password_reuse_interval
Category: General
performance_schema
Category: General
performance_schema_accounts_size
Category: General
performance_schema_digests_size
Category: General
performance_schema_error_size
Category: General
performance_schema_events_stages_history_long_size
Category: General
performance_schema_events_stages_history_size
Category: General
performance_schema_events_statements_history_long_size
Category: General
performance_schema_events_statements_history_size
Category: General
performance_schema_events_transactions_history_long_size
Category: General
performance_schema_events_transactions_history_size
Category: General
performance_schema_events_waits_history_long_size
Category: General
performance_schema_events_waits_history_size
Category: General
performance_schema_hosts_size
Category: General
performance_schema_max_cond_classes
Category: General
performance_schema_max_cond_instances
Category: General
performance_schema_max_digest_length
Category: General
performance_schema_max_digest_sample_age
Category: General
performance_schema_max_file_classes
Category: General
performance_schema_max_file_handles
Category: General
performance_schema_max_file_instances
Category: General
performance_schema_max_index_stat
Category: General
performance_schema_max_memory_classes
Category: General
performance_schema_max_metadata_locks
Category: General
performance_schema_max_mutex_classes
Category: General
performance_schema_max_mutex_instances
Category: General
performance_schema_max_prepared_statements_instances
Category: General
performance_schema_max_program_instances
Category: General
performance_schema_max_rwlock_classes
Category: General
performance_schema_max_rwlock_instances
Category: General
performance_schema_max_socket_classes
Category: General
performance_schema_max_socket_instances
Category: General
performance_schema_max_sql_text_length
Category: General
performance_schema_max_stage_classes
Category: General
performance_schema_max_statement_classes
Category: General
performance_schema_max_statement_stack
Category: General
performance_schema_max_table_handles
Category: General
performance_schema_max_table_instances
Category: General
performance_schema_max_table_lock_stat
Category: General
performance_schema_max_thread_classes
Category: General
performance_schema_max_thread_instances
Category: General
performance_schema_session_connect_attrs_size
Category: General
performance_schema_setup_actors_size
Category: General
performance_schema_setup_objects_size
Category: General
performance_schema_show_processlist
Category: General
performance_schema_users_size
Category: General
persist_sensitive_variables_in_plaintext
Category: General
persisted_globals_load
Category: General
pid_file
Category: General
plugin_dir
Category: General
port
Category: General
preload_buffer_size
Category: General
print_identified_with_as_hex
Category: General
profiling
Category: General
profiling_history_size
Category: General
protocol_compression_algorithms
Category: General
protocol_version
Category: General
pseudo_replica_mode
Category: General
pseudo_slave_mode
Category: General
pseudo_thread_id
Category: General
query_alloc_block_size
Category: General
query_prealloc_size
Category: General
rand_seed1
Category: General
rand_seed2
Category: General
range_alloc_block_size
Category: General
range_optimizer_max_mem_size
Category: General
rbr_exec_mode
Category: General
read_buffer_size
Category: General
read_only
Category: General
read_rnd_buffer_size
Category: General
regexp_stack_limit
Category: General
regexp_time_limit
Category: General
relay_log
Category: General
relay_log_basename
Category: General
relay_log_index
Category: General
relay_log_info_file
Category: General
relay_log_info_repository
Category: General
relay_log_purge
Category: General
relay_log_recovery
Category: General
relay_log_space_limit
Category: General
replica_allow_batching
Category: General
replica_checkpoint_group
Category: General
replica_checkpoint_period
Category: General
replica_compressed_protocol
Category: General
replica_exec_mode
Category: General
replica_load_tmpdir
Category: General
replica_max_allowed_packet
Category: General
replica_net_timeout
Category: General
replica_parallel_type
Category: General
replica_parallel_workers
Category: General
replica_pending_jobs_size_max
Category: General
replica_preserve_commit_order
Category: General
replica_skip_errors
Category: General
replica_sql_verify_checksum
Category: General
replica_transaction_retries
Category: General
replication_optimize_for_static_plugin_config
Category: General
replication_sender_observe_commit_only
Category: General
report_port
Category: General
require_row_format
Category: General
require_secure_transport
Category: General
resultset_metadata
Category: General
rpl_read_size
Category: General
rpl_stop_replica_timeout
Category: General
rpl_stop_slave_timeout
Category: General
schema_definition_cache
Category: General
secondary_engine_cost_threshold
Category: General
secure_file_priv
Category: General
select_into_buffer_size
Category: General
select_into_disk_sync
Category: General
select_into_disk_sync_delay
Category: General
server_id
Category: General
server_id_bits
Category: General
server_uuid
Category: General
session_track_gtids
Category: General
session_track_schema
Category: General
session_track_state_change
Category: General
session_track_system_variables
Category: General
session_track_transaction_info
Category: General
sha256_password_auto_generate_rsa_keys
Category: General
sha256_password_private_key_path
Category: General
sha256_password_proxy_users
Category: General
sha256_password_public_key_path
Category: General
show_create_table_skip_secondary_engine
Category: General
show_create_table_verbosity
Category: General
show_gipk_in_create_table_and_information_schema
Category: General
show_old_temporals
Category: General
skip_external_locking
Category: General
skip_name_resolve
Category: General
skip_networking
Category: General
skip_replica_start
Category: General
skip_show_database
Category: General
skip_slave_start
Category: General
slave_allow_batching
Category: General
slave_checkpoint_group
Category: General
slave_checkpoint_period
Category: General
slave_compressed_protocol
Category: General
slave_exec_mode
Category: General
slave_load_tmpdir
Category: General
slave_max_allowed_packet
Category: General
slave_net_timeout
Category: General
slave_parallel_type
Category: General
slave_parallel_workers
Category: General
slave_pending_jobs_size_max
Category: General
slave_preserve_commit_order
Category: General
slave_rows_search_algorithms
Category: General
slave_skip_errors
Category: General
slave_sql_verify_checksum
Category: General
slave_transaction_retries
Category: General
slow_launch_time
Category: General
slow_query_log
Category: General
slow_query_log_file
Category: General
socket
Category: General
sort_buffer_size
Category: General
source_verify_checksum
Category: General
sql_auto_is_null
Category: General
sql_big_selects
Category: General
sql_buffer_result
Category: General
sql_generate_invisible_primary_key
Category: General
sql_log_bin
Category: General
sql_log_off
Category: General
sql_mode
Category: General
sql_notes
Category: General
sql_quote_show_create
Category: General
sql_replica_skip_counter
Category: General
sql_require_primary_key
Category: General
sql_safe_updates
Category: General
sql_select_limit
Category: General
sql_slave_skip_counter
Category: General
sql_warnings
Category: General
ssl_ca
Category: General
ssl_cert
Category: General
ssl_fips_mode
Category: General
ssl_key
Category: General
ssl_session_cache_mode
Category: General
ssl_session_cache_timeout
Category: General
statement_id
Category: General
stored_program_cache
Category: General
stored_program_definition_cache
Category: General
super_read_only
Category: General
sync_binlog
Category: General
sync_master_info
Category: General
sync_relay_log
Category: General
sync_relay_log_info
Category: General
sync_source_info
Category: General
system_time_zone
Category: General
table_definition_cache
Category: General
table_encryption_privilege_check
Category: General
The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires.
Category: General
table_open_cache_instances
Category: General
tablespace_definition_cache
Category: General
temptable_max_mmap
Category: General
temptable_max_ram
Category: General
temptable_use_mmap
Category: General
terminology_use_previous
Category: General
thread_cache_size
Category: General
thread_handling
Category: General
thread_stack
Category: General
time_zone
Category: General
timestamp
Category: General
tls_version
Category: General
tmp_table_size
Category: General
tmpdir
Category: General
transaction_alloc_block_size
Category: General
transaction_allow_batching
Category: General
transaction_isolation
Category: General
transaction_prealloc_size
Category: General
transaction_read_only
Category: General
transaction_write_set_extraction
Category: General
unique_checks
Category: General
updatable_views_with_limit
Category: General
use_secondary_engine
Category: General
validate_password.changed_characters_percentage
Category: General
validate_password.check_user_name
Category: General
validate_password.length
Category: General
validate_password.mixed_case_count
Category: General
validate_password.number_count
Category: General
validate_password.policy
Category: General
validate_password.special_char_count
Category: General
version
Category: General
version_comment
Category: General
version_compile_machine
Category: General
version_compile_os
Category: General
version_compile_zlib
Category: General
wait_timeout
Category: General
warning_count
Category: General
windowing_use_high_precision
Category: General
xa_detach_on_prepare