5.1.1 서버 옵션 및 변수 설명
다음 표는 mysqld 에서 적용 가능한 모든 명령 줄 옵션 서버 변수 및 상태 변수의 목록이 제공되어 있습니다.
이 표에는 명령 행 옵션 (명령 행) 구성 파일에서 사용할 수있는 옵션 (옵션 파일) 서버 시스템 변수 (시스템 변수) 및 상태 변수 (상태 변수)가 하나의 통일 목록에 추가 각 옵션 또는 변수가 유효한지 여부가 표시되어 있습니다. 명령 행 또는 옵션 파일에 설정된 서버 옵션이 해당 서버 시스템 변수 나 상태 변수의 이름과 다른 경우 해당 옵션의 바로 아래에 변수 이름이 기재되어 있습니다. 상태 변수의 경우 변수의 스코프 (범위)는 글로벌 세션 또는 모두로 표시되어 있습니다. 옵션 및 변수 설정 및 사용에 대한 자세한 내용은 해당 섹션을 참조하십시오. 항목에 대한 추가 정보에 대한 직접 링크를 이용할 수있는 경우도 있습니다.
MySQL 클러스터에 고유하게 테이블의 버전은 섹션 18.3.4.1 "MySQL Cluster의 mysqld 옵션과 변수 참조" 를 참조하십시오.
Table 5.1 Option/Variable Summary
| Name | Cmd-Line | Option File | System Var | Status Var | Var Scope | Dynamic |
|---|---|---|---|---|---|---|
| abort-slave-event-count | Yes | Yes | | | | |
| Aborted_clients | | | | Yes | Global | No |
| Aborted_connects | | | | Yes | Global | No |
| allow-suspicious-udfs | Yes | Yes | | | | |
| ansi | Yes | Yes | | | | |
| audit-log | Yes | Yes | | | | |
| audit_log_buffer_size | Yes | Yes | Yes | | Global | No |
| audit_log_connection_policy | Yes | Yes | Yes | | Global | Yes |
| audit_log_current_session | | | Yes | | Both | No |
| Audit_log_current_size | | | | Yes | Global | No |
| Audit_log_event_max_drop_size | | | | Yes | Global | No |
| Audit_log_events | | | | Yes | Global | No |
| Audit_log_events_filtered | | | | Yes | Global | No |
| Audit_log_events_lost | | | | Yes | Global | No |
| Audit_log_events_written | | | | Yes | Global | No |
| audit_log_exclude_accounts | Yes | Yes | Yes | | Global | Yes |
| audit_log_file | Yes | Yes | Yes | | Global | No |
| audit_log_flush | | | Yes | | Global | Yes |
| audit_log_format | Yes | Yes | Yes | | Global | No |
| audit_log_include_accounts | Yes | Yes | Yes | | Global | Yes |
| audit_log_policy | Yes | Yes | Yes | | Global | Varies |
| audit_log_rotate_on_size | Yes | Yes | Yes | | Global | Yes |
| audit_log_statement_policy | Yes | Yes | Yes | | Global | Yes |
| audit_log_strategy | Yes | Yes | Yes | | Global | No |
| Audit_log_total_size | | | | Yes | Global | No |
| Audit_log_write_waits | | | | Yes | Global | No |
| authentication_windows_log_level | Yes | Yes | | | | |
| authentication_windows_use_principal_name | Yes | Yes | | | | |
| auto_increment_increment | | | Yes | | Both | Yes |
| auto_increment_offset | | | Yes | | Both | Yes |
| autocommit | Yes | Yes | Yes | | Both | Yes |
| automatic_sp_privileges | | | Yes | | Global | Yes |
| avoid_temporal_upgrade | Yes | Yes | Yes | | Global | Yes |
| back_log | | | Yes | | Global | No |
| basedir | Yes | Yes | Yes | | Global | No |
| big-tables | Yes | Yes | | | Both | Yes |
| - Variable: big_tables | | | Yes | | Both | Yes |
| bind-address | Yes | Yes | | | Global | No |
| - Variable: bind_address | | | Yes | | Global | No |
| Binlog_cache_disk_use | | | | Yes | Global | No |
| binlog_cache_size | Yes | Yes | Yes | | Global | Yes |
| Binlog_cache_use | | | | Yes | Global | No |
| binlog-checksum | Yes | Yes | | | | |
| binlog_checksum | | | Yes | | Global | Yes |
| binlog_direct_non_transactional_updates | Yes | Yes | Yes | | Both | Yes |
| binlog-do-db | Yes | Yes | | | | |
| binlog_error_action | Yes | Yes | Yes | | Both | Yes |
| binlog-format | Yes | Yes | | | Both | Yes |
| - Variable: binlog_format | | | Yes | | Both | Yes |
| binlog_gtid_simple_recovery | Yes | Yes | Yes | | Global | No |
| binlog-ignore-db | Yes | Yes | | | | |
| binlog_max_flush_queue_time | | | Yes | | Global | Yes |
| binlog_order_commits | | | Yes | | Global | Yes |
| binlog-row-event-max-size | Yes | Yes | | | | |
| binlog_row_image | Yes | Yes | Yes | | Both | Yes |
| binlog-rows-query-log-events | Yes | Yes | | | | |
| - Variable: binlog_rows_query_log_events | | | | | | |
| binlog_rows_query_log_events | | | Yes | | Both | Yes |
| Binlog_stmt_cache_disk_use | | | | Yes | Global | No |
| binlog_stmt_cache_size | Yes | Yes | Yes | | Global | Yes |
| Binlog_stmt_cache_use | | | | Yes | Global | No |
| binlogging_impossible_mode | Yes | Yes | Yes | | Both | Yes |
| block_encryption_mode | Yes | Yes | Yes | | Both | Yes |
| bootstrap | Yes | Yes | | | | |
| bulk_insert_buffer_size | Yes | Yes | Yes | | Both | Yes |
| Bytes_received | | | | Yes | Both | No |
| Bytes_sent | | | | Yes | Both | No |
| character_set_client | | | Yes | | Both | Yes |
| character-set-client-handshake | Yes | Yes | | | | |
| character_set_connection | | | Yes | | Both | Yes |
| character_set_database[a] | | | Yes | | Both | Yes |
| character-set-filesystem | Yes | Yes | | | Both | Yes |
| - Variable: character_set_filesystem | | | Yes | | Both | Yes |
| character_set_results | | | Yes | | Both | Yes |
| character-set-server | Yes | Yes | | | Both | Yes |
| - Variable: character_set_server | | | Yes | | Both | Yes |
| character_set_system | | | Yes | | Global | No |
| character-sets-dir | Yes | Yes | | | Global | No |
| - Variable: character_sets_dir | | | Yes | | Global | No |
| chroot | Yes | Yes | | | | |
| collation_connection | | | Yes | | Both | Yes |
| collation_database[b] | | | Yes | | Both | Yes |
| collation-server | Yes | Yes | | | Both | Yes |
| - Variable: collation_server | | | Yes | | Both | Yes |
| Com_admin_commands | | | | Yes | Both | No |
| Com_alter_db | | | | Yes | Both | No |
| Com_alter_db_upgrade | | | | Yes | Both | No |
| Com_alter_event | | | | Yes | Both | No |
| Com_alter_function | | | | Yes | Both | No |
| Com_alter_procedure | | | | Yes | Both | No |
| Com_alter_server | | | | Yes | Both | No |
| Com_alter_table | | | | Yes | Both | No |
| Com_alter_tablespace | | | | Yes | Both | No |
| Com_alter_user | | | | Yes | Both | No |
| Com_analyze | | | | Yes | Both | No |
| Com_assign_to_keycache | | | | Yes | Both | No |
| Com_begin | | | | Yes | Both | No |
| Com_binlog | | | | Yes | Both | No |
| Com_call_procedure | | | | Yes | Both | No |
| Com_change_db | | | | Yes | Both | No |
| Com_change_master | | | | Yes | Both | No |
| Com_check | | | | Yes | Both | No |
| Com_checksum | | | | Yes | Both | No |
| Com_commit | | | | Yes | Both | No |
| Com_create_db | | | | Yes | Both | No |
| Com_create_event | | | | Yes | Both | No |
| Com_create_function | | | | Yes | Both | No |
| Com_create_index | | | | Yes | Both | No |
| Com_create_procedure | | | | Yes | Both | No |
| Com_create_server | | | | Yes | Both | No |
| Com_create_table | | | | Yes | Both | No |
| Com_create_trigger | | | | Yes | Both | No |
| Com_create_udf | | | | Yes | Both | No |
| Com_create_user | | | | Yes | Both | No |
| Com_create_view | | | | Yes | Both | No |
| Com_dealloc_sql | | | | Yes | Both | No |
| Com_delete | | | | Yes | Both | No |
| Com_delete_multi | | | | Yes | Both | No |
| Com_do | | | | Yes | Both | No |
| Com_drop_db | | | | Yes | Both | No |
| Com_drop_event | | | | Yes | Both | No |
| Com_drop_function | | | | Yes | Both | No |
| Com_drop_index | | | | Yes | Both | No |
| Com_drop_procedure | | | | Yes | Both | No |
| Com_drop_server | | | | Yes | Both | No |
| Com_drop_table | | | | Yes | Both | No |
| Com_drop_trigger | | | | Yes | Both | No |
| Com_drop_user | | | | Yes | Both | No |
| Com_drop_view | | | | Yes | Both | No |
| Com_empty_query | | | | Yes | Both | No |
| Com_execute_sql | | | | Yes | Both | No |
| Com_flush | | | | Yes | Both | No |
| Com_get_diagnostics | | | | Yes | Both | No |
| Com_grant | | | | Yes | Both | No |
| Com_ha_close | | | | Yes | Both | No |
| Com_ha_open | | | | Yes | Both | No |
| Com_ha_read | | | | Yes | Both | No |
| Com_help | | | | Yes | Both | No |
| Com_insert | | | | Yes | Both | No |
| Com_insert_select | | | | Yes | Both | No |
| Com_install_plugin | | | | Yes | Both | No |
| Com_kill | | | | Yes | Both | No |
| Com_load | | | | Yes | Both | No |
| Com_lock_tables | | | | Yes | Both | No |
| Com_optimize | | | | Yes | Both | No |
| Com_preload_keys | | | | Yes | Both | No |
| Com_prepare_sql | | | | Yes | Both | No |
| Com_purge | | | | Yes | Both | No |
| Com_purge_before_date | | | | Yes | Both | No |
| Com_release_savepoint | | | | Yes | Both | No |
| Com_rename_table | | | | Yes | Both | No |
| Com_rename_user | | | | Yes | Both | No |
| Com_repair | | | | Yes | Both | No |
| Com_replace | | | | Yes | Both | No |
| Com_replace_select | | | | Yes | Both | No |
| Com_reset | | | | Yes | Both | No |
| Com_resignal | | | | Yes | Both | No |
| Com_revoke | | | | Yes | Both | No |
| Com_revoke_all | | | | Yes | Both | No |
| Com_rollback | | | | Yes | Both | No |
| Com_rollback_to_savepoint | | | | Yes | Both | No |
| Com_savepoint | | | | Yes | Both | No |
| Com_select | | | | Yes | Both | No |
| Com_set_option | | | | Yes | Both | No |
| Com_show_authors | | | | Yes | Both | No |
| Com_show_binlog_events | | | | Yes | Both | No |
| Com_show_binlogs | | | | Yes | Both | No |
| Com_show_charsets | | | | Yes | Both | No |
| Com_show_collations | | | | Yes | Both | No |
| Com_show_contributors | | | | Yes | Both | No |
| Com_show_create_db | | | | Yes | Both | No |
| Com_show_create_event | | | | Yes | Both | No |
| Com_show_create_func | | | | Yes | Both | No |
| Com_show_create_proc | | | | Yes | Both | No |
| Com_show_create_table | | | | Yes | Both | No |
| Com_show_create_trigger | | | | Yes | Both | No |
| Com_show_databases | | | | Yes | Both | No |
| Com_show_engine_logs | | | | Yes | Both | No |
| Com_show_engine_mutex | | | | Yes | Both | No |
| Com_show_engine_status | | | | Yes | Both | No |
| Com_show_errors | | | | Yes | Both | No |
| Com_show_events | | | | Yes | Both | No |
| Com_show_fields | | | | Yes | Both | No |
| Com_show_function_code | | | | Yes | Both | No |
| Com_show_function_status | | | | Yes | Both | No |
| Com_show_grants | | | | Yes | Both | No |
| Com_show_keys | | | | Yes | Both | No |
| Com_show_master_status | | | | Yes | Both | No |
| Com_show_ndb_status | | | | Yes | Both | No |
| Com_show_new_master | | | | Yes | Both | No |
| Com_show_open_tables | | | | Yes | Both | No |
| Com_show_plugins | | | | Yes | Both | No |
| Com_show_privileges | | | | Yes | Both | No |
| Com_show_procedure_code | | | | Yes | Both | No |
| Com_show_procedure_status | | | | Yes | Both | No |
| Com_show_processlist | | | | Yes | Both | No |
| Com_show_profile | | | | Yes | Both | No |
| Com_show_profiles | | | | Yes | Both | No |
| Com_show_relaylog_events | | | | Yes | Both | No |
| Com_show_slave_hosts | | | | Yes | Both | No |
| Com_show_slave_status | | | | Yes | Both | No |
| Com_show_status | | | | Yes | Both | No |
| Com_show_storage_engines | | | | Yes | Both | No |
| Com_show_table_status | | | | Yes | Both | No |
| Com_show_tables | | | | Yes | Both | No |
| Com_show_triggers | | | | Yes | Both | No |
| Com_show_variables | | | | Yes | Both | No |
| Com_show_warnings | | | | Yes | Both | No |
| Com_signal | | | | Yes | Both | No |
| Com_slave_start | | | | Yes | Both | No |
| Com_slave_stop | | | | Yes | Both | No |
| Com_stmt_close | | | | Yes | Both | No |
| Com_stmt_execute | | | | Yes | Both | No |
| Com_stmt_fetch | | | | Yes | Both | No |
| Com_stmt_prepare | | | | Yes | Both | No |
| Com_stmt_reprepare | | | | Yes | Both | No |
| Com_stmt_reset | | | | Yes | Both | No |
| Com_stmt_send_long_data | | | | Yes | Both | No |
| Com_truncate | | | | Yes | Both | No |
| Com_uninstall_plugin | | | | Yes | Both | No |
| Com_unlock_tables | | | | Yes | Both | No |
| Com_update | | | | Yes | Both | No |
| Com_update_multi | | | | Yes | Both | No |
| Com_xa_commit | | | | Yes | Both | No |
| Com_xa_end | | | | Yes | Both | No |
| Com_xa_prepare | | | | Yes | Both | No |
| Com_xa_recover | | | | Yes | Both | No |
| Com_xa_rollback | | | | Yes | Both | No |
| Com_xa_start | | | | Yes | Both | No |
| completion_type | Yes | Yes | Yes | | Both | Yes |
| Compression | | | | Yes | Session | No |
| concurrent_insert | Yes | Yes | Yes | | Global | Yes |
| connect_timeout | Yes | Yes | Yes | | Global | Yes |
| Connection_errors_accept | | | | Yes | Global | No |
| Connection_errors_internal | | | | Yes | Global | No |
| Connection_errors_max_connections | | | | Yes | Global | No |
| Connection_errors_peer_addr | | | | Yes | Global | No |
| Connection_errors_select | | | | Yes | Global | No |
| Connection_errors_tcpwrap | | | | Yes | Global | No |
| Connections | | | | Yes | Global | No |
| console | Yes | Yes | | | | |
| core-file | Yes | Yes | | | | |
| core_file | | | Yes | | Global | No |
| create_old_temporals | Yes | Yes | Yes | | Global | No |
| Created_tmp_disk_tables | | | | Yes | Both | No |
| Created_tmp_files | | | | Yes | Global | No |
| Created_tmp_tables | | | | Yes | Both | No |
| daemon_memcached_enable_binlog | Yes | Yes | Yes | | Global | No |
| daemon_memcached_engine_lib_name | Yes | Yes | Yes | | Global | No |
| daemon_memcached_engine_lib_path | Yes | Yes | Yes | | Global | No |
| daemon_memcached_option | Yes | Yes | Yes | | Global | No |
| daemon_memcached_r_batch_size | Yes | Yes | Yes | | Global | No |
| daemon_memcached_w_batch_size | Yes | Yes | Yes | | Global | No |
| datadir | Yes | Yes | Yes | | Global | No |
| date_format | | | Yes | | Global | No |
| datetime_format | | | Yes | | Global | No |
| debug | Yes | Yes | Yes | | Both | Yes |
| debug_sync | | | Yes | | Session | Yes |
| debug-sync-timeout | Yes | Yes | | | | |
| default-authentication-plugin | Yes | Yes | | | | |
| default-storage-engine | Yes | Yes | | | Both | Yes |
| - Variable: default_storage_engine | | | Yes | | Both | Yes |
| default-time-zone | Yes | Yes | | | | |
| default_tmp_storage_engine | Yes | Yes | Yes | | Both | Yes |
| default_week_format | Yes | Yes | Yes | | Both | Yes |
| defaults-extra-file | Yes | | | | | |
| defaults-file | Yes | | | | | |
| defaults-group-suffix | Yes | | | | | |
| delay-key-write | Yes | Yes | | | Global | Yes |
| - Variable: delay_key_write | | | Yes | | Global | Yes |
| Delayed_errors | | | | Yes | Global | No |
| delayed_insert_limit | Yes | Yes | Yes | | Global | Yes |
| Delayed_insert_threads | | | | Yes | Global | No |
| delayed_insert_timeout | Yes | Yes | Yes | | Global | Yes |
| delayed_queue_size | Yes | Yes | Yes | | Global | Yes |
| Delayed_writes | | | | Yes | Global | No |
| des-key-file | Yes | Yes | | | | |
| disable-gtid-unsafe-statements | Yes | Yes | Yes | | Global | No |
| disable_gtid_unsafe_statements | Yes | Yes | Yes | | Global | No |
| disconnect_on_expired_password | Yes | Yes | Yes | | Session | No |
| disconnect-slave-event-count | Yes | Yes | | | | |
| div_precision_increment | Yes | Yes | Yes | | Both | Yes |
| enable-named-pipe | Yes | Yes | | | | |
| - Variable: named_pipe | | | | | | |
| end_markers_in_json | | | Yes | | Both | Yes |
| enforce-gtid-consistency | Yes | Yes | Yes | | Global | No |
| enforce_gtid_consistency | Yes | Yes | Yes | | Global | No |
| engine-condition-pushdown | Yes | Yes | | | Both | Yes |
| - Variable: engine_condition_pushdown | | | Yes | | Both | Yes |
| eq_range_index_dive_limit | | | Yes | | Both | Yes |
| error_count | | | Yes | | Session | No |
| event-scheduler | Yes | Yes | | | Global | Yes |
| - Variable: event_scheduler | | | Yes | | Global | Yes |
| exit-info | Yes | Yes | | | | |
| expire_logs_days | Yes | Yes | Yes | | Global | Yes |
| explicit_defaults_for_timestamp | Yes | Yes | Yes | | Both | No |
| external-locking | Yes | Yes | | | | |
| - Variable: skip_external_locking | | | | | | |
| external_user | | | Yes | | Session | No |
| federated | Yes | Yes | | | | |
| Firewall_access_denied | | | | Yes | Global | No |
| Firewall_access_granted | | | | Yes | Global | No |
| Firewall_cached_entries | | | | Yes | Global | No |
| flush | Yes | Yes | Yes | | Global | Yes |
| Flush_commands | | | | Yes | Global | No |
| flush_time | Yes | Yes | Yes | | Global | Yes |
| foreign_key_checks | | | Yes | | Both | Yes |
| ft_boolean_syntax | Yes | Yes | Yes | | Global | Yes |
| ft_max_word_len | Yes | Yes | Yes | | Global | No |
| ft_min_word_len | Yes | Yes | Yes | | Global | No |
| ft_query_expansion_limit | Yes | Yes | Yes | | Global | No |
| ft_stopword_file | Yes | Yes | Yes | | Global | No |
| gdb | Yes | Yes | | | | |
| general-log | Yes | Yes | | | Global | Yes |
| - Variable: general_log | | | Yes | | Global | Yes |
| general_log_file | Yes | Yes | Yes | | Global | Yes |
| group_concat_max_len | Yes | Yes | Yes | | Both | Yes |
| gtid_done | | | Yes | | Both | No |
| gtid_executed | | | Yes | | Both | No |
| gtid_lost | | | Yes | | Global | No |
| gtid-mode | Yes | Yes | | | Global | No |
| - Variable: gtid_mode | | | Yes | | Global | No |
| gtid_mode | | | Yes | | Global | No |
| gtid_next | | | Yes | | Session | Yes |
| gtid_owned | | | Yes | | Both | No |
| gtid_purged | | | Yes | | Global | Yes |
| Handler_commit | | | | Yes | Both | No |
| Handler_delete | | | | Yes | Both | No |
| Handler_discover | | | | Yes | Both | No |
| Handler_external_lock | | | | Yes | Both | No |
| Handler_mrr_init | | | | Yes | Both | No |
| Handler_prepare | | | | Yes | Both | No |
| Handler_read_first | | | | Yes | Both | No |
| Handler_read_key | | | | Yes | Both | No |
| Handler_read_last | | | | Yes | Both | No |
| Handler_read_next | | | | Yes | Both | No |
| Handler_read_prev | | | | Yes | Both | No |
| Handler_read_rnd | | | | Yes | Both | No |
| Handler_read_rnd_next | | | | Yes | Both | No |
| Handler_rollback | | | | Yes | Both | No |
| Handler_savepoint | | | | Yes | Both | No |
| Handler_savepoint_rollback | | | | Yes | Both | No |
| Handler_update | | | | Yes | Both | No |
| Handler_write | | | | Yes | Both | No |
| have_compress | | | Yes | | Global | No |
| have_crypt | | | Yes | | Global | No |
| have_csv | | | Yes | | Global | No |
| have_dynamic_loading | | | Yes | | Global | No |
| have_geometry | | | Yes | | Global | No |
| have_innodb | | | Yes | | Global | No |
| have_ndbcluster | | | Yes | | Global | No |
| have_openssl | | | Yes | | Global | No |
| have_partitioning | | | Yes | | Global | No |
| have_profiling | | | Yes | | Global | No |
| have_query_cache | | | Yes | | Global | No |
| have_rtree_keys | | | Yes | | Global | No |
| have_ssl | | | Yes | | Global | No |
| have_symlink | | | Yes | | Global | No |
| help | Yes | Yes | | | | |
| host_cache_size | | | Yes | | Global | Yes |
| hostname | | | Yes | | Global | No |
| identity | | | Yes | | Session | Yes |
| ignore-builtin-innodb | Yes | Yes | | | Global | No |
| - Variable: ignore_builtin_innodb | | | Yes | | Global | No |
| ignore-db-dir | Yes | Yes | | | | |
| ignore_db_dirs | | | Yes | | Global | No |
| init_connect | Yes | Yes | Yes | | Global | Yes |
| init-file | Yes | Yes | | | Global | No |
| - Variable: init_file | | | Yes | | Global | No |
| init_slave | Yes | Yes | Yes | | Global | Yes |
| innodb | Yes | Yes | | | | |
| innodb_adaptive_flushing | Yes | Yes | Yes | | Global | Yes |
| innodb_adaptive_flushing_lwm | Yes | Yes | Yes | | Global | Yes |
| innodb_adaptive_hash_index | Yes | Yes | Yes | | Global | Yes |
| innodb_adaptive_max_sleep_delay | Yes | Yes | Yes | | Global | Yes |
| innodb_additional_mem_pool_size | Yes | Yes | Yes | | Global | No |
| innodb_api_bk_commit_interval | Yes | Yes | Yes | | Global | Yes |
| innodb_api_disable_rowlock | Yes | Yes | Yes | | Global | No |
| innodb_api_enable_binlog | Yes | Yes | Yes | | Global | No |
| innodb_api_enable_mdl | Yes | Yes | Yes | | Global | No |
| innodb_api_trx_level | Yes | Yes | Yes | | Global | Yes |
| innodb_autoextend_increment | Yes | Yes | Yes | | Global | Yes |
| innodb_autoinc_lock_mode | Yes | Yes | Yes | | Global | No |
| Innodb_available_undo_logs | | | | Yes | Global | No |
| Innodb_buffer_pool_bytes_data | | | | Yes | Global | No |
| Innodb_buffer_pool_bytes_dirty | | | | Yes | Global | No |
| innodb_buffer_pool_dump_at_shutdown | Yes | Yes | Yes | | Global | Yes |
| innodb_buffer_pool_dump_now | Yes | Yes | Yes | | Global | Yes |
| Innodb_buffer_pool_dump_status | | | | Yes | Global | No |
| innodb_buffer_pool_filename | Yes | Yes | Yes | | Global | Yes |
| innodb_buffer_pool_instances | Yes | Yes | Yes | | Global | No |
| innodb_buffer_pool_load_abort | Yes | Yes | Yes | | Global | Yes |
| innodb_buffer_pool_load_at_startup | Yes | Yes | Yes | | Global | No |
| innodb_buffer_pool_load_now | Yes | Yes | Yes | | Global | Yes |
| Innodb_buffer_pool_load_status | | | | Yes | Global | No |
| Innodb_buffer_pool_pages_data | | | | Yes | Global | No |
| Innodb_buffer_pool_pages_dirty | | | | Yes | Global | No |
| Innodb_buffer_pool_pages_flushed | | | | Yes | Global | No |
| Innodb_buffer_pool_pages_free | | | | Yes | Global | No |
| Innodb_buffer_pool_pages_latched | | | | Yes | Global | No |
| Innodb_buffer_pool_pages_misc | | | | Yes | Global | No |
| Innodb_buffer_pool_pages_total | | | | Yes | Global | No |
| Innodb_buffer_pool_read_ahead | | | | Yes | Global | No |
| Innodb_buffer_pool_read_ahead_evicted | | | | Yes | Global | No |
| Innodb_buffer_pool_read_requests | | | | Yes | Global | No |
| Innodb_buffer_pool_reads | | | | Yes | Global | No |
| innodb_buffer_pool_size | Yes | Yes | Yes | | Global | No |
| Innodb_buffer_pool_wait_free | | | | Yes | Global | No |
| Innodb_buffer_pool_write_requests | | | | Yes | Global | No |
| innodb_change_buffer_max_size | Yes | Yes | Yes | | Global | Yes |
| innodb_change_buffering | Yes | Yes | Yes | | Global | Yes |
| innodb_change_buffering_debug | Yes | Yes | Yes | | Global | Yes |
| innodb_checksum_algorithm | Yes | Yes | Yes | | Global | Yes |
| innodb_checksums | Yes | Yes | Yes | | Global | No |
| innodb_cmp_per_index_enabled | Yes | Yes | Yes | | Global | Yes |
| innodb_commit_concurrency | Yes | Yes | Yes | | Global | Yes |
| innodb_compression_failure_threshold_pct | Yes | Yes | Yes | | Global | Yes |
| innodb_compression_level | Yes | Yes | Yes | | Global | Yes |
| innodb_compression_pad_pct_max | Yes | Yes | Yes | | Global | Yes |
| innodb_concurrency_tickets | Yes | Yes | Yes | | Global | Yes |
| innodb_data_file_path | Yes | Yes | Yes | | Global | No |
| Innodb_data_fsyncs | | | | Yes | Global | No |
| innodb_data_home_dir | Yes | Yes | Yes | | Global | No |
| Innodb_data_pending_fsyncs | | | | Yes | Global | No |
| Innodb_data_pending_reads | | | | Yes | Global | No |
| Innodb_data_pending_writes | | | | Yes | Global | No |
| Innodb_data_read | | | | Yes | Global | No |
| Innodb_data_reads | | | | Yes | Global | No |
| Innodb_data_writes | | | | Yes | Global | No |
| Innodb_data_written | | | | Yes | Global | No |
| Innodb_dblwr_pages_written | | | | Yes | Global | No |
| Innodb_dblwr_writes | | | | Yes | Global | No |
| innodb_disable_sort_file_cache | Yes | Yes | Yes | | Global | Yes |
| innodb_doublewrite | Yes | Yes | Yes | | Global | No |
| innodb_fast_shutdown | Yes | Yes | Yes | | Global | Yes |
| innodb_fil_make_page_dirty_debug | Yes | Yes | Yes | | Global | Yes |
| innodb_file_format | Yes | Yes | Yes | | Global | Yes |
| innodb_file_format_check | Yes | Yes | Yes | | Global | No |
| innodb_file_format_max | Yes | Yes | Yes | | Global | Yes |
| innodb_file_per_table | Yes | Yes | Yes | | Global | Yes |
| innodb_flush_log_at_timeout | | | Yes | | Global | Yes |
| innodb_flush_log_at_trx_commit | Yes | Yes | Yes | | Global | Yes |
| innodb_flush_method | Yes | Yes | Yes | | Global | No |
| innodb_flush_neighbors | Yes | Yes | Yes | | Global | Yes |
| innodb_flushing_avg_loops | Yes | Yes | Yes | | Global | Yes |
| innodb_force_load_corrupted | Yes | Yes | Yes | | Global | No |
| innodb_force_recovery | Yes | Yes | Yes | | Global | No |
| innodb_ft_aux_table | | | Yes | | Global | Yes |
| innodb_ft_cache_size | Yes | Yes | Yes | | Global | No |
| innodb_ft_enable_diag_print | Yes | Yes | Yes | | Global | Yes |
| innodb_ft_enable_stopword | Yes | Yes | Yes | | Global | Yes |
| innodb_ft_max_token_size | Yes | Yes | Yes | | Global | No |
| innodb_ft_min_token_size | Yes | Yes | Yes | | Global | No |
| innodb_ft_num_word_optimize | Yes | Yes | Yes | | Global | Yes |
| innodb_ft_result_cache_limit | Yes | Yes | Yes | | Global | Yes |
| innodb_ft_server_stopword_table | Yes | Yes | Yes | | Global | Yes |
| innodb_ft_sort_pll_degree | Yes | Yes | Yes | | Global | No |
| innodb_ft_total_cache_size | Yes | Yes | Yes | | Global | No |
| innodb_ft_user_stopword_table | Yes | Yes | Yes | | Both | Yes |
| Innodb_have_atomic_builtins | | | | Yes | Global | No |
| innodb_io_capacity | Yes | Yes | Yes | | Global | Yes |
| innodb_io_capacity_max | Yes | Yes | Yes | | Global | Yes |
| innodb_large_prefix | Yes | Yes | Yes | | Global | Yes |
| innodb_limit_optimistic_insert_debug | Yes | Yes | Yes | | Global | Yes |
| innodb_lock_wait_timeout | Yes | Yes | Yes | | Both | Yes |
| innodb_locks_unsafe_for_binlog | Yes | Yes | Yes | | Global | No |
| innodb_log_buffer_size | Yes | Yes | Yes | | Global | No |
| innodb_log_compressed_pages | Yes | Yes | Yes | | Global | Yes |
| innodb_log_file_size | Yes | Yes | Yes | | Global | No |
| innodb_log_files_in_group | Yes | Yes | Yes | | Global | No |
| innodb_log_group_home_dir | Yes | Yes | Yes | | Global | No |
| Innodb_log_waits | | | | Yes | Global | No |
| Innodb_log_write_requests | | | | Yes | Global | No |
| Innodb_log_writes | | | | Yes | Global | No |
| innodb_lru_scan_depth | Yes | Yes | Yes | | Global | Yes |
| innodb_max_dirty_pages_pct | Yes | Yes | Yes | | Global | Yes |
| innodb_max_dirty_pages_pct_lwm | Yes | Yes | Yes | | Global | Yes |
| innodb_max_purge_lag | Yes | Yes | Yes | | Global | Yes |
| innodb_max_purge_lag_delay | Yes | Yes | Yes | | Global | Yes |
| innodb_mirrored_log_groups | Yes | Yes | Yes | | Global | No |
| innodb_monitor_disable | Yes | Yes | Yes | | Global | Yes |
| innodb_monitor_enable | Yes | Yes | Yes | | Global | Yes |
| innodb_monitor_reset | Yes | Yes | Yes | | Global | Yes |
| innodb_monitor_reset_all | Yes | Yes | Yes | | Global | Yes |
| Innodb_num_open_files | | | | Yes | Global | No |
| innodb_numa_interleave | Yes | Yes | Yes | | Global | No |
| innodb_old_blocks_pct | Yes | Yes | Yes | | Global | Yes |
| innodb_old_blocks_time | Yes | Yes | Yes | | Global | Yes |
| innodb_online_alter_log_max_size | Yes | Yes | Yes | | Global | Yes |
| innodb_open_files | Yes | Yes | Yes | | Global | No |
| innodb_optimize_fulltext_only | Yes | Yes | Yes | | Global | Yes |
| Innodb_os_log_fsyncs | | | | Yes | Global | No |
| Innodb_os_log_pending_fsyncs | | | | Yes | Global | No |
| Innodb_os_log_pending_writes | | | | Yes | Global | No |
| Innodb_os_log_written | | | | Yes | Global | No |
| Innodb_page_size | | | | Yes | Global | No |
| innodb_page_size | Yes | Yes | Yes | | Global | No |
| Innodb_pages_created | | | | Yes | Global | No |
| Innodb_pages_read | | | | Yes | Global | No |
| Innodb_pages_written | | | | Yes | Global | No |
| innodb_print_all_deadlocks | Yes | Yes | Yes | | Global | Yes |
| innodb_purge_batch_size | Yes | Yes | Yes | | Global | Yes |
| innodb_purge_threads | Yes | Yes | Yes | | Global | No |
| innodb_random_read_ahead | Yes | Yes | Yes | | Global | Yes |
| innodb_read_ahead_threshold | Yes | Yes | Yes | | Global | Yes |
| innodb_read_io_threads | Yes | Yes | Yes | | Global | No |
| innodb_read_only | Yes | Yes | Yes | | Global | No |
| innodb_replication_delay | Yes | Yes | Yes | | Global | Yes |
| innodb_rollback_on_timeout | Yes | Yes | Yes | | Global | No |
| innodb_rollback_segments | Yes | Yes | Yes | | Global | Yes |
| Innodb_row_lock_current_waits | | | | Yes | Global | No |
| Innodb_row_lock_time | | | | Yes | Global | No |
| Innodb_row_lock_time_avg | | | | Yes | Global | No |
| Innodb_row_lock_time_max | | | | Yes | Global | No |
| Innodb_row_lock_waits | | | | Yes | Global | No |
| Innodb_rows_deleted | | | | Yes | Global | No |
| Innodb_rows_inserted | | | | Yes | Global | No |
| Innodb_rows_read | | | | Yes | Global | No |
| Innodb_rows_updated | | | | Yes | Global | No |
| innodb_saved_page_number_debug | Yes | Yes | Yes | | Global | Yes |
| innodb_sort_buffer_size | Yes | Yes | Yes | | Global | No |
| innodb_spin_wait_delay | Yes | Yes | Yes | | Global | Yes |
| innodb_stats_auto_recalc | Yes | Yes | Yes | | Global | Yes |
| innodb_stats_method | Yes | Yes | Yes | | Global | Yes |
| innodb_stats_on_metadata | Yes | Yes | Yes | | Global | Yes |
| innodb_stats_persistent | Yes | Yes | Yes | | Global | Yes |
| innodb_stats_persistent_sample_pages | Yes | Yes | Yes | | Global | Yes |
| innodb_stats_sample_pages | Yes | Yes | Yes | | Global | Yes |
| innodb_stats_transient_sample_pages | Yes | Yes | Yes | | Global | Yes |
| innodb-status-file | Yes | Yes | | | | |
| innodb_status_output | Yes | Yes | Yes | | Global | Yes |
| innodb_status_output_locks | Yes | Yes | Yes | | Global | Yes |
| innodb_strict_mode | Yes | Yes | Yes | | Both | Yes |
| innodb_support_xa | Yes | Yes | Yes | | Both | Yes |
| innodb_sync_array_size | Yes | Yes | Yes | | Global | No |
| innodb_sync_spin_loops | Yes | Yes | Yes | | Global | Yes |
| innodb_table_locks | Yes | Yes | Yes | | Both | Yes |
| innodb_thread_concurrency | Yes | Yes | Yes | | Global | Yes |
| innodb_thread_sleep_delay | Yes | Yes | Yes | | Global | Yes |
| innodb_tmpdir | Yes | Yes | Yes | | Session | Yes |
| Innodb_truncated_status_writes | | | | Yes | Global | No |
| innodb_trx_purge_view_update_only_debug | Yes | Yes | Yes | | Global | Yes |
| innodb_trx_rseg_n_slots_debug | Yes | Yes | Yes | | Global | Yes |
| innodb_undo_directory | Yes | Yes | Yes | | Global | No |
| innodb_undo_logs | Yes | Yes | Yes | | Global | Yes |
| innodb_undo_tablespaces | Yes | Yes | Yes | | Global | No |
| innodb_use_native_aio | Yes | Yes | Yes | | Global | No |
| innodb_use_sys_malloc | Yes | Yes | Yes | | Global | No |
| innodb_version | | | Yes | | Global | No |
| innodb_write_io_threads | Yes | Yes | Yes | | Global | No |
| insert_id | | | Yes | | Session | Yes |
| install | Yes | | | | | |
| install-manual | Yes | | | | | |
| interactive_timeout | Yes | Yes | Yes | | Both | Yes |
| join_buffer_size | Yes | Yes | Yes | | Both | Yes |
| keep_files_on_create | Yes | Yes | Yes | | Both | Yes |
| Key_blocks_not_flushed | | | | Yes | Global | No |
| Key_blocks_unused | | | | Yes | Global | No |
| Key_blocks_used | | | | Yes | Global | No |
| key_buffer_size | Yes | Yes | Yes | | Global | Yes |
| key_cache_age_threshold | Yes | Yes | Yes | | Global | Yes |
| key_cache_block_size | Yes | Yes | Yes | | Global | Yes |
| key_cache_division_limit | Yes | Yes | Yes | | Global | Yes |
| Key_read_requests | | | | Yes | Global | No |
| Key_reads | | | | Yes | Global | No |
| Key_write_requests | | | | Yes | Global | No |
| Key_writes | | | | Yes | Global | No |
| language | Yes | Yes | Yes | | Global | No |
| large_files_support | | | Yes | | Global | No |
| large_page_size | | | Yes | | Global | No |
| large-pages | Yes | Yes | | | Global | No |
| - Variable: large_pages | | | Yes | | Global | No |
| last_insert_id | | | Yes | | Session | Yes |
| Last_query_cost | | | | Yes | Session | No |
| Last_query_partial_plans | | | | Yes | Session | No |
| lc-messages | Yes | Yes | | | Both | Yes |
| - Variable: lc_messages | | | Yes | | Both | Yes |
| lc-messages-dir | Yes | Yes | | | Global | No |
| - Variable: lc_messages_dir | | | Yes | | Global | No |
| lc_time_names | | | Yes | | Both | Yes |
| license | | | Yes | | Global | No |
| local_infile | | | Yes | | Global | Yes |
| local-service | Yes | | | | | |
| lock_wait_timeout | Yes | Yes | Yes | | Both | Yes |
| locked_in_memory | | | Yes | | Global | No |
| log | Yes | Yes | Yes | | Global | Yes |
| log-bin | Yes | Yes | Yes | | Global | No |
| log_bin | | | Yes | | Global | No |
| log_bin_basename | | | Yes | | Global | No |
| log-bin-index | Yes | Yes | | | | |
| log_bin_index | | | Yes | | Global | No |
| log-bin-trust-function-creators | Yes | Yes | | | Global | Yes |
| - Variable: log_bin_trust_function_creators | | | Yes | | Global | Yes |
| log-bin-use-v1-row-events | Yes | Yes | | | Global | No |
| - Variable: log_bin_use_v1_row_events | | | Yes | | Global | No |
| log_bin_use_v1_row_events | Yes | Yes | Yes | | Global | No |
| log-error | Yes | Yes | | | Global | No |
| - Variable: log_error | | | Yes | | Global | No |
| log-isam | Yes | Yes | | | | |
| log-output | Yes | Yes | | | Global | Yes |
| - Variable: log_output | | | Yes | | Global | Yes |
| log-queries-not-using-indexes | Yes | Yes | | | Global | Yes |
| - Variable: log_queries_not_using_indexes | | | Yes | | Global | Yes |
| log-raw | Yes | Yes | | | | |
| log-short-format | Yes | Yes | | | | |
| log-slave-updates | Yes | Yes | | | Global | No |
| - Variable: log_slave_updates | | | Yes | | Global | No |
| log_slave_updates | Yes | Yes | Yes | | Global | No |
| log-slow-admin-statements | Yes | Yes | | | | |
| log_slow_admin_statements | | | Yes | | Global | Yes |
| log-slow-queries | Yes | Yes | | | Global | Yes |
| - Variable: log_slow_queries | | | Yes | | Global | Yes |
| log-slow-slave-statements | Yes | Yes | | | | |
| log_slow_slave_statements | | | Yes | | Global | Yes |
| log-tc | Yes | Yes | | | | |
| log-tc-size | Yes | Yes | | | | |
| log_throttle_queries_not_using_indexes | | | Yes | | Global | Yes |
| log-warnings | Yes | Yes | | | Varies | Yes |
| - Variable: log_warnings | | | Yes | | Varies | Yes |
| long_query_time | Yes | Yes | Yes | | Both | Yes |
| low-priority-updates | Yes | Yes | | | Both | Yes |
| - Variable: low_priority_updates | | | Yes | | Both | Yes |
| lower_case_file_system | | | Yes | | Global | No |
| lower_case_table_names | Yes | Yes | Yes | | Global | No |
| master-info-file | Yes | Yes | | | | |
| master-info-repository | Yes | Yes | | | | |
| - Variable: master_info_repository | | | | | | |
| master_info_repository | Yes | Yes | Yes | | Global | Yes |
| master-retry-count | Yes | Yes | | | | |
| master-verify-checksum | Yes | Yes | | | | |
| - Variable: master_verify_checksum | | | | | | |
| master_verify_checksum | | | Yes | | Global | Yes |
| max_allowed_packet | Yes | Yes | Yes | | Both | Yes |
| max_binlog_cache_size | Yes | Yes | Yes | | Global | Yes |
| max-binlog-dump-events | Yes | Yes | | | | |
| max_binlog_size | Yes | Yes | Yes | | Global | Yes |
| max_binlog_stmt_cache_size | Yes | Yes | Yes | | Global | Yes |
| max_connect_errors | Yes | Yes | Yes | | Global | Yes |
| max_connections | Yes | Yes | Yes | | Global | Yes |
| max_delayed_threads | Yes | Yes | Yes | | Both | Yes |
| max_digest_length | Yes | Yes | Yes | | Global | No |
| max_error_count | Yes | Yes | Yes | | Both | Yes |
| max_heap_table_size | Yes | Yes | Yes | | Both | Yes |
| max_insert_delayed_threads | | | Yes | | Both | Yes |
| max_join_size | Yes | Yes | Yes | | Both | Yes |
| max_length_for_sort_data | Yes | Yes | Yes | | Both | Yes |
| max_prepared_stmt_count | Yes | Yes | Yes | | Global | Yes |
| max_relay_log_size | Yes | Yes | Yes | | Global | Yes |
| max_seeks_for_key | Yes | Yes | Yes | | Both | Yes |
| max_sort_length | Yes | Yes | Yes | | Both | Yes |
| max_sp_recursion_depth | Yes | Yes | Yes | | Both | Yes |
| max_tmp_tables | | | Yes | | Both | Yes |
| Max_used_connections | | | | Yes | Global | No |
| max_user_connections | Yes | Yes | Yes | | Both | Yes |
| max_write_lock_count | Yes | Yes | Yes | | Global | Yes |
| memlock | Yes | Yes | | | | |
| - Variable: locked_in_memory | | | | | | |
| metadata_locks_cache_size | | | Yes | | Global | No |
| metadata_locks_hash_instances | | | Yes | | Global | No |
| min-examined-row-limit | Yes | Yes | Yes | | Both | Yes |
| multi_range_count | Yes | Yes | Yes | | Both | Yes |
| myisam-block-size | Yes | Yes | | | | |
| myisam_data_pointer_size | Yes | Yes | Yes | | Global | Yes |
| myisam_max_sort_file_size | Yes | Yes | Yes | | Global | Yes |
| myisam_mmap_size | Yes | Yes | Yes | | Global | No |
| myisam-recover-options | Yes | Yes | | | | |
| - Variable: myisam_recover_options | | | | | | |
| myisam_recover_options | | | Yes | | Global | No |
| myisam_repair_threads | Yes | Yes | Yes | | Both | Yes |
| myisam_sort_buffer_size | Yes | Yes | Yes | | Both | Yes |
| myisam_stats_method | Yes | Yes | Yes | | Both | Yes |
| myisam_use_mmap | Yes | Yes | Yes | | Global | Yes |
| mysql_firewall_max_query_size | Yes | Yes | Yes | | Global | No |
| mysql_firewall_mode | Yes | Yes | Yes | | Global | Yes |
| mysql_firewall_trace | Yes | Yes | Yes | | Global | Yes |
| named_pipe | | | Yes | | Global | No |
| Ndb_api_bytes_received_count | | | | Yes | Global | No |
| Ndb_api_bytes_received_count_session | | | | Yes | Session | No |
| Ndb_api_bytes_received_count_slave | | | | Yes | Global | No |
| Ndb_api_bytes_sent_count | | | | Yes | Global | No |
| Ndb_api_bytes_sent_count_session | | | | Yes | Session | No |
| Ndb_api_bytes_sent_count_slave | | | | Yes | Global | No |
| Ndb_api_event_bytes_count | | | | Yes | Global | No |
| Ndb_api_event_bytes_count_injector | | | | Yes | Global | No |
| Ndb_api_event_data_count | | | | Yes | Global | No |
| Ndb_api_event_data_count_injector | | | | Yes | Global | No |
| Ndb_api_event_nondata_count | | | | Yes | Global | No |
| Ndb_api_event_nondata_count_injector | | | | Yes | Global | No |
| Ndb_api_pk_op_count | | | | Yes | Global | No |
| Ndb_api_pk_op_count_session | | | | Yes | Session | No |
| Ndb_api_pk_op_count_slave | | | | Yes | Global | No |
| Ndb_api_pruned_scan_count | | | | Yes | Global | No |
| Ndb_api_pruned_scan_count_session | | | | Yes | Session | No |
| Ndb_api_pruned_scan_count_slave | | | | Yes | Global | No |
| Ndb_api_range_scan_count | | | | Yes | Global | No |
| Ndb_api_range_scan_count_session | | | | Yes | Session | No |
| Ndb_api_range_scan_count_slave | | | | Yes | Global | No |
| Ndb_api_read_row_count | | | | Yes | Global | No |
| Ndb_api_read_row_count_session | | | | Yes | Session | No |
| Ndb_api_read_row_count_slave | | | | Yes | Global | No |
| Ndb_api_scan_batch_count | | | | Yes | Global | No |
| Ndb_api_scan_batch_count_session | | | | Yes | Session | No |
| Ndb_api_scan_batch_count_slave | | | | Yes | Global | No |
| Ndb_api_table_scan_count | | | | Yes | Global | No |
| Ndb_api_table_scan_count_session | | | | Yes | Session | No |
| Ndb_api_table_scan_count_slave | | | | Yes | Global | No |
| Ndb_api_trans_abort_count | | | | Yes | Global | No |
| Ndb_api_trans_abort_count_session | | | | Yes | Session | No |
| Ndb_api_trans_abort_count_slave | | | | Yes | Global | No |
| Ndb_api_trans_close_count | | | | Yes | Global | No |
| Ndb_api_trans_close_count_session | | | | Yes | Session | No |
| Ndb_api_trans_close_count_slave | | | | Yes | Global | No |
| Ndb_api_trans_commit_count | | | | Yes | Global | No |
| Ndb_api_trans_commit_count_session | | | | Yes | Session | No |
| Ndb_api_trans_commit_count_slave | | | | Yes | Global | No |
| Ndb_api_trans_local_read_row_count | | | | Yes | Global | No |
| Ndb_api_trans_local_read_row_count_session | | | | Yes | Session | No |
| Ndb_api_trans_local_read_row_count_slave | | | | Yes | Global | No |
| Ndb_api_trans_start_count | | | | Yes | Global | No |
| Ndb_api_trans_start_count_session | | | | Yes | Session | No |
| Ndb_api_trans_start_count_slave | | | | Yes | Global | No |
| Ndb_api_uk_op_count | | | | Yes | Global | No |
| Ndb_api_uk_op_count_session | | | | Yes | Session | No |
| Ndb_api_uk_op_count_slave | | | | Yes | Global | No |
| Ndb_api_wait_exec_complete_count | | | | Yes | Global | No |
| Ndb_api_wait_exec_complete_count_session | | | | Yes | Session | No |
| Ndb_api_wait_exec_complete_count_slave | | | | Yes | Global | No |
| Ndb_api_wait_meta_request_count | | | | Yes | Global | No |
| Ndb_api_wait_meta_request_count_session | | | | Yes | Session | No |
| Ndb_api_wait_meta_request_count_slave | | | | Yes | Global | No |
| Ndb_api_wait_nanos_count | | | | Yes | Global | No |
| Ndb_api_wait_nanos_count_session | | | | Yes | Session | No |
| Ndb_api_wait_nanos_count_slave | | | | Yes | Global | No |
| Ndb_api_wait_scan_result_count | | | | Yes | Global | No |
| Ndb_api_wait_scan_result_count_session | | | | Yes | Session | No |
| Ndb_api_wait_scan_result_count_slave | | | | Yes | Global | No |
| ndb_autoincrement_prefetch_sz | Yes | Yes | Yes | | Both | Yes |
| ndb-batch-size | Yes | Yes | Yes | | Global | No |
| ndb-blob-read-batch-bytes | Yes | Yes | Yes | | Both | Yes |
| ndb-blob-write-batch-bytes | Yes | Yes | Yes | | Both | Yes |
| ndb_cache_check_time | Yes | Yes | Yes | | Global | Yes |
| ndb_clear_apply_status | Yes | | Yes | | Global | Yes |
| ndb-cluster-connection-pool | Yes | Yes | Yes | | Global | No |
| Ndb_cluster_node_id | | | | Yes | Both | No |
| Ndb_config_from_host | | | | Yes | Both | No |
| Ndb_config_from_port | | | | Yes | Both | No |
| Ndb_conflict_fn_epoch | | | | Yes | Global | No |
| Ndb_conflict_fn_epoch_trans | | | | Yes | Global | No |
| Ndb_conflict_fn_epoch2 | | | | Yes | Global | No |
| Ndb_conflict_fn_epoch2_trans | | | | Yes | Global | No |
| Ndb_conflict_fn_max | | | | Yes | Global | No |
| Ndb_conflict_fn_max_del_win | | | | Yes | Global | No |
| Ndb_conflict_fn_old | | | | Yes | Global | No |
| Ndb_conflict_last_conflict_epoch | | | Yes | | Global | No |
| Ndb_conflict_last_stable_epoch | | | | Yes | Global | No |
| Ndb_conflict_reflected_op_discard_count | | | | Yes | Global | No |
| Ndb_conflict_reflected_op_prepare_count | | | | Yes | Global | No |
| Ndb_conflict_refresh_op_count | | | | Yes | Global | No |
| Ndb_conflict_trans_conflict_commit_count | | | | Yes | Global | No |
| Ndb_conflict_trans_detect_iter_count | | | | Yes | Global | No |
| Ndb_conflict_trans_reject_count | | | | Yes | Global | No |
| Ndb_conflict_trans_row_conflict_count | | | | Yes | Global | No |
| Ndb_conflict_trans_row_reject_count | | | | Yes | Global | No |
| ndb-connectstring | Yes | Yes | | | | |
| ndb-deferred-constraints | Yes | Yes | | | Both | Yes |
| - Variable: ndb_deferred_constraints | | | Yes | | Both | Yes |
| ndb_deferred_constraints | Yes | Yes | Yes | | Both | Yes |
| ndb-distribution | Yes | Yes | | | Global | Yes |
| - Variable: ndb_distribution | | | Yes | | Global | Yes |
| ndb_distribution | Yes | Yes | Yes | | Global | Yes |
| Ndb_epoch_delete_delete_count | | | | Yes | Global | No |
| ndb_eventbuffer_free_percent | Yes | Yes | Yes | | Global | Yes |
| ndb_eventbuffer_max_alloc | Yes | Yes | Yes | | Global | Yes |
| Ndb_execute_count | | | | Yes | Global | No |
| ndb_extra_logging | Yes | Yes | Yes | | Global | Yes |
| ndb_force_send | Yes | Yes | Yes | | Both | Yes |
| ndb_index_stat_cache_entries | Yes | Yes | Yes | | Both | Yes |
| ndb_index_stat_enable | Yes | Yes | Yes | | Both | Yes |
| ndb_index_stat_option | Yes | Yes | Yes | | Both | Yes |
| ndb_index_stat_update_freq | Yes | Yes | Yes | | Both | Yes |
| ndb_join_pushdown | | | Yes | | Both | Yes |
| Ndb_last_commit_epoch_server | | | | Yes | Global | No |
| Ndb_last_commit_epoch_session | | | | Yes | Session | No |
| ndb-log-apply-status | Yes | Yes | | | Global | No |
| - Variable: ndb_log_apply_status | | | Yes | | Global | No |
| ndb_log_apply_status | Yes | Yes | Yes | | Global | No |
| ndb_log_bin | Yes | | Yes | | Both | Yes |
| ndb_log_binlog_index | Yes | | Yes | | Global | Yes |
| ndb-log-empty-epochs | Yes | Yes | Yes | | Global | Yes |
| ndb_log_empty_epochs | Yes | Yes | Yes | | Global | Yes |
| ndb-log-exclusive-reads | Yes | Yes | | | Both | Yes |
| - Variable: ndb_log_exclusive_reads | | | Yes | | Both | Yes |
| ndb_log_exclusive_reads | Yes | Yes | Yes | | Both | Yes |
| ndb-log-orig | Yes | Yes | | | Global | No |
| - Variable: ndb_log_orig | | | Yes | | Global | No |
| ndb_log_orig | Yes | Yes | Yes | | Global | No |
| ndb-log-transaction-id | Yes | Yes | | | Global | No |
| - Variable: ndb_log_transaction_id | | | Yes | | Global | No |
| ndb_log_transaction_id | | | Yes | | Global | No |
| ndb-log-update-as-write | Yes | Yes | Yes | | Global | Yes |
| ndb_log_updated_only | Yes | Yes | Yes | | Global | Yes |
| ndb-mgmd-host | Yes | Yes | | | | |
| ndb-nodeid | Yes | Yes | | Yes | Global | No |
| Ndb_number_of_data_nodes | | | | Yes | Global | No |
| ndb_optimization_delay | | | Yes | | Global | Yes |
| ndb_optimized_node_selection | Yes | Yes | Yes | | Global | No |
| Ndb_pruned_scan_count | | | | Yes | Global | No |
| Ndb_pushed_queries_defined | | | | Yes | Global | No |
| Ndb_pushed_queries_dropped | | | | Yes | Global | No |
| Ndb_pushed_queries_executed | | | | Yes | Global | No |
| Ndb_pushed_reads | | | | Yes | Global | No |
| ndb-recv-thread-activation-threshold | Yes | Yes | | | | |
| - Variable: ndb_recv_thread_activation_threshold | | | | | | |
| ndb_recv_thread_activation_threshold | | | | | | |
| ndb-recv-thread-cpu-mask | Yes | Yes | | | | |
| - Variable: ndb_recv_thread_cpu_mask | | | | | | |
| ndb_recv_thread_cpu_mask | | | Yes | | Global | Yes |
| ndb_report_thresh_binlog_epoch_slip | Yes | Yes | | | | |
| ndb_report_thresh_binlog_mem_usage | Yes | Yes | | | | |
| Ndb_scan_count | | | | Yes | Global | No |
| ndb_show_foreign_key_mock_tables | Yes | Yes | Yes | | Global | Yes |
| ndb_slave_conflict_role | Yes | Yes | Yes | | Global | Yes |
| Ndb_slave_max_replicated_epoch | | | Yes | | Global | No |
| ndb_table_no_logging | | | Yes | | Session | Yes |
| ndb_table_temporary | | | Yes | | Session | Yes |
| ndb-transid-mysql-connection-map | Yes | | | | | |
| ndb_use_copying_alter_table | | | Yes | | Both | No |
| ndb_use_exact_count | | | Yes | | Both | Yes |
| ndb_use_transactions | Yes | Yes | Yes | | Both | Yes |
| ndb_version | | | Yes | | Global | No |
| ndb_version_string | | | Yes | | Global | No |
| ndb-wait-connected | Yes | Yes | Yes | | Global | No |
| ndb-wait-setup | Yes | Yes | Yes | | Global | No |
| ndbcluster | Yes | Yes | | | | |
| - Variable: have_ndbcluster | | | | | | |
| ndbinfo_database | | | Yes | | Global | No |
| ndbinfo_max_bytes | Yes | | Yes | | Both | Yes |
| ndbinfo_max_rows | Yes | | Yes | | Both | Yes |
| ndbinfo_offline | | | Yes | | Global | Yes |
| ndbinfo_show_hidden | Yes | | Yes | | Both | Yes |
| ndbinfo_table_prefix | Yes | | Yes | | Both | Yes |
| ndbinfo_version | | | Yes | | Global | No |
| net_buffer_length | Yes | Yes | Yes | | Both | Yes |
| net_read_timeout | Yes | Yes | Yes | | Both | Yes |
| net_retry_count | Yes | Yes | Yes | | Both | Yes |
| net_write_timeout | Yes | Yes | Yes | | Both | Yes |
| new | Yes | Yes | Yes | | Both | Yes |
| no-defaults | Yes | | | | | |
| Not_flushed_delayed_rows | | | | Yes | Global | No |
| old | Yes | Yes | Yes | | Global | No |
| old-alter-table | Yes | Yes | | | Both | Yes |
| - Variable: old_alter_table | | | Yes | | Both | Yes |
| old_passwords | | | Yes | | Both | Yes |
| old-style-user-limits | Yes | Yes | | | | |
| one-thread | Yes | Yes | | | | |
| Open_files | | | | Yes | Global | No |
| open-files-limit | Yes | Yes | | | Global | No |
| - Variable: open_files_limit | | | Yes | | Global | No |
| Open_streams | | | | Yes | Global | No |
| Open_table_definitions | | | | Yes | Global | No |
| Open_tables | | | | Yes | Both | No |
| Opened_files | | | | Yes | Global | No |
| Opened_table_definitions | | | | Yes | Both | No |
| Opened_tables | | | | Yes | Both | No |
| optimizer_join_cache_level | Yes | Yes | Yes | | Both | Yes |
| optimizer_prune_level | Yes | Yes | Yes | | Both | Yes |
| optimizer_search_depth | Yes | Yes | Yes | | Both | Yes |
| optimizer_switch | Yes | Yes | Yes | | Both | Yes |
| optimizer_trace | | | Yes | | Both | Yes |
| optimizer_trace_features | | | Yes | | Both | Yes |
| optimizer_trace_limit | | | Yes | | Both | Yes |
| optimizer_trace_max_mem_size | | | Yes | | Both | Yes |
| optimizer_trace_offset | | | Yes | | Both | Yes |
| partition | Yes | Yes | | | | |
| - Variable: have_partitioning | | | | | | |
| performance_schema | Yes | Yes | Yes | | Global | No |
| Performance_schema_accounts_lost | | | | Yes | Global | No |
| performance_schema_accounts_size | Yes | Yes | Yes | | Global | No |
| Performance_schema_cond_classes_lost | | | | Yes | Global | No |
| Performance_schema_cond_instances_lost | | | | Yes | Global | No |
| performance-schema-consumer-events-stages-current | Yes | Yes | | | | |
| performance-schema-consumer-events-stages-history | Yes | Yes | | | | |
| performance-schema-consumer-events-stages-history-long | Yes | Yes | | | | |
| performance-schema-consumer-events-statements-current | Yes | Yes | | | | |
| performance-schema-consumer-events-statements-history | Yes | Yes | | | | |
| performance-schema-consumer-events-statements-history-long | Yes | Yes | | | | |
| performance-schema-consumer-events-waits-current | Yes | Yes | | | | |
| performance-schema-consumer-events-waits-history | Yes | Yes | | | | |
| performance-schema-consumer-events-waits-history-long | Yes | Yes | | | | |
| performance-schema-consumer-global-instrumentation | Yes | Yes | | | | |
| performance-schema-consumer-statements-digest | Yes | Yes | | | | |
| performance-schema-consumer-thread-instrumentation | Yes | Yes | | | | |
| Performance_schema_digest_lost | | | | Yes | Global | No |
| performance_schema_digests_size | Yes | Yes | Yes | | Global | No |
| performance_schema_events_stages_history_long_size | Yes | Yes | Yes | | Global | No |
| performance_schema_events_stages_history_size | Yes | Yes | Yes | | Global | No |
| performance_schema_events_statements_history_long_size | Yes | Yes | Yes | | Global | No |
| performance_schema_events_statements_history_size | Yes | Yes | Yes | | Global | No |
| performance_schema_events_waits_history_long_size | Yes | Yes | Yes | | Global | No |
| performance_schema_events_waits_history_size | Yes | Yes | Yes | | Global | No |
| Performance_schema_file_classes_lost | | | | Yes | Global | No |
| Performance_schema_file_handles_lost | | | | Yes | Global | No |
| Performance_schema_file_instances_lost | | | | Yes | Global | No |
| Performance_schema_hosts_lost | | | | Yes | Global | No |
| performance_schema_hosts_size | Yes | Yes | Yes | | Global | No |
| performance-schema-instrument | Yes | Yes | | | | |
| Performance_schema_locker_lost | | | | Yes | Global | No |
| performance_schema_max_cond_classes | Yes | Yes | Yes | | Global | No |
| performance_schema_max_cond_instances | Yes | Yes | Yes | | Global | No |
| performance_schema_max_digest_length | Yes | Yes | Yes | | Global | No |
| performance_schema_max_file_classes | Yes | Yes | Yes | | Global | No |
| performance_schema_max_file_handles | Yes | Yes | Yes | | Global | No |
| performance_schema_max_file_instances | Yes | Yes | Yes | | Global | No |
| performance_schema_max_mutex_classes | Yes | Yes | Yes | | Global | No |
| performance_schema_max_mutex_instances | Yes | Yes | Yes | | Global | No |
| performance_schema_max_rwlock_classes | Yes | Yes | Yes | | Global | No |
| performance_schema_max_rwlock_instances | Yes | Yes | Yes | | Global | No |
| performance_schema_max_socket_classes | Yes | Yes | Yes | | Global | No |
| performance_schema_max_socket_instances | Yes | Yes | Yes | | Global | No |
| performance_schema_max_stage_classes | Yes | Yes | Yes | | Global | No |
| performance_schema_max_statement_classes | Yes | Yes | Yes | | Global | No |
| performance_schema_max_table_handles | Yes | Yes | Yes | | Global | No |
| performance_schema_max_table_instances | Yes | Yes | Yes | | Global | No |
| performance_schema_max_thread_classes | Yes | Yes | Yes | | Global | No |
| performance_schema_max_thread_instances | Yes | Yes | Yes | | Global | No |
| Performance_schema_mutex_classes_lost | | | | Yes | Global | No |
| Performance_schema_mutex_instances_lost | | | | Yes | Global | No |
| Performance_schema_rwlock_classes_lost | | | | Yes | Global | No |
| Performance_schema_rwlock_instances_lost | | | | Yes | Global | No |
| Performance_schema_session_connect_attrs_lost | | | | Yes | Global | No |
| performance_schema_session_connect_attrs_size | Yes | Yes | Yes | | Global | No |
| performance_schema_setup_actors_size | Yes | Yes | Yes | | Global | No |
| performance_schema_setup_objects_size | Yes | Yes | Yes | | Global | No |
| Performance_schema_socket_classes_lost | | | | Yes | Global | No |
| Performance_schema_socket_instances_lost | | | | Yes | Global | No |
| Performance_schema_stage_classes_lost | | | | Yes | Global | No |
| Performance_schema_statement_classes_lost | | | | Yes | Global | No |
| Performance_schema_table_handles_lost | | | | Yes | Global | No |
| Performance_schema_table_instances_lost | | | | Yes | Global | No |
| Performance_schema_thread_classes_lost | | | | Yes | Global | No |
| Performance_schema_thread_instances_lost | | | | Yes | Global | No |
| Performance_schema_users_lost | | | | Yes | Global | No |
| performance_schema_users_size | Yes | Yes | Yes | | Global | No |
| pid-file | Yes | Yes | | | Global | No |
| - Variable: pid_file | | | Yes | | Global | No |
| plugin | Yes | Yes | | | | |
| plugin_dir | Yes | Yes | Yes | | Global | No |
| plugin-load | Yes | Yes | | | | |
| plugin-load-add | Yes | Yes | | | | |
| port | Yes | Yes | Yes | | Global | No |
| port-open-timeout | Yes | Yes | | | | |
| preload_buffer_size | Yes | Yes | Yes | | Both | Yes |
| Prepared_stmt_count | | | | Yes | Global | No |
| print-defaults | Yes | | | | | |
| profiling | | | Yes | | Both | Yes |
| profiling_history_size | Yes | Yes | Yes | | Both | Yes |
| protocol_version | | | Yes | | Global | No |
| proxy_user | | | Yes | | Session | No |
| pseudo_slave_mode | | | Yes | | Session | Yes |
| pseudo_thread_id | | | Yes | | Session | Yes |
| Qcache_free_blocks | | | | Yes | Global | No |
| Qcache_free_memory | | | | Yes | Global | No |
| Qcache_hits | | | | Yes | Global | No |
| Qcache_inserts | | | | Yes | Global | No |
| Qcache_lowmem_prunes | | | | Yes | Global | No |
| Qcache_not_cached | | | | Yes | Global | No |
| Qcache_queries_in_cache | | | | Yes | Global | No |
| Qcache_total_blocks | | | | Yes | Global | No |
| Queries | | | | Yes | Both | No |
| query_alloc_block_size | Yes | Yes | Yes | | Both | Yes |
| query_cache_limit | Yes | Yes | Yes | | Global | Yes |
| query_cache_min_res_unit | Yes | Yes | Yes | | Global | Yes |
| query_cache_size | Yes | Yes | Yes | | Global | Yes |
| query_cache_type | Yes | Yes | Yes | | Both | Yes |
| query_cache_wlock_invalidate | Yes | Yes | Yes | | Both | Yes |
| query_prealloc_size | Yes | Yes | Yes | | Both | Yes |
| Questions | | | | Yes | Both | No |
| rand_seed1 | | | Yes | | Session | Yes |
| rand_seed2 | | | Yes | | Session | Yes |
| range_alloc_block_size | Yes | Yes | Yes | | Both | Yes |
| read_buffer_size | Yes | Yes | Yes | | Both | Yes |
| read_only | Yes | Yes | Yes | | Global | Yes |
| read_rnd_buffer_size | Yes | Yes | Yes | | Both | Yes |
| relay-log | Yes | Yes | | | Global | No |
| - Variable: relay_log | | | Yes | | Global | No |
| relay_log_basename | | | Yes | | Global | No |
| relay-log-index | Yes | Yes | | | Global | No |
| - Variable: relay_log_index | | | Yes | | Global | No |
| relay_log_index | Yes | Yes | Yes | | Global | No |
| relay-log-info-file | Yes | Yes | | | | |
| - Variable: relay_log_info_file | | | | | | |
| relay_log_info_file | Yes | Yes | Yes | | Global | No |
| relay-log-info-repository | Yes | Yes | | | | |
| - Variable: relay_log_info_repository | | | | | | |
| relay_log_info_repository | | | Yes | | Global | Yes |
| relay_log_purge | Yes | Yes | Yes | | Global | Yes |
| relay-log-recovery | Yes | Yes | | | | |
| - Variable: relay_log_recovery | | | | | | |
| relay_log_recovery | Yes | Yes | Yes | | Global | Varies |
| relay_log_space_limit | Yes | Yes | Yes | | Global | No |
| remove | Yes | | | | | |
| replicate-do-db | Yes | Yes | | | | |
| replicate-do-table | Yes | Yes | | | | |
| replicate-ignore-db | Yes | Yes | | | | |
| replicate-ignore-table | Yes | Yes | | | | |
| replicate-rewrite-db | Yes | Yes | | | | |
| replicate-same-server-id | Yes | Yes | | | | |
| replicate-wild-do-table | Yes | Yes | | | | |
| replicate-wild-ignore-table | Yes | Yes | | | | |
| report-host | Yes | Yes | | | Global | No |
| - Variable: report_host | | | Yes | | Global | No |
| report-password | Yes | Yes | | | Global | No |
| - Variable: report_password | | | Yes | | Global | No |
| report-port | Yes | Yes | | | Global | No |
| - Variable: report_port | | | Yes | | Global | No |
| report-user | Yes | Yes | | | Global | No |
| - Variable: report_user | | | Yes | | Global | No |
| Rpl_semi_sync_master_clients | | | | Yes | Global | No |
| rpl_semi_sync_master_enabled | | | Yes | | Global | Yes |
| Rpl_semi_sync_master_net_avg_wait_time | | | | Yes | Global | No |
| Rpl_semi_sync_master_net_wait_time | | | | Yes | Global | No |
| Rpl_semi_sync_master_net_waits | | | | Yes | Global | No |
| Rpl_semi_sync_master_no_times | | | | Yes | Global | No |
| Rpl_semi_sync_master_no_tx | | | | Yes | Global | No |
| Rpl_semi_sync_master_status | | | | Yes | Global | No |
| Rpl_semi_sync_master_timefunc_failures | | | | Yes | Global | No |
| rpl_semi_sync_master_timeout | | | Yes | | Global | Yes |
| rpl_semi_sync_master_trace_level | | | Yes | | Global | Yes |
| Rpl_semi_sync_master_tx_avg_wait_time | | | | Yes | Global | No |
| Rpl_semi_sync_master_tx_wait_time | | | | Yes | Global | No |
| Rpl_semi_sync_master_tx_waits | | | | Yes | Global | No |
| rpl_semi_sync_master_wait_no_slave | | | Yes | | Global | Yes |
| Rpl_semi_sync_master_wait_pos_backtraverse | | | | Yes | Global | No |
| Rpl_semi_sync_master_wait_sessions | | | | Yes | Global | No |
| Rpl_semi_sync_master_yes_tx | | | | Yes | Global | No |
| rpl_semi_sync_slave_enabled | | | Yes | | Global | Yes |
| Rpl_semi_sync_slave_status | | | | Yes | Global | No |
| rpl_semi_sync_slave_trace_level | | | Yes | | Global | Yes |
| rpl_stop_slave_timeout | Yes | Yes | Yes | | Global | Yes |
| Rsa_public_key | | | | Yes | Global | No |
| safe-mode | Yes | Yes | | | | |
| safe-user-create | Yes | Yes | | | | |
| secure-auth | Yes | Yes | | | Global | Yes |
| - Variable: secure_auth | | | Yes | | Global | Yes |
| secure-file-priv | Yes | Yes | | | Global | No |
| - Variable: secure_file_priv | | | Yes | | Global | No |
| Select_full_join | | | | Yes | Both | No |
| Select_full_range_join | | | | Yes | Both | No |
| Select_range | | | | Yes | Both | No |
| Select_range_check | | | | Yes | Both | No |
| Select_scan | | | | Yes | Both | No |
| server-id | Yes | Yes | | | Global | Yes |
| - Variable: server_id | | | Yes | | Global | Yes |
| server-id-bits | Yes | Yes | | | Global | No |
| - Variable: server_id_bits | | | Yes | | Global | No |
| server_id_bits | Yes | Yes | Yes | | Global | No |
| server_uuid | | | Yes | | Global | No |
| sha256_password_private_key_path | | | Yes | | Global | No |
| sha256_password_public_key_path | | | Yes | | Global | No |
| shared_memory | Yes | Yes | Yes | | Global | No |
| shared_memory_base_name | Yes | Yes | Yes | | Global | No |
| show_old_temporals | Yes | Yes | Yes | | Both | Yes |
| show-slave-auth-info | Yes | Yes | | | | |
| simplified_binlog_gtid_recovery | Yes | Yes | Yes | | Global | No |
| skip-character-set-client-handshake | Yes | Yes | | | | |
| skip-concurrent-insert | Yes | Yes | | | | |
| - Variable: concurrent_insert | | | | | | |
| skip-event-scheduler | Yes | Yes | | | | |
| skip_external_locking | Yes | Yes | Yes | | Global | No |
| skip-grant-tables | Yes | Yes | | | | |
| skip-host-cache | Yes | Yes | | | | |
| skip-name-resolve | Yes | Yes | | | Global | No |
| - Variable: skip_name_resolve | | | Yes | | Global | No |
| skip-ndbcluster | Yes | Yes | | | | |
| skip-networking | Yes | Yes | | | Global | No |
| - Variable: skip_networking | | | Yes | | Global | No |
| skip-new | Yes | Yes | | | | |
| skip-partition | Yes | Yes | | | | |
| skip-show-database | Yes | Yes | | | Global | No |
| - Variable: skip_show_database | | | Yes | | Global | No |
| skip-slave-start | Yes | Yes | | | | |
| skip-ssl | Yes | Yes | | | | |
| skip-stack-trace | Yes | Yes | | | | |
| skip-symbolic-links | Yes | | | | | |
| skip-thread-priority | Yes | Yes | | | | |
| slave_allow_batching | Yes | Yes | Yes | | Global | Yes |
| slave-checkpoint-group | Yes | Yes | | | | |
| - Variable: slave_checkpoint_group | | | | | | |
| slave_checkpoint_group | Yes | Yes | Yes | | Global | Yes |
| slave-checkpoint-period | Yes | Yes | | | | |
| - Variable: slave_checkpoint_period | | | | | | |
| slave_checkpoint_period | Yes | Yes | Yes | | Global | Yes |
| slave_compressed_protocol | Yes | Yes | Yes | | Global | Yes |
| slave_exec_mode | Yes | Yes | Yes | | Global | Yes |
| Slave_heartbeat_period | | | | Yes | Global | No |
| Slave_last_heartbeat | | | | Yes | Global | No |
| slave-load-tmpdir | Yes | Yes | | | Global | No |
| - Variable: slave_load_tmpdir | | | Yes | | Global | No |
| slave-max-allowed-packet | Yes | Yes | | | | |
| - Variable: slave_max_allowed_packet | | | | | | |
| slave_max_allowed_packet | | | Yes | | Global | Yes |
| slave-net-timeout | Yes | Yes | | | Global | Yes |
| - Variable: slave_net_timeout | | | Yes | | Global | Yes |
| Slave_open_temp_tables | | | | Yes | Global | No |
| slave-parallel-workers | Yes | Yes | | | | |
| - Variable: slave_parallel_workers | | | | | | |
| slave_parallel_workers | Yes | | Yes | | Global | Yes |
| slave-pending-jobs-size-max | Yes | | | | | |
| - Variable: slave_pending_jobs_size_max | | | | | | |
| slave_pending_jobs_size_max | | | Yes | | Global | Yes |
| Slave_received_heartbeats | | | | Yes | Global | No |
| Slave_retried_transactions | | | | Yes | Global | No |
| slave-rows-search-algorithms | Yes | Yes | | | | |
| - Variable: slave_rows_search_algorithms | | | | | | |
| slave_rows_search_algorithms | | | Yes | | Global | Yes |
| Slave_running | | | | Yes | Global | No |
| slave-skip-errors | Yes | Yes | | | Global | No |
| - Variable: slave_skip_errors | | | Yes | | Global | No |
| slave-sql-verify-checksum | Yes | Yes | | | | |
| slave_sql_verify_checksum | | | Yes | | Global | Yes |
| slave_transaction_retries | Yes | Yes | Yes | | Global | Yes |
| slave_type_conversions | Yes | Yes | Yes | | Global | No |
| Slow_launch_threads | | | | Yes | Both | No |
| slow_launch_time | Yes | Yes | Yes | | Global | Yes |
| Slow_queries | | | | Yes | Both | No |
| slow-query-log | Yes | Yes | | | Global | Yes |
| - Variable: slow_query_log | | | Yes | | Global | Yes |
| slow_query_log_file | Yes | Yes | Yes | | Global | Yes |
| slow-start-timeout | Yes | Yes | | | | |
| socket | Yes | Yes | Yes | | Global | No |
| sort_buffer_size | Yes | Yes | Yes | | Both | Yes |
| Sort_merge_passes | | | | Yes | Both | No |
| Sort_range | | | | Yes | Both | No |
| Sort_rows | | | | Yes | Both | No |
| Sort_scan | | | | Yes | Both | No |
| sporadic-binlog-dump-fail | Yes | Yes | | | | |
| sql_auto_is_null | | | Yes | | Both | Yes |
| sql_big_selects | | | Yes | | Both | Yes |
| sql_big_tables | | | Yes | | Both | Yes |
| sql_buffer_result | | | Yes | | Both | Yes |
| sql_log_bin | | | Yes | | Session | Yes |
| sql_log_off | | | Yes | | Both | Yes |
| sql_low_priority_updates | | | Yes | | Both | Yes |
| sql_max_join_size | | | Yes | | Both | Yes |
| sql-mode | Yes | Yes | | | Both | Yes |
| - Variable: sql_mode | | | Yes | | Both | Yes |
| sql_notes | | | Yes | | Both | Yes |
| sql_quote_show_create | | | Yes | | Both | Yes |
| sql_safe_updates | | | Yes | | Both | Yes |
| sql_select_limit | | | Yes | | Both | Yes |
| sql_slave_skip_counter | | | Yes | | Global | Yes |
| sql_warnings | | | Yes | | Both | Yes |
| ssl | Yes | Yes | | | | |
| Ssl_accept_renegotiates | | | | Yes | Global | No |
| Ssl_accepts | | | | Yes | Global | No |
| ssl-ca | Yes | Yes | | | Global | No |
| - Variable: ssl_ca | | | Yes | | Global | No |
| Ssl_callback_cache_hits | | | | Yes | Global | No |
| ssl-capath | Yes | Yes | | | Global | No |
| - Variable: ssl_capath | | | Yes | | Global | No |
| ssl-cert | Yes | Yes | | | Global | No |
| - Variable: ssl_cert | | | Yes | | Global | No |
| Ssl_cipher | | | | Yes | Both | No |
| ssl-cipher | Yes | Yes | | | Global | No |
| - Variable: ssl_cipher | | | Yes | | Global | No |
| Ssl_cipher_list | | | | Yes | Both | No |
| Ssl_client_connects | | | | Yes | Global | No |
| Ssl_connect_renegotiates | | | | Yes | Global | No |
| ssl-crl | Yes | Yes | | | Global | No |
| - Variable: ssl_crl | | | Yes | | Global | No |
| ssl-crlpath | Yes | Yes | | | Global | No |
| - Variable: ssl_crlpath | | | Yes | | Global | No |
| Ssl_ctx_verify_depth | | | | Yes | Global | No |
| Ssl_ctx_verify_mode | | | | Yes | Global | No |
| Ssl_default_timeout | | | | Yes | Both | No |
| Ssl_finished_accepts | | | | Yes | Global | No |
| Ssl_finished_connects | | | | Yes | Global | No |
| ssl-key | Yes | Yes | | | Global | No |
| - Variable: ssl_key | | | Yes | | Global | No |
| Ssl_server_not_after | | | | Yes | Both | No |
| Ssl_server_not_before | | | | Yes | Both | No |
| Ssl_session_cache_hits | | | | Yes | Global | No |
| Ssl_session_cache_misses | | | | Yes | Global | No |
| Ssl_session_cache_mode | | | | Yes | Global | No |
| Ssl_session_cache_overflows | | | | Yes | Global | No |
| Ssl_session_cache_size | | | | Yes | Global | No |
| Ssl_session_cache_timeouts | | | | Yes | Global | No |
| Ssl_sessions_reused | | | | Yes | Both | No |
| Ssl_used_session_cache_entries | | | | Yes | Global | No |
| Ssl_verify_depth | | | | Yes | Both | No |
| Ssl_verify_mode | | | | Yes | Both | No |
| Ssl_version | | | | Yes | Both | No |
| standalone | Yes | Yes | | | | |
| storage_engine | | | Yes | | Both | Yes |
| stored_program_cache | Yes | Yes | Yes | | Global | Yes |
| super-large-pages | Yes | Yes | | | | |
| symbolic-links | Yes | Yes | | | | |
| sync_binlog | Yes | Yes | Yes | | Global | Yes |
| sync_frm | Yes | Yes | Yes | | Global | Yes |
| sync_master_info | Yes | Yes | Yes | | Global | Yes |
| sync_relay_log | Yes | Yes | Yes | | Global | Yes |
| sync_relay_log_info | Yes | Yes | Yes | | Global | Yes |
| sysdate-is-now | Yes | Yes | | | | |
| system_time_zone | | | Yes | | Global | No |
| table_definition_cache | | | Yes | | Global | Yes |
| Table_locks_immediate | | | | Yes | Global | No |
| Table_locks_waited | | | | Yes | Global | No |
| table_open_cache | | | Yes | | Global | Yes |
| Table_open_cache_hits | | | | Yes | Both | No |
| table_open_cache_instances | | | Yes | | Global | No |
| Table_open_cache_misses | | | | Yes | Both | No |
| Table_open_cache_overflows | | | | Yes | Both | No |
| tc-heuristic-recover | Yes | Yes | | | | |
| Tc_log_max_pages_used | | | | Yes | Global | No |
| Tc_log_page_size | | | | Yes | Global | No |
| Tc_log_page_waits | | | | Yes | Global | No |
| temp-pool | Yes | Yes | | | | |
| thread_cache_size | Yes | Yes | Yes | | Global | Yes |
| thread_concurrency | Yes | Yes | Yes | | Global | No |
| thread_handling | Yes | Yes | Yes | | Global | No |
| thread_pool_algorithm | Yes | Yes | Yes | | Global | No |
| thread_pool_high_priority_connection | Yes | Yes | Yes | | Both | Yes |
| thread_pool_max_unused_threads | Yes | Yes | Yes | | Global | Yes |
| thread_pool_prio_kickup_timer | Yes | Yes | Yes | | Both | Yes |
| thread_pool_size | Yes | Yes | Yes | | Global | No |
| thread_pool_stall_limit | Yes | Yes | Yes | | Global | Yes |
| thread_stack | Yes | Yes | Yes | | Global | No |
| Threads_cached | | | | Yes | Global | No |
| Threads_connected | | | | Yes | Global | No |
| Threads_created | | | | Yes | Global | No |
| Threads_running | | | | Yes | Global | No |
| time_format | | | Yes | | Global | No |
| time_zone | | | Yes | | Both | Yes |
| timed_mutexes | Yes | Yes | Yes | | Global | Yes |
| timestamp | | | Yes | | Session | Yes |
| tmp_table_size | Yes | Yes | Yes | | Both | Yes |
| tmpdir | Yes | Yes | Yes | | Global | No |
| transaction_alloc_block_size | Yes | Yes | Yes | | Both | Yes |
| transaction_allow_batching | | | Yes | | Session | Yes |
| transaction-isolation | Yes | Yes | | | | |
| - Variable: tx_isolation | | | | | | |
| transaction_prealloc_size | Yes | Yes | Yes | | Both | Yes |
| transaction-read-only | Yes | Yes | | | | |
| - Variable: tx_read_only | | | | | | |
| tx_isolation | | | Yes | | Both | Yes |
| tx_read_only | | | Yes | | Both | Yes |
| unique_checks | | | Yes | | Both | Yes |
| updatable_views_with_limit | Yes | Yes | Yes | | Both | Yes |
| Uptime | | | | Yes | Global | No |
| Uptime_since_flush_status | | | | Yes | Global | No |
| user | Yes | Yes | | | | |
| validate-password | Yes | Yes | | | | |
| validate_password_dictionary_file | | | Yes | | Global | Varies |
| validate_password_dictionary_file_last_parsed | | | | Yes | Global | No |
| validate_password_dictionary_file_words_count | | | | Yes | Global | No |
| validate_password_length | | | Yes | | Global | Yes |
| validate_password_mixed_case_count | | | Yes | | Global | Yes |
| validate_password_number_count | | | Yes | | Global | Yes |
| validate_password_policy | | | Yes | | Global | Yes |
| validate_password_special_char_count | | | Yes | | Global | Yes |
| validate_user_plugins | | | Yes | | Global | No |
| verbose | Yes | Yes | | | | |
| version | | | Yes | | Global | No |
| version_comment | | | Yes | | Global | No |
| version_compile_machine | | | Yes | | Global | No |
| version_compile_os | | | Yes | | Global | No |
| wait_timeout | Yes | Yes | Yes | | Both | Yes |
| warning_count | | | Yes | | Session | No |
|
[a] 이 옵션은 동적이며, 서버 만이 정보를 설정하도록하십시오. 이 변수의 값은 수동으로 설정하지 마십시오. [b] 이 옵션은 동적이며, 서버 만이 정보를 설정하도록하십시오. 이 변수의 값은 수동으로 설정하지 마십시오. | ||||||