Skip to content

Percona Server for MySQL 8.4 variables

System variables

Name Cmd-Line Option File Var Scope Dynamic
csv_mode Yes Yes Both Yes
enforce_storage_engine Yes Yes Global No
expand_fast_index_creation Yes No Both Yes
extra_max_connections Yes Yes Global Yes
extra_port Yes Yes Global No
have_backup_locks Yes No Global No
have_backup_safe_binlog_info Yes No Global No
have_snapshot_cloning Yes No Global No
innodb_cleaner_lsn_age_factor Yes Yes Global Yes
innodb_corrupt_table_action Yes Yes Global Yes
innodb_empty_free_list_algorithm Yes Yes Global Yes
innodb_encrypt_online_alter_logs Yes Yes Global Yes
innodb_encrypt_tables Yes Yes Global Yes
innodb_kill_idle_transaction Yes Yes Global Yes
innodb_max_bitmap_file_size Yes Yes Global Yes
innodb_max_changed_pages Yes Yes Global Yes
innodb_print_lock_wait_timeout_info Yes Yes Global Yes
innodb_show_locks_held Yes Yes Global Yes
innodb_temp_tablespace_encrypt Yes Yes Global No
innodb_track_changed_pages Yes Yes Global No
keyring_vault_config Yes Yes Global Yes
keyring_vault_timeout Yes Yes Global Yes
log_slow_filter Yes Yes Both Yes
log_slow_rate_limit Yes Yes Both Yes
log_slow_rate_type Yes Yes Global Yes
log_slow_sp_statements Yes Yes Global Yes
log_slow_verbosity Yes Yes Both Yes
log_warnings_suppress Yes Yes Global Yes
proxy_protocol_networks Yes Yes Global No
query_response_time_flush Yes No Global No
query_response_time_range_base Yes Yes Global Yes
query_response_time_stats Yes Yes Global Yes
secure_log_path Yes Yes Global No
slow_query_log_always_write_time Yes Yes Global Yes
slow_query_log_use_global_control Yes Yes Global Yes
thread_pool_high_prio_mode Yes Yes Both Yes
thread_pool_high_prio_tickets Yes Yes Both Yes
thread_pool_idle_timeout Yes Yes Global Yes
thread_pool_max_threads Yes Yes Global Yes
thread_pool_oversubscribe Yes Yes Global Yes
thread_pool_size Yes Yes Global Yes
thread_pool_stall_limit Yes Yes Global No
thread_statistics Yes Yes Global Yes
userstat Yes Yes Global Yes
version_comment Yes Yes Global Yes
version_suffix Yes Yes Global Yes

Status variables

Name Var Type Var Scope
Binlog_snapshot_file String Global
Binlog_snapshot_position Numeric Global
Com_lock_binlog_for_backup Numeric Both
Com_lock_tables_for_backup Numeric Both
Com_show_client_statistics Numeric Both
Com_show_index_statistics Numeric Both
Com_show_table_statistics Numeric Both
Com_show_thread_statistics Numeric Both
Com_show_user_statistics Numeric Both
Com_unlock_binlog Numeric Both
Innodb_background_log_sync Numeric Global
Innodb_buffer_pool_pages_LRU_flushed Numeric Global
Innodb_buffer_pool_pages_made_not_young Numeric Global
Innodb_buffer_pool_pages_made_young Numeric Global
Innodb_buffer_pool_pages_old Numeric Global
Innodb_checkpoint_age Numeric Global
Innodb_checkpoint_max_age Numeric Global
Innodb_ibuf_free_list Numeric Global
Innodb_ibuf_segment_size Numeric Global
Innodb_lsn_current Numeric Global
Innodb_lsn_flushed Numeric Global
Innodb_lsn_last_checkpoint Numeric Global
Innodb_max_trx_id Numeric Global
Innodb_mem_adaptive_hash Numeric Global
Innodb_mem_dictionary Numeric Global
Innodb_oldest_view_low_limit_trx_id Numeric Global
Innodb_purge_trx_id Numeric Global
Innodb_purge_undo_no Numeric Global
Threadpool_idle_threads Numeric Global
Threadpool_threads Numeric Global

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.


Last update: 2024-08-22