• MySQL매뉴얼
    • MySQL 5.6 매뉴얼
    • MySQL 5.1 매뉴얼
    • MySQL 5.0 매뉴얼
    • MySQL HA 매뉴얼
  • 기술문서
    • Xtrabackup 구성
    • 메모리 사용량 모니터링
  • 라이선스
  • 온라인문의
  • 회사소개
  • → 목 록 (MySQL5.6 한글메뉴얼) [close]
  • 1. MySQL 5.6 새로운 기능
  • 2. MySQL 설치 및 업그레이드
  • 3. MySQL Tutorial
  • 4. MySQL 프로그램
  • 5. MySQL 서버관리
  • 1. MySQL Server
    1. 서버 옵션 및 변수 설명
    2. 서버 구성의 기본값
    3. 서버 명령 옵션
    4. 서버 시스템 변수
    5. 시스템 변수 사용
    6. 서버 상태 변수
    7. 서버 SQL 모드
    8. 서버 플러그인
    9. IPv6 지원
    10. 서버측 도움말
    11. 신호에 대한 서버 응답
    12. 서버 셧다운 프로세스
    2. MySQL Server 로그
    3. 하나의 시스템에서 여러 MySQL 인스턴스 실행
    4. DTrace를 사용하여 mysqld 추적
  • 6. 보안
  • 7. 백업 및 복구
  • 8. 최적화
  • 9. Language Structure(언어구조)
  • 10. Character Sets(Globalization)
  • 11. 데이터형(Data Types)
  • 12. 함수와 연산자
  • 13. SQL 문법
  • 14. InnoDB 스토리지 엔진
  • 15. 기타 스토리지 엔진
  • 16. 고가용성 및 확장성
  • 17. 리플리케이션
  • 18. MySQL Cluster
  • 19. 파티셔닝
  • 20. Stored Programs and Views
  • 21. INFORMATION_SCHEMA
  • 22. PERFORMANCE SCHEMA
  • 23. 컨넥터 및 API
  • 24. MySQL 확장
  • 25. MySQL Enterprise Edition
  • 26. MySQL Workbench
  • 27. 제약 및 제한
  • 28. MySQL 5.7 새로운 기능

5.1.1 서버 옵션 및 변수 설명

다음 표는 mysqld 에서 적용 가능한 모든 명령 줄 옵션 서버 변수 및 상태 변수의 목록이 제공되어 있습니다.

이 표에는 명령 행 옵션 (명령 행) 구성 파일에서 사용할 수있는 옵션 (옵션 파일) 서버 시스템 변수 (시스템 변수) 및 상태 변수 (상태 변수)가 하나의 통일 목록에 추가 각 옵션 또는 변수가 유효한지 여부가 표시되어 있습니다. 명령 행 또는 옵션 파일에 설정된 서버 옵션이 해당 서버 시스템 변수 나 상태 변수의 이름과 다른 경우 해당 옵션의 바로 아래에 변수 이름이 기재되어 있습니다. 상태 변수의 경우 변수의 스코프 (범위)는 글로벌 세션 또는 모두로 표시되어 있습니다. 옵션 및 변수 설정 및 사용에 대한 자세한 내용은 해당 섹션을 참조하십시오. 항목에 대한 추가 정보에 대한 직접 링크를 이용할 수있는 경우도 있습니다.

MySQL 클러스터에 고유하게 테이블의 버전은 섹션 18.3.4.1 "MySQL Cluster의 mysqld 옵션과 변수 참조" 를 참조하십시오.

Table 5.1 Option/Variable Summary

NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic
abort-slave-event-countYesYes



Aborted_clients


YesGlobalNo
Aborted_connects


YesGlobalNo
allow-suspicious-udfsYesYes



ansiYesYes



audit-logYesYes



audit_log_buffer_sizeYesYesYes
GlobalNo
audit_log_connection_policyYesYesYes
GlobalYes
audit_log_current_session

Yes
BothNo
Audit_log_current_size


YesGlobalNo
Audit_log_event_max_drop_size


YesGlobalNo
Audit_log_events


YesGlobalNo
Audit_log_events_filtered


YesGlobalNo
Audit_log_events_lost


YesGlobalNo
Audit_log_events_written


YesGlobalNo
audit_log_exclude_accountsYesYesYes
GlobalYes
audit_log_fileYesYesYes
GlobalNo
audit_log_flush

Yes
GlobalYes
audit_log_formatYesYesYes
GlobalNo
audit_log_include_accountsYesYesYes
GlobalYes
audit_log_policyYesYesYes
GlobalVaries
audit_log_rotate_on_sizeYesYesYes
GlobalYes
audit_log_statement_policyYesYesYes
GlobalYes
audit_log_strategyYesYesYes
GlobalNo
Audit_log_total_size


YesGlobalNo
Audit_log_write_waits


YesGlobalNo
authentication_windows_log_levelYesYes



authentication_windows_use_principal_nameYesYes



auto_increment_increment

Yes
BothYes
auto_increment_offset

Yes
BothYes
autocommitYesYesYes
BothYes
automatic_sp_privileges

Yes
GlobalYes
avoid_temporal_upgradeYesYesYes
GlobalYes
back_log

Yes
GlobalNo
basedirYesYesYes
GlobalNo
big-tablesYesYes

BothYes
- Variable: big_tables

Yes
BothYes
bind-addressYesYes

GlobalNo
- Variable: bind_address

Yes
GlobalNo
Binlog_cache_disk_use


YesGlobalNo
binlog_cache_sizeYesYesYes
GlobalYes
Binlog_cache_use


YesGlobalNo
binlog-checksumYesYes



binlog_checksum

Yes
GlobalYes
binlog_direct_non_transactional_updatesYesYesYes
BothYes
binlog-do-dbYesYes



binlog_error_actionYesYesYes
BothYes
binlog-formatYesYes

BothYes
- Variable: binlog_format

Yes
BothYes
binlog_gtid_simple_recoveryYesYesYes
GlobalNo
binlog-ignore-dbYesYes



binlog_max_flush_queue_time

Yes
GlobalYes
binlog_order_commits

Yes
GlobalYes
binlog-row-event-max-sizeYesYes



binlog_row_imageYesYesYes
BothYes
binlog-rows-query-log-eventsYesYes



- Variable: binlog_rows_query_log_events





binlog_rows_query_log_events

Yes
BothYes
Binlog_stmt_cache_disk_use


YesGlobalNo
binlog_stmt_cache_sizeYesYesYes
GlobalYes
Binlog_stmt_cache_use


YesGlobalNo
binlogging_impossible_modeYesYesYes
BothYes
block_encryption_modeYesYesYes
BothYes
bootstrapYesYes



bulk_insert_buffer_sizeYesYesYes
BothYes
Bytes_received


YesBothNo
Bytes_sent


YesBothNo
character_set_client

Yes
BothYes
character-set-client-handshakeYesYes



character_set_connection

Yes
BothYes
character_set_database[a]

Yes
BothYes
character-set-filesystemYesYes

BothYes
- Variable: character_set_filesystem

Yes
BothYes
character_set_results

Yes
BothYes
character-set-serverYesYes

BothYes
- Variable: character_set_server

Yes
BothYes
character_set_system

Yes
GlobalNo
character-sets-dirYesYes

GlobalNo
- Variable: character_sets_dir

Yes
GlobalNo
chrootYesYes



collation_connection

Yes
BothYes
collation_database[b]

Yes
BothYes
collation-serverYesYes

BothYes
- Variable: collation_server

Yes
BothYes
Com_admin_commands


YesBothNo
Com_alter_db


YesBothNo
Com_alter_db_upgrade


YesBothNo
Com_alter_event


YesBothNo
Com_alter_function


YesBothNo
Com_alter_procedure


YesBothNo
Com_alter_server


YesBothNo
Com_alter_table


YesBothNo
Com_alter_tablespace


YesBothNo
Com_alter_user


YesBothNo
Com_analyze


YesBothNo
Com_assign_to_keycache


YesBothNo
Com_begin


YesBothNo
Com_binlog


YesBothNo
Com_call_procedure


YesBothNo
Com_change_db


YesBothNo
Com_change_master


YesBothNo
Com_check


YesBothNo
Com_checksum


YesBothNo
Com_commit


YesBothNo
Com_create_db


YesBothNo
Com_create_event


YesBothNo
Com_create_function


YesBothNo
Com_create_index


YesBothNo
Com_create_procedure


YesBothNo
Com_create_server


YesBothNo
Com_create_table


YesBothNo
Com_create_trigger


YesBothNo
Com_create_udf


