Server System Variable Reference Name Cmd-Line Option File System Var Var Scope Dynamic skip_external_locking Yes Yes Yes Global No skip_name_resolve Yes Yes Yes Global No skip_networking Yes Yes Yes Global No skip_show_database Yes Yes Yes Global No skip_slave_start Yes Yes Yes Global No slave_allow_batching Yes Yes Yes Global Yes slave_checkpoint_group Yes Yes Yes Global Yes slave_checkpoint_period Yes Yes Yes Global Yes slave_compressed_protocol Yes Yes Yes Global Yes slave_exec_mode Yes Yes Yes Global Yes slave_load_tmpdir Yes Yes Yes Global No slave_max_allowed_packet Yes Yes Yes Global Yes slave_net_timeout Yes Yes Yes Global Yes slave_parallel_type Yes Yes Yes Global Yes slave_parallel_workers Yes Yes Yes Global Yes slave_pending_jobs_size_max Yes Yes Yes Global Yes slave_preserve_commit_order Yes Yes Yes Global Yes slave_rows_search_algorithms Yes Yes Yes Global Yes slave_skip_errors Yes Yes Yes Global No slave_sql_verify_checksum Yes Yes Yes Global Yes slave_transaction_retries Yes Yes Yes Global Yes slave_type_conversions Yes Yes Yes Global Yes slow_launch_time Yes Yes Yes Global Yes slow_query_log Yes Yes Yes Global Yes slow_query_log_file Yes Yes Yes Global Yes socket Yes Yes Yes Global No sort_buffer_size Yes Yes Yes Both Yes sql_auto_is_null Yes Both Yes sql_big_selects Yes Both Yes sql_buffer_result Yes Both Yes sql_log_bin Yes Session Yes sql_log_off Yes Both Yes sql_mode Yes Yes Yes Both Yes sql_notes Yes Both Yes sql_quote_show_create Yes Both Yes sql_require_primary_key Yes Yes Yes Both Yes sql_safe_updates Yes Both Yes sql_select_limit Yes Both Yes 712