MySQL 5.0 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
bdb_cache_size Yes GlobalNo
bdb-homeYesYes GlobalNo
- Variable: bdb_home Yes GlobalNo
bdb-lock-detectYesYesYes GlobalNo
bdb_log_buffer_size Yes GlobalNo
bdb-logdirYesYes GlobalNo
- Variable: bdb_logdir Yes GlobalNo
bdb_max_lock Yes GlobalNo
bdb-no-recoverYesYes
bdb-no-syncYesYes
bdb-shared-dataYesYes GlobalNo
- Variable: bdb_shared_data Yes GlobalNo
bdb-tmpdirYesYes GlobalNo
- Variable: bdb_tmpdir Yes 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-do-dbYesYes
binlog-ignore-dbYesYes
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_event YesBothNo
Com_alter_table YesBothNo
Com_analyze YesBothNo
Com_backup_table YesBothNo
Com_begin 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_table YesBothNo
Com_create_user 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_table YesBothNo
Com_drop_user 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_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_rename_table 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_savepoint YesBothNo
Com_select YesBothNo
Com_set_option 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_create_db YesBothNo
Com_show_create_event YesBothNo
Com_show_create_table 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_grants YesBothNo
Com_show_innodb_status 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_processlist YesBothNo
Com_show_slave_hosts YesBothNo
Com_show_slave_status YesBothNo
Com_show_status YesBothNo
Com_show_storage_engines 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_reset YesBothNo
Com_stmt_send_long_data YesBothNo
Com_truncate 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
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
exit-infoYesYes
expire_logs_daysYesYesYes GlobalYes
external-lockingYesYes
- Variable: skip_external_locking
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
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_bdb 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_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_profiling Yes GlobalNo
have_query_cache Yes GlobalNo
have_raid Yes GlobalNo
have_rtree_keys Yes GlobalNo
have_ssl Yes GlobalNo
have_symlink Yes GlobalNo
helpYesYes
hostname Yes GlobalNo
identity Yes SessionYes
init_connectYesYesYes GlobalYes
init-fileYesYes GlobalNo
- Variable: init_file Yes GlobalNo
init-rpl-roleYesYes
init_slaveYesYesYes GlobalYes
innodbYesYes
innodb_adaptive_hash_indexYesYesYes GlobalNo
innodb_additional_mem_pool_sizeYesYesYes GlobalNo
innodb_autoextend_incrementYesYesYes GlobalYes
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_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_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_io_threadsYesYesYes GlobalNo
innodb_file_per_tableYesYesYes GlobalNo
innodb_flush_log_at_trx_commitYesYesYes GlobalYes
innodb_flush_methodYesYesYes GlobalNo
innodb_force_recoveryYesYesYes GlobalNo
innodb_lock_wait_timeoutYesYesYes GlobalNo
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_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_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-safe-binlogYesYes
innodb-status-fileYesYes
innodb_support_xaYesYesYes BothYes
innodb_sync_spin_loopsYesYesYes GlobalYes
innodb_table_locksYesYesYes BothYes
innodb_thread_concurrencyYesYesYes GlobalYes
innodb_thread_sleep_delayYesYesYes GlobalYes
innodb_use_legacy_cardinality_algorithmYesYesYes GlobalYes
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 GlobalNo
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-errorYesYes GlobalNo
- Variable: log_error Yes GlobalNo
log-isamYesYes
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 GlobalNo
- Variable: log_slow_queries Yes GlobalNo
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_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 VariesYes
max_write_lock_countYesYesYes GlobalYes
memlockYesYes
- Variable: locked_in_memory
mergeYesYes
multi_range_countYesYesYes BothYes
myisam-block-sizeYesYes
myisam_data_pointer_sizeYesYesYes GlobalYes
myisam_max_extra_sort_file_sizeYesYesYes GlobalNo
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
named_pipe Yes GlobalNo
ndb_autoincrement_prefetch_szYesYesYes BothYes
ndb_cache_check_timeYesYesYes GlobalYes
Ndb_cluster_node_id YesBothNo
Ndb_config_from_host YesBothNo
Ndb_config_from_port YesBothNo
ndb-connectstringYesYes
ndb_force_sendYesYesYes BothYes
ndb_index_stat_cache_entriesYesYesYes BothYes
ndb_index_stat_enableYesYesYes BothYes
ndb_index_stat_update_freqYesYesYes BothYes
ndb-mgmd-hostYesYes
ndb-nodeidYesYes YesGlobalNo
ndb_optimized_node_selectionYesYesYes GlobalNo
ndb_report_thresh_binlog_epoch_slipYesYes
ndb_report_thresh_binlog_mem_usageYesYes
ndb_use_exact_count Yes BothYes
ndb_use_transactionsYesYesYes BothYes
ndbclusterYesYes
- Variable: have_ndbcluster
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
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_tables YesBothNo
Opened_tables YesBothNo
optimizer_prune_levelYesYesYes BothYes
optimizer_search_depthYesYesYes BothYes
pid-fileYesYes GlobalNo
- Variable: pid_file Yes GlobalNo
plugin_dirYesYesYes GlobalNo
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
report-passwordYesYes
report-portYesYes
report-userYesYes
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
set-variableYesYes
shared_memoryYesYesYes GlobalNo
shared_memory_base_nameYesYesYes GlobalNo
show-slave-auth-infoYesYes
skip-bdbYesYes
skip-character-set-client-handshakeYesYes
skip-concurrent-insertYesYes
- Variable: concurrent_insert
skip_external_lockingYesYesYes GlobalNo
skip-grant-tablesYesYes
skip-host-cacheYesYes
skip-lockingYesYes
skip-mergeYesYes
skip-name-resolveYesYes
skip-ndbclusterYesYes
skip-networkingYesYes GlobalNo
- Variable: skip_networking Yes GlobalNo
skip-newYesYes
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-sync-bdb-logsYesYesYes GlobalNo
skip-thread-priorityYesYes
slave_compressed_protocolYesYesYes GlobalYes
slave-load-tmpdirYesYes GlobalNo
- Variable: slave_load_tmpdir Yes GlobalNo
slave-net-timeoutYesYes GlobalYes
- Variable: slave_net_timeout Yes GlobalYes
Slave_open_temp_tables YesGlobalNo
Slave_retried_transactions YesGlobalNo
Slave_running YesGlobalNo
slave-skip-errorsYesYes GlobalNo
- Variable: slave_skip_errors Yes GlobalNo
slave_transaction_retriesYesYesYes GlobalYes
Slow_launch_threads YesBothNo
slow_launch_timeYesYesYes GlobalYes
Slow_queries YesBothNo
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-bdb-logsYesYesYes GlobalNo
sync_binlogYesYesYes GlobalYes
sync_frmYesYesYes GlobalYes
sysdate-is-nowYesYes
system_time_zone Yes GlobalNo
table_cacheYesYesYes GlobalYes
table_lock_wait_timeoutYesYesYes GlobalYes
Table_locks_immediate YesGlobalNo
Table_locks_waited YesGlobalNo
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_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-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
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
warningsYesYes

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