YesBothNo
Com_create_user


YesBothNo
Com_create_view


YesBothNo
Com_dealloc_sql


YesBothNo
Com_delete


YesBothNo
Com_delete_multi


YesBothNo
Com_do


YesBothNo
Com_drop_db


YesBothNo
Com_drop_event


YesBothNo
Com_drop_function


YesBothNo
Com_drop_index


YesBothNo
Com_drop_procedure


YesBothNo
Com_drop_server


YesBothNo
Com_drop_table


YesBothNo
Com_drop_trigger


YesBothNo
Com_drop_user


YesBothNo
Com_drop_view


YesBothNo
Com_empty_query


YesBothNo
Com_execute_sql


YesBothNo
Com_flush


YesBothNo
Com_get_diagnostics


YesBothNo
Com_grant


YesBothNo
Com_ha_close


YesBothNo
Com_ha_open


YesBothNo
Com_ha_read


YesBothNo
Com_help


YesBothNo
Com_insert


YesBothNo
Com_insert_select


YesBothNo
Com_install_plugin


YesBothNo
Com_kill


YesBothNo
Com_load


YesBothNo
Com_lock_tables


YesBothNo
Com_optimize


YesBothNo
Com_preload_keys


YesBothNo
Com_prepare_sql


YesBothNo
Com_purge


YesBothNo
Com_purge_before_date


YesBothNo
Com_release_savepoint


YesBothNo
Com_rename_table


YesBothNo
Com_rename_user


YesBothNo
Com_repair


YesBothNo
Com_replace


YesBothNo
Com_replace_select


YesBothNo
Com_reset


YesBothNo
Com_resignal


YesBothNo
Com_revoke


YesBothNo
Com_revoke_all


YesBothNo
Com_rollback


YesBothNo
Com_rollback_to_savepoint


YesBothNo
Com_savepoint


YesBothNo
Com_select


YesBothNo
Com_set_option


YesBothNo
Com_show_authors


YesBothNo
Com_show_binlog_events


YesBothNo
Com_show_binlogs


YesBothNo
Com_show_charsets


YesBothNo
Com_show_collations


YesBothNo
Com_show_contributors


YesBothNo
Com_show_create_db


YesBothNo
Com_show_create_event


YesBothNo
Com_show_create_func


YesBothNo
Com_show_create_proc


YesBothNo
Com_show_create_table


YesBothNo
Com_show_create_trigger


YesBothNo
Com_show_databases


YesBothNo
Com_show_engine_logs


YesBothNo
Com_show_engine_mutex


YesBothNo
Com_show_engine_status


YesBothNo
Com_show_errors


YesBothNo
Com_show_events


YesBothNo
Com_show_fields


YesBothNo
Com_show_function_code


YesBothNo
Com_show_function_status


YesBothNo
Com_show_grants


YesBothNo
Com_show_keys


YesBothNo
Com_show_master_status


YesBothNo
Com_show_ndb_status


YesBothNo
Com_show_new_master


YesBothNo
Com_show_open_tables


YesBothNo
Com_show_plugins


YesBothNo
Com_show_privileges


YesBothNo
Com_show_procedure_code


YesBothNo
Com_show_procedure_status


YesBothNo
Com_show_processlist


YesBothNo
Com_show_profile


YesBothNo
Com_show_profiles


YesBothNo
Com_show_relaylog_events


YesBothNo
Com_show_slave_hosts


YesBothNo
Com_show_slave_status


YesBothNo
Com_show_status


YesBothNo
Com_show_storage_engines


YesBothNo
Com_show_table_status


YesBothNo
Com_show_tables


YesBothNo
Com_show_triggers


YesBothNo
Com_show_variables


YesBothNo
Com_show_warnings


YesBothNo
Com_signal


YesBothNo
Com_slave_start


YesBothNo
Com_slave_stop


YesBothNo
Com_stmt_close


YesBothNo
Com_stmt_execute


YesBothNo
Com_stmt_fetch


YesBothNo
Com_stmt_prepare


YesBothNo
Com_stmt_reprepare


YesBothNo
Com_stmt_reset


YesBothNo
Com_stmt_send_long_data


YesBothNo
Com_truncate


YesBothNo
Com_uninstall_plugin


YesBothNo
Com_unlock_tables


YesBothNo
Com_update


YesBothNo
Com_update_multi


YesBothNo
Com_xa_commit


YesBothNo
Com_xa_end


YesBothNo
Com_xa_prepare


YesBothNo
Com_xa_recover


YesBothNo
Com_xa_rollback


YesBothNo
Com_xa_start


YesBothNo
completion_typeYesYesYes
BothYes
Compression


YesSessionNo
concurrent_insertYesYesYes
GlobalYes
connect_timeoutYesYesYes
GlobalYes
Connection_errors_accept


YesGlobalNo
Connection_errors_internal


YesGlobalNo
Connection_errors_max_connections


YesGlobalNo
Connection_errors_peer_addr


YesGlobalNo
Connection_errors_select


YesGlobalNo
Connection_errors_tcpwrap


YesGlobalNo
Connections


YesGlobalNo
consoleYesYes



core-fileYesYes



core_file

Yes
GlobalNo
create_old_temporalsYesYesYes
GlobalNo
Created_tmp_disk_tables


YesBothNo
Created_tmp_files


YesGlobalNo
Created_tmp_tables


YesBothNo
daemon_memcached_enable_binlogYesYesYes
GlobalNo
daemon_memcached_engine_lib_nameYesYesYes
GlobalNo
daemon_memcached_engine_lib_pathYesYesYes
GlobalNo
daemon_memcached_optionYesYesYes
GlobalNo
daemon_memcached_r_batch_sizeYesYesYes
GlobalNo
daemon_memcached_w_batch_sizeYesYesYes
GlobalNo
datadirYesYesYes
GlobalNo
date_format

Yes
GlobalNo
datetime_format

Yes
GlobalNo
debugYesYesYes
BothYes
debug_sync

Yes
SessionYes
debug-sync-timeoutYesYes



default-authentication-pluginYesYes



default-storage-engineYesYes

BothYes
- Variable: default_storage_engine

Yes
BothYes
default-time-zoneYesYes



default_tmp_storage_engineYesYesYes
BothYes
default_week_formatYesYesYes
BothYes
defaults-extra-fileYes




defaults-fileYes




defaults-group-suffixYes




delay-key-writeYesYes

GlobalYes
- Variable: delay_key_write

Yes
GlobalYes
Delayed_errors


YesGlobalNo
delayed_insert_limitYesYesYes
GlobalYes
Delayed_insert_threads


YesGlobalNo
delayed_insert_timeoutYesYesYes
GlobalYes
delayed_queue_sizeYesYesYes
GlobalYes
Delayed_writes


YesGlobalNo
des-key-fileYesYes



disable-gtid-unsafe-statementsYesYesYes
GlobalNo
disable_gtid_unsafe_statementsYesYesYes
GlobalNo
disconnect_on_expired_passwordYesYesYes
SessionNo
disconnect-slave-event-countYesYes



div_precision_incrementYesYesYes
BothYes
enable-named-pipeYesYes



- Variable: named_pipe





end_markers_in_json

Yes
BothYes
enforce-gtid-consistencyYesYesYes
GlobalNo
enforce_gtid_consistencyYesYesYes
GlobalNo
engine-condition-pushdownYesYes

BothYes
- Variable: engine_condition_pushdown

Yes
BothYes
eq_range_index_dive_limit

Yes
BothYes
error_count

Yes
SessionNo
event-schedulerYesYes

GlobalYes
- Variable: event_scheduler

Yes
GlobalYes
exit-infoYesYes



expire_logs_daysYesYesYes
GlobalYes
explicit_defaults_for_timestampYesYesYes
BothNo
external-lockingYesYes



- Variable: skip_external_locking





external_user

Yes
SessionNo
federatedYesYes



Firewall_access_denied


YesGlobalNo
Firewall_access_granted


YesGlobalNo
Firewall_cached_entries


YesGlobalNo
flushYesYesYes
GlobalYes
Flush_commands


YesGlobalNo
flush_timeYesYesYes
GlobalYes
foreign_key_checks

Yes
BothYes
ft_boolean_syntaxYesYesYes
GlobalYes
ft_max_word_lenYesYesYes
GlobalNo
ft_min_word_lenYesYesYes
GlobalNo
ft_query_expansion_limitYesYesYes
GlobalNo
ft_stopword_fileYesYesYes
GlobalNo
gdbYesYes



general-logYesYes

GlobalYes
- Variable: general_log

