Skip to main content

Allowed configurations

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

binlog_cache_size

BINLOG_CACHE_SIZE

binlog_checksum

BINLOG_CHECKSUM

binlog_direct_non_transactional_updates

BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES

binlog_encryption

BINLOG_ENCRYPTION

binlog_error_action

BINLOG_ERROR_ACTION

binlog_expire_logs_auto_purge

BINLOG_EXPIRE_LOGS_AUTO_PURGE

binlog_expire_logs_seconds

BINLOG_EXPIRE_LOGS_SECONDS

binlog_format

BINLOG_FORMAT

binlog_group_commit_sync_delay

BINLOG_GROUP_COMMIT_SYNC_DELAY

binlog_group_commit_sync_no_delay_count

BINLOG_GROUP_COMMIT_SYNC_NO_DELAY_COUNT

binlog_max_flush_queue_time

BINLOG_MAX_FLUSH_QUEUE_TIME

binlog_order_commits

BINLOG_ORDER_COMMITS

binlog_rotate_encryption_master_key_at_startup

BINLOG_ROTATE_ENCRYPTION_MASTER_KEY_AT_STARTUP

binlog_row_event_max_size

BINLOG_ROW_EVENT_MAX_SIZE

binlog_row_image

BINLOG_ROW_IMAGE

binlog_row_metadata

BINLOG_ROW_METADATA

binlog_row_value_options

BINLOG_ROW_VALUE_OPTIONS

binlog_rows_query_log_events

BINLOG_ROWS_QUERY_LOG_EVENTS

binlog_stmt_cache_size

BINLOG_STMT_CACHE_SIZE

binlog_transaction_compression

BINLOG_TRANSACTION_COMPRESSION

binlog_transaction_compression_level_zstd

BINLOG_TRANSACTION_COMPRESSION_LEVEL_ZSTD

binlog_transaction_dependency_history_size

BINLOG_TRANSACTION_DEPENDENCY_HISTORY_SIZE

expire_logs_days

EXPIRE_LOGS_DAYS

log_bin

LOG_BIN

log_bin_basename

LOG_BIN_BASENAME

log_bin_index

LOG_BIN_INDEX

log_bin_trust_function_creators

LOG_BIN_TRUST_FUNCTION_CREATORS

log_replica_updates

LOG_REPLICA_UPDATES

log_statements_unsafe_for_binlog

LOG_STATEMENTS_UNSAFE_FOR_BINLOG

max_binlog_cache_size

MAX_BINLOG_CACHE_SIZE

max_binlog_size

MAX_BINLOG_SIZE

max_binlog_stmt_cache_size

MAX_BINLOG_STMT_CACHE_SIZE

original_commit_timestamp

ORIGINAL_COMMIT_TIMESTAMP

source_verify_checksum

SOURCE_VERIFY_CHECKSUM

sql_log_bin

SQL_LOG_BIN

sync_binlog

SYNC_BINLOG

Was this page helpful?