Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic 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_open_temp_tables Yes Global No 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_last_search_algorithm_used Yes Global No slave_rows_search_algorithms Yes Yes Yes Global Yes slave_skip_errors Yes Yes Yes Global No slave-sql- verify- checksum Yes Yes 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_threads Yes Both No slow_launch_time Yes Yes Yes Global Yes Slow_queries Yes Both No slow_query_log Yes Yes Yes Global Yes slow_query_log_file Yes Yes Yes Global Yes slow-start- timeout Yes Yes socket Yes Yes Yes Global No sort_buffer_size Yes Yes Yes Both Yes Sort_merge_passes Yes Both No Sort_range Yes Both No Sort_rows Yes Both No Sort_scan Yes Both No sporadic- binlog-dump- fail Yes Yes sql_auto_is_null Yes Both Yes 685