Yes
GlobalYes
general_log_fileYesYesYes
GlobalYes
group_concat_max_lenYesYesYes
BothYes
gtid_done

Yes
BothNo
gtid_executed

Yes
BothNo
gtid_lost

Yes
GlobalNo
gtid-modeYesYes

GlobalNo
- Variable: gtid_mode

Yes
GlobalNo
gtid_mode

Yes
GlobalNo
gtid_next

Yes
SessionYes
gtid_owned

Yes
BothNo
gtid_purged

Yes
GlobalYes
Handler_commit


YesBothNo
Handler_delete


YesBothNo
Handler_discover


YesBothNo
Handler_external_lock


YesBothNo
Handler_mrr_init


YesBothNo
Handler_prepare


YesBothNo
Handler_read_first


YesBothNo
Handler_read_key


YesBothNo
Handler_read_last


YesBothNo
Handler_read_next


YesBothNo
Handler_read_prev


YesBothNo
Handler_read_rnd


YesBothNo
Handler_read_rnd_next


YesBothNo
Handler_rollback


YesBothNo
Handler_savepoint


YesBothNo
Handler_savepoint_rollback


YesBothNo
Handler_update


YesBothNo
Handler_write


YesBothNo
have_compress

Yes
GlobalNo
have_crypt

Yes
GlobalNo
have_csv

Yes
GlobalNo
have_dynamic_loading

Yes
GlobalNo
have_geometry

Yes
GlobalNo
have_innodb

Yes
GlobalNo
have_ndbcluster

Yes
GlobalNo
have_openssl

Yes
GlobalNo
have_partitioning

Yes
GlobalNo
have_profiling

Yes
GlobalNo
have_query_cache

Yes
GlobalNo
have_rtree_keys

Yes
GlobalNo
have_ssl

Yes
GlobalNo
have_symlink

Yes
GlobalNo
helpYesYes



host_cache_size

Yes
GlobalYes
hostname

Yes
GlobalNo
identity

Yes
SessionYes
ignore-builtin-innodbYesYes

GlobalNo
- Variable: ignore_builtin_innodb

Yes
GlobalNo
ignore-db-dirYesYes



ignore_db_dirs

Yes
GlobalNo
init_connectYesYesYes
GlobalYes
init-fileYesYes

GlobalNo
- Variable: init_file

Yes
GlobalNo
init_slaveYesYesYes
GlobalYes
innodbYesYes



innodb_adaptive_flushingYesYesYes
GlobalYes
innodb_adaptive_flushing_lwmYesYesYes
GlobalYes
innodb_adaptive_hash_indexYesYesYes
GlobalYes
innodb_adaptive_max_sleep_delayYesYesYes
GlobalYes
innodb_additional_mem_pool_sizeYesYesYes
GlobalNo
innodb_api_bk_commit_intervalYesYesYes
GlobalYes
innodb_api_disable_rowlockYesYesYes
GlobalNo
innodb_api_enable_binlogYesYesYes
GlobalNo
innodb_api_enable_mdlYesYesYes
GlobalNo
innodb_api_trx_levelYesYesYes
GlobalYes
innodb_autoextend_incrementYesYesYes
GlobalYes
innodb_autoinc_lock_modeYesYesYes
GlobalNo
Innodb_available_undo_logs


YesGlobalNo
Innodb_buffer_pool_bytes_data


YesGlobalNo
Innodb_buffer_pool_bytes_dirty


YesGlobalNo
innodb_buffer_pool_dump_at_shutdownYesYesYes
GlobalYes
innodb_buffer_pool_dump_nowYesYesYes
GlobalYes
Innodb_buffer_pool_dump_status


YesGlobalNo
innodb_buffer_pool_filenameYesYesYes
GlobalYes
innodb_buffer_pool_instancesYesYesYes
GlobalNo
innodb_buffer_pool_load_abortYesYesYes
GlobalYes
innodb_buffer_pool_load_at_startupYesYesYes
GlobalNo
innodb_buffer_pool_load_nowYesYesYes
GlobalYes
Innodb_buffer_pool_load_status


YesGlobalNo
Innodb_buffer_pool_pages_data


YesGlobalNo
Innodb_buffer_pool_pages_dirty


YesGlobalNo
Innodb_buffer_pool_pages_flushed


YesGlobalNo
Innodb_buffer_pool_pages_free


YesGlobalNo
Innodb_buffer_pool_pages_latched


YesGlobalNo
Innodb_buffer_pool_pages_misc


YesGlobalNo
Innodb_buffer_pool_pages_total


YesGlobalNo
Innodb_buffer_pool_read_ahead


YesGlobalNo
Innodb_buffer_pool_read_ahead_evicted


YesGlobalNo
Innodb_buffer_pool_read_requests


YesGlobalNo
Innodb_buffer_pool_reads


YesGlobalNo
innodb_buffer_pool_sizeYesYesYes
GlobalNo
Innodb_buffer_pool_wait_free


YesGlobalNo
Innodb_buffer_pool_write_requests


YesGlobalNo
innodb_change_buffer_max_sizeYesYesYes
GlobalYes
innodb_change_bufferingYesYesYes
GlobalYes
innodb_change_buffering_debugYesYesYes
GlobalYes
innodb_checksum_algorithmYesYesYes
GlobalYes
innodb_checksumsYesYesYes
GlobalNo
innodb_cmp_per_index_enabledYesYesYes
GlobalYes
innodb_commit_concurrencyYesYesYes
GlobalYes
innodb_compression_failure_threshold_pctYesYesYes
GlobalYes
innodb_compression_levelYesYesYes
GlobalYes
innodb_compression_pad_pct_maxYesYesYes
GlobalYes
innodb_concurrency_ticketsYesYesYes
GlobalYes
innodb_data_file_pathYesYesYes
GlobalNo
Innodb_data_fsyncs


YesGlobalNo
innodb_data_home_dirYesYesYes
GlobalNo
Innodb_data_pending_fsyncs


YesGlobalNo
Innodb_data_pending_reads


YesGlobalNo
Innodb_data_pending_writes


YesGlobalNo
Innodb_data_read


YesGlobalNo
Innodb_data_reads


YesGlobalNo
Innodb_data_writes


YesGlobalNo
Innodb_data_written


YesGlobalNo
Innodb_dblwr_pages_written


YesGlobalNo
Innodb_dblwr_writes


YesGlobalNo
innodb_disable_sort_file_cacheYesYesYes
GlobalYes
innodb_doublewriteYesYesYes
GlobalNo
innodb_fast_shutdownYesYesYes
GlobalYes
innodb_fil_make_page_dirty_debugYesYesYes
GlobalYes
innodb_file_formatYesYesYes
GlobalYes
innodb_file_format_checkYesYesYes
GlobalNo
innodb_file_format_maxYesYesYes
GlobalYes
innodb_file_per_tableYesYesYes
GlobalYes
innodb_flush_log_at_timeout

Yes
GlobalYes
innodb_flush_log_at_trx_commitYesYesYes
GlobalYes
innodb_flush_methodYesYesYes
GlobalNo
innodb_flush_neighborsYesYesYes
GlobalYes
innodb_flushing_avg_loopsYesYesYes
GlobalYes
innodb_force_load_corruptedYesYesYes
GlobalNo
innodb_force_recoveryYesYesYes
GlobalNo
innodb_ft_aux_table

Yes
GlobalYes
innodb_ft_cache_sizeYesYesYes
GlobalNo
innodb_ft_enable_diag_printYesYesYes
GlobalYes
innodb_ft_enable_stopwordYesYesYes
GlobalYes
innodb_ft_max_token_sizeYesYesYes
GlobalNo
innodb_ft_min_token_sizeYesYesYes
GlobalNo
innodb_ft_num_word_optimizeYesYesYes
GlobalYes
innodb_ft_result_cache_limitYesYesYes
GlobalYes
innodb_ft_server_stopword_tableYesYesYes
GlobalYes
innodb_ft_sort_pll_degreeYesYesYes
GlobalNo
innodb_ft_total_cache_sizeYesYesYes
GlobalNo
innodb_ft_user_stopword_tableYesYesYes
BothYes
Innodb_have_atomic_builtins


YesGlobalNo
innodb_io_capacityYesYesYes
GlobalYes
innodb_io_capacity_maxYesYesYes
GlobalYes
innodb_large_prefixYesYesYes
GlobalYes
innodb_limit_optimistic_insert_debugYesYesYes
GlobalYes
innodb_lock_wait_timeoutYesYesYes
BothYes
innodb_locks_unsafe_for_binlogYesYesYes
GlobalNo
innodb_log_buffer_sizeYesYesYes
GlobalNo
innodb_log_compressed_pagesYesYesYes
GlobalYes
innodb_log_file_sizeYesYesYes
GlobalNo
innodb_log_files_in_groupYesYesYes
GlobalNo
innodb_log_group_home_dirYesYesYes
GlobalNo
Innodb_log_waits


