Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic ndbinfo_max_bytes Yes Yes Both Yes ndbinfo_max_rows Yes Yes Both Yes ndbinfo_offline Yes Global Yes ndbinfo_show_hidden Yes Yes Both Yes 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 no-dd- upgrade Yes Yes no-defaults Yes no-monitor Yes Yes Not_flushed_delayed_rows Yes Global No offline_mode Yes Yes Yes Global Yes old Yes Yes Yes Global No old_alter_table Yes Yes Yes Both Yes old-style- user-limits Yes Yes Ongoing_anonymous_gtid_violating_transaction_count Yes Global No Ongoing_anonymous_transaction_count Yes Global No Ongoing_automatic_gtid_violating_transaction_count Yes Global No Open_files Yes Global No open_files_limit Yes Yes Yes Global No Open_streams Yes Global No Open_table_definitions Yes Global No Open_tables Yes Both No Opened_files Yes Global No Opened_table_definitions Yes Both No Opened_tables Yes Both 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 676