Server System Variable Reference Name Cmd-Line Option File System Var Var Scope Dynamic plugin_load Yes Yes Yes Global No plugin_load_add Yes Yes Yes Global No port Yes Yes Yes Global No preload_buffer_size Yes Yes Yes Both 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 query_alloc_block_size Yes Yes Yes Both Yes query_prealloc_size Yes Yes Yes Both Yes 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 relay_log_basename Yes Global No relay_log_index Yes Yes Yes Global No relay_log_info_file Yes Yes Yes Global No relay_log_info_repository Yes Yes Yes Global Yes relay_log_purge Yes Yes Yes Global Yes relay_log_recovery Yes Yes Yes Global No relay_log_space_limit Yes Yes Yes Global No replication_optimize_for_static_plugin_config Yes Yes Yes Global Yes replication_sender_observe_commit_only Yes Yes Yes Global Yes report_host Yes Yes Yes Global No report_password Yes Yes Yes Global No report_port Yes Yes Yes Global No report_user Yes Yes Yes Global No 710