Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic 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-time- zone Yes Yes default_tmp_storage_engine Yes Yes Yes Both Yes default_week_format Yes Yes Yes Both Yes defaults- extra-file Yes defaults-file Yes defaults- group-suffix Yes delay_key_write Yes Yes Yes Global Yes Delayed_errors Yes Global No delayed_insert_limit Yes Yes Yes Global Yes Delayed_insert_threads Yes Global No delayed_insert_timeout Yes Yes Yes Global Yes delayed_queue_size Yes Yes Yes Global Yes Delayed_writes Yes Global No disabled_storage_engines Yes Yes Yes Global No disconnect_on_expired_password Yes Yes Yes Global No disconnect- slave-event- count Yes Yes div_precision_increment Yes Yes Yes Both Yes dragnet.log_error_filter_rules Yes Yes Yes Global Yes dragnet.Status Yes Global No early-plugin- load Yes 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 Error_log_buffered_bytes Yes Global No Error_log_buffered_events Yes Global No Error_log_expired_events Yes Global No Error_log_latest_write Yes Global No event_scheduler Yes Yes Yes Global Yes 652