YesGlobalNo
Innodb_log_write_requests


YesGlobalNo
Innodb_log_writes


YesGlobalNo
innodb_lru_scan_depthYesYesYes
GlobalYes
innodb_max_dirty_pages_pctYesYesYes
GlobalYes
innodb_max_dirty_pages_pct_lwmYesYesYes
GlobalYes
innodb_max_purge_lagYesYesYes
GlobalYes
innodb_max_purge_lag_delayYesYesYes
GlobalYes
innodb_mirrored_log_groupsYesYesYes
GlobalNo
innodb_monitor_disableYesYesYes
GlobalYes
innodb_monitor_enableYesYesYes
GlobalYes
innodb_monitor_resetYesYesYes
GlobalYes
innodb_monitor_reset_allYesYesYes
GlobalYes
Innodb_num_open_files


YesGlobalNo
innodb_numa_interleaveYesYesYes
GlobalNo
innodb_old_blocks_pctYesYesYes
GlobalYes
innodb_old_blocks_timeYesYesYes
GlobalYes
innodb_online_alter_log_max_sizeYesYesYes
GlobalYes
innodb_open_filesYesYesYes
GlobalNo
innodb_optimize_fulltext_onlyYesYesYes
GlobalYes
Innodb_os_log_fsyncs


YesGlobalNo
Innodb_os_log_pending_fsyncs


YesGlobalNo
Innodb_os_log_pending_writes


YesGlobalNo
Innodb_os_log_written


YesGlobalNo
Innodb_page_size


YesGlobalNo
innodb_page_sizeYesYesYes
GlobalNo
Innodb_pages_created


YesGlobalNo
Innodb_pages_read


YesGlobalNo
Innodb_pages_written


YesGlobalNo
innodb_print_all_deadlocksYesYesYes
GlobalYes
innodb_purge_batch_sizeYesYesYes
GlobalYes
innodb_purge_threadsYesYesYes
GlobalNo
innodb_random_read_aheadYesYesYes
GlobalYes
innodb_read_ahead_thresholdYesYesYes
GlobalYes
innodb_read_io_threadsYesYesYes
GlobalNo
innodb_read_onlyYesYesYes
GlobalNo
innodb_replication_delayYesYesYes
GlobalYes
innodb_rollback_on_timeoutYesYesYes
GlobalNo
innodb_rollback_segmentsYesYesYes
GlobalYes
Innodb_row_lock_current_waits


YesGlobalNo
Innodb_row_lock_time


YesGlobalNo
Innodb_row_lock_time_avg


YesGlobalNo
Innodb_row_lock_time_max


YesGlobalNo
Innodb_row_lock_waits


YesGlobalNo
Innodb_rows_deleted


YesGlobalNo
Innodb_rows_inserted


YesGlobalNo
Innodb_rows_read


YesGlobalNo
Innodb_rows_updated


YesGlobalNo
innodb_saved_page_number_debugYesYesYes
GlobalYes
innodb_sort_buffer_sizeYesYesYes
GlobalNo
innodb_spin_wait_delayYesYesYes
GlobalYes
innodb_stats_auto_recalcYesYesYes
GlobalYes
innodb_stats_methodYesYesYes
GlobalYes
innodb_stats_on_metadataYesYesYes
GlobalYes
innodb_stats_persistentYesYesYes
GlobalYes
innodb_stats_persistent_sample_pagesYesYesYes
GlobalYes
innodb_stats_sample_pagesYesYesYes
GlobalYes
innodb_stats_transient_sample_pagesYesYesYes
GlobalYes
innodb-status-fileYesYes



innodb_status_outputYesYesYes
GlobalYes
innodb_status_output_locksYesYesYes
GlobalYes
innodb_strict_modeYesYesYes
BothYes
innodb_support_xaYesYesYes
BothYes
innodb_sync_array_sizeYesYesYes
GlobalNo
innodb_sync_spin_loopsYesYesYes
GlobalYes
innodb_table_locksYesYesYes
BothYes
innodb_thread_concurrencyYesYesYes
GlobalYes
innodb_thread_sleep_delayYesYesYes
GlobalYes
innodb_tmpdirYesYesYes
SessionYes
Innodb_truncated_status_writes


YesGlobalNo
innodb_trx_purge_view_update_only_debugYesYesYes
GlobalYes
innodb_trx_rseg_n_slots_debugYesYesYes
GlobalYes
innodb_undo_directoryYesYesYes
GlobalNo
innodb_undo_logsYesYesYes
GlobalYes
innodb_undo_tablespacesYesYesYes
GlobalNo
innodb_use_native_aioYesYesYes
GlobalNo
innodb_use_sys_mallocYesYesYes
GlobalNo
innodb_version

Yes
GlobalNo
innodb_write_io_threadsYesYesYes
GlobalNo
insert_id

Yes
SessionYes
installYes




install-manualYes




interactive_timeoutYesYesYes
BothYes
join_buffer_sizeYesYesYes
BothYes
keep_files_on_createYesYesYes
BothYes
Key_blocks_not_flushed


YesGlobalNo
Key_blocks_unused


YesGlobalNo
Key_blocks_used


YesGlobalNo
key_buffer_sizeYesYesYes
GlobalYes
key_cache_age_thresholdYesYesYes
GlobalYes
key_cache_block_sizeYesYesYes
GlobalYes
key_cache_division_limitYesYesYes
GlobalYes
Key_read_requests


YesGlobalNo
Key_reads


YesGlobalNo
Key_write_requests


YesGlobalNo
Key_writes


YesGlobalNo
languageYesYesYes
GlobalNo
large_files_support

Yes
GlobalNo
large_page_size

Yes
GlobalNo
large-pagesYesYes

GlobalNo
- Variable: large_pages

Yes
GlobalNo
last_insert_id

Yes
SessionYes
Last_query_cost


YesSessionNo
Last_query_partial_plans


YesSessionNo
lc-messagesYesYes

BothYes
- Variable: lc_messages

Yes
BothYes
lc-messages-dirYesYes

GlobalNo
- Variable: lc_messages_dir

Yes
GlobalNo
lc_time_names

Yes
BothYes
license

Yes
GlobalNo
local_infile

Yes
GlobalYes
local-serviceYes




lock_wait_timeoutYesYesYes
BothYes
locked_in_memory

Yes
GlobalNo
logYesYesYes
GlobalYes
log-binYesYesYes
GlobalNo
log_bin

Yes
GlobalNo
log_bin_basename

Yes
GlobalNo
log-bin-indexYesYes



log_bin_index

Yes
GlobalNo
log-bin-trust-function-creatorsYesYes

GlobalYes
- Variable: log_bin_trust_function_creators

Yes
GlobalYes
log-bin-use-v1-row-eventsYesYes

GlobalNo
- Variable: log_bin_use_v1_row_events

Yes
GlobalNo
log_bin_use_v1_row_eventsYesYesYes
GlobalNo
log-errorYesYes

GlobalNo
- Variable: log_error

Yes
GlobalNo
log-isamYesYes



log-outputYesYes

GlobalYes
- Variable: log_output

Yes
GlobalYes
log-queries-not-using-indexesYesYes

GlobalYes
- Variable: log_queries_not_using_indexes

Yes
GlobalYes
log-rawYesYes



log-short-formatYesYes



log-slave-updatesYesYes

GlobalNo
- Variable: log_slave_updates

Yes
GlobalNo
log_slave_updatesYesYesYes
GlobalNo
log-slow-admin-statementsYesYes



log_slow_admin_statements

Yes
GlobalYes
log-slow-queriesYesYes

GlobalYes
- Variable: log_slow_queries

Yes
GlobalYes
log-slow-slave-statementsYesYes



log_slow_slave_statements

Yes
GlobalYes
log-tcYesYes



log-tc-sizeYesYes



log_throttle_queries_not_using_indexes

Yes
GlobalYes
log-warningsYesYes

VariesYes
- Variable: log_warnings

Yes
VariesYes
long_query_timeYesYesYes
BothYes
low-priority-updatesYesYes

BothYes
- Variable: low_priority_updates

Yes
BothYes
lower_case_file_system

Yes
GlobalNo
lower_case_table_namesYesYesYes
GlobalNo
master-info-fileYesYes



master-info-repositoryYesYes



- Variable: master_info_repository





