MySQL 5.1 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 17.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
auto_increment_increment Yes BothYes
auto_increment_offset Yes BothYes
autocommit Yes SessionYes
automatic_sp_privileges Yes GlobalYes
back_log Yes GlobalNo
basedirYesYesYes GlobalNo
big-tablesYesYes SessionYes
- Variable: big_tables Yes SessionYes
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
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_backup_table 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_restore_table 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_column_types 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_logs 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_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_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 BothNo
datetime_format Yes BothNo
debugYesYesYes BothYes
debug_sync Yes BothYes
debug-sync-timeoutYesYes
default-character-setYesYes
default-storage-engineYesYesYes BothYes
default-table-typeYesYes
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
federatedYesYes
flushYesYesYes GlobalYes
Flush_commands YesGlobalNo
flush_timeYesYesYes GlobalYes
foreign_key_checks Yes SessionYes
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_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_archive Yes GlobalNo
have_blackhole_engine Yes GlobalNo
have_community_features Yes GlobalNo
have_compress Yes GlobalNo
have_crypt Yes GlobalNo
have_csv Yes GlobalNo
have_dynamic_loading Yes GlobalNo
have_example_engine Yes GlobalNo
have_federated_engine Yes GlobalNo
have_geometry Yes GlobalNo
have_innodb Yes GlobalNo
have_isam Yes GlobalNo
have_merge_engine Yes GlobalNo
have_ndbcluster Yes GlobalNo
have_openssl Yes GlobalNo
have_partition_engine Yes GlobalNo
have_partitioning Yes GlobalNo
have_query_cache Yes GlobalNo
have_raid Yes GlobalNo
have_row_based_replication 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 GlobalNo
innodb_additional_mem_pool_sizeYesYesYes GlobalNo
innodb_autoextend_incrementYesYesYes GlobalYes
innodb_autoinc_lock_modeYesYesYes GlobalNo
innodb_buffer_pool_awe_mem_mbYesYesYes 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_ahead_rnd YesGlobalNo
Innodb_buffer_pool_read_ahead_seq 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 GlobalYes
innodb_file_io_threadsYesYesYes GlobalNo
innodb_file_per_tableYesYesYes GlobalNo
innodb_flush_log_at_trx_commitYesYesYes GlobalYes
innodb_flush_methodYesYesYes GlobalNo
innodb_force_recoveryYesYesYes GlobalNo
Innodb_have_atomic_builtins YesGlobalNo
innodb_io_capacityYesYesYes GlobalNo
innodb_limit_optimistic_insert_debugYesYesYes GlobalYes
innodb_lock_wait_timeoutYesYesYes VariesNo
innodb_locks_unsafe_for_binlogYesYesYes GlobalNo
innodb_log_arch_dirYesYesYes GlobalNo
innodb_log_archiveYesYesYes 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_random_read_aheadYesYesYes GlobalYes
innodb_read_ahead_thresholdYesYesYes GlobalYes
innodb_read_io_threadsYesYesYes GlobalNo
innodb_replication_delayYesYesYes GlobalYes
innodb_rollback_on_timeoutYesYesYes GlobalNo
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 GlobalVaries
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_trx_purge_view_update_only_debugYesYesYes GlobalYes
innodb_trx_rseg_n_slots_debugYesYesYes GlobalYes
innodb_use_legacy_cardinality_algorithmYesYesYes GlobalYes
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_time_names Yes BothYes
license Yes GlobalNo
local_infile Yes GlobalYes
local-serviceYes
locked_in_memory Yes GlobalNo
logYesYesYes GlobalVaries
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 GlobalVaries
- Variable: log_slow_queries Yes GlobalVaries
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_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
mergeYesYes
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_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-poolYesYesYesYesGlobalNo
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
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
prepared_stmt_count Yes GlobalNo
print-defaultsYes
profiling Yes SessionYes
profiling_history_sizeYesYesYes BothYes
protocol_version Yes GlobalNo
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_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_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-mergeYesYes
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
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 SessionYes
sql_big_selects Yes SessionYes
sql_big_tables Yes SessionYes
sql_buffer_result Yes SessionYes
sql_log_bin Yes SessionYes
sql_log_off Yes SessionYes
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 SessionYes
sql_quote_show_create Yes SessionYes
sql_safe_updates Yes SessionYes
sql_select_limit Yes BothYes
sql_slave_skip_counter Yes GlobalYes
sql_warnings Yes SessionYes
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
symbolic-linksYesYes
sync_binlogYesYesYes GlobalYes
sync_frmYesYesYes GlobalYes
sysdate-is-nowYesYes
system_time_zone Yes GlobalNo
table_cacheYesYesYes GlobalYes
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_stackYesYesYes GlobalNo
Threads_cached YesGlobalNo
Threads_connected YesGlobalNo
Threads_created YesGlobalNo
Threads_running YesGlobalNo
time_format Yes BothNo
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 SessionYes
updatable_views_with_limitYesYesYes BothYes
Uptime YesGlobalNo
Uptime_since_flush_status YesGlobalNo
use-symbolic-linksYesYes
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.