This table that lists every MySQL Server option or variable, what version it was introduced or deprecated in, whether it’s dynamic or not, whether variables have session/global/both scope, and links to the version-specific documentation for that variable.
Name | Intr | Depr | Cmd | Cnf | Srvr | Stat | Scope | Dyn | 5.0 | 5.1 | 5.5 | 5.6 | 5.7 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
abort-slave-event-count |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
Aborted_clients |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Aborted_connects |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
allow-suspicious-udfs |
5.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||
ansi |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
audit-log |
5.5.28, 5.6.10 | Yes | Yes | Yes | Yes | ||||||||
audit_log_buffer_size |
5.5.28, 5.6.10 | Yes | Global | No | Yes | Yes | |||||||
audit_log_file |
5.5.28, 5.6.10 | Yes | Global | No | Yes | Yes | |||||||
audit_log_flush |
5.5.28, 5.6.10 | Yes | Global | Yes | Yes | Yes | |||||||
audit_log_format |
5.5.34, 5.6.14, 5.7.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
audit_log_policy |
5.5.28, 5.6.10 | Yes | Global | Yes | Yes | Yes | |||||||
audit_log_rotate_on_size |
5.5.28, 5.6.10 | Yes | Global | Yes | Yes | Yes | |||||||
audit_log_strategy |
5.5.28, 5.6.10 | Yes | Global | No | Yes | Yes | |||||||
authentication_windows_log_level |
5.5.16, 5.6.10 | Yes | Yes | Yes | Yes | ||||||||
authentication_windows_use_principal_name |
5.5.16, 5.6.10 | Yes | Yes | Yes | Yes | ||||||||
auto_increment_increment |
5.0.2 | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||||
auto_increment_offset |
5.0.2 | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||||
autocommit |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
automatic_sp_privileges |
5.0.3 | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||||
back_log |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
basedir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
bdb_cache_size |
Yes | Global | No | Yes | |||||||||
bdb-home |
Yes | Yes | Yes | Global | No | Yes | |||||||
bdb-lock-detect |
Yes | Yes | Yes | Global | No | Yes | |||||||
bdb_log_buffer_size |
Yes | Global | No | Yes | |||||||||
bdb-logdir |
Yes | Yes | Yes | Global | No | Yes | |||||||
bdb_max_lock |
Yes | Global | No | Yes | |||||||||
bdb-no-recover |
Yes | Yes | Yes | ||||||||||
bdb-no-sync |
4.0.18 | Yes | Yes | Yes | |||||||||
bdb-shared-data |
Yes | Yes | Yes | Global | No | Yes | |||||||
bdb-tmpdir |
Yes | Yes | Yes | Global | No | Yes | |||||||
big-tables |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
bind-address |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
Binlog_cache_disk_use |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
binlog_cache_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
Binlog_cache_use |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
binlog-checksum |
5.6.2 | Yes | Yes | Yes | Yes | ||||||||
binlog_checksum |
5.6.2 | Yes | Global | Yes | Yes | Yes | |||||||
binlog_direct_non_transactional_updates |
5.1.44, 5.5.2 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | |||
binlog-do-db |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
binlog-format |
5.1.5 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | |||
binlog-ignore-db |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
binlog_max_flush_queue_time |
5.6.6 | Yes | Global | Yes | Yes | Yes | |||||||
binlog_order_commits |
5.6.6 | Yes | Global | Yes | Yes | Yes | |||||||
binlog-row-event-max-size |
5.1.5 | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
binlog_row_image |
5.6.2 | Yes | Yes | Yes | Both | Yes | Yes | Yes | |||||
binlog_rows_query_log_events |
5.6.2 | Yes | Both | Yes | Yes | Yes | |||||||
binlog-rows-query-log-events |
5.6.2 | Yes | Yes | Yes | Yes | ||||||||
Binlog_stmt_cache_disk_use |
5.5.9, 5.6.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
binlog_stmt_cache_size |
5.5.9, 5.6.1 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
Binlog_stmt_cache_use |
5.5.9, 5.6.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
bootstrap |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
bulk_insert_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
Bytes_received |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Bytes_sent |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
character_set_client |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
character-set-client-handshake |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
character_set_connection |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
character_set_database |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
character-set-filesystem |
5.0.19, 5.1.6 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||
character_set_results |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
character-set-server |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
character_set_system |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
character-sets-dir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
chroot |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
collation_connection |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
collation_database |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
collation-server |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
Com_admin_commands |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_alter_db |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_alter_db_upgrade |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_alter_event |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_alter_function |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_alter_procedure |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_alter_server |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_alter_table |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_alter_tablespace |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_alter_user |
5.6.6 | Yes | Both | No | Yes | Yes | |||||||
Com_analyze |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_assign_to_keycache |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_backup_table |
Yes | Both | No | Yes | Yes | ||||||||
Com_begin |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_binlog |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_call_procedure |
5.0.44, 5.1.19 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
Com_change_db |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_change_master |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_change_repl_filter |
5.7.3 | Yes | Both | No | Yes | ||||||||
Com_check |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_checksum |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_commit |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_create_db |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_create_event |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_create_function |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_create_index |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_create_procedure |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_create_server |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_create_table |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_create_trigger |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_create_udf |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_create_user |
5.0.30 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
Com_create_view |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_dealloc_sql |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_delete |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_delete_multi |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_do |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_drop_db |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_drop_event |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_drop_function |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_drop_index |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_drop_procedure |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_drop_server |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_drop_table |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_drop_trigger |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_drop_user |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_drop_view |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_empty_query |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_execute_sql |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_flush |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_get_diagnostics |
5.6.4 | Yes | Both | No | Yes | Yes | |||||||
Com_grant |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_ha_close |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_ha_open |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_ha_read |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_help |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_insert |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_insert_select |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_install_plugin |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_kill |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_load |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_lock_tables |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_optimize |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_preload_keys |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_prepare_sql |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_purge |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_purge_before_date |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_release_savepoint |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_rename_table |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_rename_user |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_repair |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_replace |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_replace_select |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_reset |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_resignal |
Yes | Both | No | Yes | Yes | Yes | |||||||
Com_restore_table |
Yes | Both | No | Yes | Yes | ||||||||
Com_revoke |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_revoke_all |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_rollback |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_rollback_to_savepoint |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_savepoint |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_select |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_set_option |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_authors |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_show_binlog_events |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_binlogs |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_charsets |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_collations |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_column_types |
Yes | Both | No | Yes | Yes | ||||||||
Com_show_contributors |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_show_create_db |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_create_event |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_create_func |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_show_create_proc |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_show_create_table |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_create_trigger |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_show_databases |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_engine_logs |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_engine_mutex |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_engine_status |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_errors |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_events |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_fields |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_function_code |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_show_function_status |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_show_grants |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_innodb_status |
Yes | Both | No | Yes | |||||||||
Com_show_keys |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_logs |
Yes | Both | No | Yes | Yes | ||||||||
Com_show_master_status |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_ndb_status |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_show_new_master |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_open_tables |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_plugins |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_privileges |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_procedure_code |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_show_procedure_status |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_show_processlist |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_profile |
5.1.24 | Yes | Both | No | Yes | Yes | Yes | Yes | |||||
Com_show_profiles |
5.1.24 | Yes | Both | No | Yes | Yes | Yes | Yes | |||||
Com_show_relaylog_events |
Yes | Both | No | Yes | Yes | Yes | |||||||
Com_show_slave_hosts |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_slave_status |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_status |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_storage_engines |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_table_status |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_show_tables |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_triggers |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_variables |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_show_warnings |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_signal |
Yes | Both | No | Yes | Yes | Yes | |||||||
Com_slave_start |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_slave_stop |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_stmt_close |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
Com_stmt_execute |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
Com_stmt_fetch |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
Com_stmt_prepare |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
Com_stmt_reprepare |
5.1.25 | Yes | Both | No | Yes | Yes | Yes | Yes | |||||
Com_stmt_reset |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
Com_stmt_send_long_data |
5.0.8 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
Com_truncate |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_uninstall_plugin |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Com_unlock_tables |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_update |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_update_multi |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_xa_commit |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_xa_end |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_xa_prepare |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_xa_recover |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_xa_rollback |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Com_xa_start |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
completion_type |
5.0.3 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||
Compression |
5.0.16 | Yes | Session | No | Yes | Yes | Yes | Yes | Yes | ||||
concurrent_insert |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
connect_timeout |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
Connection_errors_accept |
5.6.5 | Yes | Global | No | Yes | Yes | |||||||
Connection_errors_internal |
5.6.5 | Yes | Global | No | Yes | Yes | |||||||
Connection_errors_max_connections |
5.6.5 | Yes | Global | No | Yes | Yes | |||||||
Connection_errors_peer_addr |
5.6.5 | Yes | Global | No | Yes | Yes | |||||||
Connection_errors_select |
5.6.5 | Yes | Global | No | Yes | Yes | |||||||
Connection_errors_tcpwrap |
5.6.5 | Yes | Global | No | Yes | Yes | |||||||
Connections |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
console |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
core_file |
5.6.2 | Yes | Global | No | Yes | Yes | |||||||
core-file |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
Created_tmp_disk_tables |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Created_tmp_files |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Created_tmp_tables |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
daemon_memcached_enable_binlog |
5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
daemon_memcached_engine_lib_name |
5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
daemon_memcached_engine_lib_path |
5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
daemon_memcached_option |
5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
daemon_memcached_r_batch_size |
5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
daemon_memcached_w_batch_size |
5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
datadir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
date_format |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
datetime_format |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
debug |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
debug_sync |
5.1.41 | Yes | Session | Yes | Yes | Yes | Yes | Yes | |||||
debug-sync-timeout |
5.1.41 | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
default-authentication-plugin |
5.6.6 | Yes | Yes | Yes | Yes | ||||||||
default_authentication_plugin |
5.7.2 | Yes | Yes | Yes | Global | No | Yes | ||||||
default-character-set |
5.0.0 | Yes | Yes | Yes | |||||||||
default-storage-engine |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
default-table-type |
5.0.0 | Yes | Yes | Yes | Yes | ||||||||
default-time-zone |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
default_tmp_storage_engine |
5.6.3 | Yes | Yes | Yes | Both | Yes | Yes | Yes | |||||
default_week_format |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
defaults-extra-file |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
defaults-file |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
defaults-group-suffix |
5.0.10 | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
delay-key-write |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
Delayed_errors |
5.6.7 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
delayed_insert_limit |
5.6.7 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
Delayed_insert_threads |
5.6.7 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
delayed_insert_timeout |
5.6.7 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
delayed_queue_size |
5.6.7 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
Delayed_writes |
5.6.7 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
des-key-file |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
disable_gtid_unsafe_statements |
5.6.5 | Yes | Yes | Yes | Global | No | Yes | ||||||
disable-gtid-unsafe-statements |
5.6.5 | Yes | Yes | Yes | Global | No | Yes | ||||||
disconnect_on_expired_password |
5.6.10, 5.7.1 | Yes | Yes | Yes | Session | No | Yes | Yes | |||||
disconnect-slave-event-count |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
div_precision_increment |
5.0.6 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||
enable-locking |
Yes | Yes | Yes | Yes | Yes | ||||||||
enable-named-pipe |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
enable-pstack |
5.1.54 | Yes | Yes | Yes | Yes | Yes | |||||||
end_markers_in_json |
5.6.5 | Yes | Both | Yes | Yes | Yes | |||||||
enforce_gtid_consistency |
5.6.9 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
enforce-gtid-consistency |
5.6.9 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
engine-condition-pushdown |
5.0.3 | 5.5.3 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | ||
eq_range_index_dive_limit |
5.6.5 | Yes | Both | Yes | Yes | Yes | |||||||
error_count |
Yes | Session | No | Yes | Yes | Yes | Yes | Yes | |||||
event-scheduler |
5.1.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
exit-info |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
expire_logs_days |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
explicit_defaults_for_timestamp |
5.6.6 | Yes | Yes | Yes | Session | No | Yes | Yes | |||||
external-locking |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
external_user |
5.5.7 | Yes | Session | No | Yes | Yes | Yes | ||||||
federated |
5.1.26 | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
flush |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
Flush_commands |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
flush_time |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
foreign_key_checks |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
ft_boolean_syntax |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
ft_max_word_len |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
ft_min_word_len |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
ft_query_expansion_limit |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
ft_stopword_file |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
gdb |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
general-log |
5.1.12 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
general_log_file |
5.1.12 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
group_concat_max_len |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
gtid_done |
5.6.5 | Yes | Both | No | Yes | ||||||||
gtid_executed |
5.6.9 | Yes | Both | No | Yes | Yes | |||||||
gtid_lost |
5.6.5 | Yes | Global | No | Yes | ||||||||
gtid_mode |
5.6.5 | Yes | Global | No | Yes | Yes | |||||||
gtid-mode |
5.6.5 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
gtid_next |
5.6.5 | Yes | Session | Yes | Yes | Yes | |||||||
gtid_owned |
5.6.5 | Yes | Both | No | Yes | Yes | |||||||
gtid_purged |
5.6.9 | Yes | Global | Yes | Yes | Yes | |||||||
Handler_commit |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Handler_delete |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Handler_discover |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Handler_external_lock |
5.6.2 | Yes | Both | No | Yes | Yes | |||||||
Handler_mrr_init |
5.6.1 | Yes | Both | No | Yes | Yes | |||||||
Handler_prepare |
5.0.3 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
Handler_read_first |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Handler_read_key |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Handler_read_last |
5.5.7, 5.6.1 | Yes | Both | No | Yes | Yes | Yes | ||||||
Handler_read_next |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Handler_read_prev |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Handler_read_rnd |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Handler_read_rnd_next |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Handler_rollback |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Handler_savepoint |
5.0.3 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
Handler_savepoint_rollback |
5.0.3 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
Handler_update |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Handler_write |
Yes | Both | No | Yes | Yes | 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.0.82, 5.1.24 | Yes | Global | No | Yes | Yes | |||||||
have_compress |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
have_crypt |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
have_csv |
Yes | Global | No | Yes | Yes | Yes | Yes | ||||||
have_dynamic_loading |
5.1.10 | Yes | Global | No | Yes | Yes | 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 | Yes | Yes | |||||
have_innodb |
Yes | Global | No | Yes | 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 | Yes | ||||||
have_openssl |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
have_partition_engine |
5.1.1 | 5.1.6 | Yes | Global | No | Yes | |||||||
have_partitioning |
5.1.6 | Yes | Global | No | Yes | Yes | Yes | ||||||
have_profiling |
5.0.82 | 5.6.8 | Yes | Global | No | Yes | Yes | Yes | Yes | ||||
have_query_cache |
Yes | Global | No | Yes | Yes | 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 | Yes | Yes | |||||
have_ssl |
5.0.38, 5.1.17 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
have_symlink |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
help |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
host_cache_size |
5.6.5 | Yes | Global | Yes | Yes | Yes | |||||||
hostname |
5.0.38, 5.1.17 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
identity |
Yes | Session | Yes | Yes | Yes | Yes | Yes | Yes | |||||
ignore-builtin-innodb |
5.1.33 | 5.5.22 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | ||
ignore-db-dir |
5.6.3 | Yes | Yes | Yes | Yes | ||||||||
ignore_db_dirs |
5.6.3 | Yes | Global | No | Yes | Yes | |||||||
init_connect |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
init-file |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
init-rpl-role |
5.5.3, 6.0.14 | Yes | Yes | Yes | Yes | Yes | |||||||
init_slave |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
innodb |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
innodb_adaptive_flushing |
5.1.38 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_adaptive_flushing_lwm |
5.6.6 | 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 | Yes | Yes | ||
innodb_adaptive_max_sleep_delay |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_additional_mem_pool_size |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
innodb_api_bk_commit_interval |
5.6.7 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_api_disable_rowlock |
5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_api_enable_binlog |
5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_api_enable_mdl |
5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_api_trx_level |
5.6.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_autoextend_increment |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
innodb_autoinc_lock_mode |
5.1.22 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | |||
Innodb_available_undo_logs |
5.6.5 | Yes | Global | No | Yes | Yes | |||||||
innodb_buffer_pool_awe_mem_mb |
Yes | Yes | Yes | Global | No | Yes | Yes | ||||||
Innodb_buffer_pool_bytes_data |
5.5.30, 5.6.10 | Yes | Global | No | Yes | Yes | Yes | ||||||
Innodb_buffer_pool_bytes_dirty |
5.5.30, 5.6.10 | Yes | Global | No | Yes | Yes | Yes | ||||||
innodb_buffer_pool_dump_at_shutdown |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_buffer_pool_dump_now |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_buffer_pool_dump_pct |
5.7.2 | Yes | Yes | Yes | Global | Yes | Yes | ||||||
Innodb_buffer_pool_dump_status |
5.6.3 | Yes | Global | No | Yes | Yes | |||||||
innodb_buffer_pool_filename |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_buffer_pool_instances |
5.5.4 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
innodb_buffer_pool_load_abort |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_buffer_pool_load_at_startup |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_buffer_pool_load_now |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
Innodb_buffer_pool_load_status |
5.6.3 | Yes | Global | No | Yes | Yes | |||||||
Innodb_buffer_pool_pages_data |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_dirty |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_flushed |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_free |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_latched |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_misc |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_buffer_pool_pages_total |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_buffer_pool_read_ahead |
5.1.42 | Yes | Global | No | Yes | Yes | Yes | Yes | |||||
Innodb_buffer_pool_read_ahead_evicted |
5.1.42 | Yes | Global | No | Yes | Yes | Yes | Yes | |||||
Innodb_buffer_pool_read_ahead_rnd |
5.0.2 | Yes | Global | No | Yes | Yes | |||||||
Innodb_buffer_pool_read_ahead_seq |
5.0.2 | Yes | Global | No | Yes | Yes | |||||||
Innodb_buffer_pool_read_requests |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_buffer_pool_reads |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
innodb_buffer_pool_size |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
Innodb_buffer_pool_wait_free |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_buffer_pool_write_requests |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
innodb_change_buffer_max_size |
5.6.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_change_buffering |
5.1.38 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_checksum_algorithm |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_checksums |
5.0.3 | 5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |
innodb_cmp_per_index_enabled |
5.6.7 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_commit_concurrency |
5.0.12 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
innodb_compression_failure_threshold_pct |
5.6.7 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_compression_level |
5.6.7 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_compression_pad_pct_max |
5.6.7 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_concurrency_tickets |
5.0.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
innodb_data_file_path |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
Innodb_data_fsyncs |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
innodb_data_home_dir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
Innodb_data_pending_fsyncs |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_data_pending_reads |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_data_pending_writes |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_data_read |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_data_reads |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_data_writes |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_data_written |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_dblwr_pages_written |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_dblwr_writes |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
innodb_disable_sort_file_cache |
5.6.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_doublewrite |
5.0.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
innodb_fast_shutdown |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
innodb_file_format |
5.1.38 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_file_format_check |
5.1.38 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | |||
innodb_file_format_max |
5.5.5 | Yes | Yes | Yes | Global | Yes | 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 | Yes | Yes | |||
innodb_flush_log_at_timeout |
5.6.6 | Yes | Global | Yes | Yes | Yes | |||||||
innodb_flush_log_at_trx_commit |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
innodb_flush_method |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
innodb_flush_neighbors |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_flushing_avg_loops |
5.6.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_force_load_corrupted |
5.5.18, 5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
innodb_force_recovery |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
innodb_ft_aux_table |
5.6.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_ft_cache_size |
5.6.4 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_ft_enable_diag_print |
5.6.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_ft_enable_stopword |
5.6.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_ft_max_token_size |
5.6.4 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_ft_min_token_size |
5.6.4 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_ft_num_word_optimize |
5.6.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_ft_server_stopword_table |
5.6.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_ft_sort_pll_degree |
5.6.4 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_ft_user_stopword_table |
5.6.4 | Yes | Yes | Yes | Both | Yes | Yes | Yes | |||||
Innodb_have_atomic_builtins |
5.1.38 | Yes | Global | No | Yes | Yes | Yes | Yes | |||||
innodb_io_capacity |
5.1.38 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_io_capacity_max |
5.6.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_large_prefix |
5.5.14, 5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
innodb_lock_wait_timeout |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
innodb_locks_unsafe_for_binlog |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | 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 | Yes | Yes | |||
innodb_log_compressed_pages |
5.6.11 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_log_file_size |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
innodb_log_files_in_group |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
innodb_log_group_home_dir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
Innodb_log_waits |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_log_write_requests |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_log_writes |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
innodb_lru_scan_depth |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_max_dirty_pages_pct |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
innodb_max_dirty_pages_pct_lwm |
5.6.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_max_purge_lag |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
innodb_max_purge_lag_delay |
5.6.5 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_mirrored_log_groups |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | ||||
innodb_monitor_disable |
5.6.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_monitor_enable |
5.6.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_monitor_reset |
5.6.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_monitor_reset_all |
5.6.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
Innodb_num_open_files |
5.6.2 | Yes | Global | No | Yes | Yes | |||||||
innodb_old_blocks_pct |
5.1.41 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_old_blocks_time |
5.1.41 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_online_alter_log_max_size |
5.6.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_open_files |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
innodb_optimize_fulltext_only |
5.6.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
Innodb_os_log_fsyncs |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_os_log_pending_fsyncs |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_os_log_pending_writes |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_os_log_written |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
innodb_page_size |
5.6.4 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
Innodb_page_size |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_pages_created |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_pages_read |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_pages_written |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
innodb_print_all_deadlocks |
5.5.30, 5.6.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
innodb_purge_batch_size |
5.5.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
innodb_purge_threads |
5.5.4 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
innodb_random_read_ahead |
5.1.59, 5.5.16, 5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_read_ahead_threshold |
5.1.38 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_read_io_threads |
5.1.38 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | |||
innodb_read_only |
5.6.7 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_replication_delay |
5.1.38 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_rollback_on_timeout |
5.0.32, 5.1.15 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
innodb_rollback_segments |
5.5.11, 5.6.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
Innodb_row_lock_current_waits |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_row_lock_time |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_row_lock_time_avg |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_row_lock_time_max |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_row_lock_waits |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_rows_deleted |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_rows_inserted |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_rows_read |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Innodb_rows_updated |
5.0.2 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
innodb-safe-binlog |
5.0.3 | Yes | Yes | Yes | |||||||||
innodb_sort_buffer_size |
5.6.4 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_spin_wait_delay |
5.1.38 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_stats_auto_recalc |
5.6.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_stats_method |
5.1.56, 5.5.10, 5.6.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_stats_on_metadata |
5.1.17, 5.5.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
innodb_stats_persistent |
5.6.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_stats_persistent_sample_pages |
5.6.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_stats_sample_pages |
5.1.38 | 5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | ||
innodb_stats_transient_sample_pages |
5.6.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb-status-file |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
innodb_strict_mode |
5.1.38 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | |||
innodb_support_xa |
5.0.3 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||
innodb_sync_array_size |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_sync_spin_loops |
5.0.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
innodb_table_locks |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
innodb_temp_data_file_path |
5.7.1 | Yes | Yes | Yes | Global | No | Yes | ||||||
innodb_thread_concurrency |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
innodb_thread_sleep_delay |
5.0.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
Innodb_truncated_status_writes |
5.5.7 | Yes | Global | No | Yes | Yes | Yes | ||||||
innodb_undo_directory |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_undo_logs |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_undo_tablespaces |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
innodb_use_legacy_cardinality_algorithm |
5.0.82, 5.1.35 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
innodb_use_native_aio |
5.5.4 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
innodb_use_sys_malloc |
5.1.38 | 5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | ||
innodb_version |
5.1.38 | Yes | Global | No | Yes | Yes | Yes | Yes | |||||
innodb_write_io_threads |
5.1.38 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | |||
insert_id |
Yes | Session | Yes | Yes | Yes | Yes | Yes | Yes | |||||
install |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
install-manual |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
interactive_timeout |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
join_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
keep_files_on_create |
5.0.48, 5.1.21 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||
Key_blocks_not_flushed |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Key_blocks_unused |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Key_blocks_used |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
key_buffer_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
key_cache_age_threshold |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
key_cache_block_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
key_cache_division_limit |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
Key_read_requests |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Key_reads |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Key_write_requests |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Key_writes |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
language |
5.5.0, 5.6.1 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
large_files_support |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
large_page_size |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
large-pages |
5.0.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
last_insert_id |
Yes | Session | Yes | Yes | Yes | Yes | Yes | Yes | |||||
Last_query_cost |
5.0.1 | Yes | Session | No | Yes | Yes | Yes | Yes | Yes | ||||
Last_query_partial_plans |
5.6.5 | Yes | Session | No | Yes | Yes | |||||||
lc-messages |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||||
lc-messages-dir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||||
lc_time_names |
5.0.25, 5.1.12 | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||||
license |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
local_infile |
Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||||
lock_wait_timeout |
5.5.3 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||||
locked_in_memory |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
log |
5.1.29 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
log_bin |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
log-bin |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
log_bin_basename |
5.6.2 | Yes | Global | No | Yes | Yes | |||||||
log_bin_index |
5.6.4 | Yes | Global | No | Yes | Yes | |||||||
log-bin-index |
Yes | Yes | 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_bin_use_v1_row_events |
5.1.56-ndb-7-0-27, 5.1.56-ndb-7.1.16, 5.5.15-ndb-7.2.1, 5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | |||
log-bin-use-v1-row-events |
5.1.56-ndb-7-0-27, 5.1.56-ndb-7.1.16, 5.5.15-ndb-7.2.1, 5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | |||
log-error |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
log_error_verbosity |
5.7.2 | Yes | Yes | Yes | Global | Yes | Yes | ||||||
log-isam |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
log-output |
5.1.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
log-queries-not-using-indexes |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
log-raw |
5.6.3 | Yes | Yes | Yes | Yes | ||||||||
log-short-format |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
log-slave-updates |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
log_slave_updates |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
log_slow_admin_statements |
5.6.11, 5.7.1 | Yes | Global | Yes | Yes | Yes | |||||||
log-slow-admin-statements |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
log-slow-queries |
5.1.29 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
log_slow_slave_statements |
5.6.11, 5.7.1 | Yes | Global | Yes | Yes | Yes | |||||||
log-slow-slave-statements |
5.1.21 | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
log-tc |
5.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||
log-tc-size |
5.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||
log_throttle_queries_not_using_indexes |
5.6.5 | Yes | Global | Yes | Yes | Yes | |||||||
log_timestamps |
5.7.2 | Yes | Yes | Yes | Global | Yes | Yes | ||||||
log-warnings |
5.7.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
long_query_time |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
low-priority-updates |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
lower_case_file_system |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
lower_case_table_names |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | 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 | Yes | Yes | ||||||
master_info_repository |
5.6.2 | Yes | Global | Yes | Yes | Yes | |||||||
master-info-repository |
5.6.2 | 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 |
5.6.1 | Yes | Yes | 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 | |||||||
master_verify_checksum |
5.6.2 | Yes | Global | Yes | Yes | Yes | |||||||
master-verify-checksum |
5.6.2 | Yes | Yes | Yes | Yes | ||||||||
max_allowed_packet |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_binlog_cache_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
max-binlog-dump-events |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
max_binlog_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_binlog_stmt_cache_size |
5.5.9, 5.6.1 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
max_connect_errors |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_connections |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_delayed_threads |
5.6.7 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||
max_error_count |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_heap_table_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_insert_delayed_threads |
5.6.7 | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||||
max_join_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_length_for_sort_data |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_long_data_size |
5.1.57, 5.5.11 | 5.1.57, 5.5.11 | Yes | Yes | Yes | Global | No | Yes | Yes | ||||
max_prepared_stmt_count |
5.0.21, 5.1.10 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
max_relay_log_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_seeks_for_key |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_sort_length |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_sp_recursion_depth |
5.0.17 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||
Max_used_connections |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
max_user_connections |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
max_write_lock_count |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
memlock |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
merge |
5.0.24, 5.1.12 | Yes | Yes | Yes | Yes | ||||||||
metadata_locks_cache_size |
5.5.19, 5.6.4 | Yes | Global | No | Yes | Yes | Yes | ||||||
metadata_locks_hash_instances |
5.6.8 | Yes | Global | No | Yes | Yes | |||||||
min-examined-row-limit |
5.1.21 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | |||
multi_range_count |
5.0.3 | Yes | Yes | Yes | Both | Yes | Yes | Yes | |||||
myisam-block-size |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
myisam_data_pointer_size |
Yes | Yes | Yes | Global | Yes | Yes | 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 | Yes | Yes | |||
myisam_mmap_size |
5.0.90, 5.1.43, 5.5.1 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
myisam-recover |
Yes | Yes | Yes | Yes | Yes | ||||||||
myisam-recover-options |
5.5.3 | Yes | Yes | Yes | Yes | Yes | |||||||
myisam_recover_options |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
myisam_repair_threads |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
myisam_sort_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
myisam_stats_method |
5.0.14 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||
myisam_use_mmap |
5.1.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
named_pipe |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ndb_api_bytes_received_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_bytes_received_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_bytes_received_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_bytes_sent_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_bytes_sent_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_bytes_sent_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_event_bytes_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_event_bytes_count_injector |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_event_data_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_event_data_count_injector |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_event_nondata_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_event_nondata_count_injector |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_pk_op_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_pk_op_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_pk_op_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_pruned_scan_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_pruned_scan_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_pruned_scan_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_range_scan_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_range_scan_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_range_scan_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_read_row_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_read_row_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_read_row_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_scan_batch_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_scan_batch_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_scan_batch_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_table_scan_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_table_scan_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_table_scan_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_abort_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_abort_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_abort_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_close_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_close_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_close_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_commit_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_commit_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_commit_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_local_read_row_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_local_read_row_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_local_read_row_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_start_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_start_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_trans_start_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_uk_op_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_uk_op_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_uk_op_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_exec_complete_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_exec_complete_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_exec_complete_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_meta_request_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_meta_request_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_meta_request_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_nanos_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_nanos_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_nanos_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_scan_result_count |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_scan_result_count_session |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Session | No | Yes | Yes | Yes | ||||||
Ndb_api_wait_scan_result_count_slave |
5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11 | Yes | Global | No | Yes | Yes | Yes | ||||||
ndb_autoincrement_prefetch_sz |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | ||||
ndb-batch-size |
5.1.23-ndb-6.3.8 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
ndb-blob-read-batch-bytes |
5.1.51-ndb-7.0.21, 5.1.51-ndb-7.1.10 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||||
ndb-blob-write-batch-bytes |
5.1.51-ndb-7.0.21, 5.1.51-ndb-7.1.10 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||||
ndb_cache_check_time |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | ||||
ndb-cluster-connection-pool |
5.1.19-ndb-6.2.2 | Yes | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | |||
Ndb_cluster_node_id |
Yes | Both | No | Yes | Yes | Yes | Yes | ||||||
Ndb_config_from_host |
5.0.23, 5.1.12 | Yes | Both | No | Yes | Yes | Yes | Yes | |||||
Ndb_config_from_port |
5.0.23, 5.1.12 | Yes | Both | No | Yes | Yes | Yes | Yes | |||||
Ndb_conflict_fn_epoch |
5.1.56-ndb-7.1.16, 5.5.15-ndb-7.2.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_conflict_fn_epoch_trans |
5.1.56-ndb-7.1.16, 5.5.15-ndb-7.2.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_conflict_fn_max |
5.1.22-ndb-6.3.3 | Yes | Global | No | Yes | Yes | Yes | Yes | |||||
Ndb_conflict_fn_old |
5.1.22-ndb-6.3.4 | Yes | Global | No | Yes | Yes | Yes | Yes | |||||
Ndb_conflict_trans_conflict_commit_count |
5.1.56-ndb-7.1.16, 5.5.15-ndb-7.2.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_conflict_trans_detect_iter_count |
5.1.56-ndb-7.1.16, 5.5.15-ndb-7.2.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_conflict_trans_reject_count |
5.1.56-ndb-7.1.16, 5.5.15-ndb-7.2.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_conflict_trans_row_conflict_count |
5.1.56-ndb-7.1.16, 5.5.15-ndb-7.2.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_conflict_trans_row_reject_count |
5.1.56-ndb-7.1.16, 5.5.15-ndb-7.2.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
ndb-connectstring |
Yes | Yes | Yes | Yes | Yes | ||||||||
ndb-deferred-constraints |
5.1.56-ndb-7.0.28, 5.1.56-ndb-7.1.14 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||||
ndb_deferred_constraints |
5.1.56-ndb-7.0.28, 5.1.56-ndb-7.1.14 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | ||||
ndb_distribution |
5.1.32-ndb-7.0.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
ndb-distribution |
5.1.32-ndb-7.0.4 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
ndb_execute_count |
5.1.22-ndb-6.3.6 | Yes | Global | No | Yes | Yes | Yes | ||||||
ndb_extra_logging |
5.1.6 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
ndb_force_send |
Yes | Yes | Yes | Both | Yes | Yes | 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_join_pushdown |
5.1.51-ndb-7.2.0 | Yes | Global | No | Yes | Yes | Yes | ||||||
ndb-log-apply-status |
5.1.51-ndb-7.0.21, 5.1.51-ndb-7.1.10 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
ndb_log_bin |
5.1.6 | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||||
ndb_log_binlog_index |
5.1.6 | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||||
ndb_log_empty_epochs |
5.1.31-ndb-6.3.21, 5.1.31-ndb-6.4.1 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
ndb-log-empty-epochs |
5.1.31-ndb-6.3.21, 5.1.31-ndb-6.4.1 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
ndb-log-orig |
5.1.22-ndb-6.3.2 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
ndb-log-transaction-id |
5.1.56-ndb-7.1.16, 5.5.15-ndb-7.2.1 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
ndb_log_transaction_id |
5.1.56-ndb-7.1.16, 5.5.15-ndb-7.2.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
ndb-log-update-as-write |
5.1.19-ndb-6.3.0, 5.1.22-ndb-6.2.5 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
ndb_log_updated_only |
5.1.19-ndb-6.3.0 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
ndb-mgmd-host |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
ndb-nodeid |
5.0.45, 5.1.15 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | |||
Ndb_number_of_data_nodes |
5.1.12 | Yes | Global | No | Yes | Yes | Yes | Yes | |||||
ndb_optimization_delay |
5.1.23-ndb-6.3.7 | Yes | Global | Yes | Yes | Yes | Yes | ||||||
ndb_optimized_node_selection |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
ndb_pruned_scan_count |
5.1.32-ndb-6.3.25, 5.1.32-ndb-7.0.5 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_pushed_queries_defined |
5.1.51-ndb-7.2.0 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_pushed_queries_dropped |
5.1.51-ndb-7.2.0 | Yes | Global | No | Yes | Yes | Yes | ||||||
Ndb_pushed_queries_executed |
5.1.51-ndb-7.2.0 | Yes | Global | No | Yes | Yes | Yes | ||||||
ndb_pushed_reads |
5.1.51-ndb-7.2.0 | Yes | Global | No | Yes | Yes | Yes | ||||||
ndb-recv-thread-activation-threshold |
5.6.10-ndb-7.3.1 | Yes | Yes | Yes | |||||||||
ndb_recv_thread_activation_threshold |
5.6.10-ndb-7.3.1 | Yes | |||||||||||
ndb-recv-thread-cpu-mask |
5.6.10-ndb-7.3.1 | Yes | Yes | Yes | |||||||||
ndb_recv_thread_cpu_mask |
5.6.10-ndb-7.3.1 | Yes | Global | Yes | Yes | ||||||||
ndb_report_thresh_binlog_epoch_slip |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
ndb_report_thresh_binlog_mem_usage |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
ndb_scan_count |
5.1.32-ndb-6.3.25, 5.1.32-ndb-7.0.5 | Yes | Global | No | Yes | Yes | Yes | ||||||
ndb_table_no_logging |
5.1.23-ndb-6.3.8 | Yes | Session | Yes | Yes | Yes | Yes | ||||||
ndb_table_temporary |
5.1.23-ndb-6.3.8 | Yes | Session | Yes | Yes | Yes | Yes | ||||||
ndb-transid-mysql-connection-map |
5.1.56-ndb-7.1.17, 5.5.16-ndb-7.2.2 | Yes | Yes | Yes | Yes | ||||||||
ndb_use_copying_alter_table |
5.1.12 | Yes | Both | No | Yes | Yes | Yes | ||||||
ndb_use_exact_count |
Yes | Both | Yes | Yes | Yes | Yes | Yes | ||||||
ndb_use_transactions |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | ||||
ndb-wait-connected |
5.1.16-ndb-6.2.0 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
ndb-wait-setup |
5.1.39-ndb-6.2.19, 5.1.39-ndb-6.3.28, 5.1.39-ndb-7.0.9 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
ndbcluster |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
ndbinfo_database |
5.1.41-ndb-7.1.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
ndbinfo_max_bytes |
5.1.41-ndb-7.1.1 | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||||
ndbinfo_max_rows |
5.1.41-ndb-7.1.1 | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||||
ndbinfo_offline |
5.1.41-ndb-7.1.1 | Yes | Global | Yes | Yes | Yes | Yes | ||||||
ndbinfo_show_hidden |
5.1.41-ndb-7.1.1 | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||||
ndbinfo_table_prefix |
5.1.41-ndb-7.1.1 | Yes | Yes | Both | Yes | Yes | Yes | Yes | |||||
ndbinfo_version |
5.1.41-ndb-7.1.1 | Yes | Global | No | Yes | Yes | Yes | ||||||
net_buffer_length |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
net_read_timeout |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
net_retry_count |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
net_write_timeout |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
new |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
no-defaults |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
Not_flushed_delayed_rows |
5.6.7 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
old |
5.1.18 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | |||
old-alter-table |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | ||||
old_passwords |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
old-style-user-limits |
5.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||
one-thread |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
Open_files |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
open-files-limit |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
Open_streams |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Open_table_definitions |
5.1.3 | Yes | Global | No | Yes | Yes | Yes | Yes | |||||
Open_tables |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Opened_files |
5.1.21 | Yes | Global | No | Yes | Yes | Yes | Yes | |||||
Opened_table_definitions |
5.1.24 | Yes | Both | No | Yes | Yes | Yes | Yes | |||||
Opened_tables |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
optimizer_join_cache_level |
5.6.1 | Yes | Yes | Yes | Both | Yes | Yes | ||||||
optimizer_prune_level |
5.0.1 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||
optimizer_search_depth |
5.0.1 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||
optimizer_switch |
5.1.34 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | |||
optimizer_trace |
5.6.3 | Yes | Both | Yes | Yes | Yes | |||||||
optimizer_trace_features |
5.6.3 | Yes | Both | Yes | Yes | Yes | |||||||
optimizer_trace_limit |
5.6.3 | Yes | Both | Yes | Yes | Yes | |||||||
optimizer_trace_max_mem_size |
5.6.3 | Yes | Both | Yes | Yes | Yes | |||||||
optimizer_trace_offset |
5.6.3 | Yes | Both | Yes | Yes | Yes | |||||||
partition |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
performance_schema |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
Performance_schema_accounts_lost |
5.6.3 | Yes | Global | No | Yes | Yes | |||||||
performance_schema_accounts_size |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
Performance_schema_cond_classes_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_cond_instances_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
performance_schema_digests_size |
5.6.5 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance_schema_events_stages_history_long_size |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance_schema_events_stages_history_size |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance_schema_events_statements_history_long_size |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance_schema_events_statements_history_size |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance_schema_events_waits_history_long_size |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_events_waits_history_size |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
Performance_schema_file_classes_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_file_handles_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_file_instances_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_hosts_lost |
5.6.3 | Yes | Global | No | Yes | Yes | |||||||
performance_schema_hosts_size |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance-schema-instrument |
5.6.4 | Yes | Yes | Yes | Yes | ||||||||
Performance_schema_locker_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
performance_schema_max_cond_classes |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_cond_instances |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_file_classes |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_file_handles |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_file_instances |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_memory_classes |
5.7.2 | Yes | Yes | Yes | Global | No | Yes | ||||||
performance_schema_max_metadata_locks |
5.7.3 | Yes | Yes | Yes | Global | No | Yes | ||||||
performance_schema_max_mutex_classes |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_mutex_instances |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_program_instances |
5.7.2 | Yes | Yes | Yes | Global | No | Yes | ||||||
performance_schema_max_rwlock_classes |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_rwlock_instances |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_socket_classes |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance_schema_max_socket_instances |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance_schema_max_stage_classes |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance_schema_max_statement_classes |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance_schema_max_statement_stack |
5.7.2 | Yes | Yes | Yes | Global | No | Yes | ||||||
performance_schema_max_table_handles |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_table_instances |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_thread_classes |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
performance_schema_max_thread_instances |
5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
Performance_schema_memory_classes_lost |
5.7.2 | Yes | Global | No | Yes | ||||||||
Performance_schema_metadata_lock_lost |
5.7.3 | Yes | Global | No | Yes | ||||||||
Performance_schema_mutex_classes_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_mutex_instances_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_nested_statement_lost |
5.7.2 | Yes | Global | No | Yes | ||||||||
Performance_schema_program_lost |
5.7.2 | Yes | Global | No | Yes | ||||||||
Performance_schema_rwlock_classes_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_rwlock_instances_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_session_connect_attrs_lost |
5.6.6 | Yes | Global | No | Yes | Yes | |||||||
performance_schema_session_connect_attrs_size |
5.6.6 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance_schema_setup_actors_size |
5.6.1 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
performance_schema_setup_objects_size |
5.6.1 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
Performance_schema_socket_classes_lost |
5.6.3 | Yes | Global | No | Yes | Yes | |||||||
Performance_schema_socket_instances_lost |
5.6.3 | Yes | Global | No | Yes | Yes | |||||||
Performance_schema_stage_classes_lost |
5.6.3 | Yes | Global | No | Yes | Yes | |||||||
Performance_schema_statement_classes_lost |
5.6.3 | Yes | Global | No | Yes | Yes | |||||||
Performance_schema_table_handles_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_table_instances_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_thread_classes_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_thread_instances_lost |
5.5.3 | Yes | Global | No | Yes | Yes | Yes | ||||||
Performance_schema_users_lost |
5.6.3 | Yes | Global | No | Yes | Yes | |||||||
performance_schema_users_size |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
pid-file |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
plugin |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
plugin_dir |
5.0.67, 5.1.2 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
plugin-load |
5.1.18 | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
plugin-load-add |
5.6.3 | Yes | Yes | Yes | Yes | ||||||||
port |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
port-open-timeout |
5.0.19, 5.1.5 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||
preload_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
prepared_stmt_count |
5.0.21, 5.1.10 | Yes | Global | No | Yes | Yes | |||||||
Prepared_stmt_count |
5.0.32, 5.1.14 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
print-defaults |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
profiling |
5.0.37, 5.1.24 | 5.6.8 | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
profiling_history_size |
5.0.37, 5.1.24 | 5.6.8 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |
protocol_version |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
proxy_user |
5.5.7 | Yes | Session | No | Yes | Yes | Yes | ||||||
pseudo_slave_mode |
5.5.30, 5.6.10 | Yes | Session | Yes | Yes | Yes | Yes | ||||||
pseudo_thread_id |
Yes | Session | Yes | Yes | Yes | Yes | Yes | Yes | |||||
Qcache_free_blocks |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Qcache_free_memory |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Qcache_hits |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Qcache_inserts |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Qcache_lowmem_prunes |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Qcache_not_cached |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Qcache_queries_in_cache |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Qcache_total_blocks |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Queries |
5.0.76, 5.1.31 | Yes | Both | No | Yes | Yes | Yes | Yes | Yes | ||||
query_alloc_block_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
query_cache_limit |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
query_cache_min_res_unit |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
query_cache_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
query_cache_type |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
query_cache_wlock_invalidate |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
query_prealloc_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
Questions |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
rand_seed1 |
Yes | Session | Yes | Yes | Yes | Yes | Yes | Yes | |||||
rand_seed2 |
Yes | Session | Yes | Yes | Yes | Yes | Yes | Yes | |||||
range_alloc_block_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
read_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
read_only |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
read_rnd_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
relay-log |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
relay_log_basename |
5.6.2 | Yes | Global | No | Yes | Yes | |||||||
relay-log-index |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
relay_log_index |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
relay-log-info-file |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
relay_log_info_file |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
relay-log-info-repository |
5.6.2 | Yes | Yes | Yes | Yes | ||||||||
relay_log_info_repository |
5.6.2 | Yes | Global | Yes | Yes | Yes | |||||||
relay_log_purge |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
relay_log_recovery |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||||
relay-log-recovery |
Yes | Yes | Yes | Yes | Yes | ||||||||
relay_log_space_limit |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
remove |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
replicate-do-db |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
replicate-do-table |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
replicate-ignore-db |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
replicate-ignore-table |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
replicate-rewrite-db |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
replicate-same-server-id |
5.0.1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||
replicate-wild-do-table |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
replicate-wild-ignore-table |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
report-host |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
report-password |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
report-port |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
report-user |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
rpl_recovery_rank |
5.5.3, 6.0.14 | Yes | Global | Yes | Yes | Yes | Yes | ||||||
Rpl_semi_sync_master_clients |
Yes | Global | No | Yes | Yes | Yes | |||||||
rpl_semi_sync_master_enabled |
Yes | Global | Yes | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_net_avg_wait_time |
Yes | Global | No | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_net_wait_time |
Yes | Global | No | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_net_waits |
Yes | Global | No | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_no_times |
Yes | Global | No | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_no_tx |
Yes | Global | No | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_status |
Yes | Global | No | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_timefunc_failures |
Yes | Global | No | Yes | Yes | Yes | |||||||
rpl_semi_sync_master_timeout |
Yes | Global | Yes | Yes | Yes | Yes | |||||||
rpl_semi_sync_master_trace_level |
Yes | Global | Yes | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_tx_avg_wait_time |
Yes | Global | No | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_tx_wait_time |
Yes | Global | No | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_tx_waits |
Yes | Global | No | Yes | Yes | Yes | |||||||
rpl_semi_sync_master_wait_no_slave |
Yes | Global | Yes | Yes | Yes | Yes | |||||||
rpl_semi_sync_master_wait_point |
5.7.2 | Yes | Global | Yes | Yes | ||||||||
Rpl_semi_sync_master_wait_pos_backtraverse |
Yes | Global | No | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_wait_sessions |
Yes | Global | No | Yes | Yes | Yes | |||||||
Rpl_semi_sync_master_yes_tx |
Yes | Global | No | Yes | Yes | Yes | |||||||
rpl_semi_sync_slave_enabled |
Yes | Global | Yes | Yes | Yes | Yes | |||||||
Rpl_semi_sync_slave_status |
Yes | Global | No | Yes | Yes | Yes | |||||||
rpl_semi_sync_slave_trace_level |
Yes | Global | Yes | Yes | Yes | Yes | |||||||
Rpl_status |
5.5.3, 6.0.14 | Yes | Global | No | Yes | Yes | Yes | ||||||
rpl_stop_slave_timeout |
5.6.13, 5.7.2 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
Rsa_public_key |
5.6.6 | Yes | Global | No | Yes | Yes | |||||||
safe-mode |
5.5.26 | Yes | 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 | Yes | Yes | ||||||
safemalloc-mem-limit |
Yes | Yes | Yes | Yes | Yes | ||||||||
secure-auth |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
secure-file-priv |
5.0.38, 5.1.17 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
Select_full_join |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Select_full_range_join |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Select_range |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Select_range_check |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Select_scan |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
server-id |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
server-id-bits |
5.1.47-ndb-7.0.17, 5.1.47-ndb-7.1.6 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | ||||
server_uuid |
5.6.0 | Yes | Global | No | Yes | Yes | |||||||
set-variable |
5.0.0 | Yes | Yes | Yes | |||||||||
sha256_password_private_key_path |
5.6.6 | Yes | Global | No | Yes | Yes | |||||||
sha256_password_public_key_path |
5.6.6 | Yes | Global | No | Yes | Yes | |||||||
shared_memory |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
shared_memory_base_name |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
show-slave-auth-info |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
skip-bdb |
Yes | Yes | Yes | ||||||||||
skip-character-set-client-handshake |
5.0.13 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||
skip-concurrent-insert |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
skip-event-scheduler |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
skip_external_locking |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
skip-grant-tables |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
skip-host-cache |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
skip-locking |
4.1.0 | Yes | Yes | Yes | Yes | Yes | |||||||
skip-merge |
5.0.24, 5.1.12 | Yes | Yes | Yes | Yes | ||||||||
skip-name-resolve |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
skip-ndbcluster |
Yes | Yes | Yes | Yes | Yes | ||||||||
skip-networking |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
skip-new |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
skip-partition |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
skip-safemalloc |
Yes | Yes | Yes | Yes | Yes | ||||||||
skip-show-database |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
skip-slave-start |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
skip-ssl |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
skip-stack-trace |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
skip-symbolic-links |
Yes | Yes | Yes | Yes | Yes | Yes | |||||||
skip-symlink |
Yes | Yes | Yes | Yes | Yes | ||||||||
skip-sync-bdb-logs |
4.1.0 | Yes | Yes | Yes | Global | No | Yes | ||||||
skip-thread-priority |
5.1.29 | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
slave_allow_batching |
5.1.19-ndb-6.2.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
slave_checkpoint_group |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
slave-checkpoint-group |
5.6.3 | Yes | Yes | Yes | Yes | ||||||||
slave_checkpoint_period |
5.6.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
slave-checkpoint-period |
5.6.3 | Yes | Yes | Yes | Yes | ||||||||
slave_compressed_protocol |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
slave_exec_mode |
5.1.23-ndb-6.2.14, 5.1.23-ndb-6.3.11, 5.1.24 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
Slave_heartbeat_period |
5.1.22-ndb-6.3.4 | Yes | Global | No | Yes | Yes | Yes | Yes | |||||
Slave_last_heartbeat |
5.6.1 | Yes | Global | No | Yes | Yes | |||||||
slave-load-tmpdir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
slave_max_allowed_packet |
5.1.64, 5.5.26, 5.6.6 | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||||
slave-max-allowed-packet |
5.1.64, 5.5.26, 5.6.6 | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
slave-net-timeout |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
Slave_open_temp_tables |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
slave_parallel_type |
5.7.2 | Yes | Global | Yes | Yes | ||||||||
slave-parallel-type |
5.7.2 | Yes | Yes | Yes | |||||||||
slave_parallel_workers |
5.6.3 | Yes | Global | Yes | Yes | Yes | |||||||
slave-parallel-workers |
5.6.3 | Yes | Yes | Yes | Yes | ||||||||
slave_pending_jobs_size_max |
5.6.3 | Yes | Global | Yes | Yes | Yes | |||||||
slave-pending-jobs-size-max |
5.6.3 | Yes | Yes | Yes | |||||||||
Slave_received_heartbeats |
5.1.22-ndb-6.3.4 | Yes | Global | No | Yes | Yes | Yes | Yes | |||||
Slave_retried_transactions |
5.0.4 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
slave-rows-search-algorithms |
5.6.6 | Yes | Yes | Yes | Yes | ||||||||
slave_rows_search_algorithms |
5.6.6 | Yes | Global | Yes | Yes | Yes | |||||||
Slave_running |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
slave-skip-errors |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
slave_sql_verify_checksum |
5.6.2 | Yes | Global | Yes | Yes | Yes | |||||||
slave-sql-verify-checksum |
5.6.2 | Yes | Yes | Yes | Yes | ||||||||
slave_transaction_retries |
5.0.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
slave_type_conversions |
5.1.44-ndb-6.3.33, 5.1.44-ndb-7.0.14, 5.1.44-ndb-7.1.3, 5.5.3 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | |||
Slow_launch_threads |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
slow_launch_time |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
Slow_queries |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
slow-query-log |
5.1.12 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
slow_query_log_file |
5.1.12 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||
slow-start-timeout |
5.5.20, 5.6.5 | Yes | Yes | Yes | Yes | Yes | |||||||
socket |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
sort_buffer_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
Sort_merge_passes |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Sort_range |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Sort_rows |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Sort_scan |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
sporadic-binlog-dump-fail |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
sql_auto_is_null |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
sql_big_selects |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
sql_big_tables |
Yes | Both | Yes | Yes | Yes | Yes | Yes | ||||||
sql_buffer_result |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
sql_log_bin |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
sql_log_off |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
sql_log_update |
5.0.0 | Yes | Session | Yes | Yes | Yes | Yes | ||||||
sql_low_priority_updates |
4.1.0 | Yes | Both | Yes | Yes | Yes | Yes | Yes | |||||
sql_max_join_size |
4.1.0 | Yes | Both | Yes | Yes | Yes | Yes | Yes | |||||
sql-mode |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
sql_notes |
5.0.3 | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||||
sql_quote_show_create |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
sql_safe_updates |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
sql_select_limit |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
sql_slave_skip_counter |
Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||||
sql_warnings |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
ssl |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
Ssl_accept_renegotiates |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_accepts |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
ssl-ca |
5.0.23, 5.1.11 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
Ssl_callback_cache_hits |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
ssl-capath |
5.0.23, 5.1.11 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
ssl-cert |
5.0.23, 5.1.11 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
ssl-cipher |
5.0.23, 5.1.11 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
Ssl_cipher |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_cipher_list |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_client_connects |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_connect_renegotiates |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
ssl-crl |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
ssl-crlpath |
5.6.3 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
Ssl_ctx_verify_depth |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_ctx_verify_mode |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_default_timeout |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_finished_accepts |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_finished_connects |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
ssl-key |
5.0.23, 5.1.11 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
Ssl_server_not_after |
5.6.3 | Yes | Both | No | Yes | Yes | |||||||
Ssl_server_not_before |
5.6.3 | Yes | Both | No | Yes | Yes | |||||||
Ssl_session_cache_hits |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_session_cache_misses |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_session_cache_mode |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_session_cache_overflows |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_session_cache_size |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_session_cache_timeouts |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_sessions_reused |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_used_session_cache_entries |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_verify_depth |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
Ssl_verify_mode |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
ssl-verify-server-cert |
5.1.11 | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
Ssl_version |
Yes | Both | No | Yes | Yes | Yes | Yes | Yes | |||||
standalone |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
storage_engine |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
stored_program_cache |
5.5.21, 5.6.5 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | ||||
super-large-pages |
5.5.3 | Yes | Yes | Yes | Yes | Yes | |||||||
symbolic-links |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
sync-bdb-logs |
4.1.0 | Yes | Yes | Yes | Global | No | Yes | ||||||
sync_binlog |
5.0.1 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
sync_frm |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
sync_master_info |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||||
sync_relay_log |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||||
sync_relay_log_info |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | |||||
sysdate-is-now |
5.0.20, 5.1.8 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||
system_time_zone |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
table_cache |
5.1.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
table_definition_cache |
5.1.3 | Yes | Global | Yes | Yes | 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 | Yes | Yes | |||||
Table_locks_waited |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
table_open_cache |
5.1.3 | Yes | Global | Yes | Yes | Yes | Yes | Yes | |||||
Table_open_cache_hits |
5.6.6 | Yes | Both | No | Yes | Yes | |||||||
table_open_cache_instances |
5.6.6 | Yes | Global | No | Yes | Yes | |||||||
Table_open_cache_misses |
5.6.6 | Yes | Both | No | Yes | Yes | |||||||
Table_open_cache_overflows |
5.6.6 | Yes | Both | No | Yes | Yes | |||||||
table_type |
5.2.5 | Yes | Both | Yes | Yes | Yes | Yes | ||||||
tc-heuristic-recover |
5.0.3 | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||
Tc_log_max_pages_used |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Tc_log_page_size |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
Tc_log_page_waits |
5.0.3 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
temp-pool |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
thread_cache_size |
Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | |||
thread_concurrency |
5.6.1 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||
thread_handling |
5.1.17 | Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | |||
thread_pool_algorithm |
5.5.16, 5.6.10 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
thread_pool_high_priority_connection |
5.5.16, 5.6.10 | Yes | Yes | Yes | Both | Yes | Yes | Yes | |||||
thread_pool_max_unused_threads |
5.5.16, 5.6.10 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
thread_pool_prio_kickup_timer |
5.5.16, 5.6.10 | Yes | Yes | Yes | Both | Yes | Yes | Yes | |||||
thread_pool_size |
5.5.16, 5.6.10 | Yes | Yes | Yes | Global | No | Yes | Yes | |||||
thread_pool_stall_limit |
5.5.16, 5.6.10 | Yes | Yes | Yes | Global | Yes | Yes | Yes | |||||
thread_stack |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
Threads_cached |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Threads_connected |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Threads_created |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Threads_running |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
time_format |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
time_zone |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
timed_mutexes |
5.0.3 | Yes | Yes | Yes | Global | Yes | Yes | Yes | Yes | Yes | Yes | ||
timestamp |
Yes | Session | Yes | Yes | Yes | Yes | Yes | Yes | |||||
tmp_table_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
tmpdir |
Yes | Yes | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||
transaction_alloc_block_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
transaction_allow_batching |
5.1.23-ndb-6.3.7 | Yes | Session | Yes | Yes | Yes | Yes | ||||||
transaction-isolation |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
transaction_prealloc_size |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
transaction-read-only |
5.6.5 | Yes | Yes | Yes | Yes | ||||||||
tx_isolation |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
tx_read_only |
5.6.5 | Yes | Both | Yes | Yes | Yes | |||||||
unique_checks |
Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||||
updatable_views_with_limit |
5.0.2 | Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | ||
Uptime |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
Uptime_since_flush_status |
5.0.35, 5.1.23-ndb-6.2.14, 5.1.24 | Yes | Global | No | Yes | Yes | Yes | Yes | Yes | ||||
use-symbolic-links |
5.0.0 | Yes | Yes | Yes | |||||||||
user |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
validate-password |
5.6.6 | Yes | Yes | Yes | Yes | ||||||||
validate_password_dictionary_file |
5.6.6 | Yes | Global | No | Yes | Yes | |||||||
validate_password_length |
5.6.6 | Yes | Global | Yes | Yes | Yes | |||||||
validate_password_mixed_case_count |
5.6.6 | Yes | Global | Yes | Yes | Yes | |||||||
validate_password_number_count |
5.6.6 | Yes | Global | Yes | Yes | Yes | |||||||
validate_password_policy |
5.6.6 | Yes | Global | Yes | Yes | Yes | |||||||
validate_password_special_char_count |
5.6.6 | Yes | Global | Yes | Yes | Yes | |||||||
validate_user_plugins |
5.1.1, 5.6.11 | Yes | Global | No | Yes | Yes | |||||||
verbose |
Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
version |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
version_comment |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
version_compile_machine |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
version_compile_os |
Yes | Global | No | Yes | Yes | Yes | Yes | Yes | |||||
wait_timeout |
Yes | Yes | Yes | Both | Yes | Yes | Yes | Yes | Yes | Yes | |||
warning_count |
Yes | Session | No | Yes | Yes | Yes | Yes | Yes | |||||
warnings |
5.0.0 | Yes | Yes | Yes |
Source: MySQL reference
mysqld Option/Variable Reference