Server System Variable Reference Name Cmd-Line Option File System Var Var Scope Dynamic ndbinfo_table_prefix Yes Global No ndbinfo_version Yes Global No net_buffer_length Yes Yes Yes Both Yes net_read_timeout Yes Yes Yes Both Yes net_retry_count Yes Yes Yes Both Yes net_write_timeout Yes Yes Yes Both Yes new Yes Yes Yes Both Yes ngram_token_size Yes Yes Yes Global No offline_mode Yes Yes Yes Global Yes old Yes Yes Yes Global No old_alter_table Yes Yes Yes Both Yes open_files_limit Yes Yes Yes Global No optimizer_prune_level Yes Yes Yes Both Yes optimizer_search_depth Yes Yes Yes Both Yes optimizer_switch Yes Yes Yes Both Yes optimizer_trace Yes Yes Yes Both Yes optimizer_trace_features Yes Yes Yes Both Yes optimizer_trace_limit Yes Yes Yes Both Yes optimizer_trace_max_mem_size Yes Yes Yes Both Yes optimizer_trace_offset Yes Yes Yes Both Yes original_commit_timestamp Yes Session Yes original_server_version Yes Session Yes parser_max_mem_size Yes Yes Yes Both Yes partial_revokes Yes Yes Yes Global Yes password_history Yes Yes Yes Global Yes password_require_current Yes Yes Yes Global Yes password_reuse_interval Yes Yes Yes Global Yes performance_schema Yes Yes Yes Global No performance_schema_accounts_size Yes Yes Yes Global No performance_schema_digests_size Yes Yes Yes Global No performance_schema_error_size Yes Yes Yes Global No performance_schema_events_stages_history_long_size Yes Yes Yes Global No performance_schema_events_stages_history_size Yes Yes Yes Global No performance_schema_events_statements_history_long_size Yes Yes Yes Global No performance_schema_events_statements_history_size Yes Yes Yes Global No performance_schema_events_transactions_history_long_size Yes Yes Yes Global No performance_schema_events_transactions_history_size Yes Yes Yes Global No performance_schema_events_waits_history_long_size Yes Yes Yes Global No 708