Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic Performance_schema_users_lost Yes Global No performance_schema_users_size Yes Yes Yes Global No persist_only_admin_x509_subject Yes Yes Yes Global No persisted_globals_load Yes Yes Yes Global No pid_file Yes Yes Yes Global No plugin_dir Yes Yes Yes Global No plugin_load Yes Yes Yes Global No plugin_load_add Yes Yes Yes Global No plugin-xxx Yes Yes port Yes Yes Yes Global No port-open- timeout Yes Yes preload_buffer_size Yes Yes Yes Both Yes Prepared_stmt_count Yes Global No print-defaults Yes print_identified_with_as_hex Yes Yes Yes Both Yes profiling Yes Both Yes profiling_history_size Yes Yes Yes Both Yes protocol_compression_algorithms Yes Yes Yes Global Yes protocol_version Yes Global No proxy_user Yes Session No pseudo_slave_mode Yes Session Yes pseudo_thread_id Yes Session Yes Queries Yes Both No query_alloc_block_size Yes Yes Yes Both Yes query_prealloc_size Yes Yes Yes Both Yes Questions Yes Both No rand_seed1 Yes Session Yes rand_seed2 Yes Session Yes range_alloc_block_size Yes Yes Yes Both Yes range_optimizer_max_mem_size Yes Yes Yes Both Yes rbr_exec_mode Yes Both Yes read_buffer_size Yes Yes Yes Both Yes read_only Yes Yes Yes Global Yes read_rnd_buffer_size Yes Yes Yes Both Yes regexp_stack_limit Yes Yes Yes Global Yes regexp_time_limit Yes Yes Yes Global Yes relay_log Yes Yes Yes Global No 681