Server configuration |
Environment variable |
PDS default value |
activate_all_roles_on_login
|
ACTIVATE_ALL_ROLES_ON_LOGIN
|
|
autocommit
|
AUTOCOMMIT
|
|
automatic_sp_privileges
|
AUTOMATIC_SP_PRIVILEGES
|
|
avoid_temporal_upgrade
|
AVOID_TEMPORAL_UPGRADE
|
|
back_log
|
BACK_LOG
|
|
big_tables
|
BIG_TABLES
|
|
block_encryption_mode
|
BLOCK_ENCRYPTION_MODE
|
|
build_id
|
BUILD_ID
|
|
bulk_insert_buffer_size
|
BULK_INSERT_BUFFER_SIZE
|
|
character_set_client
|
CHARACTER_SET_CLIENT
|
|
character_set_connection
|
CHARACTER_SET_CONNECTION
|
|
character_set_database
|
CHARACTER_SET_DATABASE
|
|
character_set_filesystem
|
CHARACTER_SET_FILESYSTEM
|
|
character_set_results
|
CHARACTER_SET_RESULTS
|
|
character_set_server
|
CHARACTER_SET_SERVER
|
|
character_set_system
|
CHARACTER_SET_SYSTEM
|
|
check_proxy_users
|
CHECK_PROXY_USERS
|
|
collation_connection
|
COLLATION_CONNECTION
|
|
collation_database
|
COLLATION_DATABASE
|
|
collation_server
|
COLLATION_SERVER
|
|
completion_type
|
COMPLETION_TYPE
|
|
concurrent_insert
|
CONCURRENT_INSERT
|
|
connection_memory_chunk_size
|
CONNECTION_MEMORY_CHUNK_SIZE
|
|
connection_memory_limit
|
CONNECTION_MEMORY_LIMIT
|
|
connect_timeout
|
CONNECT_TIMEOUT
|
|
core_file
|
CORE_FILE
|
|
create_admin_listener_thread
|
CREATE_ADMIN_LISTENER_THREAD
|
|
cte_max_recursion_depth
|
CTE_MAX_RECURSION_DEPTH
|
|
daemon_memcached_enable_binlog
|
DAEMON_MEMCACHED_ENABLE_BINLOG
|
|
daemon_memcached_engine_lib_name
|
DAEMON_MEMCACHED_ENGINE_LIB_NAME
|
|
daemon_memcached_option
|
DAEMON_MEMCACHED_OPTION
|
|
daemon_memcached_r_batch_size
|
DAEMON_MEMCACHED_R_BATCH_SIZE
|
|
daemon_memcached_w_batch_size
|
DAEMON_MEMCACHED_W_BATCH_SIZE
|
|
debug
|
DEBUG
|
|
debug_sync
|
DEBUG_SYNC
|
|
default_authentication_plugin
|
DEFAULT_AUTHENTICATION_PLUGIN
|
|
default_collation_for_utf8mb4
|
DEFAULT_COLLATION_FOR_UTF8MB4
|
|
default_password_lifetime
|
DEFAULT_PASSWORD_LIFETIME
|
|
default_storage_engine
|
DEFAULT_STORAGE_ENGINE
|
|
default_table_encryption
|
DEFAULT_TABLE_ENCRYPTION
|
|
default_tmp_storage_engine
|
DEFAULT_TMP_STORAGE_ENGINE
|
|
default_week_format
|
DEFAULT_WEEK_FORMAT
|
|
delayed_insert_limit
|
DELAYED_INSERT_LIMIT
|
|
delayed_insert_timeout
|
DELAYED_INSERT_TIMEOUT
|
|
delayed_queue_size
|
DELAYED_QUEUE_SIZE
|
|
delay_key_write
|
DELAY_KEY_WRITE
|
|
disabled_storage_engines
|
DISABLED_STORAGE_ENGINES
|
|
disconnect_on_expired_password
|
DISCONNECT_ON_EXPIRED_PASSWORD
|
|
div_precision_increment
|
DIV_PRECISION_INCREMENT
|
|
dragnet.log_error_filter_rules
|
DRAGNET_LOG_ERROR_FILTER_RULES
|
|
end_markers_in_json
|
END_MARKERS_IN_JSON
|
|
eq_range_index_dive_limit
|
EQ_RANGE_INDEX_DIVE_LIMIT
|
|
error_count
|
ERROR_COUNT
|
|
event_scheduler
|
EVENT_SCHEDULER
|
|
explicit_defaults_for_timestamp
|
EXPLICIT_DEFAULTS_FOR_TIMESTAMP
|
|
external_user
|
EXTERNAL_USER
|
|
flush
|
FLUSH
|
|
flush_time
|
FLUSH_TIME
|
|
foreign_key_checks
|
FOREIGN_KEY_CHECKS
|
|
ft_boolean_syntax
|
FT_BOOLEAN_SYNTAX
|
|
ft_max_word_len
|
FT_MAX_WORD_LEN
|
|
ft_min_word_len
|
FT_MIN_WORD_LEN
|
|
ft_query_expansion_limit
|
FT_QUERY_EXPANSION_LIMIT
|
|
ft_stopword_file
|
FT_STOPWORD_FILE
|
|
general_log
|
GENERAL_LOG
|
|
general_log_file
|
GENERAL_LOG_FILE
|
|
generated_random_password_length
|
GENERATED_RANDOM_PASSWORD_LENGTH
|
|
global_connection_memory_limit
|
GLOBAL_CONNECTION_MEMORY_LIMIT
|
|
global_connection_memory_tracking
|
GLOBAL_CONNECTION_MEMORY_TRACKING
|
|
group_concat_max_len
|
GROUP_CONCAT_MAX_LEN
|
|
have_compress
|
HAVE_COMPRESS
|
|
have_dynamic_loading
|
HAVE_DYNAMIC_LOADING
|
|
have_geometry
|
HAVE_GEOMETRY
|
|
have_openssl
|
HAVE_OPENSSL
|
|
have_profiling
|
HAVE_PROFILING
|
|
have_query_cache
|
HAVE_QUERY_CACHE
|
|
have_rtree_keys
|
HAVE_RTREE_KEYS
|
|
have_ssl
|
HAVE_SSL
|
|
have_statement_timeout
|
HAVE_STATEMENT_TIMEOUT
|
|
have_symlink
|
HAVE_SYMLINK
|
|
histogram_generation_max_mem_size
|
HISTOGRAM_GENERATION_MAX_MEM_SIZE
|
|
host_cache_size
|
HOST_CACHE_SIZE
|
|
identity
|
IDENTITY
|
|
information_schema_stats_expiry
|
INFORMATION_SCHEMA_STATS_EXPIRY
|
|
init_connect
|
INIT_CONNECT
|
|
init_file
|
INIT_FILE
|
|
innodb_adaptive_flushing
|
INNODB_ADAPTIVE_FLUSHING
|
|
innodb_adaptive_flushing_lwm
|
INNODB_ADAPTIVE_FLUSHING_LWM
|
|
innodb_adaptive_hash_index
|
INNODB_ADAPTIVE_HASH_INDEX
|
|
innodb_adaptive_hash_index_parts
|
INNODB_ADAPTIVE_HASH_INDEX_PARTS
|
|
innodb_adaptive_max_sleep_delay
|
INNODB_ADAPTIVE_MAX_SLEEP_DELAY
|
|
innodb_api_bk_commit_interval
|
INNODB_API_BK_COMMIT_INTERVAL
|
|
innodb_api_disable_rowlock
|
INNODB_API_DISABLE_ROWLOCK
|
|
innodb_api_enable_binlog
|
INNODB_API_ENABLE_BINLOG
|
|
innodb_api_enable_mdl
|
INNODB_API_ENABLE_MDL
|
|
innodb_api_trx_level
|
INNODB_API_TRX_LEVEL
|
|
innodb_autoextend_increment
|
INNODB_AUTOEXTEND_INCREMENT
|
|
innodb_autoinc_lock_mode
|
INNODB_AUTOINC_LOCK_MODE
|
|
innodb_background_drop_list_empty
|
INNODB_BACKGROUND_DROP_LIST_EMPTY
|
|
innodb_buffer_pool_chunk_size
|
INNODB_BUFFER_POOL_CHUNK_SIZE
|
|
innodb_buffer_pool_debug
|
INNODB_BUFFER_POOL_DEBUG
|
|
innodb_buffer_pool_dump_at_shutdown
|
INNODB_BUFFER_POOL_DUMP_AT_SHUTDOWN
|
|
innodb_buffer_pool_dump_now
|
INNODB_BUFFER_POOL_DUMP_NOW
|
|
innodb_buffer_pool_dump_pct
|
INNODB_BUFFER_POOL_DUMP_PCT
|
|
innodb_buffer_pool_filename
|
INNODB_BUFFER_POOL_FILENAME
|
|
innodb_buffer_pool_in_core_file
|
INNODB_BUFFER_POOL_IN_CORE_FILE
|
|
innodb_buffer_pool_instances
|
INNODB_BUFFER_POOL_INSTANCES
|
|
innodb_buffer_pool_load_abort
|
INNODB_BUFFER_POOL_LOAD_ABORT
|
|
innodb_buffer_pool_load_at_startup
|
INNODB_BUFFER_POOL_LOAD_AT_STARTUP
|
|
innodb_buffer_pool_load_now
|
INNODB_BUFFER_POOL_LOAD_NOW
|
|
innodb_buffer_pool_size
|
INNODB_BUFFER_POOL_SIZE
|
|
innodb_change_buffering
|
INNODB_CHANGE_BUFFERING
|
|
innodb_change_buffering_debug
|
INNODB_CHANGE_BUFFERING_DEBUG
|
|
innodb_change_buffer_max_size
|
INNODB_CHANGE_BUFFER_MAX_SIZE
|
|
innodb_checkpoint_disabled
|
INNODB_CHECKPOINT_DISABLED
|
|
innodb_checksum_algorithm
|
INNODB_CHECKSUM_ALGORITHM
|
|
innodb_cmp_per_index_enabled
|
INNODB_CMP_PER_INDEX_ENABLED
|
|
innodb_commit_concurrency
|
INNODB_COMMIT_CONCURRENCY
|
|
innodb_compress_debug
|
INNODB_COMPRESS_DEBUG
|
|
innodb_compression_failure_threshold_pct
|
INNODB_COMPRESSION_FAILURE_THRESHOLD_PCT
|
|
innodb_compression_level
|
INNODB_COMPRESSION_LEVEL
|
|
innodb_compression_pad_pct_max
|
INNODB_COMPRESSION_PAD_PCT_MAX
|
|
innodb_concurrency_tickets
|
INNODB_CONCURRENCY_TICKETS
|
|
innodb_ddl_buffer_size
|
INNODB_DDL_BUFFER_SIZE
|
|
innodb_ddl_log_crash_reset_debug
|
INNODB_DDL_LOG_CRASH_RESET_DEBUG
|
|
innodb_ddl_threads
|
INNODB_DDL_THREADS
|
|
innodb_deadlock_detect
|
INNODB_DEADLOCK_DETECT
|
|
innodb_dedicated_server
|
INNODB_DEDICATED_SERVER
|
|
innodb_default_row_format
|
INNODB_DEFAULT_ROW_FORMAT
|
|
innodb_disable_sort_file_cache
|
INNODB_DISABLE_SORT_FILE_CACHE
|
|
innodb_doublewrite
|
INNODB_DOUBLEWRITE
|
|
innodb_doublewrite_batch_size
|
INNODB_DOUBLEWRITE_BATCH_SIZE
|
|
innodb_doublewrite_pages
|
INNODB_DOUBLEWRITE_PAGES
|
|
innodb_extend_and_initialize
|
INNODB_EXTEND_AND_INITIALIZE
|
|
innodb_fast_shutdown
|
INNODB_FAST_SHUTDOWN
|
|
innodb_file_per_table
|
INNODB_FILE_PER_TABLE
|
|
innodb_fill_factor
|
INNODB_FILL_FACTOR
|
|
innodb_fil_make_page_dirty_debug
|
INNODB_FIL_MAKE_PAGE_DIRTY_DEBUG
|
|
innodb_flushing_avg_loops
|
INNODB_FLUSHING_AVG_LOOPS
|
|
innodb_flush_log_at_timeout
|
INNODB_FLUSH_LOG_AT_TIMEOUT
|
|
innodb_flush_log_at_trx_commit
|
INNODB_FLUSH_LOG_AT_TRX_COMMIT
|
|
innodb_flush_method
|
INNODB_FLUSH_METHOD
|
|
innodb_flush_neighbors
|
INNODB_FLUSH_NEIGHBORS
|
|
innodb_flush_sync
|
INNODB_FLUSH_SYNC
|
|
innodb_force_load_corrupted
|
INNODB_FORCE_LOAD_CORRUPTED
|
|
innodb_force_recovery
|
INNODB_FORCE_RECOVERY
|
|
innodb_fsync_threshold
|
INNODB_FSYNC_THRESHOLD
|
|
innodb_ft_aux_table
|
INNODB_FT_AUX_TABLE
|
|
innodb_ft_cache_size
|
INNODB_FT_CACHE_SIZE
|
|
innodb_ft_enable_diag_print
|
INNODB_FT_ENABLE_DIAG_PRINT
|
|
innodb_ft_enable_stopword
|
INNODB_FT_ENABLE_STOPWORD
|
|
innodb_ft_max_token_size
|
INNODB_FT_MAX_TOKEN_SIZE
|
|
innodb_ft_min_token_size
|
INNODB_FT_MIN_TOKEN_SIZE
|
|
innodb_ft_num_word_optimize
|
INNODB_FT_NUM_WORD_OPTIMIZE
|
|
innodb_ft_result_cache_limit
|
INNODB_FT_RESULT_CACHE_LIMIT
|
|
innodb_ft_server_stopword_table
|
INNODB_FT_SERVER_STOPWORD_TABLE
|
|
innodb_ft_sort_pll_degree
|
INNODB_FT_SORT_PLL_DEGREE
|
|
innodb_ft_total_cache_size
|
INNODB_FT_TOTAL_CACHE_SIZE
|
|
innodb_ft_user_stopword_table
|
INNODB_FT_USER_STOPWORD_TABLE
|
|
innodb_idle_flush_pct
|
INNODB_IDLE_FLUSH_PCT
|
|
innodb_io_capacity
|
INNODB_IO_CAPACITY
|
|
innodb_io_capacity_max
|
INNODB_IO_CAPACITY_MAX
|
|
innodb_limit_optimistic_insert_debug
|
INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG
|
|
innodb_lock_wait_timeout
|
INNODB_LOCK_WAIT_TIMEOUT
|
|
innodb_log_buffer_size
|
INNODB_LOG_BUFFER_SIZE
|
|
innodb_log_checkpoint_fuzzy_now
|
INNODB_LOG_CHECKPOINT_FUZZY_NOW
|
|
innodb_log_checkpoint_now
|
INNODB_LOG_CHECKPOINT_NOW
|
|
innodb_log_checksums
|
INNODB_LOG_CHECKSUMS
|
|
innodb_log_compressed_pages
|
INNODB_LOG_COMPRESSED_PAGES
|
|
innodb_log_files_in_group
|
INNODB_LOG_FILES_IN_GROUP
|
|
innodb_log_file_size
|
INNODB_LOG_FILE_SIZE
|
|
innodb_log_spin_cpu_abs_lwm
|
INNODB_LOG_SPIN_CPU_ABS_LWM
|
|
innodb_log_spin_cpu_pct_hwm
|
INNODB_LOG_SPIN_CPU_PCT_HWM
|
|
innodb_log_wait_for_flush_spin_hwm
|
INNODB_LOG_WAIT_FOR_FLUSH_SPIN_HWM
|
|
innodb_log_write_ahead_size
|
INNODB_LOG_WRITE_AHEAD_SIZE
|
|
innodb_log_writer_threads
|
INNODB_LOG_WRITER_THREADS
|
|
innodb_lru_scan_depth
|
INNODB_LRU_SCAN_DEPTH
|
|
innodb_max_dirty_pages_pct
|
INNODB_MAX_DIRTY_PAGES_PCT
|
|
innodb_max_dirty_pages_pct_lwm
|
INNODB_MAX_DIRTY_PAGES_PCT_LWM
|
|
innodb_max_purge_lag
|
INNODB_MAX_PURGE_LAG
|
|
innodb_max_purge_lag_delay
|
INNODB_MAX_PURGE_LAG_DELAY
|
|
innodb_max_undo_log_size
|
INNODB_MAX_UNDO_LOG_SIZE
|
|
innodb_merge_threshold_set_all_debug
|
INNODB_MERGE_THRESHOLD_SET_ALL_DEBUG
|
|
innodb_monitor_disable
|
INNODB_MONITOR_DISABLE
|
|
innodb_monitor_enable
|
INNODB_MONITOR_ENABLE
|
|
innodb_monitor_reset
|
INNODB_MONITOR_RESET
|
|
innodb_monitor_reset_all
|
INNODB_MONITOR_RESET_ALL
|
|
innodb_numa_interleave
|
INNODB_NUMA_INTERLEAVE
|
|
innodb_old_blocks_pct
|
INNODB_OLD_BLOCKS_PCT
|
|
innodb_old_blocks_time
|
INNODB_OLD_BLOCKS_TIME
|
|
innodb_online_alter_log_max_size
|
INNODB_ONLINE_ALTER_LOG_MAX_SIZE
|
|
innodb_open_files
|
INNODB_OPEN_FILES
|
|
innodb_optimize_fulltext_only
|
INNODB_OPTIMIZE_FULLTEXT_ONLY
|
|
innodb_page_cleaners
|
INNODB_PAGE_CLEANERS
|
|
innodb_page_size
|
INNODB_PAGE_SIZE
|
|
innodb_parallel_read_threads
|
INNODB_PARALLEL_READ_THREADS
|
|
innodb_print_all_deadlocks
|
INNODB_PRINT_ALL_DEADLOCKS
|
|
innodb_print_ddl_logs
|
INNODB_PRINT_DDL_LOGS
|
|
innodb_purge_batch_size
|
INNODB_PURGE_BATCH_SIZE
|
|
innodb_purge_rseg_truncate_frequency
|
INNODB_PURGE_RSEG_TRUNCATE_FREQUENCY
|
|
innodb_purge_threads
|
INNODB_PURGE_THREADS
|
|
innodb_random_read_ahead
|
INNODB_RANDOM_READ_AHEAD
|
|
innodb_read_ahead_threshold
|
INNODB_READ_AHEAD_THRESHOLD
|
|
innodb_read_io_threads
|
INNODB_READ_IO_THREADS
|
|
innodb_read_only
|
INNODB_READ_ONLY
|
|
innodb_redo_log_encrypt
|
INNODB_REDO_LOG_ENCRYPT
|
|
innodb_replication_delay
|
INNODB_REPLICATION_DELAY
|
|
innodb_rollback_on_timeout
|
INNODB_ROLLBACK_ON_TIMEOUT
|
|
innodb_rollback_segments
|
INNODB_ROLLBACK_SEGMENTS
|
|
innodb_saved_page_number_debug
|
INNODB_SAVED_PAGE_NUMBER_DEBUG
|
|
innodb_segment_reserve_factor
|
INNODB_SEGMENT_RESERVE_FACTOR
|
|
innodb_sort_buffer_size
|
INNODB_SORT_BUFFER_SIZE
|
|
innodb_spin_wait_delay
|
INNODB_SPIN_WAIT_DELAY
|
|
innodb_spin_wait_pause_multiplier
|
INNODB_SPIN_WAIT_PAUSE_MULTIPLIER
|
|
innodb_stats_auto_recalc
|
INNODB_STATS_AUTO_RECALC
|
|
innodb_stats_include_delete_marked
|
INNODB_STATS_INCLUDE_DELETE_MARKED
|
|
innodb_stats_method
|
INNODB_STATS_METHOD
|
|
innodb_stats_on_metadata
|
INNODB_STATS_ON_METADATA
|
|
innodb_stats_persistent
|
INNODB_STATS_PERSISTENT
|
|
innodb_stats_persistent_sample_pages
|
INNODB_STATS_PERSISTENT_SAMPLE_PAGES
|
|
innodb_stats_transient_sample_pages
|
INNODB_STATS_TRANSIENT_SAMPLE_PAGES
|
|
innodb_status_output
|
INNODB_STATUS_OUTPUT
|
|
innodb_status_output_locks
|
INNODB_STATUS_OUTPUT_LOCKS
|
|
innodb_strict_mode
|
INNODB_STRICT_MODE
|
|
innodb_sync_array_size
|
INNODB_SYNC_ARRAY_SIZE
|
|
innodb_sync_debug
|
INNODB_SYNC_DEBUG
|
|
innodb_sync_spin_loops
|
INNODB_SYNC_SPIN_LOOPS
|
|
innodb_table_locks
|
INNODB_TABLE_LOCKS
|
|
innodb_thread_concurrency
|
INNODB_THREAD_CONCURRENCY
|
|
innodb_thread_sleep_delay
|
INNODB_THREAD_SLEEP_DELAY
|
|
innodb_trx_purge_view_update_only_debug
|
INNODB_TRX_PURGE_VIEW_UPDATE_ONLY_DEBUG
|
|
innodb_trx_rseg_n_slots_debug
|
INNODB_TRX_RSEG_N_SLOTS_DEBUG
|
|
innodb_undo_log_encrypt
|
INNODB_UNDO_LOG_ENCRYPT
|
|
innodb_undo_log_truncate
|
INNODB_UNDO_LOG_TRUNCATE
|
|
innodb_undo_tablespaces
|
INNODB_UNDO_TABLESPACES
|
|
innodb_use_fdatasync
|
INNODB_USE_FDATASYNC
|
|
innodb_use_native_aio
|
INNODB_USE_NATIVE_AIO
|
|
innodb_validate_tablespace_paths
|
INNODB_VALIDATE_TABLESPACE_PATHS
|
|
innodb_version
|
INNODB_VERSION
|
|
innodb_write_io_threads
|
INNODB_WRITE_IO_THREADS
|
|
insert_id
|
INSERT_ID
|
|
interactive_timeout
|
INTERACTIVE_TIMEOUT
|
|
internal_tmp_disk_storage_engine
|
INTERNAL_TMP_DISK_STORAGE_ENGINE
|
|
internal_tmp_mem_storage_engine
|
INTERNAL_TMP_MEM_STORAGE_ENGINE
|
|
join_buffer_size
|
JOIN_BUFFER_SIZE
|
|
keep_files_on_create
|
KEEP_FILES_ON_CREATE
|
|
key_buffer_size
|
KEY_BUFFER_SIZE
|
|
key_cache_age_threshold
|
KEY_CACHE_AGE_THRESHOLD
|
|
key_cache_block_size
|
KEY_CACHE_BLOCK_SIZE
|
|
key_cache_division_limit
|
KEY_CACHE_DIVISION_LIMIT
|
|
large_files_support
|
LARGE_FILES_SUPPORT
|
|
large_pages
|
LARGE_PAGES
|
|
large_page_size
|
LARGE_PAGE_SIZE
|
|
last_insert_id
|
LAST_INSERT_ID
|
|
lc_messages
|
LC_MESSAGES
|
|
lc_time_names
|
LC_TIME_NAMES
|
|
license
|
LICENSE
|
|
local_infile
|
LOCAL_INFILE
|
|
locked_in_memory
|
LOCKED_IN_MEMORY
|
|
lock_wait_timeout
|
LOCK_WAIT_TIMEOUT
|
|
log_error
|
LOG_ERROR
|
|
log_error_services
|
LOG_ERROR_SERVICES
|
|
log_error_suppression_list
|
LOG_ERROR_SUPPRESSION_LIST
|
|
log_error_verbosity
|
LOG_ERROR_VERBOSITY
|
|
log_output
|
LOG_OUTPUT
|
|
log_queries_not_using_indexes
|
LOG_QUERIES_NOT_USING_INDEXES
|
|
log_raw
|
LOG_RAW
|
|
log_slow_admin_statements
|
LOG_SLOW_ADMIN_STATEMENTS
|
|
log_slow_extra
|
LOG_SLOW_EXTRA
|
|
log_syslog
|
LOG_SYSLOG
|
|
log_syslog_facility
|
LOG_SYSLOG_FACILITY
|
|
log_syslog_include_pid
|
LOG_SYSLOG_INCLUDE_PID
|
|
log_syslog_tag
|
LOG_SYSLOG_TAG
|
|
log_throttle_queries_not_using_indexes
|
LOG_THROTTLE_QUERIES_NOT_USING_INDEXES
|
|
log_timestamps
|
LOG_TIMESTAMPS
|
|
long_query_time
|
LONG_QUERY_TIME
|
|
lower_case_file_system
|
LOWER_CASE_FILE_SYSTEM
|
|
lower_case_table_names
|
LOWER_CASE_TABLE_NAMES
|
|
low_priority_updates
|
LOW_PRIORITY_UPDATES
|
|
mandatory_roles
|
MANDATORY_ROLES
|
|
max_allowed_packet
|
MAX_ALLOWED_PACKET
|
|
max_connect_errors
|
MAX_CONNECT_ERRORS
|
|
max_connections
|
MAX_CONNECTIONS
|
|
max_delayed_threads
|
MAX_DELAYED_THREADS
|
|
max_digest_length
|
MAX_DIGEST_LENGTH
|
|
max_error_count
|
MAX_ERROR_COUNT
|
|
max_execution_time
|
MAX_EXECUTION_TIME
|
|
max_heap_table_size
|
MAX_HEAP_TABLE_SIZE
|
|
max_insert_delayed_threads
|
MAX_INSERT_DELAYED_THREADS
|
|
max_join_size
|
MAX_JOIN_SIZE
|
|
max_length_for_sort_data
|
MAX_LENGTH_FOR_SORT_DATA
|
|
max_points_in_geometry
|
MAX_POINTS_IN_GEOMETRY
|
|
max_prepared_stmt_count
|
MAX_PREPARED_STMT_COUNT
|
|
max_seeks_for_key
|
MAX_SEEKS_FOR_KEY
|
|
max_sort_length
|
MAX_SORT_LENGTH
|
|
max_sp_recursion_depth
|
MAX_SP_RECURSION_DEPTH
|
|
max_user_connections
|
MAX_USER_CONNECTIONS
|
|
max_write_lock_count
|
MAX_WRITE_LOCK_COUNT
|
|
mecab_rc_file
|
MECAB_RC_FILE
|
|
metadata_locks_cache_size
|
METADATA_LOCKS_CACHE_SIZE
|
|
metadata_locks_hash_instances
|
METADATA_LOCKS_HASH_INSTANCES
|
|
min_examined_row_limit
|
MIN_EXAMINED_ROW_LIMIT
|
|
myisam_data_pointer_size
|
MYISAM_DATA_POINTER_SIZE
|
|
myisam_max_sort_file_size
|
MYISAM_MAX_SORT_FILE_SIZE
|
|
myisam_mmap_size
|
MYISAM_MMAP_SIZE
|
|
myisam_recover_options
|
MYISAM_RECOVER_OPTIONS
|
|
myisam_repair_threads
|
MYISAM_REPAIR_THREADS
|
|
myisam_sort_buffer_size
|
MYISAM_SORT_BUFFER_SIZE
|
|
myisam_stats_method
|
MYISAM_STATS_METHOD
|
|
myisam_use_mmap
|
MYISAM_USE_MMAP
|
|
mysql_native_password_proxy_users
|
MYSQL_NATIVE_PASSWORD_PROXY_USERS
|
|
named_pipe
|
NAMED_PIPE
|
|
named_pipe_full_access_group
|
NAMED_PIPE_FULL_ACCESS_GROUP
|
|
net_buffer_length
|
NET_BUFFER_LENGTH
|
|
net_read_timeout
|
NET_READ_TIMEOUT
|
|
net_retry_count
|
NET_RETRY_COUNT
|
|
net_write_timeout
|
NET_WRITE_TIMEOUT
|
|
new
|
NEW
|
|
ngram_token_size
|
NGRAM_TOKEN_SIZE
|
|
offline_mode
|
OFFLINE_MODE
|
|
old
|
OLD
|
|
old_alter_table
|
OLD_ALTER_TABLE
|
|
open_files_limit
|
OPEN_FILES_LIMIT
|
|
optimizer_prune_level
|
OPTIMIZER_PRUNE_LEVEL
|
|
optimizer_search_depth
|
OPTIMIZER_SEARCH_DEPTH
|
|
optimizer_switch
|
OPTIMIZER_SWITCH
|
|
optimizer_trace
|
OPTIMIZER_TRACE
|
|
optimizer_trace_features
|
OPTIMIZER_TRACE_FEATURES
|
|
optimizer_trace_limit
|
OPTIMIZER_TRACE_LIMIT
|
|
optimizer_trace_max_mem_size
|
OPTIMIZER_TRACE_MAX_MEM_SIZE
|
|
optimizer_trace_offset
|
OPTIMIZER_TRACE_OFFSET
|
|
parser_max_mem_size
|
PARSER_MAX_MEM_SIZE
|
|
partial_revokes
|
PARTIAL_REVOKES
|
|
password_history
|
PASSWORD_HISTORY
|
|
password_require_current
|
PASSWORD_REQUIRE_CURRENT
|
|
password_reuse_interval
|
PASSWORD_REUSE_INTERVAL
|
|
performance_schema
|
PERFORMANCE_SCHEMA
|
|
performance_schema_accounts_size
|
PERFORMANCE_SCHEMA_ACCOUNTS_SIZE
|
|
performance_schema_digests_size
|
PERFORMANCE_SCHEMA_DIGESTS_SIZE
|
|
performance_schema_error_size
|
PERFORMANCE_SCHEMA_ERROR_SIZE
|
|
performance_schema_events_stages_history_long_size
|
PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE
|
|
performance_schema_events_stages_history_size
|
PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE
|
|
performance_schema_events_statements_history_long_size
|
PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE
|
|
performance_schema_events_statements_history_size
|
PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE
|
|
performance_schema_events_transactions_history_long_size
|
PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_LONG_SIZE
|
|
performance_schema_events_transactions_history_size
|
PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_SIZE
|
|
performance_schema_events_waits_history_long_size
|
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE
|
|
performance_schema_events_waits_history_size
|
PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE
|
|
performance_schema_hosts_size
|
PERFORMANCE_SCHEMA_HOSTS_SIZE
|
|
performance_schema_max_cond_classes
|
PERFORMANCE_SCHEMA_MAX_COND_CLASSES
|
|
performance_schema_max_cond_instances
|
PERFORMANCE_SCHEMA_MAX_COND_INSTANCES
|
|
performance_schema_max_digest_length
|
PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH
|
|
performance_schema_max_digest_sample_age
|
PERFORMANCE_SCHEMA_MAX_DIGEST_SAMPLE_AGE
|
|
performance_schema_max_file_classes
|
PERFORMANCE_SCHEMA_MAX_FILE_CLASSES
|
|
performance_schema_max_file_handles
|
PERFORMANCE_SCHEMA_MAX_FILE_HANDLES
|
|
performance_schema_max_file_instances
|
PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES
|
|
performance_schema_max_index_stat
|
PERFORMANCE_SCHEMA_MAX_INDEX_STAT
|
|
performance_schema_max_memory_classes
|
PERFORMANCE_SCHEMA_MAX_MEMORY_CLASSES
|
|
performance_schema_max_metadata_locks
|
PERFORMANCE_SCHEMA_MAX_METADATA_LOCKS
|
|
performance_schema_max_mutex_classes
|
PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES
|
|
performance_schema_max_mutex_instances
|
PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES
|
|
performance_schema_max_prepared_statements_instances
|
PERFORMANCE_SCHEMA_MAX_PREPARED_STATEMENTS_INSTANCES
|
|
performance_schema_max_program_instances
|
PERFORMANCE_SCHEMA_MAX_PROGRAM_INSTANCES
|
|
performance_schema_max_rwlock_classes
|
PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES
|
|
performance_schema_max_rwlock_instances
|
PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES
|
|
performance_schema_max_socket_classes
|
PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES
|
|
performance_schema_max_socket_instances
|
PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES
|
|
performance_schema_max_sql_text_length
|
PERFORMANCE_SCHEMA_MAX_SQL_TEXT_LENGTH
|
|
performance_schema_max_stage_classes
|
PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES
|
|
performance_schema_max_statement_classes
|
PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES
|
|
performance_schema_max_statement_stack
|
PERFORMANCE_SCHEMA_MAX_STATEMENT_STACK
|
|
performance_schema_max_table_handles
|
PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES
|
|
performance_schema_max_table_instances
|
PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES
|
|
performance_schema_max_table_lock_stat
|
PERFORMANCE_SCHEMA_MAX_TABLE_LOCK_STAT
|
|
performance_schema_max_thread_classes
|
PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES
|
|
performance_schema_max_thread_instances
|
PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES
|
|
performance_schema_session_connect_attrs_size
|
PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE
|
|
performance_schema_setup_actors_size
|
PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE
|
|
performance_schema_setup_objects_size
|
PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE
|
|
performance_schema_show_processlist
|
PERFORMANCE_SCHEMA_SHOW_PROCESSLIST
|
|
performance_schema_users_size
|
PERFORMANCE_SCHEMA_USERS_SIZE
|
|
persisted_globals_load
|
PERSISTED_GLOBALS_LOAD
|
|
persist_only_admin_x509_subject
|
PERSIST_ONLY_ADMIN_X509_SUBJECT
|
|
persist_sensitive_variables_in_plaintext
|
PERSIST_SENSITIVE_VARIABLES_IN_PLAINTEXT
|
|
preload_buffer_size
|
PRELOAD_BUFFER_SIZE
|
|
print_identified_with_as_hex
|
PRINT_IDENTIFIED_WITH_AS_HEX
|
|
profiling
|
PROFILING
|
|
profiling_history_size
|
PROFILING_HISTORY_SIZE
|
|
protocol_compression_algorithms
|
PROTOCOL_COMPRESSION_ALGORITHMS
|
|
protocol_version
|
PROTOCOL_VERSION
|
|
proxy_user
|
PROXY_USER
|
|
pseudo_replica_mode
|
PSEUDO_REPLICA_MODE
|
|
pseudo_slave_mode
|
PSEUDO_SLAVE_MODE
|
|
pseudo_thread_id
|
PSEUDO_THREAD_ID
|
|
query_alloc_block_size
|
QUERY_ALLOC_BLOCK_SIZE
|
|
query_prealloc_size
|
QUERY_PREALLOC_SIZE
|
|
rand_seed1
|
RAND_SEED1
|
|
rand_seed2
|
RAND_SEED2
|
|
range_alloc_block_size
|
RANGE_ALLOC_BLOCK_SIZE
|
|
range_optimizer_max_mem_size
|
RANGE_OPTIMIZER_MAX_MEM_SIZE
|
|
rbr_exec_mode
|
RBR_EXEC_MODE
|
|
read_buffer_size
|
READ_BUFFER_SIZE
|
|
read_only
|
READ_ONLY
|
|
read_rnd_buffer_size
|
READ_RND_BUFFER_SIZE
|
|
regexp_stack_limit
|
REGEXP_STACK_LIMIT
|
|
regexp_time_limit
|
REGEXP_TIME_LIMIT
|
|
require_row_format
|
REQUIRE_ROW_FORMAT
|
|
require_secure_transport
|
REQUIRE_SECURE_TRANSPORT
|
|
resultset_metadata
|
RESULTSET_METADATA
|
|
schema_definition_cache
|
SCHEMA_DEFINITION_CACHE
|
|
secondary_engine_cost_threshold
|
SECONDARY_ENGINE_COST_THRESHOLD
|
|
secure_file_priv
|
SECURE_FILE_PRIV
|
|
select_into_buffer_size
|
SELECT_INTO_BUFFER_SIZE
|
|
select_into_disk_sync
|
SELECT_INTO_DISK_SYNC
|
|
select_into_disk_sync_delay
|
SELECT_INTO_DISK_SYNC_DELAY
|
|
session_track_gtids
|
SESSION_TRACK_GTIDS
|
|
session_track_schema
|
SESSION_TRACK_SCHEMA
|
|
session_track_state_change
|
SESSION_TRACK_STATE_CHANGE
|
|
session_track_system_variables
|
SESSION_TRACK_SYSTEM_VARIABLES
|
|
session_track_transaction_info
|
SESSION_TRACK_TRANSACTION_INFO
|
|
shared_memory
|
SHARED_MEMORY
|
|
shared_memory_base_name
|
SHARED_MEMORY_BASE_NAME
|
|
show_create_table_skip_secondary_engine
|
SHOW_CREATE_TABLE_SKIP_SECONDARY_ENGINE
|
|
show_create_table_verbosity
|
SHOW_CREATE_TABLE_VERBOSITY
|
|
show_gipk_in_create_table_and_information_schema
|
SHOW_GIPK_IN_CREATE_TABLE_AND_INFORMATION_SCHEMA
|
|
show_old_temporals
|
SHOW_OLD_TEMPORALS
|
|
skip_external_locking
|
SKIP_EXTERNAL_LOCKING
|
|
skip_name_resolve
|
SKIP_NAME_RESOLVE
|
|
skip_networking
|
SKIP_NETWORKING
|
|
skip_show_database
|
SKIP_SHOW_DATABASE
|
|
slow_launch_time
|
SLOW_LAUNCH_TIME
|
|
slow_query_log
|
SLOW_QUERY_LOG
|
|
slow_query_log_file
|
SLOW_QUERY_LOG_FILE
|
|
socket
|
SOCKET
|
|
sort_buffer_size
|
SORT_BUFFER_SIZE
|
|
sql_auto_is_null
|
SQL_AUTO_IS_NULL
|
|
sql_big_selects
|
SQL_BIG_SELECTS
|
|
sql_buffer_result
|
SQL_BUFFER_RESULT
|
|
sql_generate_invisible_primary_key
|
SQL_GENERATE_INVISIBLE_PRIMARY_KEY
|
|
sql_log_off
|
SQL_LOG_OFF
|
|
sql_mode
|
SQL_MODE
|
|
sql_notes
|
SQL_NOTES
|
|
sql_quote_show_create
|
SQL_QUOTE_SHOW_CREATE
|
|
sql_require_primary_key
|
SQL_REQUIRE_PRIMARY_KEY
|
|
sql_safe_updates
|
SQL_SAFE_UPDATES
|
|
sql_select_limit
|
SQL_SELECT_LIMIT
|
|
sql_warnings
|
SQL_WARNINGS
|
|
stored_program_cache
|
STORED_PROGRAM_CACHE
|
|
stored_program_definition_cache
|
STORED_PROGRAM_DEFINITION_CACHE
|
|
super_read_only
|
SUPER_READ_ONLY
|
|
syseventlog.facility
|
SYSEVENTLOG_FACILITY
|
|
syseventlog.include_pid
|
SYSEVENTLOG_INCLUDE_PID
|
|
syseventlog.tag
|
SYSEVENTLOG_TAG
|
|
system_time_zone
|
SYSTEM_TIME_ZONE
|
|
table_definition_cache
|
TABLE_DEFINITION_CACHE
|
|
table_encryption_privilege_check
|
TABLE_ENCRYPTION_PRIVILEGE_CHECK
|
|
table_open_cache
|
TABLE_OPEN_CACHE
|
|
table_open_cache_instances
|
TABLE_OPEN_CACHE_INSTANCES
|
|
tablespace_definition_cache
|
TABLESPACE_DEFINITION_CACHE
|
|
temptable_max_mmap
|
TEMPTABLE_MAX_MMAP
|
|
temptable_max_ram
|
TEMPTABLE_MAX_RAM
|
|
temptable_use_mmap
|
TEMPTABLE_USE_MMAP
|
|
thread_cache_size
|
THREAD_CACHE_SIZE
|
|
thread_handling
|
THREAD_HANDLING
|
|
thread_pool_algorithm
|
THREAD_POOL_ALGORITHM
|
|
thread_pool_high_priority_connection
|
THREAD_POOL_HIGH_PRIORITY_CONNECTION
|
|
thread_pool_max_active_query_threads
|
THREAD_POOL_MAX_ACTIVE_QUERY_THREADS
|
|
thread_pool_max_unused_threads
|
THREAD_POOL_MAX_UNUSED_THREADS
|
|
thread_pool_prio_kickup_timer
|
THREAD_POOL_PRIO_KICKUP_TIMER
|
|
thread_pool_size
|
THREAD_POOL_SIZE
|
|
thread_pool_stall_limit
|
THREAD_POOL_STALL_LIMIT
|
|
thread_stack
|
THREAD_STACK
|
|
timestamp
|
TIMESTAMP
|
|
time_zone
|
TIME_ZONE
|
|
tls_ciphersuites
|
TLS_CIPHERSUITES
|
|
tls_version
|
TLS_VERSION
|
|
tmp_table_size
|
TMP_TABLE_SIZE
|
|
transaction_alloc_block_size
|
TRANSACTION_ALLOC_BLOCK_SIZE
|
|
transaction_isolation
|
TRANSACTION_ISOLATION
|
|
transaction_prealloc_size
|
TRANSACTION_PREALLOC_SIZE
|
|
transaction_read_only
|
TRANSACTION_READ_ONLY
|
|
unique_checks
|
UNIQUE_CHECKS
|
|
updatable_views_with_limit
|
UPDATABLE_VIEWS_WITH_LIMIT
|
|
use_secondary_engine
|
USE_SECONDARY_ENGINE
|
|
wait_timeout
|
WAIT_TIMEOUT
|
|
warning_count
|
WARNING_COUNT
|
|
windowing_use_high_precision
|
WINDOWING_USE_HIGH_PRECISION
|
|
xa_detach_on_prepare
|
XA_DETACH_ON_PREPARE
|
|