master_info_repositoryYesYesYes
GlobalYes
master-retry-countYesYes



master-verify-checksumYesYes



- Variable: master_verify_checksum





master_verify_checksum

Yes
GlobalYes
max_allowed_packetYesYesYes
BothYes
max_binlog_cache_sizeYesYesYes
GlobalYes
max-binlog-dump-eventsYesYes



max_binlog_sizeYesYesYes
GlobalYes
max_binlog_stmt_cache_sizeYesYesYes
GlobalYes
max_connect_errorsYesYesYes
GlobalYes
max_connectionsYesYesYes
GlobalYes
max_delayed_threadsYesYesYes
BothYes
max_digest_lengthYesYesYes
GlobalNo
max_error_countYesYesYes
BothYes
max_heap_table_sizeYesYesYes
BothYes
max_insert_delayed_threads

Yes
BothYes
max_join_sizeYesYesYes
BothYes
max_length_for_sort_dataYesYesYes
BothYes
max_prepared_stmt_countYesYesYes
GlobalYes
max_relay_log_sizeYesYesYes
GlobalYes
max_seeks_for_keyYesYesYes
BothYes
max_sort_lengthYesYesYes
BothYes
max_sp_recursion_depthYesYesYes
BothYes
max_tmp_tables

Yes
BothYes
Max_used_connections


YesGlobalNo
max_user_connectionsYesYesYes
BothYes
max_write_lock_countYesYesYes
GlobalYes
memlockYesYes



- Variable: locked_in_memory





metadata_locks_cache_size

Yes
GlobalNo
metadata_locks_hash_instances

Yes
GlobalNo
min-examined-row-limitYesYesYes
BothYes
multi_range_countYesYesYes
BothYes
myisam-block-sizeYesYes



myisam_data_pointer_sizeYesYesYes
GlobalYes
myisam_max_sort_file_sizeYesYesYes
GlobalYes
myisam_mmap_sizeYesYesYes
GlobalNo
myisam-recover-optionsYesYes



- Variable: myisam_recover_options





myisam_recover_options

Yes
GlobalNo
myisam_repair_threadsYesYesYes
BothYes
myisam_sort_buffer_sizeYesYesYes
BothYes
myisam_stats_methodYesYesYes
BothYes
myisam_use_mmapYesYesYes
GlobalYes
mysql_firewall_max_query_sizeYesYesYes
GlobalNo
mysql_firewall_modeYesYesYes
GlobalYes
mysql_firewall_traceYesYesYes
GlobalYes
named_pipe

Yes
GlobalNo
Ndb_api_bytes_received_count


YesGlobalNo
Ndb_api_bytes_received_count_session


YesSessionNo
Ndb_api_bytes_received_count_slave


YesGlobalNo
Ndb_api_bytes_sent_count


YesGlobalNo
Ndb_api_bytes_sent_count_session


YesSessionNo
Ndb_api_bytes_sent_count_slave


YesGlobalNo
Ndb_api_event_bytes_count


YesGlobalNo
Ndb_api_event_bytes_count_injector


YesGlobalNo
Ndb_api_event_data_count


YesGlobalNo
Ndb_api_event_data_count_injector


YesGlobalNo
Ndb_api_event_nondata_count


YesGlobalNo
Ndb_api_event_nondata_count_injector


YesGlobalNo
Ndb_api_pk_op_count


YesGlobalNo
Ndb_api_pk_op_count_session


YesSessionNo
Ndb_api_pk_op_count_slave


YesGlobalNo
Ndb_api_pruned_scan_count


YesGlobalNo
Ndb_api_pruned_scan_count_session


YesSessionNo
Ndb_api_pruned_scan_count_slave


YesGlobalNo
Ndb_api_range_scan_count


YesGlobalNo
Ndb_api_range_scan_count_session


YesSessionNo
Ndb_api_range_scan_count_slave


YesGlobalNo
Ndb_api_read_row_count


YesGlobalNo
Ndb_api_read_row_count_session


YesSessionNo
Ndb_api_read_row_count_slave


YesGlobalNo
Ndb_api_scan_batch_count


YesGlobalNo
Ndb_api_scan_batch_count_session


YesSessionNo
Ndb_api_scan_batch_count_slave


YesGlobalNo
Ndb_api_table_scan_count


YesGlobalNo
Ndb_api_table_scan_count_session


YesSessionNo
Ndb_api_table_scan_count_slave


YesGlobalNo
Ndb_api_trans_abort_count


YesGlobalNo
Ndb_api_trans_abort_count_session


YesSessionNo
Ndb_api_trans_abort_count_slave


YesGlobalNo
Ndb_api_trans_close_count


YesGlobalNo
Ndb_api_trans_close_count_session


YesSessionNo
Ndb_api_trans_close_count_slave


YesGlobalNo
Ndb_api_trans_commit_count


YesGlobalNo
Ndb_api_trans_commit_count_session


YesSessionNo
Ndb_api_trans_commit_count_slave


YesGlobalNo
Ndb_api_trans_local_read_row_count


YesGlobalNo
Ndb_api_trans_local_read_row_count_session


YesSessionNo
Ndb_api_trans_local_read_row_count_slave


YesGlobalNo
Ndb_api_trans_start_count


YesGlobalNo
Ndb_api_trans_start_count_session


YesSessionNo
Ndb_api_trans_start_count_slave


YesGlobalNo
Ndb_api_uk_op_count


YesGlobalNo
Ndb_api_uk_op_count_session


YesSessionNo
Ndb_api_uk_op_count_slave


YesGlobalNo
Ndb_api_wait_exec_complete_count


YesGlobalNo
Ndb_api_wait_exec_complete_count_session


YesSessionNo
Ndb_api_wait_exec_complete_count_slave


YesGlobalNo
Ndb_api_wait_meta_request_count


YesGlobalNo
Ndb_api_wait_meta_request_count_session


YesSessionNo
Ndb_api_wait_meta_request_count_slave


YesGlobalNo
Ndb_api_wait_nanos_count


YesGlobalNo
Ndb_api_wait_nanos_count_session


YesSessionNo
Ndb_api_wait_nanos_count_slave


YesGlobalNo
Ndb_api_wait_scan_result_count


YesGlobalNo
Ndb_api_wait_scan_result_count_session


YesSessionNo
Ndb_api_wait_scan_result_count_slave


YesGlobalNo
ndb_autoincrement_prefetch_szYesYesYes
BothYes
ndb-batch-sizeYesYesYes
GlobalNo
ndb-blob-read-batch-bytesYesYesYes
BothYes
ndb-blob-write-batch-bytesYesYesYes
BothYes
ndb_cache_check_timeYesYesYes
GlobalYes
ndb_clear_apply_statusYes
Yes
GlobalYes
ndb-cluster-connection-poolYesYesYes
GlobalNo
Ndb_cluster_node_id


YesBothNo
Ndb_config_from_host


YesBothNo
Ndb_config_from_port


YesBothNo
Ndb_conflict_fn_epoch


YesGlobalNo
Ndb_conflict_fn_epoch_trans


YesGlobalNo
Ndb_conflict_fn_epoch2


YesGlobalNo
Ndb_conflict_fn_epoch2_trans


YesGlobalNo
Ndb_conflict_fn_max


YesGlobalNo
Ndb_conflict_fn_max_del_win


YesGlobalNo
Ndb_conflict_fn_old


YesGlobalNo
Ndb_conflict_last_conflict_epoch

Yes
GlobalNo
Ndb_conflict_last_stable_epoch


YesGlobalNo
Ndb_conflict_reflected_op_discard_count


YesGlobalNo
Ndb_conflict_reflected_op_prepare_count


YesGlobalNo
Ndb_conflict_refresh_op_count


YesGlobalNo
Ndb_conflict_trans_conflict_commit_count


YesGlobalNo
Ndb_conflict_trans_detect_iter_count


YesGlobalNo
Ndb_conflict_trans_reject_count


YesGlobalNo
Ndb_conflict_trans_row_conflict_count


YesGlobalNo
Ndb_conflict_trans_row_reject_count


YesGlobalNo
ndb-connectstringYesYes



ndb-deferred-constraintsYesYes

BothYes
- Variable: ndb_deferred_constraints

Yes
BothYes
ndb_deferred_constraintsYesYesYes
BothYes
ndb-distributionYesYes

GlobalYes
- Variable: ndb_distribution

Yes
GlobalYes
ndb_distributionYesYesYes
GlobalYes
Ndb_epoch_delete_delete_count


YesGlobalNo
ndb_eventbuffer_free_percentYesYesYes
GlobalYes
ndb_eventbuffer_max_allocYesYesYes
GlobalYes
Ndb_execute_count


