Server System Variable Reference Name Cmd-Line Option File System Var Var Scope Dynamic automatic_sp_privileges Yes Yes Yes Global Yes avoid_temporal_upgrade Yes Yes Yes Global Yes back_log Yes Yes Yes Global No basedir Yes Yes Yes Global No big_tables Yes Yes Yes Both Yes bind_address Yes Yes Yes Global No binlog_cache_size Yes Yes Yes Global Yes binlog_checksum Yes Yes Yes Global Yes binlog_direct_non_transactional_updates Yes Yes Yes Both Yes binlog_encryption Yes Yes Yes Global Yes binlog_error_action Yes Yes Yes Global Yes binlog_expire_logs_seconds Yes Yes Yes Global Yes binlog_format Yes Yes Yes Both Yes binlog_group_commit_sync_delay Yes Yes Yes Global Yes binlog_group_commit_sync_no_delay_count Yes Yes Yes Global Yes binlog_gtid_simple_recovery Yes Yes Yes Global No binlog_max_flush_queue_time Yes Yes Yes Global Yes binlog_order_commits Yes Yes Yes Global Yes binlog_rotate_encryption_master_key_at_startup Yes Yes Yes Global No binlog_row_event_max_size Yes Yes Yes Global No binlog_row_image Yes Yes Yes Both Yes binlog_row_metadata Yes Yes Yes Global Yes binlog_row_value_options Yes Yes Yes Both Yes binlog_rows_query_log_events Yes Yes Yes Both Yes binlog_stmt_cache_size Yes Yes Yes Global Yes binlog_transaction_compression Yes Yes Yes Both Yes binlog_transaction_compression_level_zstd Yes Yes Yes Both Yes binlog_transaction_dependency_history_size Yes Yes Yes Global Yes binlog_transaction_dependency_tracking Yes Yes Yes Global Yes block_encryption_mode Yes Yes Yes Both Yes bulk_insert_buffer_size Yes Yes Yes Both Yes caching_sha2_password_auto_generate_rsa_keys Yes Yes Yes Global No caching_sha2_password_digest_rounds Yes Yes Yes Global No caching_sha2_password_private_key_path Yes Yes Yes Global No caching_sha2_password_public_key_path Yes Yes Yes Global No character_set_client Yes Both Yes character_set_connection Yes Both Yes 692