Table of Contents [+/-]
The table below shows all the options and variables available across all versions of the mysqld server. The columns are as follows:
Name — the name of the option or variable.
Intr — the version in which the option or variable was introduced in mysqld
Depr — the version of mysqld in which the option or variable was deprecated.
Cmd — indicates whether the option/variable is valid on the command line.
Cnf — indicates whether the option is valid within a configuration file.
Srvr — indicates whether the variable is a server system variable.
Stat — indicates whether the variable is a status variable.
Scp — indicates the scope of the variable (session-specific, global, or both).
Dyn — indicates whether the variable is dynamically settable while the server is running.
5.0, 5.1, and so forth — indicates if the option/variable is available in the MySQL 5.0 series. If more information is available in the main reference manual, the indication will be a link to the correct part of the manual.
Table 1.1. Option/Variable Reference
Name | Intr | Depr | Cmd | Cnf | Srvr | Stat | Scope | Dyn | 5.0 | 5.1 | 5.4 |
---|---|---|---|---|---|---|---|---|---|---|---|
abort-slave-event-count |
Yes | Yes | Yes | Yes | Yes | ||||||
Aborted_clients |
Yes | Global | No | Yes | Yes | Yes | |||||
Aborted_connects |
Yes | Global | No | Yes | Yes | Yes | |||||
allow-suspicious-udfs |
5.0.3 | Yes | Yes | Yes | Yes | Yes | |||||
ansi |
Yes | Yes | Yes | Yes | Yes | ||||||
auto_increment_increment |
5.0.2 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
auto_increment_offset |
5.0.2 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
autocommit |
Yes | Session | Yes | Yes | Yes | Yes | |||||
automatic_sp_privileges |
5.0.3 | Yes | Global | Yes | Yes | Yes | Yes | ||||
back_log |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
backup_history_log |
Yes | Yes | Yes | Global | Yes | ||||||
backup_history_log_file |
Yes | Yes | Yes | Global | Yes | ||||||
backup_progress_log |
Yes | Yes | Yes | Global | Yes | ||||||
backup_progress_log_file |
Yes | Yes | Yes | Global | Yes | ||||||
backup_wait_timeout |
Yes | Session | Yes | ||||||||
backupdir |
Yes | Yes | Yes | Global | Yes | ||||||
basedir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
bdb_cache_size |
Yes | Yes | Yes | Global | No | Yes | |||||
bdb-data-direct |
5.1.4 | Yes | Global | No | |||||||
bdb-home |
Yes | Yes | Yes | Global | No | Yes | |||||
bdb-lock-detect |
Yes | Yes | Yes | Global | No | Yes | |||||
bdb_log_buffer_size |
Yes | Yes | Yes | Global | No | Yes | |||||
bdb-log-direct |
5.1.4 | Yes | Global | No | |||||||
bdb-logdir |
Yes | Yes | Yes | Global | No | Yes | |||||
bdb_max_lock |
Yes | Yes | Yes | Global | No | Yes | |||||
bdb-no-recover |
Yes | Yes | Yes | ||||||||
bdb-no-sync |
4.0.18 | Yes | Yes | ||||||||
bdb-shared-data |
Yes | Yes | Yes | Global | No | Yes | |||||
bdb-tmpdir |
Yes | Yes | Yes | Global | No | Yes | |||||
big-tables |
Yes | Yes | Yes | Session | Yes | Yes | Yes | Yes | |||
bind-address |
Yes | Yes | Yes | Yes | Yes | ||||||
Binlog_cache_disk_use |
Yes | Global | No | Yes | Yes | Yes | |||||
binlog_cache_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
Binlog_cache_use |
Yes | Global | No | Yes | Yes | Yes | |||||
binlog-direct-non-transactional-updates |
5.1.44 | Yes | Yes | Yes | |||||||
binlog-do-db |
Yes | Yes | Yes | Yes | Yes | ||||||
binlog-format |
5.1.5 | Yes | Yes | Yes | Both | Yes | Yes | Yes | |||
binlog-ignore-db |
Yes | Yes | Yes | Yes | Yes | ||||||
binlog-row-event-max-size |
5.1.5 | Yes | Yes | Yes | Yes | ||||||
bootstrap |
Yes | Yes | Yes | Yes | Yes | ||||||
bulk_insert_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
Bytes_received |
Yes | Both | No | Yes | Yes | Yes | |||||
Bytes_sent |
Yes | Both | No | Yes | Yes | Yes | |||||
character_set |
4.1.1 | Yes | Yes | No | |||||||
character_set_client |
Yes | Both | Yes | Yes | Yes | Yes | |||||
character-set-client-handshake |
Yes | Yes | Yes | Yes | Yes | ||||||
character_set_connection |
Yes | Both | Yes | Yes | Yes | Yes | |||||
character_set_database |
Yes | Both | Yes | Yes | Yes | Yes | |||||
character-set-filesystem |
5.0.19, 5.1.6 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
character_set_results |
Yes | Both | Yes | Yes | Yes | Yes | |||||
character-set-server |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
character_set_system |
Yes | Global | No | Yes | Yes | Yes | |||||
character-sets-dir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
chroot |
Yes | Yes | Yes | Yes | Yes | ||||||
collation_connection |
Yes | Both | Yes | Yes | Yes | Yes | |||||
collation_database |
Yes | Both | Yes | Yes | Yes | Yes | |||||
collation-server |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
Com_admin_commands |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_alter_db |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_alter_event |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_alter_table |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_analyze |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_backup |
Yes | Both | No | ||||||||
Com_backup_table |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_begin |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_call_procedure |
5.0.44, 5.1.19 | Yes | Both | No | Yes | Yes | Yes | ||||
Com_change_db |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_change_master |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_check |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_checksum |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_commit |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_create_db |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_create_event |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_create_function |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_create_index |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_create_table |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_create_user |
5.0.30 | Yes | Both | No | Yes | Yes | Yes | ||||
Com_dealloc_sql |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_delete |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_delete_multi |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_do |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_drop_db |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_drop_event |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_drop_function |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_drop_index |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_drop_table |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_drop_user |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_execute_sql |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_flush |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_grant |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_ha_close |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_ha_open |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_ha_read |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_help |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_insert |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_insert_select |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_kill |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_load |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_load_master_data |
4.1.22 | Yes | Both | No | |||||||
Com_load_master_table |
4.1.22 | Yes | Both | No | |||||||
Com_lock_tables |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_optimize |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_preload_keys |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_prepare_sql |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_purge |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_purge_before_date |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_rename_table |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_repair |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_replace |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_replace_select |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_reset |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_restore |
Yes | Both | No | ||||||||
Com_restore_table |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_revoke |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_revoke_all |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_rollback |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_savepoint |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_select |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_set_option |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_binlog_events |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_binlogs |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_charsets |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_collations |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_column_types |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_create_db |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_create_event |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_create_table |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_databases |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_engine_logs |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_engine_mutex |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_engine_status |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_errors |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_events |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_fields |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_grants |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_innodb_status |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_keys |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_logs |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_master_status |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_ndb_status |
Yes | Both | No | Yes | Yes | ||||||
Com_show_new_master |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_open_tables |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_plugins |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_privileges |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_processlist |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_profile |
5.1.24 | Yes | Both | No | Yes | Yes | |||||
Com_show_profiles |
5.1.24 | Yes | Both | No | Yes | Yes | |||||
Com_show_slave_hosts |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_slave_status |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_status |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_storage_engines |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_tables |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_triggers |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_variables |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_show_warnings |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_slave_start |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_slave_stop |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_stmt_close |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | ||||
Com_stmt_execute |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | ||||
Com_stmt_fetch |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | ||||
Com_stmt_prepare |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | ||||
Com_stmt_reprepare |
5.1.25 | Yes | Both | No | Yes | Yes | |||||
Com_stmt_reset |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | ||||
Com_stmt_send_long_data |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | ||||
Com_truncate |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_unlock_tables |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_update |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_update_multi |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_xa_commit |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_xa_end |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_xa_prepare |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_xa_recover |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_xa_rollback |
Yes | Both | No | Yes | Yes | Yes | |||||
Com_xa_start |
Yes | Both | No | Yes | Yes | Yes | |||||
completion_type |
5.0.3 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
Compression |
5.0.16 | Yes | Session | No | Yes | Yes | Yes | ||||
concurrent_insert |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
connect_timeout |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
Connections |
Yes | Global | No | Yes | Yes | Yes | |||||
console |
Yes | Yes | Yes | Yes | Yes | ||||||
core-file |
Yes | Yes | Yes | Yes | Yes | ||||||
crash_binlog_innodb |
Yes | Yes | |||||||||
Created_tmp_disk_tables |
Yes | Both | No | Yes | Yes | Yes | |||||
Created_tmp_files |
Yes | Global | No | Yes | Yes | Yes | |||||
Created_tmp_tables |
Yes | Both | No | Yes | Yes | Yes | |||||
datadir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
date_format |
Yes | Both | No | Yes | Yes | Yes | |||||
datetime_format |
Yes | Yes | Yes | Both | No | Yes | Yes | Yes | |||
debug |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
debug_sync |
5.1.41 | Yes | Both | Yes | Yes | ||||||
debug-sync-timeout |
5.1.41 | Yes | Yes | Yes | |||||||
default-character-set |
5.0 | Yes | Yes | Yes | |||||||
default-collation |
4.1.3 | Yes | Yes | No | |||||||
default-storage-engine |
Yes | Yes | Yes | Yes | Yes | ||||||
default-table-type |
5.0 | Yes | Yes | Yes | Yes | Yes | |||||
default-time-zone |
Yes | Yes | Yes | Yes | Yes | ||||||
default_week_format |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
defaults-extra-file |
Yes | Yes | Yes | Yes | |||||||
defaults-file |
Yes | Yes | Yes | Yes | |||||||
defaults-group-suffix |
5.0.10 | Yes | Yes | Yes | Yes | ||||||
delay-key-write |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
delay-key-write-for-all-tables |
4.0.3 | Yes | |||||||||
Delayed_errors |
Yes | Global | No | Yes | Yes | Yes | |||||
delayed_insert_limit |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
Delayed_insert_threads |
Yes | Global | No | Yes | Yes | Yes | |||||
delayed_insert_timeout |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
delayed_queue_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
Delayed_writes |
Yes | Global | No | Yes | Yes | Yes | |||||
des-key-file |
Yes | Yes | Yes | Yes | Yes | ||||||
disconnect-slave-event-count |
Yes | Yes | Yes | Yes | Yes | ||||||
div_precision_increment |
5.0.6 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
enable-locking |
4.0.3 | Yes | Yes | Yes | Yes | Yes | |||||
enable-named-pipe |
Yes | Yes | Yes | Yes | Yes | ||||||
enable-pstack |
Yes | Yes | Yes | Yes | Yes | ||||||
engine-condition-pushdown |
5.0.3 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
error_count |
Yes | Session | No | Yes | Yes | Yes | |||||
event-scheduler |
5.1.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
exit-info |
Yes | Yes | Yes | Yes | Yes | ||||||
expire_logs_days |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
external-locking |
Yes | Yes | Yes | Yes | Yes | ||||||
falcon |
Yes | Yes | |||||||||
falcon_checkpoint_schedule |
Yes | Yes | Yes | Global | Yes | ||||||
falcon_checksums |
Yes | Yes | Yes | Global | Yes | ||||||
falcon_consistent_read |
Yes | Yes | Yes | Both | 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 | ||||||
falcon_support_xa |
Yes | Yes | Yes | Global | No | ||||||
falcon_use_deferred_index_hash |
Yes | Yes | Yes | Global | No | ||||||
falcon_use_sectorcache |
Yes | Yes | Yes | Global | No | ||||||
falcon_use_supernodes |
Yes | Yes | Yes | Global | No | ||||||
federated |
5.1.26 | Yes | Yes | Yes | Yes | ||||||
flush |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
Flush_commands |
Yes | Global | No | Yes | Yes | Yes | |||||
flush_time |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
foreign_key_checks |
Yes | Session | Yes | Yes | Yes | Yes | |||||
ft_boolean_syntax |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
ft_max_word_len |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
ft_min_word_len |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
ft_query_expansion_limit |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
ft_stopword_file |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
gdb |
Yes | Yes | Yes | Yes | Yes | ||||||
general-log |
5.1.12 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
general_log_file |
5.1.12 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
group_concat_max_len |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
Handler_commit |
Yes | Both | No | Yes | Yes | Yes | |||||
Handler_delete |
Yes | Both | No | Yes | Yes | Yes | |||||
Handler_discover |
Yes | Both | No | Yes | Yes | Yes | |||||
Handler_prepare |
5.0.3 | Yes | Both | No | Yes | Yes | Yes | ||||
Handler_read_first |
Yes | Both | No | Yes | Yes | Yes | |||||
Handler_read_key |
Yes | Both | No | Yes | Yes | Yes | |||||
Handler_read_next |
Yes | Both | No | Yes | Yes | Yes | |||||
Handler_read_prev |
Yes | Both | No | Yes | Yes | Yes | |||||
Handler_read_rnd |
Yes | Both | No | Yes | Yes | Yes | |||||
Handler_read_rnd_next |
Yes | Both | No | Yes | Yes | Yes | |||||
Handler_rollback |
Yes | Both | No | Yes | Yes | Yes | |||||
Handler_savepoint |
5.0.3 | Yes | Both | No | Yes | Yes | Yes | ||||
Handler_savepoint_rollback |
5.0.3 | Yes | Both | No | Yes | Yes | Yes | ||||
Handler_update |
Yes | Both | No | Yes | Yes | Yes | |||||
Handler_write |
Yes | Both | No | Yes | Yes | Yes | |||||
have_archive |
Yes | Global | No | Yes | Yes | ||||||
have_bdb |
Yes | Global | No | Yes | |||||||
have_blackhole_engine |
Yes | Global | No | Yes | Yes | ||||||
have_community_features |
5.1.24 | Yes | Global | No | Yes | Yes | |||||
have_compress |
Yes | Global | No | Yes | Yes | Yes | |||||
have_crypt |
Yes | Global | No | Yes | Yes | Yes | |||||
have_csv |
Yes | Global | No | Yes | Yes | Yes | |||||
have_dynamic_loading |
5.1.10 | Yes | Global | No | Yes | Yes | |||||
have_example_engine |
Yes | Global | No | Yes | Yes | ||||||
have_federated_engine |
5.0.6 | Yes | Global | No | Yes | Yes | |||||
have_geometry |
Yes | Global | No | Yes | Yes | Yes | |||||
have_innodb |
Yes | Global | No | Yes | Yes | Yes | |||||
have_isam |
Yes | Global | No | Yes | Yes | ||||||
have_merge_engine |
5.0.24 | Yes | Global | No | Yes | Yes | |||||
have_ndbcluster |
Yes | Global | No | Yes | Yes | Yes | |||||
have_openssl |
Yes | Global | No | Yes | Yes | Yes | |||||
have_partition_engine |
5.1.1 | 5.1.6 | Yes | Global | No | ||||||
have_partitioning |
5.1.6 | Yes | Global | No | Yes | Yes | |||||
have_profiling |
Yes | Global | No | ||||||||
have_query_cache |
Yes | Global | No | Yes | Yes | Yes | |||||
have_raid |
Yes | Global | No | Yes | Yes | ||||||
have_row_based_replication |
5.1.5 | Yes | Global | No | Yes | ||||||
have_rtree_keys |
Yes | Global | No | Yes | Yes | Yes | |||||
have_ssl |
5.0.38, 5.1.17 | Yes | Global | No | Yes | Yes | Yes | ||||
have_symlink |
Yes | Global | No | Yes | Yes | Yes | |||||
help |
Yes | Yes | Yes | Yes | Yes | ||||||
hostname |
5.0.38, 5.1.17 | Yes | Global | No | Yes | Yes | Yes | ||||
identity |
Yes | Session | Yes | Yes | Yes | Yes | |||||
ignore_builtin_innodb |
5.1.33 | Yes | Yes | Yes | Global | No | Yes | Yes | |||
init_connect |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
init-file |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
init_slave |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
innodb |
Yes | Yes | Yes | Yes | Yes | ||||||
innodb_adaptive_flushing |
5.1.38, 5.4.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
innodb_adaptive_hash_index |
5.0.52, 5.1.24 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
innodb_additional_mem_pool_size |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
innodb_autoextend_increment |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
innodb_autoinc_lock_mode |
5.1.22 | Yes | Yes | Yes | Global | No | Yes | Yes | |||
innodb_buffer_pool_awe_mem_mb |
Yes | Yes | Yes | Global | No | Yes | Yes | ||||
Innodb_buffer_pool_pages_data |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_dirty |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_flushed |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_free |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_latched |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_misc |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_total |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_buffer_pool_read_ahead |
5.1.42 | Yes | Global | No | Yes | ||||||
Innodb_buffer_pool_read_ahead_evicted |
5.1.42 | Yes | Global | No | Yes | ||||||
Innodb_buffer_pool_read_ahead_rnd |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_buffer_pool_read_ahead_seq |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_buffer_pool_read_requests |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_buffer_pool_reads |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
innodb_buffer_pool_size |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
Innodb_buffer_pool_wait_free |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_buffer_pool_write_requests |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
innodb_change_buffering |
5.1.38, 5.4.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
innodb_checksums |
5.0.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
innodb_commit_concurrency |
5.0.12 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
innodb_concurrency_tickets |
5.0.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
innodb_data_file_path |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
Innodb_data_fsyncs |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
innodb_data_home_dir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
Innodb_data_pending_fsyncs |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_data_pending_reads |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_data_pending_writes |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_data_read |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_data_reads |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_data_writes |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_data_written |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_dblwr_pages_written |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_dblwr_writes |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
innodb_doublewrite |
5.0.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
innodb_extra_dirty_writes |
Yes | Yes | Yes | Global | No | Yes | |||||
innodb_fast_shutdown |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
innodb_file_format |
5.1.38, 5.4.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
innodb_file_format_check |
5.1.38, 5.4.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
innodb_file_io_threads |
Yes | Yes | Yes | Global | No | Yes | Yes | ||||
innodb_file_per_table |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
innodb_flush_log_at_trx_commit |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
innodb_flush_method |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
innodb_force_recovery |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
Innodb_have_atomic_builtins |
5.1.38, 5.4.2 | Yes | Global | No | Yes | Yes | |||||
Innodb_have_sync_atomic |
Yes | Global | No | Yes | |||||||
Innodb_heap_enabled |
Yes | Global | No | Yes | |||||||
innodb_io_capacity |
5.1.38 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
innodb_lock_wait_timeout |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
innodb_locks_unsafe_for_binlog |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
innodb_log_arch_dir |
5.0.24 | Yes | Yes | Yes | Global | No | Yes | Yes | |||
innodb_log_archive |
Yes | Yes | Yes | Global | No | Yes | Yes | ||||
innodb_log_buffer_size |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
innodb_log_file_size |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
innodb_log_files_in_group |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
innodb_log_group_home_dir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
Innodb_log_waits |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_log_write_requests |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_log_writes |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
innodb_max_dirty_pages_pct |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
innodb_max_merged_io |
Yes | Yes | Yes | Global | No | Yes | |||||
innodb_max_purge_lag |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
innodb_mirrored_log_groups |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
innodb_old_blocks_pct |
5.1.41 | Yes | Yes | Yes | Global | Yes | Yes | ||||
innodb_old_blocks_time |
5.1.41 | Yes | Yes | Yes | Global | Yes | Yes | ||||
innodb_open_files |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
Innodb_os_log_fsyncs |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_os_log_pending_fsyncs |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_os_log_pending_writes |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_os_log_written |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_page_size |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_pages_created |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_pages_read |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_pages_written |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
innodb_purge_threads |
Yes | Yes | Yes | Global | No | ||||||
innodb_read_ahead_threshold |
5.1.38, 5.4.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
innodb_read_io_threads |
5.1.38 | Yes | Yes | Yes | Global | No | Yes | Yes | |||
innodb_replication_delay |
5.1.38, 5.4.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
innodb_rollback_on_timeout |
5.0.32, 5.1.15 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
Innodb_row_lock_current_waits |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_row_lock_time |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_row_lock_time_avg |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_row_lock_time_max |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_row_lock_waits |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_rows_deleted |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_rows_inserted |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_rows_read |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
Innodb_rows_updated |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | ||||
innodb_safe_binlog |
5.0.3 | Yes | Yes | Yes | |||||||
innodb_spin_wait_delay |
5.1.38, 5.4.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
innodb_stats_on_metadata |
5.1.17 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
innodb_stats_sample_pages |
5.1.38, 5.4.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
innodb_status_file |
Yes | Yes | Yes | Yes | Yes | ||||||
innodb_strict_mode |
5.1.38, 5.4.2 | Yes | Yes | Yes | Both | Yes | Yes | Yes | |||
innodb_support_xa |
5.0.3 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
innodb_sync_spin_loops |
5.0.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
innodb_table_locks |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
innodb_thread_concurrency |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
innodb_thread_concurrency_timer_based |
Yes | Yes | Yes | Global | No | Yes | |||||
innodb_thread_sleep_delay |
5.0.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
innodb_use_legacy_cardinality_algorithm |
5.0.82, 5.1.35 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
innodb_use_native_aio |
Yes | Yes | Yes | Global | No | ||||||
innodb_use_sys_malloc |
5.1.38, 5.4.2 | Yes | Yes | Yes | Global | No | Yes | Yes | |||
innodb_version |
5.1.38, 5.4.2 | Yes | Global | No | Yes | Yes | |||||
Innodb_wake_ups |
Yes | Global | No | Yes | |||||||
innodb_write_io_threads |
5.1.38 | Yes | Yes | Yes | Global | No | Yes | Yes | |||
insert_id |
Yes | Session | Yes | Yes | Yes | Yes | |||||
interactive_timeout |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
isam |
Yes | Yes | Yes | No | |||||||
join_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
join_cache_level |
Yes | Yes | Yes | Both | Yes | ||||||
keep_files_on_create |
5.0.48, 5.1.21 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
Key_blocks_not_flushed |
Yes | Global | No | Yes | Yes | Yes | |||||
Key_blocks_unused |
Yes | Global | No | Yes | Yes | Yes | |||||
Key_blocks_used |
Yes | Global | No | Yes | Yes | Yes | |||||
key_buffer_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
key_cache_age_threshold |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
key_cache_block_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
key_cache_division_limit |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
Key_read_requests |
Yes | Global | No | Yes | Yes | Yes | |||||
Key_reads |
Yes | Global | No | Yes | Yes | Yes | |||||
Key_write_requests |
Yes | Global | No | Yes | Yes | Yes | |||||
Key_writes |
Yes | Global | No | Yes | Yes | Yes | |||||
language |
5.5.0 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
large_files_support |
Yes | Global | No | Yes | Yes | Yes | |||||
large_page_size |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | ||||
large-pages |
5.0.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
last_insert_id |
Yes | Session | Yes | Yes | Yes | Yes | |||||
Last_query_cost |
5.0.1 | Yes | Session | No | Yes | Yes | Yes | ||||
lc-messages |
Yes | Yes | Yes | Both | Yes | ||||||
lc-messages-dir |
Yes | Yes | Yes | Global | No | ||||||
lc_time_names |
5.0.25, 5.1.12 | Yes | Both | Yes | Yes | Yes | Yes | ||||
license |
Yes | Global | No | Yes | Yes | Yes | |||||
local_infile |
Yes | Global | Yes | Yes | Yes | Yes | |||||
local-infile |
Yes | Yes | Yes | Yes | Yes | ||||||
lock_wait_timeout |
Yes | Yes | Yes | Both | Yes | ||||||
locked_in_memory |
Yes | Global | No | Yes | Yes | Yes | |||||
log |
5.1.29 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
log-backup-output |
Yes | Yes | Yes | Global | Yes | ||||||
log_bin |
Yes | Global | No | Yes | Yes | Yes | |||||
log-bin |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
log-bin-index |
Yes | Yes | Yes | Yes | Yes | ||||||
log-bin-trust-function-creators |
5.0.16 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
log-bin-trust-routine-creators |
5.0.6 | 5.0.16 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |
log-error |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
log-isam |
Yes | Yes | Yes | Yes | Yes | ||||||
log-long-format |
4.1 | Yes | Yes | ||||||||
log-output |
5.1.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
log-queries-not-using-indexes |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
log-short-format |
Yes | Yes | Yes | Yes | Yes | ||||||
log-slave-updates |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
log-slow-admin-statements |
Yes | Yes | Yes | Yes | Yes | ||||||
log-slow-queries |
5.1.29 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
log-slow-slave-statements |
5.1.21 | Yes | Yes | Yes | Yes | ||||||
log-tc |
5.0.3 | Yes | Yes | Yes | Yes | Yes | |||||
log-tc-size |
5.0.3 | Yes | Yes | Yes | Yes | Yes | |||||
log-update |
5.0 | Yes | |||||||||
log-warnings |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
long_query_time |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
low-priority-updates |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
lower_case_file_system |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
lower_case_table_names |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
maria |
Yes | Yes | |||||||||
maria-block-size |
Yes | Yes | Yes | No | |||||||
maria-checkpoint-interval |
Yes | Yes | Yes | Global | Yes | ||||||
maria-force-start-after-recovery-failures |
Yes | Yes | |||||||||
maria-log-dir-path |
Yes | Yes | |||||||||
maria-log-file-size |
Yes | Yes | Yes | Global | Yes | ||||||
maria-log-purge-type |
Yes | Yes | Yes | Global | Yes | ||||||
maria-max-sort-file-size |
Yes | Yes | Yes | Global | Yes | ||||||
maria-page-checksum |
Yes | Yes | Yes | Global | Yes | ||||||
maria-pagecache-age-threshold |
Yes | Yes | Yes | Global | Yes | ||||||
maria-pagecache-buffer-size |
Yes | Yes | Yes | Global | No | ||||||
maria-pagecache-division-limit |
Yes | Yes | Yes | Global | Yes | ||||||
maria-recover |
Yes | Yes | Yes | Global | Yes | ||||||
maria-repair-threads |
Yes | Yes | Yes | Both | Yes | ||||||
maria-sort-buffer-size |
Yes | Yes | Yes | Both | Yes | ||||||
maria-stats-method |
Yes | Yes | Yes | Both | Yes | ||||||
maria-sync-log-dir |
Yes | Yes | Yes | Global | Yes | ||||||
master-bind |
5.1.22-ndb-6.3.4 | Yes | Yes | Yes | No | Yes | Yes | ||||
master-connect-retry |
5.1.17 | Yes | Yes | Yes | Yes | Yes | |||||
master-host |
5.1.17 | Yes | Yes | Yes | Yes | Yes | |||||
master-info-file |
Yes | Yes | Yes | Yes | Yes | ||||||
master-password |
5.1.17 | Yes | Yes | Yes | Yes | Yes | |||||
master-port |
5.1.17 | Yes | Yes | Yes | Yes | Yes | |||||
master-retry-count |
Yes | Yes | Yes | Yes | Yes | ||||||
master-ssl |
5.1.17 | Yes | Yes | Yes | Yes | Yes | |||||
master-ssl-ca |
5.1.17 | Yes | Yes | Yes | Yes | Yes | |||||
master-ssl-capath |
5.1.17 | Yes | Yes | Yes | Yes | Yes | |||||
master-ssl-cert |
5.1.17 | Yes | Yes | Yes | Yes | Yes | |||||
master-ssl-cipher |
5.1.17 | Yes | Yes | Yes | Yes | Yes | |||||
master-ssl-key |
5.1.17 | Yes | Yes | Yes | Yes | Yes | |||||
master-user |
5.1.17 | Yes | Yes | Yes | Yes | Yes | |||||
max_allowed_packet |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
max_binlog_cache_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
max-binlog-dump-events |
Yes | Yes | Yes | Yes | Yes | ||||||
max_binlog_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
max_connect_errors |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
max_connections |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
max_delayed_threads |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
max_error_count |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
max_heap_table_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
max_insert_delayed_threads |
Yes | Both | Yes | Yes | Yes | Yes | |||||
max_join_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
max_length_for_sort_data |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
max_prepared_stmt_count |
5.0.21, 5.1.10 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
max_relay_log_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
max_seeks_for_key |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
max_sort_length |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
max_sp_recursion_depth |
5.0.17 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
max_tmp_tables |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
Max_used_connections |
Yes | Global | No | Yes | Yes | Yes | |||||
max_user_connections |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
max_write_lock_count |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
memlock |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
merge |
5.0.24, 5.1.12 | Yes | Yes | Yes | Yes | ||||||
min-examined-row-limit |
5.1.21 | Yes | Yes | Yes | Both | Yes | Yes | Yes | |||
multi_range_count |
5.0.3 | Yes | Yes | Yes | Both | Yes | Yes | Yes | |||
mutex-deadlock-detector |
Yes | Yes | |||||||||
myisam-block-size |
Yes | Yes | Yes | Yes | Yes | ||||||
myisam_data_pointer_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
myisam_max_extra_sort_file_size |
5.0.6 | Yes | Yes | Yes | Global | No | Yes | ||||
myisam_max_sort_file_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
myisam_mmap_size |
5.0.90, 5.1.43 | Yes | Yes | Yes | Global | No | Yes | Yes | |||
myisam-recover |
Yes | Yes | Yes | Yes | Yes | ||||||
myisam_recover_options |
Yes | Global | No | Yes | Yes | Yes | |||||
myisam_repair_threads |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
myisam_sort_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
myisam_stats_method |
5.0.14 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
myisam_use_mmap |
5.1.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
mysql-backup |
Yes | Yes | |||||||||
named_pipe |
Yes | Global | No | Yes | Yes | Yes | |||||
ndb_autoincrement_prefetch_sz |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
ndb-batch-size |
5.1.23-ndb-6.3.8 | Yes | Yes | Yes | Global | No | Yes | ||||
ndb_cache_check_time |
Yes | Yes | Yes | Global | Yes | Yes | Yes | ||||
ndb-cluster-connection-pool |
5.1.19-ndb-6.2.2 | Yes | Yes | Yes | Global | No | Yes | ||||
Ndb_cluster_node_id |
Yes | Both | No | Yes | Yes | ||||||
Ndb_config_from_host |
5.0.23, 5.1.12 | Yes | Both | No | Yes | Yes | |||||
Ndb_config_from_port |
5.0.23, 5.1.12 | Yes | Both | No | Yes | Yes | |||||
Ndb_conflict_fn_max |
5.1.22-ndb-6.3.3 | Yes | Global | No | Yes | Yes | |||||
Ndb_conflict_fn_old |
5.1.22-ndb-6.3.4 | Yes | Global | No | Yes | Yes | |||||
ndb-connectstring |
Yes | Yes | Yes | ||||||||
ndb_execute_count |
5.1.22-ndb-6.3.6 | Yes | Global | No | Yes | ||||||
ndb_extra_logging |
5.1.6 | Yes | Yes | Yes | Global | Yes | Yes | ||||
ndb_force_send |
Yes | Yes | Yes | Both | Yes | Yes | Yes | ||||
ndb_index_stat_cache_entries |
Yes | Yes | Yes | Yes | |||||||
ndb_index_stat_enable |
Yes | Yes | Yes | Yes | |||||||
ndb_index_stat_update_freq |
Yes | Yes | Yes | Yes | |||||||
ndb_log_empty_epochs |
5.1.31-ndb-6.4.1 | Yes | Yes | Yes | Global | Yes | Yes | ||||
ndb_log_orig |
5.1.22-ndb-6.3.2 | Yes | Global | No | Yes | ||||||
ndb-log-update-as-write |
5.1.22-ndb-6.2.5 | Yes | Yes | Yes | Global | Yes | Yes | ||||
ndb_log_updated_only |
5.1.19-ndb-6.3.0 | Yes | Yes | Yes | Global | Yes | Yes | ||||
ndb-mgmd-host |
Yes | Yes | Yes | Yes | |||||||
ndb-nodeid |
5.0.45, 5.1.15 | Yes | Yes | Yes | Global | No | Yes | Yes | |||
Ndb_number_of_data_nodes |
5.1.12 | Yes | Global | No | Yes | Yes | |||||
ndb_optimization_delay |
5.1.23-ndb-6.3.7 | Yes | Global | Yes | Yes | ||||||
ndb_optimized_node_selection |
Yes | Yes | Yes | Yes | |||||||
ndb_pruned_scan_count |
5.1.32-ndb-7.0.5 | Yes | Global | No | Yes | ||||||
ndb_report_thresh_binlog_epoch_slip |
Yes | Yes | Yes | Yes | |||||||
ndb_report_thresh_binlog_mem_usage |
Yes | Yes | Yes | Yes | |||||||
ndb_scan_count |
5.1.32-ndb-7.0.5 | Yes | Global | No | Yes | ||||||
ndb_table_no_logging |
5.1.23-ndb-6.3.8 | Yes | Session | Yes | Yes | ||||||
ndb_table_temporary |
5.1.23-ndb-6.3.8 | Yes | Session | Yes | Yes | ||||||
ndb_use_copying_alter_table |
5.1.12 | Yes | Both | No | Yes | ||||||
ndb_use_exact_count |
Yes | Both | Yes | Yes | Yes | ||||||
ndb_use_transactions |
Yes | Yes | Yes | Both | Yes | Yes | Yes | ||||
ndb_wait_connected |
5.1.16-ndb-6.2.0 | Yes | Yes | Yes | No | Yes | |||||
ndb-wait-setup |
5.1.39-ndb-7.0.9 | Yes | Yes | Yes | No | Yes | |||||
ndbcluster |
Yes | Yes | Yes | Yes | |||||||
net_buffer_length |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
net_read_timeout |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
net_retry_count |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
net_write_timeout |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
new |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
no-defaults |
Yes | Yes | Yes | Yes | |||||||
Not_flushed_delayed_rows |
Yes | Global | No | Yes | Yes | Yes | |||||
old |
5.1.18 | Yes | Yes | Yes | Global | No | Yes | Yes | |||
old-alter-table |
Yes | Yes | Yes | Both | Yes | Yes | Yes | ||||
old-passwords |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
old-protocol |
Yes | Yes | |||||||||
old-style-user-limits |
5.0.3 | Yes | Yes | Yes | Yes | Yes | |||||
one-thread |
Yes | Yes | Yes | Yes | Yes | ||||||
Open_files |
Yes | Global | No | Yes | Yes | Yes | |||||
open-files-limit |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
Open_streams |
Yes | Global | No | Yes | Yes | Yes | |||||
Open_table_definitions |
5.1.3 | Yes | Global | No | Yes | Yes | |||||
Open_tables |
Yes | Both | No | Yes | Yes | Yes | |||||
Opened_files |
5.1.21 | Yes | Global | No | Yes | Yes | |||||
Opened_table_definitions |
5.1.24 | Yes | Both | No | Yes | Yes | |||||
Opened_tables |
Yes | Both | No | Yes | Yes | Yes | |||||
optimizer_prune_level |
5.0.1 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
optimizer_search_depth |
5.0.1 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
optimizer_switch |
5.1.34, 5.4.2 | Yes | Yes | Yes | Both | Yes | Yes | Yes | |||
optimizer_use_mrr |
Yes | Both | Yes | ||||||||
partition |
Yes | Yes | Yes | Global | No | Yes | Yes | ||||
performance_schema |
Yes | Yes | Yes | Global | No | ||||||
Performance_schema_cond_classes_lost |
Yes | Global | No | ||||||||
Performance_schema_cond_instances_lost |
Yes | Global | No | ||||||||
performance_schema_events_waits_history_long_size |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_events_waits_history_size |
Yes | Yes | Yes | Global | No | ||||||
Performance_schema_file_classes_lost |
Yes | Global | No | ||||||||
Performance_schema_file_handles_lost |
Yes | Global | No | ||||||||
Performance_schema_file_instances_lost |
Yes | Global | No | ||||||||
Performance_schema_locker_lost |
Yes | Global | No | ||||||||
performance_schema_max_cond_classes |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_cond_instances |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_file_classes |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_file_handles |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_file_instances |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_mutex_classes |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_mutex_instances |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_rwlock_classes |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_rwlock_instances |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_table_handles |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_table_instances |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_thread_classes |
Yes | Yes | Yes | Global | No | ||||||
performance_schema_max_thread_instances |
Yes | Yes | Yes | Global | No | ||||||
Performance_schema_mutex_classes_lost |
Yes | Global | No | ||||||||
Performance_schema_mutex_instances_lost |
Yes | Global | No | ||||||||
Performance_schema_rwlock_classes_lost |
Yes | Global | No | ||||||||
Performance_schema_rwlock_instances_lost |
Yes | Global | No | ||||||||
Performance_schema_table_handles_lost |
Yes | Global | No | ||||||||
Performance_schema_table_instances_lost |
Yes | Global | No | ||||||||
Performance_schema_thread_classes_lost |
Yes | Global | No | ||||||||
Performance_schema_thread_instances_lost |
Yes | Global | No | ||||||||
pid-file |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
plugin |
Yes | Yes | Yes | Yes | |||||||
plugin_dir |
5.0.67, 5.1.2 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
plugin-load |
5.1.18 | Yes | Yes | Yes | Yes | ||||||
port |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
port-open-timeout |
5.0.19, 5.1.5 | Yes | Yes | Yes | Yes | Yes | |||||
preload_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
Prepared_stmt_count |
5.0.32, 5.1.14 | Yes | Global | No | Yes | Yes | Yes | ||||
prepared_stmt_count |
5.0.21, 5.1.10 | Yes | Global | No | Yes | Yes | |||||
print-defaults |
Yes | Yes | Yes | Yes | |||||||
profiling |
5.0.37 CS, 5.1.24 | Yes | Session | Yes | Yes | Yes | Yes | ||||
profiling_history_size |
5.0.37 CS, 5.1.24 | Yes | Both | Yes | Yes | Yes | Yes | ||||
protocol_version |
Yes | Global | No | Yes | Yes | Yes | |||||
pseudo_thread_id |
Yes | Session | Yes | Yes | Yes | Yes | |||||
Qcache_free_blocks |
Yes | Global | No | Yes | Yes | Yes | |||||
Qcache_free_memory |
Yes | Global | No | Yes | Yes | Yes | |||||
Qcache_hits |
Yes | Global | No | Yes | Yes | Yes | |||||
Qcache_inserts |
Yes | Global | No | Yes | Yes | Yes | |||||
Qcache_lowmem_prunes |
Yes | Global | No | Yes | Yes | Yes | |||||
Qcache_not_cached |
Yes | Global | No | Yes | Yes | Yes | |||||
Qcache_queries_in_cache |
Yes | Global | No | Yes | Yes | Yes | |||||
Qcache_total_blocks |
Yes | Global | No | Yes | Yes | Yes | |||||
Queries |
5.0.76, 5.1.31 | Yes | Both | No | Yes | Yes | Yes | ||||
query_alloc_block_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
query_cache_limit |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
query_cache_min_res_unit |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
query_cache_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
query_cache_type |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
query_cache_wlock_invalidate |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
query_prealloc_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
Questions |
Yes | Both | No | Yes | Yes | Yes | |||||
rand_seed1 |
Yes | Session | Yes | Yes | Yes | Yes | |||||
rand_seed2 |
Yes | Session | Yes | Yes | Yes | Yes | |||||
range_alloc_block_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
read_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
read_only |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
read_rnd_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
record_buffer |
4.0.3 | Yes | Yes | Yes | No | ||||||
relay-log |
Yes | Yes | Yes | Yes | Yes | ||||||
relay-log-index |
Yes | Yes | Yes | Yes | Yes | ||||||
relay-log-info-file |
Yes | Yes | Yes | Yes | Yes | ||||||
relay_log_purge |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
relay_log_recovery |
Yes | Yes | Yes | Global | Yes | ||||||
relay_log_space_limit |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
replicate-do-db |
Yes | Yes | Yes | Yes | Yes | ||||||
replicate-do-table |
Yes | Yes | Yes | Yes | Yes | ||||||
replicate-ignore-db |
Yes | Yes | Yes | Yes | Yes | ||||||
replicate-ignore-table |
Yes | Yes | Yes | Yes | Yes | ||||||
replicate-rewrite-db |
Yes | Yes | Yes | Yes | Yes | ||||||
replicate-same-server-id |
5.0.1 | Yes | Yes | Yes | Yes | Yes | |||||
replicate-wild-do-table |
Yes | Yes | Yes | Yes | Yes | ||||||
replicate-wild-ignore-table |
Yes | Yes | Yes | Yes | Yes | ||||||
report-host |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
report-password |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
report-port |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
report-user |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
restore-disables-events |
Yes | Yes | Yes | Both | Yes | ||||||
restore-elevation |
Yes | Yes | Yes | Global | No | ||||||
restore-precheck |
Yes | Yes | Yes | Both | Yes | ||||||
rpl_recovery_rank |
Yes | Global | Yes | Yes | Yes | Yes | |||||
Rpl_semi_sync_master_clients |
Yes | Global | No | ||||||||
rpl_semi_sync_master_enabled |
Yes | Global | Yes | ||||||||
Rpl_semi_sync_master_net_avg_wait_time |
Yes | Global | No | ||||||||
Rpl_semi_sync_master_net_wait_time |
Yes | Global | No | ||||||||
Rpl_semi_sync_master_net_waits |
Yes | Global | No | ||||||||
Rpl_semi_sync_master_no_times |
Yes | Global | No | ||||||||
Rpl_semi_sync_master_no_tx |
Yes | Global | No | ||||||||
rpl_semi_sync_master_reply_log_file_pos |
Yes | Global | Yes | ||||||||
Rpl_semi_sync_master_status |
Yes | Global | No | ||||||||
Rpl_semi_sync_master_timefunc_failures |
Yes | Global | No | ||||||||
rpl_semi_sync_master_timeout |
Yes | Global | Yes | ||||||||
rpl_semi_sync_master_trace_level |
Yes | Global | Yes | ||||||||
Rpl_semi_sync_master_tx_avg_wait_time |
Yes | Global | No | ||||||||
Rpl_semi_sync_master_tx_wait_time |
Yes | Global | No | ||||||||
Rpl_semi_sync_master_tx_waits |
Yes | Global | No | ||||||||
rpl_semi_sync_master_wait_no_slave |
Yes | Global | Yes | ||||||||
Rpl_semi_sync_master_wait_pos_backtraverse |
Yes | Global | No | ||||||||
Rpl_semi_sync_master_wait_sessions |
Yes | Global | No | ||||||||
Rpl_semi_sync_master_yes_tx |
Yes | Global | No | ||||||||
rpl_semi_sync_slave_enabled |
Yes | Global | Yes | ||||||||
Rpl_semi_sync_slave_status |
Yes | Global | No | ||||||||
rpl_semi_sync_slave_trace_level |
Yes | Global | Yes | ||||||||
Rpl_status |
Yes | Global | No | Yes | Yes | Yes | |||||
safe-mode |
5.0 | Yes | Yes | Yes | Yes | Yes | |||||
safe-show-database |
4.0.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
safe-user-create |
Yes | Yes | Yes | Yes | Yes | ||||||
safemalloc-mem-limit |
Yes | Yes | Yes | Yes | Yes | ||||||
secure-auth |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
secure-backup-file-priv |
Yes | Yes | Yes | Global | No | ||||||
secure-file-priv |
5.0.38, 5.1.17 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
Select_full_join |
Yes | Both | No | Yes | Yes | Yes | |||||
Select_full_range_join |
Yes | Both | No | Yes | Yes | Yes | |||||
Select_range |
Yes | Both | No | Yes | Yes | Yes | |||||
Select_range_check |
Yes | Both | No | Yes | Yes | Yes | |||||
Select_scan |
Yes | Both | No | Yes | Yes | Yes | |||||
server-id |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
set-variable |
5.0 | Yes | Yes | Yes | |||||||
shared_memory |
Yes | Global | No | Yes | Yes | Yes | |||||
shared_memory_base_name |
Yes | Global | No | Yes | Yes | Yes | |||||
show-slave-auth-info |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-bdb |
Yes | Yes | Yes | ||||||||
skip-character-set-client-handshake |
5.0.13 | Yes | Yes | Yes | Yes | Yes | |||||
skip-concurrent-insert |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-event-scheduler |
Yes | Yes | Yes | Yes | |||||||
skip-external-locking |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
skip-falcon |
Yes | Yes | |||||||||
skip-grant-tables |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-host-cache |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-innodb |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-innodb-checksums |
5.0.3 | Yes | Yes | Yes | Yes | Yes | |||||
skip-isam |
Yes | Yes | Yes | No | |||||||
skip-locking |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-log-warnings |
Yes | Yes | Yes | Yes | |||||||
skip-merge |
5.0.24, 5.1.12 | Yes | Yes | Yes | Yes | ||||||
skip-name-resolve |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-ndbcluster |
Yes | Yes | Yes | ||||||||
skip-networking |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
skip-new |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-partition |
Yes | Yes | Yes | Yes | |||||||
skip-safemalloc |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-show-database |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
skip-slave-start |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-ssl |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-stack-trace |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-symbolic-links |
Yes | Yes | Yes | Yes | |||||||
skip-symlink |
Yes | Yes | Yes | Yes | Yes | ||||||
skip-sync-bdb-logs |
Yes | Yes | Yes | Global | No | Yes | |||||
skip-thread-priority |
5.1.29 | Yes | Yes | Yes | Yes | Yes | |||||
slave-allow-batching |
5.1.19-ndb-6.2.3 | Yes | Yes | Yes | Global | Yes | Yes | ||||
slave_compressed_protocol |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
slave_exec_mode |
5.1.24 | Yes | Global | Yes | Yes | Yes | |||||
Slave_heartbeat_period |
5.1.22-ndb-6.3.4 | Yes | Global | No | Yes | ||||||
slave-load-tmpdir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
slave-net-timeout |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
Slave_open_temp_tables |
Yes | Global | No | Yes | Yes | Yes | |||||
Slave_received_heartbeats |
5.1.22-ndb-6.3.4 | Yes | Global | No | Yes | ||||||
Slave_retried_transactions |
5.0.4 | Yes | Global | No | Yes | Yes | Yes | ||||
Slave_running |
Yes | Global | No | Yes | Yes | Yes | |||||
slave-skip-errors |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
slave_transaction_retries |
5.0.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
slave_type_conversions |
5.1.44-ndb-7.1.3 | Yes | Yes | Yes | Global | No | Yes | ||||
Slow_launch_threads |
Yes | Both | No | Yes | Yes | Yes | |||||
slow_launch_time |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
Slow_queries |
Yes | Both | No | Yes | Yes | Yes | |||||
slow-query-log |
5.1.12 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
slow_query_log_file |
5.1.12 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
socket |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
sort_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
Sort_merge_passes |
Yes | Both | No | Yes | Yes | Yes | |||||
Sort_range |
Yes | Both | No | Yes | Yes | Yes | |||||
Sort_rows |
Yes | Both | No | Yes | Yes | Yes | |||||
Sort_scan |
Yes | Both | No | Yes | Yes | Yes | |||||
sporadic-binlog-dump-fail |
Yes | Yes | Yes | Yes | Yes | ||||||
sql_auto_is_null |
Yes | Session | Yes | Yes | Yes | Yes | |||||
sql_big_selects |
Yes | Session | Yes | Yes | Yes | Yes | |||||
sql_big_tables |
Yes | Session | Yes | Yes | Yes | Yes | |||||
sql-bin-update-same |
Yes | Yes | |||||||||
sql_buffer_result |
Yes | Session | Yes | Yes | Yes | Yes | |||||
sql_log_bin |
Yes | Session | Yes | Yes | Yes | Yes | |||||
sql_log_off |
Yes | Session | Yes | Yes | Yes | Yes | |||||
sql_log_update |
5.0 | Yes | Session | Yes | Yes | Yes | Yes | ||||
sql_low_priority_updates |
Yes | Both | Yes | Yes | Yes | Yes | |||||
sql_max_join_size |
Yes | Both | Yes | Yes | Yes | Yes | |||||
sql-mode |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
sql_notes |
5.0.3 | Yes | Session | Yes | Yes | Yes | Yes | ||||
sql_quote_show_create |
Yes | Session | Yes | Yes | Yes | Yes | |||||
sql_safe_updates |
Yes | Session | Yes | Yes | Yes | Yes | |||||
sql_select_limit |
Yes | Both | Yes | Yes | Yes | Yes | |||||
sql_slave_skip_counter |
Yes | Global | Yes | Yes | Yes | Yes | |||||
sql_warnings |
Yes | Session | Yes | Yes | Yes | Yes | |||||
ssl |
Yes | Yes | Yes | Yes | Yes | ||||||
Ssl_accept_renegotiates |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_accepts |
Yes | Global | No | Yes | Yes | Yes | |||||
ssl-ca |
5.0.23, 5.1.11 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
Ssl_callback_cache_hits |
Yes | Global | No | Yes | Yes | Yes | |||||
ssl-capath |
5.0.23, 5.1.11 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
ssl-cert |
5.0.23, 5.1.11 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
ssl-cipher |
5.0.23, 5.1.11 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
Ssl_cipher |
Yes | Both | No | Yes | Yes | Yes | |||||
Ssl_cipher_list |
Yes | Both | No | Yes | Yes | Yes | |||||
Ssl_client_connects |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_connect_renegotiates |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_ctx_verify_depth |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_ctx_verify_mode |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_default_timeout |
Yes | Both | No | Yes | Yes | Yes | |||||
Ssl_finished_accepts |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_finished_connects |
Yes | Global | No | Yes | Yes | Yes | |||||
ssl-key |
5.0.23, 5.1.11 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||
Ssl_session_cache_hits |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_session_cache_misses |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_session_cache_mode |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_session_cache_overflows |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_session_cache_size |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_session_cache_timeouts |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_sessions_reused |
Yes | Both | No | Yes | Yes | Yes | |||||
Ssl_used_session_cache_entries |
Yes | Global | No | Yes | Yes | Yes | |||||
Ssl_verify_depth |
Yes | Both | No | Yes | Yes | Yes | |||||
Ssl_verify_mode |
Yes | Both | No | Yes | Yes | Yes | |||||
ssl-verify-server-cert |
5.1.11 | Yes | Yes | Yes | Yes | ||||||
Ssl_version |
Yes | Both | No | Yes | Yes | Yes | |||||
standalone |
Yes | Yes | Yes | Yes | Yes | ||||||
storage_engine |
Yes | Both | Yes | Yes | Yes | Yes | |||||
symbolic-links |
Yes | Yes | Yes | Yes | Yes | ||||||
sync-bdb-logs |
Yes | Yes | Yes | Global | No | Yes | |||||
sync_binlog |
5.0.1 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
sync_frm |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
sync_master_info |
Yes | Yes | Yes | Global | Yes | ||||||
sync_relay_log |
Yes | Yes | Yes | Global | Yes | ||||||
sync_relay_log_info |
Yes | Yes | Yes | Global | Yes | ||||||
sysdate-is-now |
5.0.20, 5.1.8 | Yes | Yes | Yes | Yes | Yes | |||||
system_time_zone |
Yes | Global | No | Yes | Yes | Yes | |||||
table_cache |
5.1.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
table_definition_cache |
5.1.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
table_lock_wait_timeout |
5.0.10 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
Table_locks_immediate |
Yes | Global | No | Yes | Yes | Yes | |||||
Table_locks_waited |
Yes | Global | No | Yes | Yes | Yes | |||||
table_open_cache |
5.1.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||
table_type |
5.2.5 | Yes | Both | Yes | Yes | Yes | Yes | ||||
tc-heuristic-recover |
5.0.3 | Yes | Yes | Yes | Yes | Yes | |||||
Tc_log_max_pages_used |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | ||||
Tc_log_page_size |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | ||||
Tc_log_page_waits |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | ||||
temp-pool |
Yes | Yes | Yes | Yes | Yes | ||||||
thread_cache_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||
thread_concurrency |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
thread_handling |
5.1.17 | Yes | Yes | Yes | Global | No | Yes | Yes | |||
thread_pool_size |
Yes | Yes | Yes | Global | No | ||||||
thread_stack |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
Threads_cached |
Yes | Global | No | Yes | Yes | Yes | |||||
Threads_connected |
Yes | Global | No | Yes | Yes | Yes | |||||
Threads_created |
Yes | Global | No | Yes | Yes | Yes | |||||
Threads_running |
Yes | Global | No | Yes | Yes | Yes | |||||
time_format |
Yes | Yes | Yes | Both | No | Yes | Yes | Yes | |||
time_zone |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
timed_mutexes |
5.0.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||
timestamp |
Yes | Session | Yes | Yes | Yes | Yes | |||||
tmp_table_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
tmpdir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
transaction_alloc_block_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
transaction_allow_batching |
5.1.23-ndb-6.3.7 | Yes | Session | Yes | Yes | ||||||
transaction-isolation |
Yes | Yes | Yes | Yes | Yes | ||||||
transaction_prealloc_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
tx_isolation |
Yes | Both | Yes | Yes | Yes | Yes | |||||
unique_checks |
Yes | Session | Yes | Yes | Yes | Yes | |||||
updatable_views_with_limit |
5.0.2 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||
Uptime |
Yes | Global | No | Yes | Yes | Yes | |||||
Uptime_since_flush_status |
5.0.35, 5.1.24 | Yes | Global | No | Yes | Yes | Yes | ||||
use-symbolic-links |
5.0 | Yes | Yes | Yes | Yes | ||||||
user |
Yes | Yes | Yes | Yes | Yes | ||||||
verbose |
Yes | Yes | Yes | Yes | Yes | ||||||
version |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
version_comment |
Yes | Global | No | Yes | Yes | Yes | |||||
version_compile_machine |
Yes | Global | No | Yes | Yes | Yes | |||||
version_compile_os |
Yes | Global | No | Yes | Yes | Yes | |||||
wait_timeout |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||
warning_count |
Yes | Session | No | Yes | Yes | Yes | |||||
warnings |
5.0 | Yes | Yes | Yes |