YesGlobalNo
ndb_extra_loggingYesYesYes
GlobalYes
ndb_force_sendYesYesYes
BothYes
ndb_index_stat_cache_entriesYesYesYes
BothYes
ndb_index_stat_enableYesYesYes
BothYes
ndb_index_stat_optionYesYesYes
BothYes
ndb_index_stat_update_freqYesYesYes
BothYes
ndb_join_pushdown

Yes
BothYes
Ndb_last_commit_epoch_server


YesGlobalNo
Ndb_last_commit_epoch_session


YesSessionNo
ndb-log-apply-statusYesYes

GlobalNo
- Variable: ndb_log_apply_status

Yes
GlobalNo
ndb_log_apply_statusYesYesYes
GlobalNo
ndb_log_binYes
Yes
BothYes
ndb_log_binlog_indexYes
Yes
GlobalYes
ndb-log-empty-epochsYesYesYes
GlobalYes
ndb_log_empty_epochsYesYesYes
GlobalYes
ndb-log-exclusive-readsYesYes

BothYes
- Variable: ndb_log_exclusive_reads

Yes
BothYes
ndb_log_exclusive_readsYesYesYes
BothYes
ndb-log-origYesYes

GlobalNo
- Variable: ndb_log_orig

Yes
GlobalNo
ndb_log_origYesYesYes
GlobalNo
ndb-log-transaction-idYesYes

GlobalNo
- Variable: ndb_log_transaction_id

Yes
GlobalNo
ndb_log_transaction_id

Yes
GlobalNo
ndb-log-update-as-writeYesYesYes
GlobalYes
ndb_log_updated_onlyYesYesYes
GlobalYes
ndb-mgmd-hostYesYes



ndb-nodeidYesYes
YesGlobalNo
Ndb_number_of_data_nodes


YesGlobalNo
ndb_optimization_delay

Yes
GlobalYes
ndb_optimized_node_selectionYesYesYes
GlobalNo
Ndb_pruned_scan_count


YesGlobalNo
Ndb_pushed_queries_defined


YesGlobalNo
Ndb_pushed_queries_dropped


YesGlobalNo
Ndb_pushed_queries_executed


YesGlobalNo
Ndb_pushed_reads


YesGlobalNo
ndb-recv-thread-activation-thresholdYesYes



- Variable: ndb_recv_thread_activation_threshold





ndb_recv_thread_activation_threshold





ndb-recv-thread-cpu-maskYesYes



- Variable: ndb_recv_thread_cpu_mask





ndb_recv_thread_cpu_mask

Yes
GlobalYes
ndb_report_thresh_binlog_epoch_slipYesYes



ndb_report_thresh_binlog_mem_usageYesYes



Ndb_scan_count


YesGlobalNo
ndb_show_foreign_key_mock_tablesYesYesYes
GlobalYes
ndb_slave_conflict_roleYesYesYes
GlobalYes
Ndb_slave_max_replicated_epoch

Yes
GlobalNo
ndb_table_no_logging

Yes
SessionYes
ndb_table_temporary

Yes
SessionYes
ndb-transid-mysql-connection-mapYes




ndb_use_copying_alter_table

Yes
BothNo
ndb_use_exact_count

Yes
BothYes
ndb_use_transactionsYesYesYes
BothYes
ndb_version

Yes
GlobalNo
ndb_version_string

Yes
GlobalNo
ndb-wait-connectedYesYesYes
GlobalNo
ndb-wait-setupYesYesYes
GlobalNo
ndbclusterYesYes



- Variable: have_ndbcluster





ndbinfo_database

Yes
GlobalNo
ndbinfo_max_bytesYes
Yes
BothYes
ndbinfo_max_rowsYes
Yes
BothYes
ndbinfo_offline

Yes
GlobalYes
ndbinfo_show_hiddenYes
Yes
BothYes
ndbinfo_table_prefixYes
Yes
BothYes
ndbinfo_version

Yes
GlobalNo
net_buffer_lengthYesYesYes
BothYes
net_read_timeoutYesYesYes
BothYes
net_retry_countYesYesYes
BothYes
net_write_timeoutYesYesYes
BothYes
newYesYesYes
BothYes
no-defaultsYes




Not_flushed_delayed_rows


YesGlobalNo
oldYesYesYes
GlobalNo
old-alter-tableYesYes

BothYes
- Variable: old_alter_table

Yes
BothYes
old_passwords

Yes
BothYes
old-style-user-limitsYesYes



one-threadYesYes



Open_files


YesGlobalNo
open-files-limitYesYes

GlobalNo
- Variable: open_files_limit

Yes
GlobalNo
Open_streams


YesGlobalNo
Open_table_definitions


YesGlobalNo
Open_tables


YesBothNo
Opened_files


YesGlobalNo
Opened_table_definitions


YesBothNo
Opened_tables


YesBothNo
optimizer_join_cache_levelYesYesYes
BothYes
optimizer_prune_levelYesYesYes
BothYes
optimizer_search_depthYesYesYes
BothYes
optimizer_switchYesYesYes
BothYes
optimizer_trace

Yes
BothYes
optimizer_trace_features

Yes
BothYes
optimizer_trace_limit

Yes
BothYes
optimizer_trace_max_mem_size

Yes
BothYes
optimizer_trace_offset

Yes
BothYes
partitionYesYes



- Variable: have_partitioning





performance_schemaYesYesYes
GlobalNo
Performance_schema_accounts_lost


YesGlobalNo
performance_schema_accounts_sizeYesYesYes
GlobalNo
Performance_schema_cond_classes_lost


YesGlobalNo
Performance_schema_cond_instances_lost


YesGlobalNo
performance-schema-consumer-events-stages-currentYesYes



performance-schema-consumer-events-stages-historyYesYes



performance-schema-consumer-events-stages-history-longYesYes



performance-schema-consumer-events-statements-currentYesYes



performance-schema-consumer-events-statements-historyYesYes



performance-schema-consumer-events-statements-history-longYesYes



performance-schema-consumer-events-waits-currentYesYes



performance-schema-consumer-events-waits-historyYesYes



performance-schema-consumer-events-waits-history-longYesYes



performance-schema-consumer-global-instrumentationYesYes



performance-schema-consumer-statements-digestYesYes



performance-schema-consumer-thread-instrumentationYesYes



Performance_schema_digest_lost


YesGlobalNo
performance_schema_digests_sizeYesYesYes
GlobalNo
performance_schema_events_stages_history_long_sizeYesYesYes
GlobalNo
performance_schema_events_stages_history_sizeYesYesYes
GlobalNo
performance_schema_events_statements_history_long_sizeYesYesYes
GlobalNo
performance_schema_events_statements_history_sizeYesYesYes
GlobalNo
performance_schema_events_waits_history_long_sizeYesYesYes
GlobalNo
performance_schema_events_waits_history_sizeYesYesYes
GlobalNo
Performance_schema_file_classes_lost


YesGlobalNo
Performance_schema_file_handles_lost


YesGlobalNo
Performance_schema_file_instances_lost


YesGlobalNo
Performance_schema_hosts_lost


YesGlobalNo
performance_schema_hosts_sizeYesYesYes
GlobalNo
performance-schema-instrumentYesYes



Performance_schema_locker_lost


YesGlobalNo
performance_schema_max_cond_classesYesYesYes
GlobalNo
performance_schema_max_cond_instancesYesYesYes
GlobalNo
performance_schema_max_digest_lengthYesYesYes
GlobalNo
performance_schema_max_file_classesYesYesYes
GlobalNo
performance_schema_max_file_handlesYesYesYes
GlobalNo
performance_schema_max_file_instancesYesYesYes
GlobalNo
performance_schema_max_mutex_classesYesYesYes
GlobalNo
performance_schema_max_mutex_instancesYesYesYes
GlobalNo
performance_schema_max_rwlock_classesYesYesYes
GlobalNo
performance_schema_max_rwlock_instancesYesYesYes
GlobalNo
performance_schema_max_socket_classesYesYesYes
GlobalNo
performance_schema_max_socket_instancesYesYesYes
GlobalNo
performance_schema_max_stage_classesYesYesYes
GlobalNo
performance_schema_max_statement_classesYesYesYes
GlobalNo
performance_schema_max_table_handlesYesYesYes
GlobalNo
performance_schema_max_table_instancesYesYesYes
GlobalNo
performance_schema_max_thread_classesYesYesYes
GlobalNo
performance_schema_max_thread_instancesYesYesYes
GlobalNo
Performance_schema_mutex_classes_lost


