Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual

MySQL 5.5 Reference Manual  /  ...  /  Server Option and Variable Reference

5.1.1 Server 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.

For a version of this table that is specific to MySQL Cluster, see Section 18.3.2.5, “MySQL Cluster mysqld Option and Variable Reference”.

Table 5.1 Option/Variable Summary

NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic
abort-slave-event-countYesYes
Aborted_clients YesGlobalNo
Aborted_connects YesGlobalNo
allow-suspicious-udfsYesYes
ansiYesYes
audit-logYesYes
audit_log_buffer_sizeYesYesYes GlobalNo
audit_log_fileYesYesYes GlobalNo
audit_log_flush Yes GlobalYes
audit_log_formatYesYesYes GlobalNo
audit_log_policyYesYesYes GlobalYes
audit_log_rotate_on_sizeYesYesYes GlobalYes
audit_log_strategyYesYesYes GlobalNo
authentication_windows_log_levelYesYes
authentication_windows_use_principal_nameYesYes
auto_increment_increment Yes BothYes
auto_increment_offset Yes BothYes
autocommitYesYesYes VariesYes
automatic_sp_privileges Yes GlobalYes
back_log Yes GlobalNo
basedirYesYesYes GlobalNo
big-tablesYesYes VariesYes
- Variable: big_tables Yes VariesYes
bind-addressYesYes
Binlog_cache_disk_use YesGlobalNo
binlog_cache_sizeYesYesYes GlobalYes
Binlog_cache_use YesGlobalNo
binlog_direct_non_transactional_updatesYesYesYes BothYes
binlog-do-dbYesYes
binlog-formatYesYes BothYes
- Variable: binlog_format Yes BothYes
binlog-ignore-dbYesYes
binlog-row-event-max-sizeYesYes
Binlog_stmt_cache_disk_use YesGlobalNo
binlog_stmt_cache_sizeYesYesYes GlobalYes
Binlog_stmt_cache_use YesGlobalNo
bootstrapYesYes
bulk_insert_buffer_sizeYesYesYes BothYes
Bytes_received YesBothNo
Bytes_sent YesBothNo
character_set_client Yes BothYes
character-set-client-handshakeYesYes
character_set_connection Yes BothYes
character_set_database[a] Yes BothYes
character-set-filesystemYesYes BothYes
- Variable: character_set_filesystem Yes BothYes
character_set_results Yes BothYes
character-set-serverYesYes BothYes
- Variable: character_set_server Yes BothYes
character_set_system Yes GlobalNo
character-sets-dirYesYes GlobalNo
- Variable: character_sets_dir Yes GlobalNo
chrootYesYes
collation_connection Yes BothYes
collation_database[b] Yes BothYes
collation-serverYesYes BothYes
- Variable: collation_server Yes BothYes
Com_admin_commands YesBothNo
Com_alter_db YesBothNo
Com_alter_db_upgrade YesBothNo
Com_alter_event YesBothNo
Com_alter_function YesBothNo
Com_alter_procedure YesBothNo
Com_alter_server YesBothNo
Com_alter_table YesBothNo
Com_alter_tablespace YesBothNo
Com_analyze YesBothNo
Com_assign_to_keycache YesBothNo
Com_begin YesBothNo
Com_binlog YesBothNo
Com_call_procedure YesBothNo
Com_change_db YesBothNo
Com_change_master YesBothNo
Com_check YesBothNo
Com_checksum YesBothNo
Com_commit YesBothNo
Com_create_db YesBothNo
Com_create_event YesBothNo
Com_create_function YesBothNo
Com_create_index YesBothNo
Com_create_procedure YesBothNo
Com_create_server YesBothNo
Com_create_table YesBothNo
Com_create_trigger YesBothNo
Com_create_udf YesBothNo
Com_create_user YesBothNo
Com_create_view YesBothNo
Com_dealloc_sql YesBothNo
Com_delete YesBothNo
Com_delete_multi YesBothNo
Com_do YesBothNo
Com_drop_db YesBothNo
Com_drop_event YesBothNo
Com_drop_function YesBothNo
Com_drop_index YesBothNo
Com_drop_procedure YesBothNo
Com_drop_server YesBothNo
Com_drop_table YesBothNo
Com_drop_trigger YesBothNo
Com_drop_user YesBothNo
Com_drop_view YesBothNo
Com_empty_query YesBothNo
Com_execute_sql YesBothNo
Com_flush YesBothNo
Com_grant YesBothNo
Com_ha_close YesBothNo
Com_ha_open YesBothNo
Com_ha_read YesBothNo
Com_help YesBothNo
Com_insert YesBothNo
Com_insert_select YesBothNo
Com_install_plugin YesBothNo
Com_kill YesBothNo
Com_load YesBothNo
Com_lock_tables YesBothNo
Com_optimize YesBothNo
Com_preload_keys YesBothNo
Com_prepare_sql YesBothNo
Com_purge YesBothNo
Com_purge_before_date YesBothNo
Com_release_savepoint YesBothNo
Com_rename_table YesBothNo
Com_rename_user YesBothNo
Com_repair YesBothNo
Com_replace YesBothNo
Com_replace_select YesBothNo
Com_reset YesBothNo
Com_resignal YesBothNo
Com_revoke YesBothNo
Com_revoke_all YesBothNo
Com_rollback YesBothNo
Com_rollback_to_savepoint YesBothNo
Com_savepoint YesBothNo
Com_select YesBothNo
Com_set_option YesBothNo
Com_show_authors YesBothNo
Com_show_binlog_events YesBothNo
Com_show_binlogs YesBothNo
Com_show_charsets YesBothNo
Com_show_collations YesBothNo
Com_show_contributors YesBothNo
Com_show_create_db YesBothNo
Com_show_create_event YesBothNo
Com_show_create_func YesBothNo
Com_show_create_proc YesBothNo
Com_show_create_table YesBothNo
Com_show_create_trigger YesBothNo
Com_show_databases YesBothNo
Com_show_engine_logs YesBothNo
Com_show_engine_mutex YesBothNo
Com_show_engine_status YesBothNo
Com_show_errors YesBothNo
Com_show_events YesBothNo
Com_show_fields YesBothNo
Com_show_function_code YesBothNo
Com_show_function_status YesBothNo
Com_show_grants YesBothNo
Com_show_keys YesBothNo
Com_show_master_status YesBothNo
Com_show_ndb_status YesBothNo
Com_show_new_master YesBothNo
Com_show_open_tables YesBothNo
Com_show_plugins YesBothNo
Com_show_privileges YesBothNo
Com_show_procedure_code YesBothNo
Com_show_procedure_status YesBothNo
Com_show_processlist YesBothNo
Com_show_profile YesBothNo
Com_show_profiles YesBothNo
Com_show_relaylog_events YesBothNo
Com_show_slave_hosts YesBothNo
Com_show_slave_status YesBothNo
Com_show_status YesBothNo
Com_show_storage_engines YesBothNo
Com_show_table_status YesBothNo
Com_show_tables YesBothNo
Com_show_triggers YesBothNo
Com_show_variables YesBothNo
Com_show_warnings YesBothNo
Com_signal YesBothNo
Com_slave_start YesBothNo
Com_slave_stop YesBothNo
Com_stmt_close YesBothNo
Com_stmt_execute YesBothNo
Com_stmt_fetch YesBothNo
Com_stmt_prepare YesBothNo
Com_stmt_reprepare YesBothNo
Com_stmt_reset YesBothNo
Com_stmt_send_long_data YesBothNo
Com_truncate YesBothNo
Com_uninstall_plugin YesBothNo
Com_unlock_tables YesBothNo
Com_update YesBothNo
Com_update_multi YesBothNo
Com_xa_commit YesBothNo
Com_xa_end YesBothNo
Com_xa_prepare YesBothNo
Com_xa_recover YesBothNo
Com_xa_rollback YesBothNo
Com_xa_start YesBothNo
completion_typeYesYesYes BothYes
Compression YesSessionNo
concurrent_insertYesYesYes GlobalYes
connect_timeoutYesYesYes GlobalYes
Connections YesGlobalNo
consoleYesYes
core-fileYesYes
Created_tmp_disk_tables YesBothNo
Created_tmp_files YesGlobalNo
Created_tmp_tables YesBothNo
datadirYesYesYes GlobalNo
date_format Yes VariesNo
datetime_format Yes VariesNo
debugYesYesYes BothYes
debug_sync Yes VariesYes
debug-sync-timeoutYesYes
default-character-setYesYes
default-storage-engineYesYes BothYes
- Variable: default_storage_engine Yes BothYes
default-time-zoneYesYes
default_week_formatYesYesYes BothYes
defaults-extra-fileYes
defaults-fileYes
defaults-group-suffixYes
delay-key-writeYesYes GlobalYes
- Variable: delay_key_write Yes GlobalYes
Delayed_errors YesGlobalNo
delayed_insert_limitYesYesYes GlobalYes
Delayed_insert_threads YesGlobalNo
delayed_insert_timeoutYesYesYes GlobalYes
delayed_queue_sizeYesYesYes GlobalYes
Delayed_writes YesGlobalNo
des-key-fileYesYes
disconnect-slave-event-countYesYes
div_precision_incrementYesYesYes BothYes
enable-lockingYesYes
enable-named-pipeYesYes
- Variable: named_pipe
enable-pstackYesYes
engine-condition-pushdownYesYes BothYes
- Variable: engine_condition_pushdown Yes BothYes
error_count Yes SessionNo
event-schedulerYesYes GlobalYes
- Variable: event_scheduler Yes GlobalYes
exit-infoYesYes
expire_logs_daysYesYesYes GlobalYes
external-lockingYesYes
- Variable: skip_external_locking
external_user Yes SessionNo
federatedYesYes
flushYesYesYes GlobalYes
Flush_commands YesGlobalNo
flush_timeYesYesYes GlobalYes
foreign_key_checks Yes VariesYes
ft_boolean_syntaxYesYesYes GlobalYes
ft_max_word_lenYesYesYes GlobalNo
ft_min_word_lenYesYesYes GlobalNo
ft_query_expansion_limitYesYesYes GlobalNo
ft_stopword_fileYesYesYes GlobalNo
gdbYesYes
general-logYesYes GlobalYes
- Variable: general_log Yes GlobalYes
general_log_fileYesYesYes GlobalYes
group_concat_max_lenYesYesYes BothYes
Handler_commit YesBothNo
Handler_delete YesBothNo
Handler_discover YesBothNo
Handler_prepare YesBothNo
Handler_read_first YesBothNo
Handler_read_key YesBothNo
Handler_read_last YesBothNo
Handler_read_next YesBothNo
Handler_read_prev YesBothNo
Handler_read_rnd YesBothNo
Handler_read_rnd_next YesBothNo
Handler_rollback YesBothNo
Handler_savepoint YesBothNo
Handler_savepoint_rollback YesBothNo
Handler_update YesBothNo
Handler_write YesBothNo
have_compress Yes GlobalNo
have_crypt Yes GlobalNo
have_csv Yes GlobalNo
have_dynamic_loading Yes GlobalNo
have_geometry Yes GlobalNo
have_innodb Yes GlobalNo
have_ndbcluster Yes GlobalNo
have_openssl Yes GlobalNo
have_partitioning Yes GlobalNo
have_profiling Yes GlobalNo
have_query_cache Yes GlobalNo
have_rtree_keys Yes GlobalNo
have_ssl Yes GlobalNo
have_symlink Yes GlobalNo
helpYesYes
hostname Yes GlobalNo
identity Yes SessionYes
ignore-builtin-innodbYesYes GlobalNo
- Variable: ignore_builtin_innodb Yes GlobalNo
init_connectYesYesYes GlobalYes
init-fileYesYes GlobalNo
- Variable: init_file Yes GlobalNo
init-rpl-roleYesYes
init_slaveYesYesYes GlobalYes
innodbYesYes
innodb_adaptive_flushingYesYesYes GlobalYes
innodb_adaptive_hash_indexYesYesYes GlobalYes
innodb_additional_mem_pool_sizeYesYesYes GlobalNo
innodb_autoextend_incrementYesYesYes GlobalYes
innodb_autoinc_lock_modeYesYesYes GlobalNo
Innodb_buffer_pool_bytes_data YesGlobalNo
Innodb_buffer_pool_bytes_dirty YesGlobalNo
innodb_buffer_pool_instancesYesYesYes GlobalNo
Innodb_buffer_pool_pages_data YesGlobalNo
Innodb_buffer_pool_pages_dirty YesGlobalNo
Innodb_buffer_pool_pages_flushed YesGlobalNo
Innodb_buffer_pool_pages_free YesGlobalNo
Innodb_buffer_pool_pages_latched YesGlobalNo
Innodb_buffer_pool_pages_misc YesGlobalNo
Innodb_buffer_pool_pages_total YesGlobalNo
Innodb_buffer_pool_read_ahead YesGlobalNo
Innodb_buffer_pool_read_ahead_evicted YesGlobalNo
Innodb_buffer_pool_read_requests YesGlobalNo
Innodb_buffer_pool_reads YesGlobalNo
innodb_buffer_pool_sizeYesYesYes GlobalNo
Innodb_buffer_pool_wait_free YesGlobalNo
Innodb_buffer_pool_write_requests YesGlobalNo
innodb_change_bufferingYesYesYes GlobalYes
innodb_change_buffering_debugYesYesYes GlobalYes
innodb_checksumsYesYesYes GlobalNo
innodb_commit_concurrencyYesYesYes GlobalYes
innodb_concurrency_ticketsYesYesYes GlobalYes
innodb_data_file_pathYesYesYes GlobalNo
Innodb_data_fsyncs YesGlobalNo
innodb_data_home_dirYesYesYes GlobalNo
Innodb_data_pending_fsyncs YesGlobalNo
Innodb_data_pending_reads YesGlobalNo
Innodb_data_pending_writes YesGlobalNo
Innodb_data_read YesGlobalNo
Innodb_data_reads YesGlobalNo
Innodb_data_writes YesGlobalNo
Innodb_data_written YesGlobalNo
Innodb_dblwr_pages_written YesGlobalNo
Innodb_dblwr_writes YesGlobalNo
innodb_doublewriteYesYesYes GlobalNo
innodb_fast_shutdownYesYesYes GlobalYes
innodb_file_formatYesYesYes GlobalYes
innodb_file_format_checkYesYesYes GlobalVaries
innodb_file_format_maxYesYesYes GlobalYes
innodb_file_per_tableYesYesYes GlobalYes
innodb_flush_log_at_trx_commitYesYesYes GlobalYes
innodb_flush_methodYesYesYes GlobalNo
innodb_force_load_corruptedYesYesYes GlobalNo
innodb_force_recoveryYesYesYes GlobalNo
Innodb_have_atomic_builtins YesGlobalNo
innodb_io_capacityYesYesYes GlobalYes
innodb_large_prefixYesYesYes GlobalYes
innodb_limit_optimistic_insert_debugYesYesYes GlobalYes
innodb_lock_wait_timeoutYesYesYes BothYes
innodb_locks_unsafe_for_binlogYesYesYes GlobalNo
innodb_log_buffer_sizeYesYesYes GlobalNo
innodb_log_file_sizeYesYesYes GlobalNo
innodb_log_files_in_groupYesYesYes GlobalNo
innodb_log_group_home_dirYesYesYes GlobalNo
Innodb_log_waits YesGlobalNo
Innodb_log_write_requests YesGlobalNo
Innodb_log_writes YesGlobalNo
innodb_max_dirty_pages_pctYesYesYes GlobalYes
innodb_max_purge_lagYesYesYes GlobalYes
innodb_mirrored_log_groupsYesYesYes GlobalNo
innodb_old_blocks_pctYesYesYes GlobalYes
innodb_old_blocks_timeYesYesYes GlobalYes
innodb_open_filesYesYesYes GlobalNo
Innodb_os_log_fsyncs YesGlobalNo
Innodb_os_log_pending_fsyncs YesGlobalNo
Innodb_os_log_pending_writes YesGlobalNo
Innodb_os_log_written YesGlobalNo
Innodb_page_size YesGlobalNo
Innodb_pages_created YesGlobalNo
Innodb_pages_read YesGlobalNo
Innodb_pages_written YesGlobalNo
innodb_print_all_deadlocksYesYesYes GlobalYes
innodb_purge_batch_sizeYesYesYes GlobalYes
innodb_purge_threadsYesYesYes GlobalNo
innodb_random_read_aheadYesYesYes GlobalYes
innodb_read_ahead_thresholdYesYesYes GlobalYes
innodb_read_io_threadsYesYesYes GlobalNo
innodb_replication_delayYesYesYes GlobalYes
innodb_rollback_on_timeoutYesYesYes GlobalNo
innodb_rollback_segmentsYesYesYes GlobalYes
Innodb_row_lock_current_waits YesGlobalNo
Innodb_row_lock_time YesGlobalNo
Innodb_row_lock_time_avg YesGlobalNo
Innodb_row_lock_time_max YesGlobalNo
Innodb_row_lock_waits YesGlobalNo
Innodb_rows_deleted YesGlobalNo
Innodb_rows_inserted YesGlobalNo
Innodb_rows_read YesGlobalNo
Innodb_rows_updated YesGlobalNo
innodb_spin_wait_delayYesYesYes GlobalYes
innodb_stats_methodYesYesYes GlobalYes
innodb_stats_on_metadataYesYesYes GlobalYes
innodb_stats_sample_pagesYesYesYes GlobalYes
innodb-status-fileYesYes
innodb_strict_modeYesYesYes BothYes
innodb_support_xaYesYesYes BothYes
innodb_sync_spin_loopsYesYesYes GlobalYes
innodb_table_locksYesYesYes BothYes
innodb_thread_concurrencyYesYesYes GlobalYes
innodb_thread_sleep_delayYesYesYes GlobalYes
Innodb_truncated_status_writes YesGlobalNo
innodb_trx_purge_view_update_only_debugYesYesYes GlobalYes
innodb_trx_rseg_n_slots_debugYesYesYes GlobalYes
innodb_use_native_aioYesYesYes GlobalNo
innodb_use_sys_mallocYesYesYes GlobalNo
innodb_version Yes GlobalNo
innodb_write_io_threadsYesYesYes GlobalNo
insert_id Yes SessionYes
installYes
install-manualYes
interactive_timeoutYesYesYes BothYes
join_buffer_sizeYesYesYes BothYes
keep_files_on_createYesYesYes BothYes
Key_blocks_not_flushed YesGlobalNo
Key_blocks_unused YesGlobalNo
Key_blocks_used YesGlobalNo
key_buffer_sizeYesYesYes GlobalYes
key_cache_age_thresholdYesYesYes GlobalYes
key_cache_block_sizeYesYesYes GlobalYes
key_cache_division_limitYesYesYes GlobalYes
Key_read_requests YesGlobalNo
Key_reads YesGlobalNo
Key_write_requests YesGlobalNo
Key_writes YesGlobalNo
languageYesYesYes GlobalNo
large_files_support Yes GlobalNo
large_page_size Yes GlobalNo
large-pagesYesYes GlobalNo
- Variable: large_pages Yes GlobalNo
last_insert_id Yes SessionYes
Last_query_cost YesSessionNo
lc-messagesYesYes BothYes
- Variable: lc_messages Yes BothYes
lc-messages-dirYesYes GlobalNo
- Variable: lc_messages_dir Yes GlobalNo
lc_time_names Yes BothYes
license Yes GlobalNo
local_infile Yes GlobalYes
local-serviceYes
lock_wait_timeoutYesYesYes BothYes
locked_in_memory Yes GlobalNo
logYesYesYes GlobalYes
log-binYesYesYes GlobalNo
log_bin Yes GlobalNo
log-bin-indexYesYes
log-bin-trust-function-creatorsYesYes GlobalYes
- Variable: log_bin_trust_function_creators Yes GlobalYes
log-bin-trust-routine-creatorsYesYes GlobalYes
- Variable: log_bin_trust_routine_creators Yes GlobalYes
log-bin-use-v1-row-eventsYesYes GlobalNo
- Variable: log_bin_use_v1_row_events Yes GlobalNo
log_bin_use_v1_row_eventsYesYesYes GlobalNo
log-errorYesYes GlobalNo
- Variable: log_error Yes GlobalNo
log-isamYesYes
log-outputYesYes GlobalYes
- Variable: log_output Yes GlobalYes
log-queries-not-using-indexesYesYes GlobalYes
- Variable: log_queries_not_using_indexes Yes GlobalYes
log-short-formatYesYes
log-slave-updatesYesYes GlobalNo
- Variable: log_slave_updates Yes GlobalNo
log_slave_updatesYesYesYes GlobalNo
log-slow-admin-statementsYesYes
log-slow-queriesYesYes GlobalYes
- Variable: log_slow_queries Yes GlobalYes
log-slow-slave-statementsYesYes
log-tcYesYes
log-tc-sizeYesYes
log-warningsYesYes BothYes
- Variable: log_warnings Yes BothYes
long_query_timeYesYesYes BothYes
low-priority-updatesYesYes BothYes
- Variable: low_priority_updates Yes BothYes
lower_case_file_system Yes GlobalNo
lower_case_table_namesYesYesYes GlobalNo
master-connect-retryYesYes
master-hostYesYes
master-info-fileYesYes
master-passwordYesYes
master-portYesYes
master-retry-countYesYes
master-sslYesYes
master-ssl-caYesYes
master-ssl-capathYesYes
master-ssl-certYesYes
master-ssl-cipherYesYes
master-ssl-keyYesYes
master-userYesYes
max_allowed_packetYesYesYes BothYes
max_binlog_cache_sizeYesYesYes GlobalYes
max-binlog-dump-eventsYesYes
max_binlog_sizeYesYesYes GlobalYes
max_binlog_stmt_cache_sizeYesYesYes GlobalYes
max_connect_errorsYesYesYes GlobalYes
max_connectionsYesYesYes GlobalYes
max_delayed_threadsYesYesYes BothYes
max_error_countYesYesYes BothYes
max_heap_table_sizeYesYesYes BothYes
max_insert_delayed_threads Yes BothYes
max_join_sizeYesYesYes BothYes
max_length_for_sort_dataYesYesYes BothYes
max_long_data_sizeYesYesYes GlobalNo
max_prepared_stmt_countYesYesYes GlobalYes
max_relay_log_sizeYesYesYes GlobalYes
max_seeks_for_keyYesYesYes BothYes
max_sort_lengthYesYesYes BothYes
max_sp_recursion_depthYesYesYes BothYes
max_tmp_tables Yes BothYes
Max_used_connections YesGlobalNo
max_user_connectionsYesYesYes BothYes
max_write_lock_countYesYesYes GlobalYes
memlockYesYes
- Variable: locked_in_memory
metadata_locks_cache_size Yes GlobalNo
min-examined-row-limitYesYesYes BothYes
multi_range_countYesYesYes BothYes
myisam-block-sizeYesYes
myisam_data_pointer_sizeYesYesYes GlobalYes
myisam_max_sort_file_sizeYesYesYes GlobalYes
myisam_mmap_sizeYesYesYes GlobalNo
myisam-recoverYesYes
- Variable: myisam_recover_options
myisam-recover-optionsYesYes
- Variable: myisam_recover_options
myisam_recover_options Yes GlobalNo
myisam_repair_threadsYesYesYes BothYes
myisam_sort_buffer_sizeYesYesYes BothYes
myisam_stats_methodYesYesYes BothYes
myisam_use_mmapYesYesYes GlobalYes
named_pipe Yes GlobalNo
Ndb_api_bytes_received_count YesGlobalNo
Ndb_api_bytes_received_count_session YesSessionNo
Ndb_api_bytes_received_count_slave YesGlobalNo
Ndb_api_bytes_sent_count YesGlobalNo
Ndb_api_bytes_sent_count_session YesSessionNo
Ndb_api_bytes_sent_count_slave YesGlobalNo
Ndb_api_event_bytes_count YesGlobalNo
Ndb_api_event_bytes_count_injector YesGlobalNo
Ndb_api_event_data_count YesGlobalNo
Ndb_api_event_data_count_injector YesGlobalNo
Ndb_api_event_nondata_count YesGlobalNo
Ndb_api_event_nondata_count_injector YesGlobalNo
Ndb_api_pk_op_count YesGlobalNo
Ndb_api_pk_op_count_session YesSessionNo
Ndb_api_pk_op_count_slave YesGlobalNo
Ndb_api_pruned_scan_count YesGlobalNo
Ndb_api_pruned_scan_count_session YesSessionNo
Ndb_api_pruned_scan_count_slave YesGlobalNo
Ndb_api_range_scan_count YesGlobalNo
Ndb_api_range_scan_count_session YesSessionNo
Ndb_api_range_scan_count_slave YesGlobalNo
Ndb_api_read_row_count YesGlobalNo
Ndb_api_read_row_count_session YesSessionNo
Ndb_api_read_row_count_slave YesGlobalNo
Ndb_api_scan_batch_count YesGlobalNo
Ndb_api_scan_batch_count_session YesSessionNo
Ndb_api_scan_batch_count_slave YesGlobalNo
Ndb_api_table_scan_count YesGlobalNo
Ndb_api_table_scan_count_session YesSessionNo
Ndb_api_table_scan_count_slave YesGlobalNo
Ndb_api_trans_abort_count YesGlobalNo
Ndb_api_trans_abort_count_session YesSessionNo
Ndb_api_trans_abort_count_slave YesGlobalNo
Ndb_api_trans_close_count YesGlobalNo
Ndb_api_trans_close_count_session YesSessionNo
Ndb_api_trans_close_count_slave YesGlobalNo
Ndb_api_trans_commit_count YesGlobalNo
Ndb_api_trans_commit_count_session YesSessionNo
Ndb_api_trans_commit_count_slave YesGlobalNo
Ndb_api_trans_local_read_row_count YesGlobalNo
Ndb_api_trans_local_read_row_count_session YesSessionNo
Ndb_api_trans_local_read_row_count_slave YesGlobalNo
Ndb_api_trans_start_count YesGlobalNo
Ndb_api_trans_start_count_session YesSessionNo
Ndb_api_trans_start_count_slave YesGlobalNo
Ndb_api_uk_op_count YesGlobalNo
Ndb_api_uk_op_count_session YesSessionNo
Ndb_api_uk_op_count_slave YesGlobalNo
Ndb_api_wait_exec_complete_count YesGlobalNo
Ndb_api_wait_exec_complete_count_session YesSessionNo
Ndb_api_wait_exec_complete_count_slave YesGlobalNo
Ndb_api_wait_meta_request_count YesGlobalNo
Ndb_api_wait_meta_request_count_session YesSessionNo
Ndb_api_wait_meta_request_count_slave YesGlobalNo
Ndb_api_wait_nanos_count YesGlobalNo
Ndb_api_wait_nanos_count_session YesSessionNo
Ndb_api_wait_nanos_count_slave YesGlobalNo
Ndb_api_wait_scan_result_count YesGlobalNo
Ndb_api_wait_scan_result_count_session YesSessionNo
Ndb_api_wait_scan_result_count_slave YesGlobalNo
ndb_autoincrement_prefetch_szYesYesYes BothYes
ndb-batch-sizeYesYesYes GlobalNo
ndb-blob-read-batch-bytesYesYesYes BothYes
ndb-blob-write-batch-bytesYesYesYes BothYes
ndb_cache_check_timeYesYesYes GlobalYes
ndb-cluster-connection-poolYesYesYes GlobalNo
Ndb_cluster_node_id YesBothNo
Ndb_config_from_host YesBothNo
Ndb_config_from_port YesBothNo
Ndb_conflict_fn_epoch YesGlobalNo
Ndb_conflict_fn_epoch_trans YesGlobalNo
Ndb_conflict_fn_max YesGlobalNo
Ndb_conflict_fn_old YesGlobalNo
Ndb_conflict_trans_conflict_commit_count YesGlobalNo
Ndb_conflict_trans_detect_iter_count YesGlobalNo
Ndb_conflict_trans_reject_count YesGlobalNo
Ndb_conflict_trans_row_reject_count YesGlobalNo
ndb-connectstringYesYes
ndb-deferred-constraintsYesYes BothYes
- Variable: ndb_deferred_constraints Yes BothYes
ndb_deferred_constraintsYesYesYes BothYes
ndb-distributionYesYes GlobalYes
- Variable: ndb_distribution Yes GlobalYes
ndb_distributionYesYesYes GlobalYes
ndb_eventbuffer_max_allocYesYesYes GlobalYes
Ndb_execute_count YesGlobalNo
ndb_extra_loggingYesYesYes GlobalYes
ndb_force_sendYesYesYes BothYes
ndb_index_stat_cache_entriesYesYesYes BothYes
ndb_index_stat_enableYesYesYes BothYes
ndb_index_stat_optionYesYesYes BothYes
ndb_index_stat_update_freqYesYesYes BothYes
ndb_join_pushdown Yes BothYes
ndb-log-apply-statusYesYes GlobalNo
- Variable: ndb_log_apply_status Yes GlobalNo
ndb_log_apply_statusYesYesYes GlobalNo
ndb_log_binYes Yes BothYes
ndb_log_binlog_indexYes Yes GlobalYes
ndb-log-empty-epochsYesYesYes GlobalYes
ndb_log_empty_epochsYesYesYes GlobalYes
ndb-log-origYesYes GlobalNo
- Variable: ndb_log_orig Yes GlobalNo
ndb_log_origYesYesYes GlobalNo
ndb-log-transaction-idYesYes GlobalNo
- Variable: ndb_log_transaction_id Yes GlobalNo
ndb_log_transaction_id Yes GlobalNo
ndb-log-update-as-writeYesYesYes GlobalYes
ndb_log_updated_onlyYesYesYes GlobalYes
ndb-mgmd-hostYesYes
ndb-nodeidYesYes YesGlobalNo
Ndb_number_of_data_nodes YesGlobalNo
ndb_optimization_delay Yes GlobalYes
ndb_optimized_node_selectionYesYesYes GlobalNo
Ndb_pruned_scan_count YesGlobalNo
Ndb_pushed_queries_defined YesGlobalNo
Ndb_pushed_queries_dropped YesGlobalNo
Ndb_pushed_queries_executed YesGlobalNo
Ndb_pushed_reads YesGlobalNo
ndb_report_thresh_binlog_epoch_slipYesYes
ndb_report_thresh_binlog_mem_usageYesYes
Ndb_scan_count YesGlobalNo
ndb_table_no_logging Yes SessionYes
ndb_table_temporary Yes SessionYes
ndb-transid-mysql-connection-mapYes
ndb_use_copying_alter_table Yes BothNo
ndb_use_exact_count Yes BothYes
ndb_use_transactionsYesYesYes BothYes
ndb_version Yes GlobalNo
ndb_version_string Yes GlobalNo
ndb-wait-connectedYesYesYes GlobalNo
ndb-wait-setupYesYesYes GlobalNo
ndbclusterYesYes
- Variable: have_ndbcluster
ndbinfo_database Yes GlobalNo
ndbinfo_max_bytesYes Yes BothYes
ndbinfo_max_rowsYes Yes BothYes
ndbinfo_offline Yes GlobalYes
ndbinfo_show_hiddenYes Yes BothYes
ndbinfo_table_prefixYes Yes BothYes
ndbinfo_version Yes GlobalNo
net_buffer_lengthYesYesYes BothYes
net_read_timeoutYesYesYes BothYes
net_retry_countYesYesYes BothYes
net_write_timeoutYesYesYes BothYes
newYesYesYes BothYes
no-defaultsYes
Not_flushed_delayed_rows YesGlobalNo
oldYesYesYes GlobalNo
old-alter-tableYesYes BothYes
- Variable: old_alter_table Yes BothYes
old_passwords Yes BothYes
old-style-user-limitsYesYes
one-threadYesYes
Open_files YesGlobalNo
open-files-limitYesYes GlobalNo
- Variable: open_files_limit Yes GlobalNo
Open_streams YesGlobalNo
Open_table_definitions YesGlobalNo
Open_tables YesBothNo
Opened_files YesGlobalNo
Opened_table_definitions YesBothNo
Opened_tables YesBothNo
optimizer_prune_levelYesYesYes BothYes
optimizer_search_depthYesYesYes BothYes
optimizer_switchYesYesYes BothYes
partitionYesYes
- Variable: have_partitioning
performance_schemaYesYesYes GlobalNo
Performance_schema_cond_classes_lost YesGlobalNo
Performance_schema_cond_instances_lost YesGlobalNo
performance_schema_events_waits_history_long_sizeYesYesYes GlobalNo
performance_schema_events_waits_history_sizeYesYesYes GlobalNo
Performance_schema_file_classes_lost YesGlobalNo
Performance_schema_file_handles_lost YesGlobalNo
Performance_schema_file_instances_lost YesGlobalNo
Performance_schema_locker_lost YesGlobalNo
performance_schema_max_cond_classesYesYesYes GlobalNo
performance_schema_max_cond_instancesYesYesYes GlobalNo
performance_schema_max_file_classesYesYesYes GlobalNo
performance_schema_max_file_handlesYesYesYes GlobalNo
performance_schema_max_file_instancesYesYesYes GlobalNo
performance_schema_max_mutex_classesYesYesYes GlobalNo
performance_schema_max_mutex_instancesYesYesYes GlobalNo
performance_schema_max_rwlock_classesYesYesYes GlobalNo
performance_schema_max_rwlock_instancesYesYesYes GlobalNo
performance_schema_max_table_handlesYesYesYes GlobalNo
performance_schema_max_table_instancesYesYesYes GlobalNo
performance_schema_max_thread_classesYesYesYes GlobalNo
performance_schema_max_thread_instancesYesYesYes GlobalNo
Performance_schema_mutex_classes_lost YesGlobalNo
Performance_schema_mutex_instances_lost YesGlobalNo
Performance_schema_rwlock_classes_lost YesGlobalNo
Performance_schema_rwlock_instances_lost YesGlobalNo
Performance_schema_table_handles_lost YesGlobalNo
Performance_schema_table_instances_lost YesGlobalNo
Performance_schema_thread_classes_lost YesGlobalNo
Performance_schema_thread_instances_lost YesGlobalNo
pid-fileYesYes GlobalNo
- Variable: pid_file Yes GlobalNo
pluginYesYes
plugin_dirYesYesYes GlobalNo
plugin-loadYesYes
portYesYesYes GlobalNo
port-open-timeoutYesYes
preload_buffer_sizeYesYesYes BothYes
Prepared_stmt_count YesGlobalNo
print-defaultsYes
profiling Yes VariesYes
profiling_history_sizeYesYesYes BothYes
protocol_version Yes GlobalNo
proxy_user Yes SessionNo
pseudo_slave_mode Yes SessionYes
pseudo_thread_id Yes SessionYes
Qcache_free_blocks YesGlobalNo
Qcache_free_memory YesGlobalNo
Qcache_hits YesGlobalNo
Qcache_inserts YesGlobalNo
Qcache_lowmem_prunes YesGlobalNo
Qcache_not_cached YesGlobalNo
Qcache_queries_in_cache YesGlobalNo
Qcache_total_blocks YesGlobalNo
Queries YesBothNo
query_alloc_block_sizeYesYesYes BothYes
query_cache_limitYesYesYes GlobalYes
query_cache_min_res_unitYesYesYes GlobalYes
query_cache_sizeYesYesYes GlobalYes
query_cache_typeYesYesYes BothYes
query_cache_wlock_invalidateYesYesYes BothYes
query_prealloc_sizeYesYesYes BothYes
Questions YesBothNo
rand_seed1 Yes SessionYes
rand_seed2 Yes SessionYes
range_alloc_block_sizeYesYesYes BothYes
read_buffer_sizeYesYesYes BothYes
read_onlyYesYesYes GlobalYes
read_rnd_buffer_sizeYesYesYes BothYes
relay-logYesYes GlobalNo
- Variable: relay_log Yes GlobalNo
relay-log-indexYesYes GlobalNo
- Variable: relay_log_index Yes GlobalNo
relay_log_indexYesYesYes GlobalNo
relay-log-info-fileYesYes
- Variable: relay_log_info_file
relay_log_info_fileYesYesYes GlobalNo
relay_log_purgeYesYesYes GlobalYes
relay-log-recoveryYesYes
- Variable: relay_log_recovery
relay_log_recoveryYesYesYes GlobalYes
relay_log_space_limitYesYesYes GlobalNo
removeYes
replicate-do-dbYesYes
replicate-do-tableYesYes
replicate-ignore-dbYesYes
replicate-ignore-tableYesYes
replicate-rewrite-dbYesYes
replicate-same-server-idYesYes
replicate-wild-do-tableYesYes
replicate-wild-ignore-tableYesYes
report-hostYesYes GlobalNo
- Variable: report_host Yes GlobalNo
report-passwordYesYes GlobalNo
- Variable: report_password Yes GlobalNo
report-portYesYes GlobalNo
- Variable: report_port Yes GlobalNo
report-userYesYes GlobalNo
- Variable: report_user Yes GlobalNo
rpl_recovery_rank Yes GlobalYes
Rpl_semi_sync_master_clients YesGlobalNo
rpl_semi_sync_master_enabled Yes GlobalYes
Rpl_semi_sync_master_net_avg_wait_time YesGlobalNo
Rpl_semi_sync_master_net_wait_time YesGlobalNo
Rpl_semi_sync_master_net_waits YesGlobalNo
Rpl_semi_sync_master_no_times YesGlobalNo
Rpl_semi_sync_master_no_tx YesGlobalNo
Rpl_semi_sync_master_status YesGlobalNo
Rpl_semi_sync_master_timefunc_failures YesGlobalNo
rpl_semi_sync_master_timeout Yes GlobalYes
rpl_semi_sync_master_trace_level Yes GlobalYes
Rpl_semi_sync_master_tx_avg_wait_time YesGlobalNo
Rpl_semi_sync_master_tx_wait_time YesGlobalNo
Rpl_semi_sync_master_tx_waits YesGlobalNo
rpl_semi_sync_master_wait_no_slave Yes GlobalYes
Rpl_semi_sync_master_wait_pos_backtraverse YesGlobalNo
Rpl_semi_sync_master_wait_sessions YesGlobalNo
Rpl_semi_sync_master_yes_tx YesGlobalNo
rpl_semi_sync_slave_enabled Yes GlobalYes
Rpl_semi_sync_slave_status YesGlobalNo
rpl_semi_sync_slave_trace_level Yes GlobalYes
Rpl_status YesGlobalNo
safe-modeYesYes
safe-show-databaseYesYes
safe-user-createYesYes
safemalloc-mem-limitYesYes
secure-authYesYes GlobalYes
- Variable: secure_auth Yes GlobalYes
secure-file-privYesYes GlobalNo
- Variable: secure_file_priv Yes GlobalNo
Select_full_join YesBothNo
Select_full_range_join YesBothNo
Select_range YesBothNo
Select_range_check YesBothNo
Select_scan YesBothNo
server-idYesYes GlobalYes
- Variable: server_id Yes GlobalYes
server-id-bitsYesYes GlobalNo
- Variable: server_id_bits Yes GlobalNo
server_id_bitsYesYesYes GlobalNo
set-variableYesYes
shared_memoryYesYesYes GlobalNo
shared_memory_base_nameYesYesYes GlobalNo
show-slave-auth-infoYesYes
skip-character-set-client-handshakeYesYes
skip-concurrent-insertYesYes
- Variable: concurrent_insert
skip-event-schedulerYesYes
skip_external_lockingYesYesYes GlobalNo
skip-grant-tablesYesYes
skip-host-cacheYesYes
skip-lockingYesYes
skip-name-resolveYesYes GlobalNo
- Variable: skip_name_resolve Yes GlobalNo
skip-ndbclusterYesYes
skip-networkingYesYes GlobalNo
- Variable: skip_networking Yes GlobalNo
skip-newYesYes
skip-partitionYesYes
skip-safemallocYesYes
skip-show-databaseYesYes GlobalNo
- Variable: skip_show_database Yes GlobalNo
skip-slave-startYesYes
skip-sslYesYes
skip-stack-traceYesYes
skip-symbolic-linksYes
skip-symlinkYesYes
skip-thread-priorityYesYes
slave_allow_batchingYesYesYes GlobalYes
slave_compressed_protocolYesYesYes GlobalYes
slave_exec_modeYesYesYes GlobalYes
Slave_heartbeat_period YesGlobalNo
slave-load-tmpdirYesYes GlobalNo
- Variable: slave_load_tmpdir Yes GlobalNo
slave-max-allowed-packetYesYes
- Variable: slave_max_allowed_packet
slave_max_allowed_packet Yes GlobalYes
slave-net-timeoutYesYes GlobalYes
- Variable: slave_net_timeout Yes GlobalYes
Slave_open_temp_tables YesGlobalNo
Slave_received_heartbeats YesGlobalNo
Slave_retried_transactions YesGlobalNo
Slave_running YesGlobalNo
slave-skip-errorsYesYes GlobalNo
- Variable: slave_skip_errors Yes GlobalNo
slave_transaction_retriesYesYesYes GlobalYes
slave_type_conversionsYesYesYes GlobalNo
Slow_launch_threads YesBothNo
slow_launch_timeYesYesYes GlobalYes
Slow_queries YesBothNo
slow-query-logYesYes GlobalYes
- Variable: slow_query_log Yes GlobalYes
slow_query_log_fileYesYesYes GlobalYes
slow-start-timeoutYesYes
socketYesYesYes GlobalNo
sort_buffer_sizeYesYesYes BothYes
Sort_merge_passes YesBothNo
Sort_range YesBothNo
Sort_rows YesBothNo
Sort_scan YesBothNo
sporadic-binlog-dump-failYesYes
sql_auto_is_null Yes VariesYes
sql_big_selects Yes VariesYes
sql_big_tables Yes VariesYes
sql_buffer_result Yes VariesYes
sql_log_bin Yes VariesYes
sql_log_off Yes VariesYes
sql_log_update Yes SessionYes
sql_low_priority_updates Yes BothYes
sql_max_join_size Yes BothYes
sql-modeYesYes BothYes
- Variable: sql_mode Yes BothYes
sql_notes Yes VariesYes
sql_quote_show_create Yes VariesYes
sql_safe_updates Yes VariesYes
sql_select_limit Yes BothYes
sql_slave_skip_counter Yes GlobalYes
sql_warnings Yes VariesYes
sslYesYes
Ssl_accept_renegotiates YesGlobalNo
Ssl_accepts YesGlobalNo
ssl-caYesYes GlobalNo
- Variable: ssl_ca Yes GlobalNo
Ssl_callback_cache_hits YesGlobalNo
ssl-capathYesYes GlobalNo
- Variable: ssl_capath Yes GlobalNo
ssl-certYesYes GlobalNo
- Variable: ssl_cert Yes GlobalNo
Ssl_cipher YesBothNo
ssl-cipherYesYes GlobalNo
- Variable: ssl_cipher Yes GlobalNo
Ssl_cipher_list YesBothNo
Ssl_client_connects YesGlobalNo
Ssl_connect_renegotiates YesGlobalNo
Ssl_ctx_verify_depth YesGlobalNo
Ssl_ctx_verify_mode YesGlobalNo
Ssl_default_timeout YesBothNo
Ssl_finished_accepts YesGlobalNo
Ssl_finished_connects YesGlobalNo
ssl-keyYesYes GlobalNo
- Variable: ssl_key Yes GlobalNo
Ssl_session_cache_hits YesGlobalNo
Ssl_session_cache_misses YesGlobalNo
Ssl_session_cache_mode YesGlobalNo
Ssl_session_cache_overflows YesGlobalNo
Ssl_session_cache_size YesGlobalNo
Ssl_session_cache_timeouts YesGlobalNo
Ssl_sessions_reused YesBothNo
Ssl_used_session_cache_entries YesGlobalNo
Ssl_verify_depth YesBothNo
Ssl_verify_mode YesBothNo
Ssl_version YesBothNo
standaloneYesYes
storage_engine Yes BothYes
stored_program_cacheYesYesYes GlobalYes
super-large-pagesYesYes
symbolic-linksYesYes
sync_binlogYesYesYes GlobalYes
sync_frmYesYesYes GlobalYes
sync_master_infoYesYesYes GlobalYes
sync_relay_logYesYesYes GlobalYes
sync_relay_log_infoYesYesYes GlobalYes
sysdate-is-nowYesYes
system_time_zone Yes GlobalNo
table_definition_cache Yes GlobalYes
table_lock_wait_timeoutYesYesYes GlobalYes
Table_locks_immediate YesGlobalNo
Table_locks_waited YesGlobalNo
table_open_cache Yes GlobalYes
table_type Yes BothYes
tc-heuristic-recoverYesYes
Tc_log_max_pages_used YesGlobalNo
Tc_log_page_size YesGlobalNo
Tc_log_page_waits YesGlobalNo
temp-poolYesYes
thread_cache_sizeYesYesYes GlobalYes
thread_concurrencyYesYesYes GlobalNo
thread_handlingYesYesYes GlobalNo
thread_pool_algorithmYesYesYes GlobalNo
thread_pool_high_priority_connectionYesYesYes BothYes
thread_pool_max_unused_threadsYesYesYes GlobalYes
thread_pool_prio_kickup_timerYesYesYes BothYes
thread_pool_sizeYesYesYes GlobalNo
thread_pool_stall_limitYesYesYes GlobalYes
thread_stackYesYesYes GlobalNo
Threads_cached YesGlobalNo
Threads_connected YesGlobalNo
Threads_created YesGlobalNo
Threads_running YesGlobalNo
time_format Yes VariesNo
time_zone Yes BothYes
timed_mutexesYesYesYes GlobalYes
timestamp Yes SessionYes
tmp_table_sizeYesYesYes BothYes
tmpdirYesYesYes GlobalNo
transaction_alloc_block_sizeYesYesYes BothYes
transaction_allow_batching Yes SessionYes
transaction-isolationYesYes
- Variable: tx_isolation
transaction_prealloc_sizeYesYesYes BothYes
tx_isolation Yes BothYes
unique_checks Yes VariesYes
updatable_views_with_limitYesYesYes BothYes
Uptime YesGlobalNo
Uptime_since_flush_status YesGlobalNo
userYesYes
verboseYesYes
version Yes GlobalNo
version_comment Yes GlobalNo
version_compile_machine Yes GlobalNo
version_compile_os Yes GlobalNo
wait_timeoutYesYesYes BothYes
warning_count Yes SessionNo

[a] This option is dynamic, but only the server should set this information. You should not set the value of this variable manually.

[b] This option is dynamic, but only the server should set this information. You should not set the value of this variable manually.



User Comments
Sign Up Login You must be logged in to post a comment.