653 Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic exit-info Yes Yes expire_logs_days Yes Yes Yes Global Yes explicit_defaults_for_timestamp Yes Yes Yes Both Yes external- locking Yes Yes -  Variable : skip_external_locking external_user Yes Session No federated Yes Yes Firewall_access_denied Yes Global No Firewall_access_granted Yes Global No Firewall_cached_entries Yes Global No flush Yes Yes Yes Global Yes Flush_commands Yes Global No flush_time Yes Yes Yes Global Yes foreign_key_checks Yes Both Yes ft_boolean_syntax Yes Yes Yes Global Yes ft_max_word_len Yes Yes Yes Global No ft_min_word_len Yes Yes Yes Global No ft_query_expansion_limit Yes Yes Yes Global No ft_stopword_file Yes Yes Yes Global No gdb Yes Yes general_log Yes Yes Yes Global Yes general_log_file Yes Yes Yes Global Yes generated_random_password_length Yes Yes Yes Both Yes group_concat_max_len Yes Yes Yes Both Yes group_replication_advertise_recovery_endpoints Yes Yes Yes Global Yes group_replication_allow_local_lower_version_join Yes Yes Yes Global Yes group_replication_auto_increment_increment Yes Yes Yes Global Yes group_replication_autorejoin_tries Yes Yes Yes Global Yes group_replication_bootstrap_group Yes Yes Yes Global Yes group_replication_clone_threshold Yes Yes Yes Global Yes group_replication_communication_debug_options Yes Yes Yes Global Yes group_replication_communication_max_message_size Yes Yes Yes Global Yes group_replication_components_stop_timeout Yes Yes Yes Global Yes group_replication_compression_threshold Yes Yes Yes Global Yes group_replication_consistency Yes Yes Yes Both Yes group_replication_enforce_update_everywhere_checks Yes Yes Yes Global Yes