YesGlobalNo
Performance_schema_mutex_instances_lost


YesGlobalNo
Performance_schema_rwlock_classes_lost


YesGlobalNo
Performance_schema_rwlock_instances_lost


YesGlobalNo
Performance_schema_session_connect_attrs_lost


YesGlobalNo
performance_schema_session_connect_attrs_sizeYesYesYes
GlobalNo
performance_schema_setup_actors_sizeYesYesYes
GlobalNo
performance_schema_setup_objects_sizeYesYesYes
GlobalNo
Performance_schema_socket_classes_lost


YesGlobalNo
Performance_schema_socket_instances_lost


YesGlobalNo
Performance_schema_stage_classes_lost


YesGlobalNo
Performance_schema_statement_classes_lost


YesGlobalNo
Performance_schema_table_handles_lost


YesGlobalNo
Performance_schema_table_instances_lost


YesGlobalNo
Performance_schema_thread_classes_lost


YesGlobalNo
Performance_schema_thread_instances_lost


YesGlobalNo
Performance_schema_users_lost


YesGlobalNo
performance_schema_users_sizeYesYesYes
GlobalNo
pid-fileYesYes

GlobalNo
- Variable: pid_file

Yes
GlobalNo
pluginYesYes



plugin_dirYesYesYes
GlobalNo
plugin-loadYesYes



plugin-load-addYesYes



portYesYesYes
GlobalNo
port-open-timeoutYesYes



preload_buffer_sizeYesYesYes
BothYes
Prepared_stmt_count


YesGlobalNo
print-defaultsYes




profiling

Yes
BothYes
profiling_history_sizeYesYesYes
BothYes
protocol_version

Yes
GlobalNo
proxy_user

Yes
SessionNo
pseudo_slave_mode

Yes
SessionYes
pseudo_thread_id

Yes
SessionYes
Qcache_free_blocks


YesGlobalNo
Qcache_free_memory


YesGlobalNo
Qcache_hits


YesGlobalNo
Qcache_inserts


YesGlobalNo
Qcache_lowmem_prunes


YesGlobalNo
Qcache_not_cached


YesGlobalNo
Qcache_queries_in_cache


YesGlobalNo
Qcache_total_blocks


YesGlobalNo
Queries


YesBothNo
query_alloc_block_sizeYesYesYes
BothYes
query_cache_limitYesYesYes
GlobalYes
query_cache_min_res_unitYesYesYes
GlobalYes
query_cache_sizeYesYesYes
GlobalYes
query_cache_typeYesYesYes
BothYes
query_cache_wlock_invalidateYesYesYes
BothYes
query_prealloc_sizeYesYesYes
BothYes
Questions


YesBothNo
rand_seed1

Yes
SessionYes
rand_seed2

Yes
SessionYes
range_alloc_block_sizeYesYesYes
BothYes
read_buffer_sizeYesYesYes
BothYes
read_onlyYesYesYes
GlobalYes
read_rnd_buffer_sizeYesYesYes
BothYes
relay-logYesYes

GlobalNo
- Variable: relay_log

Yes
GlobalNo
relay_log_basename

Yes
GlobalNo
relay-log-indexYesYes

GlobalNo
- Variable: relay_log_index

Yes
GlobalNo
relay_log_indexYesYesYes
GlobalNo
relay-log-info-fileYesYes



- Variable: relay_log_info_file





relay_log_info_fileYesYesYes
GlobalNo
relay-log-info-repositoryYesYes



- Variable: relay_log_info_repository





relay_log_info_repository

Yes
GlobalYes
relay_log_purgeYesYesYes
GlobalYes
relay-log-recoveryYesYes



- Variable: relay_log_recovery





relay_log_recoveryYesYesYes
GlobalVaries
relay_log_space_limitYesYesYes
GlobalNo
removeYes




replicate-do-dbYesYes



replicate-do-tableYesYes



replicate-ignore-dbYesYes



replicate-ignore-tableYesYes



replicate-rewrite-dbYesYes



replicate-same-server-idYesYes



replicate-wild-do-tableYesYes



replicate-wild-ignore-tableYesYes



report-hostYesYes

GlobalNo
- Variable: report_host

Yes
GlobalNo
report-passwordYesYes

GlobalNo
- Variable: report_password

Yes
GlobalNo
report-portYesYes

GlobalNo
- Variable: report_port

Yes
GlobalNo
report-userYesYes

GlobalNo
- Variable: report_user

Yes
GlobalNo
Rpl_semi_sync_master_clients


YesGlobalNo
rpl_semi_sync_master_enabled

Yes
GlobalYes
Rpl_semi_sync_master_net_avg_wait_time


YesGlobalNo
Rpl_semi_sync_master_net_wait_time


YesGlobalNo
Rpl_semi_sync_master_net_waits


YesGlobalNo
Rpl_semi_sync_master_no_times


YesGlobalNo
Rpl_semi_sync_master_no_tx


YesGlobalNo
Rpl_semi_sync_master_status


YesGlobalNo
Rpl_semi_sync_master_timefunc_failures


YesGlobalNo
rpl_semi_sync_master_timeout

Yes
GlobalYes
rpl_semi_sync_master_trace_level

Yes
GlobalYes
Rpl_semi_sync_master_tx_avg_wait_time


YesGlobalNo
Rpl_semi_sync_master_tx_wait_time


YesGlobalNo
Rpl_semi_sync_master_tx_waits


YesGlobalNo
rpl_semi_sync_master_wait_no_slave

Yes
GlobalYes
Rpl_semi_sync_master_wait_pos_backtraverse


YesGlobalNo
Rpl_semi_sync_master_wait_sessions


YesGlobalNo
Rpl_semi_sync_master_yes_tx


YesGlobalNo
rpl_semi_sync_slave_enabled

Yes
GlobalYes
Rpl_semi_sync_slave_status


YesGlobalNo
rpl_semi_sync_slave_trace_level

Yes
GlobalYes
rpl_stop_slave_timeoutYesYesYes
GlobalYes
Rsa_public_key


YesGlobalNo
safe-modeYesYes



safe-user-createYesYes



secure-authYesYes

GlobalYes
- Variable: secure_auth

Yes
GlobalYes
secure-file-privYesYes

GlobalNo
- Variable: secure_file_priv

Yes
GlobalNo
Select_full_join


YesBothNo
Select_full_range_join


YesBothNo
Select_range


YesBothNo
Select_range_check


YesBothNo
Select_scan


YesBothNo
server-idYesYes

GlobalYes
- Variable: server_id

Yes
GlobalYes
server-id-bitsYesYes

GlobalNo
- Variable: server_id_bits

Yes
GlobalNo
server_id_bitsYesYesYes
GlobalNo
server_uuid

Yes
GlobalNo
sha256_password_private_key_path

Yes
GlobalNo
sha256_password_public_key_path

Yes
GlobalNo
shared_memoryYesYesYes
GlobalNo
shared_memory_base_nameYesYesYes
GlobalNo
show_old_temporalsYesYesYes
BothYes
show-slave-auth-infoYesYes



simplified_binlog_gtid_recoveryYesYesYes
GlobalNo
skip-character-set-client-handshakeYesYes



skip-concurrent-insertYesYes



- Variable: concurrent_insert





skip-event-schedulerYesYes



skip_external_lockingYesYesYes
GlobalNo
skip-grant-tablesYesYes



skip-host-cacheYesYes



skip-name-resolveYesYes

GlobalNo
- Variable: skip_name_resolve

Yes
GlobalNo
skip-ndbclusterYesYes



skip-networkingYesYes

GlobalNo
- Variable: skip_networking

Yes
GlobalNo
skip-newYesYes



skip-partitionYesYes



skip-show-databaseYesYes

GlobalNo
- Variable: skip_show_database

Yes
GlobalNo
skip-slave-startYesYes



skip-sslYesYes



skip-stack-traceYesYes



skip-symbolic-linksYes




skip-thread-priorityYesYes



slave_allow_batchingYesYesYes
GlobalYes
slave-checkpoint-groupYesYes



- Variable: slave_checkpoint_group





slave_checkpoint_groupYesYesYes
GlobalYes
slave-checkpoint-periodYesYes



- Variable: slave_checkpoint_period





slave_checkpoint_periodYesYesYes
GlobalYes
slave_compressed_protocolYesYesYes
GlobalYes
slave_exec_modeYesYesYes
GlobalYes
Slave_heartbeat_period


YesGlobalNo
Slave_last_heartbeat


YesGlobalNo
slave-load-tmpdirYesYes

GlobalNo
- Variable: slave_load_tmpdir

