Server System Variable Reference Name Cmd-Line Option File System Var Var Scope Dynamic daemon_memcached_w_batch_size Yes Yes Yes Global No datadir Yes Yes Yes Global No debug Yes Yes Yes Both Yes debug_sync Yes Session Yes default_authentication_plugin Yes Yes Yes Global No default_collation_for_utf8mb4 Yes Both Yes default_password_lifetime Yes Yes Yes Global Yes default_storage_engine Yes Yes Yes Both Yes default_table_encryption Yes Yes Yes Both Yes default_tmp_storage_engine Yes Yes Yes Both Yes default_week_format Yes Yes Yes Both Yes delay_key_write Yes Yes Yes Global Yes delayed_insert_limit Yes Yes Yes Global Yes delayed_insert_timeout Yes Yes Yes Global Yes delayed_queue_size Yes Yes Yes Global Yes disabled_storage_engines Yes Yes Yes Global No disconnect_on_expired_password Yes Yes Yes Global No div_precision_increment Yes Yes Yes Both Yes dragnet.log_error_filter_rules Yes Yes Yes Global Yes end_markers_in_json Yes Yes Yes Both Yes enforce_gtid_consistency Yes Yes Yes Global Yes eq_range_index_dive_limit Yes Yes Yes Both Yes error_count Yes Session No event_scheduler Yes Yes Yes Global Yes expire_logs_days Yes Yes Yes Global Yes explicit_defaults_for_timestamp Yes Yes Yes Both Yes external_user Yes Session No flush Yes Yes Yes Global Yes 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 general_log Yes Yes Yes Global Yes general_log_file Yes Yes Yes Global Yes generated_random_password_length Yes Yes Yes Both Yes 694