Skip navigation links

Additional languages
5.1.2 Command Options »
Section Navigation      [Toggle]

5.1.1. Option and Variable Reference

The following table provides a list of all the command line options, server and status variables applicable within mysqld.

The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in one unified list, with notification of where each option/variable is valid. If a server option set on the command line or in an option file differs from the name of the corresponding server system or status variable, the variable name is noted immediately below the corresponding option. For status variables, the scope of the variable is shown (Scope) as either global, session, or both. Please see the corresponding sections for details on setting and using the options and variables. Where appropriate, a direct link to further information on the item as available.

Note

This table is part of an ongoing process to expand and simplify the information provided on these elements. Further improvements to the table, and corresponding descriptions will be applied over the coming months.

Name Cmd-Line Option file System Var Status Var Var Scope Dynamic
Aborted_clients       Yes Both No
Aborted_connects       Yes Global No
abort-slave-event-count Yes Yes        
allow-suspicious-udfs Yes Yes        
ansi Yes Yes        
autocommit     Yes   Session Yes
auto-increment-increment Yes Yes     Both Yes
- Variable: auto_increment_increment     Yes   Both Yes
auto-increment-offset Yes Yes     Both Yes
- Variable: auto_increment_offset     Yes   Both Yes
automatic_sp_privileges     Yes   Global Yes
back_log Yes Yes Yes   Global No
basedir Yes Yes Yes   Global No
big-tables Yes Yes     Session Yes
- Variable: big_tables     Yes   Session Yes
bind-address Yes Yes        
Binlog_cache_disk_use       Yes Both No
binlog_cache_size Yes Yes Yes   Global Yes
Binlog_cache_use       Yes Both No
binlog-do-db Yes Yes        
binlog-format Yes Yes     Both Yes
- Variable: binlog_format     Yes   Both Yes
binlog-ignore-db Yes Yes        
binlog-row-event-max-size Yes Yes        
bootstrap Yes Yes        
bulk_insert_buffer_size Yes Yes Yes   Both Yes
Bytes_received       Yes Both No
Bytes_sent       Yes Both No
character_set_client     Yes   Both Yes
character-set-client-handshake Yes          
character_set_connection     Yes   Both Yes
character_set_database     Yes   Both Yes
character-set-filesystem Yes Yes     Both Yes
- Variable: character_set_filesystem     Yes   Both Yes
character_set_results     Yes   Both Yes
character-sets-dir Yes Yes     Global No
- Variable: character_sets_dir     Yes   Global No
character-set-server Yes Yes     Both Yes
- Variable: character_set_server     Yes   Both Yes
character_set_system     Yes   Global No
chroot Yes Yes        
collation_connection     Yes   Both Yes
collation_database     Yes   Both Yes
collation-server Yes Yes     Both Yes
- Variable: collation_server     Yes   Both Yes
Com_admin_commands       Yes Both No
Com_alter_db       Yes Both No
Com_alter_event       Yes Both No
Com_alter_table       Yes Both No
Com_analyze       Yes Both No
Com_backup       Yes Both No
Com_backup_table       Yes Both No
Com_begin       Yes Both No
Com_call_procedure       Yes Both No
Com_change_db       Yes Both No
Com_change_master       Yes Both No
Com_check       Yes Both No
Com_checksum       Yes Both No
Com_commit       Yes Both No
Com_create_db       Yes Both No
Com_create_event       Yes Both No
Com_create_function       Yes Both No
Com_create_index       Yes Both No
Com_create_table       Yes Both No
Com_create_user       Yes Both No
Com_dealloc_sql       Yes Both No
Com_delete       Yes Both No
Com_delete_multi       Yes Both No
Com_do       Yes Both No
Com_drop_db       Yes Both No
Com_drop_event       Yes Both No
Com_drop_function       Yes Both No
Com_drop_index       Yes Both No
Com_drop_table       Yes Both No
Com_drop_user       Yes Both No
Com_execute_sql       Yes Both No
Com_flush       Yes Both No
Com_grant       Yes Both No
Com_ha_close       Yes Both No
Com_ha_open       Yes Both No
Com_ha_read       Yes Both No
Com_help       Yes Both No
Com_insert       Yes Both No
Com_insert_select       Yes Both No
Com_kill       Yes Both No
Com_load       Yes Both No
Com_lock_tables       Yes Both No
Com_optimize       Yes Both No
completion_type Yes Yes Yes   Both Yes
Com_preload_keys       Yes Both No
Com_prepare_sql       Yes Both No
Compression       Yes Both No
Com_purge       Yes Both No
Com_purge_before_date       Yes Both No
Com_rename_table       Yes Both No
Com_repair       Yes Both No
Com_replace       Yes Both No
Com_replace_select       Yes Both No
Com_reset       Yes Both No
Com_restore       Yes Both No
Com_restore_table       Yes Both No
Com_revoke       Yes Both No
Com_revoke_all       Yes Both No
Com_rollback       Yes Both No
Com_savepoint       Yes Both No
Com_select       Yes Both No
Com_set_option       Yes Both No
Com_show_binlog_events       Yes Both No
Com_show_binlogs       Yes Both No
Com_show_charsets       Yes Both No
Com_show_collations       Yes Both No
Com_show_column_types       Yes Both No
Com_show_create_db       Yes Both No
Com_show_create_event       Yes Both No
Com_show_create_table       Yes Both No
Com_show_databases       Yes Both No
Com_show_engine_logs       Yes Both No
Com_show_engine_mutex       Yes Both No
Com_show_engine_status       Yes Both No
Com_show_errors       Yes Both No
Com_show_events       Yes Both No
Com_show_fields       Yes Both No
Com_show_grants       Yes Both No
Com_show_innodb_status       Yes Both No
Com_show_keys       Yes Both No
Com_show_logs       Yes Both No
Com_show_master_status       Yes Both No
Com_show_ndb_status       Yes Both No
Com_show_new_master       Yes Both No
Com_show_open_tables       Yes Both No
Com_show_plugins       Yes Both No
Com_show_privileges       Yes Both No
Com_show_processlist       Yes Both No
Com_show_slave_hosts       Yes Both No
Com_show_slave_status       Yes Both No
Com_show_status       Yes Both No
Com_show_storage_engines       Yes Both No
Com_show_tables       Yes Both No
Com_show_triggers       Yes Both No
Com_show_variables       Yes Both No
Com_show_warnings       Yes Both No
Com_slave_start       Yes Both No
Com_slave_stop       Yes Both No
Com_stmt_close       Yes Both No
Com_stmt_execute       Yes Both No
Com_stmt_fetch       Yes Both No
Com_stmt_prepare       Yes Both No
Com_stmt_reprepare       Yes Both No
Com_stmt_reset       Yes Both No
Com_stmt_send_long_data       Yes Both No
Com_truncate       Yes Both No
Com_unlock_tables       Yes Both No
Com_update       Yes Both No
Com_update_multi       Yes Both No
Com_xa_commit       Yes Both No
Com_xa_end       Yes Both No
Com_xa_prepare       Yes Both No
Com_xa_recover       Yes Both No
Com_xa_rollback       Yes Both No
Com_xa_start       Yes Both No
concurrent_insert Yes Yes Yes   Global Yes
Connections       Yes Both No
connect_timeout Yes Yes Yes   Global Yes
console Yes Yes        
core-file Yes Yes        
Created_tmp_disk_tables       Yes Both No
Created_tmp_files       Yes Both No
Created_tmp_tables       Yes Both No
datadir Yes Yes Yes   Global No
date_format     Yes   Both Yes
datetime_format Yes Yes Yes   Both Yes
debug Yes Yes Yes   Both Yes
defaults-extra-file Yes          
defaults-file Yes          
defaults-group-suffix Yes          
default-storage-engine Yes Yes        
default-table-type Yes Yes        
default-time-zone Yes Yes        
default_week_format Yes Yes Yes   Both Yes
Delayed_errors       Yes Both No
delayed_insert_limit Yes Yes Yes   Global Yes
Delayed_insert_threads       Yes Both No
delayed_insert_timeout Yes Yes Yes   Global Yes
delayed_queue_size Yes Yes Yes   Global Yes
Delayed_writes       Yes Both No
delay-key-write Yes Yes     Global Yes
- Variable: delay_key_write     Yes   Global Yes
des-key-file Yes Yes        
disconnect-slave-event-count Yes Yes        
div_precision_increment Yes Yes Yes   Both Yes
enable-locking Yes          
enable-named-pipe Yes Yes        
enable-pstack Yes Yes        
engine-condition-pushdown Yes Yes     Both Yes
- Variable: engine_condition_pushdown     Yes   Both Yes
error_count     Yes   Session No
event-scheduler Yes Yes Yes   Global Yes
exit-info Yes Yes        
expire_logs_days Yes Yes Yes   Global Yes
external-locking Yes Yes        
- Variable: external_locking            
falcon_checkpoint_schedule Yes Yes Yes   Global Yes
falcon_consistent_read Yes Yes Yes   Global Yes
falcon_debug_mask Yes Yes Yes   Global Yes
falcon_debug_server Yes Yes Yes   Global No
falcon_disable_fsync Yes Yes Yes   Global Yes
falcon_gopher_threads Yes Yes Yes   Global No
falcon_index_chill_threshold Yes Yes Yes   Global Yes
falcon_initial_allocation Yes Yes Yes   Global Yes
falcon_io_threads Yes Yes Yes   Global Yes
falcon_large_blob_threshold Yes Yes Yes   Global No
falcon_lock_wait_timeout Yes Yes Yes   Global Yes
falcon_max_transaction_backlog Yes Yes Yes   Global Yes
falcon_page_cache_size Yes Yes Yes   Global No
falcon_page_size Yes Yes Yes   Global No
falcon_record_chill_threshold Yes Yes Yes   Global Yes
falcon_record_memory_max Yes Yes Yes   Global Yes
falcon_record_scavenge_floor Yes Yes Yes   Global Yes
falcon_record_scavenge_threshold Yes Yes Yes   Global Yes
falcon_scavenge_schedule Yes Yes Yes   Global No
falcon_serial_log_buffers Yes Yes Yes   Global No
falcon_serial_log_dir Yes Yes Yes   Global No
falcon_serial_log_priority Yes Yes Yes   Global Yes
flush Yes Yes Yes   Global Yes
Flush_commands       Yes Both No
flush_time Yes Yes Yes   Global Yes
foreign_key_checks     Yes   Session Yes
ft_boolean_syntax Yes Yes Yes   Global Yes
ft_max_word_len Yes Yes Yes   Global No
ft_min_word_len Yes Yes Yes   Global No
ft_query_expansion_limit Yes Yes Yes   Global No
ft_stopword_file Yes Yes Yes   Global No
gdb Yes Yes        
general-log Yes Yes     Global Yes
- Variable: general_log     Yes   Global Yes
general_log_file     Yes   Global Yes
group_concat_max_len Yes Yes Yes   Both Yes
Handler_commit       Yes Both No
Handler_delete       Yes Both No
Handler_discover       Yes Both No
Handler_prepare       Yes Both No
Handler_read_first       Yes Both No
Handler_read_key       Yes Both No
Handler_read_next       Yes Both No
Handler_read_prev       Yes Both No
Handler_read_rnd       Yes Both No
Handler_read_rnd_next       Yes Both No
Handler_rollback       Yes Both No
Handler_savepoint       Yes Both No
Handler_savepoint_rollback       Yes Both No
Handler_update       Yes Both No
Handler_write       Yes Both No
have_compress     Yes   Global No
have_crypt     Yes   Global No
have_csv     Yes   Global No
have_dynamic_loading     Yes   Global No
have_geometry     Yes   Global No
have_innodb     Yes   Global No
have_ndbcluster     Yes   Global No
have_openssl     Yes   Global No
have_partitioning     Yes   Global No
have_query_cache     Yes   Global No
have_rtree_keys     Yes   Global No
have_ssl     Yes   Global No
have_symlink     Yes   Global No
help Yes          
hostname     Yes   Global No
identity     Yes   Session Yes
init_connect Yes Yes Yes   Global Yes
init-file Yes Yes     Global No
- Variable: init_file     Yes   Global No
init_slave Yes Yes Yes   Global Yes
innodb Yes Yes        
innodb_adaptive_hash_index Yes Yes Yes   Global No
innodb_additional_mem_pool_size Yes Yes Yes   Global No
innodb_autoextend_increment Yes Yes Yes   Global Yes
innodb_autoinc_lock_mode Yes Yes Yes   Global No
Innodb_buffer_pool_pages_data       Yes Global No
Innodb_buffer_pool_pages_dirty       Yes Global No
Innodb_buffer_pool_pages_flushed       Yes Global No
Innodb_buffer_pool_pages_free       Yes Global No
Innodb_buffer_pool_pages_latched       Yes Global No
Innodb_buffer_pool_pages_misc       Yes Global No
Innodb_buffer_pool_pages_total       Yes Global No
Innodb_buffer_pool_read_ahead_rnd       Yes Global No
Innodb_buffer_pool_read_ahead_seq       Yes Global No
Innodb_buffer_pool_read_requests       Yes Global No
Innodb_buffer_pool_reads       Yes Global No
innodb_buffer_pool_size Yes Yes Yes   Global No
Innodb_buffer_pool_wait_free       Yes Global No
Innodb_buffer_pool_write_requests       Yes Global No
innodb_checksums Yes Yes Yes   Global No
innodb_commit_concurrency Yes Yes Yes   Global Yes
innodb_concurrency_tickets Yes Yes Yes   Global Yes
innodb_data_file_path Yes Yes Yes   Global No
Innodb_data_fsyncs       Yes Global No
innodb_data_home_dir Yes Yes Yes   Global No
Innodb_data_pending_fsyncs       Yes Global No
Innodb_data_pending_reads       Yes Global No
Innodb_data_pending_writes       Yes Global No
Innodb_data_read       Yes Global No
Innodb_data_reads       Yes Global No
Innodb_data_writes       Yes Global No
Innodb_data_written       Yes Global No
Innodb_dblwr_pages_written       Yes Global No
Innodb_dblwr_writes       Yes Global No
innodb_doublewrite Yes Yes Yes   Global No
innodb_fast_shutdown Yes Yes Yes   Global Yes
innodb_file_io_threads Yes Yes Yes   Global No
innodb_file_per_table Yes Yes Yes   Global No
innodb_flush_log_at_trx_commit Yes Yes Yes   Global Yes
innodb_flush_method Yes Yes Yes   Global No
innodb_force_recovery Yes Yes Yes   Global No
innodb_locks_unsafe_for_binlog Yes Yes Yes   Global No
innodb_lock_wait_timeout Yes Yes Yes   Global No
innodb_log_buffer_size Yes Yes Yes   Global No
innodb_log_files_in_group Yes Yes Yes   Global No
innodb_log_file_size Yes Yes Yes   Global No
innodb_log_group_home_dir Yes Yes Yes   Global No
Innodb_log_waits       Yes Global No
Innodb_log_write_requests       Yes Global No
Innodb_log_writes       Yes Global No
innodb_max_dirty_pages_pct Yes Yes Yes   Global Yes
innodb_max_purge_lag Yes Yes Yes   Global Yes
innodb_mirrored_log_groups Yes Yes Yes   Global No
innodb_open_files Yes Yes Yes   Global No
Innodb_os_log_fsyncs       Yes Global No
Innodb_os_log_pending_fsyncs       Yes Global No
Innodb_os_log_pending_writes       Yes Global No
Innodb_os_log_written       Yes Global No
Innodb_pages_created       Yes Global No
Innodb_page_size       Yes Global No
Innodb_pages_read       Yes Global No
Innodb_pages_written       Yes Global No
innodb_rollback_on_timeout Yes Yes Yes   Global No
Innodb_row_lock_current_waits       Yes Global No
Innodb_row_lock_time       Yes Global No
Innodb_row_lock_time_avg       Yes Global No
Innodb_row_lock_time_max       Yes Global No
Innodb_row_lock_waits       Yes Global No
Innodb_rows_deleted       Yes Global No
Innodb_rows_inserted       Yes Global No
Innodb_rows_read       Yes Global No
Innodb_rows_updated       Yes Global No
innodb_stats_on_metadata Yes Yes Yes   Global No
innodb_status_file Yes Yes Yes   Global No
innodb_support_xa Yes Yes Yes   Both Yes
innodb_sync_spin_loops Yes Yes Yes   Global Yes
innodb_table_locks Yes Yes Yes   Both Yes
innodb_thread_concurrency Yes Yes Yes   Global Yes
innodb_thread_sleep_delay Yes Yes Yes   Global Yes
insert_id     Yes   Session Yes
interactive_timeout Yes Yes Yes   Both Yes
join_buffer_size Yes Yes Yes   Both Yes
keep_files_on_create Yes Yes Yes   Both Yes
Key_blocks_not_flushed       Yes Both No
Key_blocks_unused       Yes Both No
Key_blocks_used       Yes Both No
key_buffer_size Yes Yes Yes   Global Yes
key_cache_age_threshold Yes Yes Yes   Global Yes
key_cache_block_size Yes Yes Yes   Global Yes
key_cache_division_limit Yes Yes Yes   Global Yes
Key_read_requests       Yes Both No
Key_reads       Yes Both No
Key_write_requests       Yes Both No
Key_writes       Yes Both No
language Yes Yes Yes   Global No
large-pages Yes Yes     Global No
- Variable: large_pages     Yes   Global No
large_page_size     Yes   Global No
last_insert_id     Yes   Session Yes
Last_query_cost       Yes Both No
lc_time_names     Yes   Both Yes
license     Yes   Global No
local_infile     Yes   Global Yes
local-infile Yes Yes        
locked_in_memory     Yes   Global No
log Yes Yes Yes   Global Yes
log_bin     Yes   Global No
log-bin Yes Yes        
log-bin-index Yes Yes        
log-bin-trust-function-creators Yes Yes     Global Yes
- Variable: log_bin_trust_function_creators     Yes   Global Yes
log-error Yes Yes     Global No
- Variable: log_error     Yes   Global No
log-isam Yes Yes        
log-output Yes Yes     Global Yes
- Variable: log_output     Yes   Global Yes
log-queries-not-using-indexes Yes Yes     Global Yes
- Variable: log_queries_not_using_indexes     Yes   Global Yes
log-short-format Yes Yes        
log-slave-updates Yes Yes     Global No
- Variable: log_slave_updates     Yes   Global No
log-slow-admin-statements Yes Yes        
log-slow-queries Yes Yes     Global Yes
- Variable: log_slow_queries     Yes   Global Yes
log-slow-slave-statements Yes Yes        
log-tc Yes Yes        
log-tc-size Yes Yes        
log-warnings Yes Yes     Both Yes
- Variable: log_warnings     Yes   Both Yes
long_query_time Yes Yes Yes   Both Yes
lower_case_file_system Yes Yes Yes   Global No
lower_case_table_names Yes Yes Yes   Global No
low-priority-updates Yes Yes     Both Yes
- Variable: low_priority_updates     Yes   Both Yes
master-bind Yes Yes Yes     No
master-info-file Yes Yes        
master-retry-count Yes Yes        
max_allowed_packet Yes Yes Yes   Both Yes
max_binlog_cache_size Yes Yes Yes   Global Yes
max-binlog-dump-events Yes Yes        
max_binlog_size Yes Yes Yes   Global Yes
max_connect_errors Yes Yes Yes   Global Yes
max_connections Yes Yes Yes   Global Yes
max_delayed_threads Yes Yes Yes   Both Yes
max_error_count Yes Yes Yes   Both Yes
max_heap_table_size Yes Yes Yes   Both Yes
max_insert_delayed_threads     Yes   Both Yes
max_join_size Yes Yes Yes   Both Yes
max_length_for_sort_data Yes Yes Yes   Both Yes
max_prepared_stmt_count Yes Yes Yes   Global Yes
max_relay_log_size Yes Yes Yes   Global Yes
max_seeks_for_key Yes Yes Yes   Both Yes
max_sort_length Yes Yes Yes   Both Yes
max_sp_recursion_depth Yes Yes Yes   Both Yes
max_tmp_tables Yes Yes Yes   Both Yes
Max_used_connections       Yes Both No