Yes
GlobalNo
slave-max-allowed-packetYesYes



- Variable: slave_max_allowed_packet





slave_max_allowed_packet

Yes
GlobalYes
slave-net-timeoutYesYes

GlobalYes
- Variable: slave_net_timeout

Yes
GlobalYes
Slave_open_temp_tables


YesGlobalNo
slave-parallel-workersYesYes



- Variable: slave_parallel_workers





slave_parallel_workersYes
Yes
GlobalYes
slave-pending-jobs-size-maxYes




- Variable: slave_pending_jobs_size_max





slave_pending_jobs_size_max

Yes
GlobalYes
Slave_received_heartbeats


YesGlobalNo
Slave_retried_transactions


YesGlobalNo
slave-rows-search-algorithmsYesYes



- Variable: slave_rows_search_algorithms





slave_rows_search_algorithms

Yes
GlobalYes
Slave_running


YesGlobalNo
slave-skip-errorsYesYes

GlobalNo
- Variable: slave_skip_errors

Yes
GlobalNo
slave-sql-verify-checksumYesYes



slave_sql_verify_checksum

Yes
GlobalYes
slave_transaction_retriesYesYesYes
GlobalYes
slave_type_conversionsYesYesYes
GlobalNo
Slow_launch_threads


YesBothNo
slow_launch_timeYesYesYes
GlobalYes
Slow_queries


YesBothNo
slow-query-logYesYes

GlobalYes
- Variable: slow_query_log

Yes
GlobalYes
slow_query_log_fileYesYesYes
GlobalYes
slow-start-timeoutYesYes



socketYesYesYes
GlobalNo
sort_buffer_sizeYesYesYes
BothYes
Sort_merge_passes


YesBothNo
Sort_range


YesBothNo
Sort_rows


YesBothNo
Sort_scan


YesBothNo
sporadic-binlog-dump-failYesYes



sql_auto_is_null

Yes
BothYes
sql_big_selects

Yes
BothYes
sql_big_tables

Yes
BothYes
sql_buffer_result

Yes
BothYes
sql_log_bin

Yes
SessionYes
sql_log_off

Yes
BothYes
sql_low_priority_updates

Yes
BothYes
sql_max_join_size

Yes
BothYes
sql-modeYesYes

BothYes
- Variable: sql_mode

Yes
BothYes
sql_notes

Yes
BothYes
sql_quote_show_create

Yes
BothYes
sql_safe_updates

Yes
BothYes
sql_select_limit

Yes
BothYes
sql_slave_skip_counter

Yes
GlobalYes
sql_warnings

Yes
BothYes
sslYesYes



Ssl_accept_renegotiates


YesGlobalNo
Ssl_accepts


YesGlobalNo
ssl-caYesYes

GlobalNo
- Variable: ssl_ca

Yes
GlobalNo
Ssl_callback_cache_hits


YesGlobalNo
ssl-capathYesYes

GlobalNo
- Variable: ssl_capath

Yes
GlobalNo
ssl-certYesYes

GlobalNo
- Variable: ssl_cert

Yes
GlobalNo
Ssl_cipher


YesBothNo
ssl-cipherYesYes

GlobalNo
- Variable: ssl_cipher

Yes
GlobalNo
Ssl_cipher_list


YesBothNo
Ssl_client_connects


YesGlobalNo
Ssl_connect_renegotiates


YesGlobalNo
ssl-crlYesYes

GlobalNo
- Variable: ssl_crl

Yes
GlobalNo
ssl-crlpathYesYes

GlobalNo
- Variable: ssl_crlpath

Yes
GlobalNo
Ssl_ctx_verify_depth


YesGlobalNo
Ssl_ctx_verify_mode


YesGlobalNo
Ssl_default_timeout


YesBothNo
Ssl_finished_accepts


YesGlobalNo
Ssl_finished_connects


YesGlobalNo
ssl-keyYesYes

GlobalNo
- Variable: ssl_key

Yes
GlobalNo
Ssl_server_not_after


YesBothNo
Ssl_server_not_before


YesBothNo
Ssl_session_cache_hits


YesGlobalNo
Ssl_session_cache_misses


YesGlobalNo
Ssl_session_cache_mode


YesGlobalNo
Ssl_session_cache_overflows


YesGlobalNo
Ssl_session_cache_size


YesGlobalNo
Ssl_session_cache_timeouts


YesGlobalNo
Ssl_sessions_reused


YesBothNo
Ssl_used_session_cache_entries


YesGlobalNo
Ssl_verify_depth


YesBothNo
Ssl_verify_mode


YesBothNo
Ssl_version


YesBothNo
standaloneYesYes



storage_engine

Yes
BothYes
stored_program_cacheYesYesYes
GlobalYes
super-large-pagesYesYes



symbolic-linksYesYes



sync_binlogYesYesYes
GlobalYes
sync_frmYesYesYes
GlobalYes
sync_master_infoYesYesYes
GlobalYes
sync_relay_logYesYesYes
GlobalYes
sync_relay_log_infoYesYesYes
GlobalYes
sysdate-is-nowYesYes



system_time_zone

Yes
GlobalNo
table_definition_cache

Yes
GlobalYes
Table_locks_immediate


YesGlobalNo
Table_locks_waited


YesGlobalNo
table_open_cache

Yes
GlobalYes
Table_open_cache_hits


YesBothNo
table_open_cache_instances

Yes
GlobalNo
Table_open_cache_misses


YesBothNo
Table_open_cache_overflows


YesBothNo
tc-heuristic-recoverYesYes



Tc_log_max_pages_used


YesGlobalNo
Tc_log_page_size


YesGlobalNo
Tc_log_page_waits


YesGlobalNo
temp-poolYesYes



thread_cache_sizeYesYesYes
GlobalYes
thread_concurrencyYesYesYes
GlobalNo
thread_handlingYesYesYes
GlobalNo
thread_pool_algorithmYesYesYes
GlobalNo
thread_pool_high_priority_connectionYesYesYes
BothYes
thread_pool_max_unused_threadsYesYesYes
GlobalYes
thread_pool_prio_kickup_timerYesYesYes
BothYes
thread_pool_sizeYesYesYes
GlobalNo
thread_pool_stall_limitYesYesYes
GlobalYes
thread_stackYesYesYes
GlobalNo
Threads_cached


YesGlobalNo
Threads_connected


YesGlobalNo
Threads_created


YesGlobalNo
Threads_running


YesGlobalNo
time_format

Yes
GlobalNo
time_zone

Yes
BothYes
timed_mutexesYesYesYes
GlobalYes
timestamp

Yes
SessionYes
tmp_table_sizeYesYesYes
BothYes
tmpdirYesYesYes
GlobalNo
transaction_alloc_block_sizeYesYesYes
BothYes
transaction_allow_batching

Yes
SessionYes
transaction-isolationYesYes



- Variable: tx_isolation





transaction_prealloc_sizeYesYesYes
BothYes
transaction-read-onlyYesYes



- Variable: tx_read_only





tx_isolation

Yes
BothYes
tx_read_only

Yes
BothYes
unique_checks

Yes
BothYes
updatable_views_with_limitYesYesYes
BothYes
Uptime


YesGlobalNo
Uptime_since_flush_status


YesGlobalNo
userYesYes



validate-passwordYesYes



validate_password_dictionary_file

Yes
GlobalVaries
validate_password_dictionary_file_last_parsed


YesGlobalNo
validate_password_dictionary_file_words_count


YesGlobalNo
validate_password_length

Yes
GlobalYes
validate_password_mixed_case_count

Yes
GlobalYes
validate_password_number_count

Yes
GlobalYes
validate_password_policy

Yes
GlobalYes
validate_password_special_char_count

Yes
GlobalYes
validate_user_plugins

Yes
GlobalNo
verboseYesYes



version

Yes
GlobalNo
version_comment

Yes
GlobalNo
version_compile_machine

Yes
GlobalNo
version_compile_os

Yes
GlobalNo
wait_timeoutYesYesYes
BothYes
warning_count

Yes
SessionNo

[a] 이 옵션은 동적이며, 서버 만이 정보를 설정하도록하십시오. 이 변수의 값은 수동으로 설정하지 마십시오.

[b] 이 옵션은 동적이며, 서버 만이 정보를 설정하도록하십시오. 이 변수의 값은 수동으로 설정하지 마십시오.



서울시 강남구 영동대로 602 6층
TEL: 02-6061-0006  /  E: csr@mysqlkorea.com
주식회사 이노클러스터  등록번호 : 727-86-02261
Copyright © innocluster Co. ltd. all rights reserved