16.1.4.1. Replication and Binary Logging Option and Variable Reference

The following tables list basic information about the MySQL command-line options and system variables applicable to replication and the binary log.

Table 16.1. Replication Options and Variables: MySQL 5.6

Option or Variable Name	Command Line	System Variable	Scope
Option or Variable Name	Option File	Status Variable	Dynamic
`Com_change_master`	N	N	Both
`Com_change_master`	N	Y	N
`Com_show_master_status`	N	N	Both
`Com_show_master_status`	N	Y	N
`Com_show_new_master`	N	N	Both
`Com_show_new_master`	N	Y	N
`Com_show_slave_hosts`	N	N	Both
`Com_show_slave_hosts`	N	Y	N
`Com_show_slave_status`	N	N	Both
`Com_show_slave_status`	N	Y	N
`Com_slave_start`	N	N	Both
`Com_slave_start`	N	Y	N
`Com_slave_stop`	N	N	Both
`Com_slave_stop`	N	Y	N
`Rpl_semi_sync_master_clients`	N	N	Global
`Rpl_semi_sync_master_clients`	N	Y	N
`Rpl_semi_sync_master_net_avg_wait_time`	N	N	Global
`Rpl_semi_sync_master_net_avg_wait_time`	N	Y	N
`Rpl_semi_sync_master_net_wait_time`	N	N	Global
`Rpl_semi_sync_master_net_wait_time`	N	Y	N
`Rpl_semi_sync_master_net_waits`	N	N	Global
`Rpl_semi_sync_master_net_waits`	N	Y	N
`Rpl_semi_sync_master_no_times`	N	N	Global
`Rpl_semi_sync_master_no_times`	N	Y	N
`Rpl_semi_sync_master_no_tx`	N	N	Global
`Rpl_semi_sync_master_no_tx`	N	Y	N
`Rpl_semi_sync_master_status`	N	N	Global
`Rpl_semi_sync_master_status`	N	Y	N
`Rpl_semi_sync_master_timefunc_failures`	N	N	Global
`Rpl_semi_sync_master_timefunc_failures`	N	Y	N
`Rpl_semi_sync_master_tx_avg_wait_time`	N	N	Global
`Rpl_semi_sync_master_tx_avg_wait_time`	N	Y	N
`Rpl_semi_sync_master_tx_wait_time`	N	N	Global
`Rpl_semi_sync_master_tx_wait_time`	N	Y	N
`Rpl_semi_sync_master_tx_waits`	N	N	Global
`Rpl_semi_sync_master_tx_waits`	N	Y	N
`Rpl_semi_sync_master_wait_pos_backtraverse`	N	N	Global
`Rpl_semi_sync_master_wait_pos_backtraverse`	N	Y	N
`Rpl_semi_sync_master_wait_sessions`	N	N	Global
`Rpl_semi_sync_master_wait_sessions`	N	Y	N
`Rpl_semi_sync_master_yes_tx`	N	N	Global
`Rpl_semi_sync_master_yes_tx`	N	Y	N
`Rpl_semi_sync_slave_status`	N	N	Global
`Rpl_semi_sync_slave_status`	N	Y	N
`slave_exec_mode`	Y	Y	Global
`slave_exec_mode`	Y	N	Y
`Slave_open_temp_tables`	N	N	Global
`Slave_open_temp_tables`	N	Y	N
`Slave_retried_transactions`	N	N	Global
`Slave_retried_transactions`	N	Y	N
`Slave_running`	N	N	Global
`Slave_running`	N	Y	N
`abort-slave-event-count`	Y	N	Global
`abort-slave-event-count`	Y	N	N
`disable-gtid-unsafe-statements`	Y	Y	Global
`disable-gtid-unsafe-statements`	Y	N	N
`disable_gtid_unsafe_statements`	Y	Y	Global
`disable_gtid_unsafe_statements`	Y	N	N
`disconnect-slave-event-count`	Y	N	Global
`disconnect-slave-event-count`	Y	N	N
`enforce-gtid-consistency`	Y	Y	Global
`enforce-gtid-consistency`	Y	N	N
`enforce_gtid_consistency`	Y	Y	Global
`enforce_gtid_consistency`	Y	N	N
`gtid_done`	N	Y	Both
`gtid_done`	N	N	N
`gtid_executed`	N	Y	Both
`gtid_executed`	N	N	N
`gtid_lost`	N	Y	Global
`gtid_lost`	N	N	N
`gtid-mode`	Y	Y	Global
`gtid-mode`	Y	N	N
`gtid_mode`	N	Y	Global
`gtid_mode`	N	N	N
`gtid_next`	N	Y	Session
`gtid_next`	N	N	Y
`gtid_owned`	N	Y	Both
`gtid_owned`	N	N	N
`gtid_purged`	N	Y	Global
`gtid_purged`	N	N	Y
`init_slave`	Y	Y	Global
`init_slave`	Y	N	Y
`log-slave-updates`	Y	Y	Global
`log-slave-updates`	Y	N	N
`log_slave_updates`	Y	Y	Global
`log_slave_updates`	Y	N	N
`master-info-file`	Y	N	Global
`master-info-file`	Y	N	N
`master-info-repository`	Y	N	Global
`master-info-repository`	Y	N	N
`master_info_repository`	N	Y	Global
`master_info_repository`	N	N	Y
`master-retry-count`	Y	N	Global
`master-retry-count`	Y	N	N
`relay-log`	Y	Y	Global
`relay-log`	Y	N	N
`relay_log_basename`	N	Y	Global
`relay_log_basename`	N	N	N
`relay-log-index`	Y	Y	Global
`relay-log-index`	Y	N	N
`relay-log-info-file`	Y	N	Global
`relay-log-info-file`	Y	N	N
`relay_log_info_file`	Y	Y	Global
`relay_log_info_file`	Y	N	N
`relay-log-info-repository`	Y	N	Global
`relay-log-info-repository`	Y	N	N
`relay_log_info_repository`	N	Y	Global
`relay_log_info_repository`	N	N	Y
`relay_log_index`	Y	Y	Global
`relay_log_index`	Y	N	N
`relay_log_purge`	Y	Y	Global
`relay_log_purge`	Y	N	Y
`relay_log_recovery`	Y	Y	Global
`relay_log_recovery`	Y	N	Y
`relay_log_space_limit`	Y	Y	Global
`relay_log_space_limit`	Y	N	N
`replicate-do-db`	Y	N	Global
`replicate-do-db`	Y	N	N
`replicate-do-table`	Y	N	Global
`replicate-do-table`	Y	N	N
`replicate-ignore-db`	Y	N	Global
`replicate-ignore-db`	Y	N	N
`replicate-ignore-table`	Y	N	Global
`replicate-ignore-table`	Y	N	N
`replicate-rewrite-db`	Y	N	Global
`replicate-rewrite-db`	Y	N	N
`replicate-same-server-id`	Y	N	Global
`replicate-same-server-id`	Y	N	N
`replicate-wild-do-table`	Y	N	Global
`replicate-wild-do-table`	Y	N	N
`replicate-wild-ignore-table`	Y	N	Global
`replicate-wild-ignore-table`	Y	N	N
`report-host`	Y	Y	Global
`report-host`	Y	N	N
`report-password`	Y	Y	Global
`report-password`	Y	N	N
`report-port`	Y	Y	Global
`report-port`	Y	N	N
`report-user`	Y	Y	Global
`report-user`	Y	N	N
`rpl_semi_sync_master_enabled`	N	Y	Global
`rpl_semi_sync_master_enabled`	N	N	Y
`rpl_semi_sync_master_timeout`	N	Y	Global
`rpl_semi_sync_master_timeout`	N	N	Y
`rpl_semi_sync_master_trace_level`	N	Y	Global
`rpl_semi_sync_master_trace_level`	N	N	Y
`rpl_semi_sync_master_wait_no_slave`	N	Y	Global
`rpl_semi_sync_master_wait_no_slave`	N	N	Y
`rpl_semi_sync_slave_enabled`	N	Y	Global
`rpl_semi_sync_slave_enabled`	N	N	Y
`rpl_semi_sync_slave_trace_level`	N	Y	Global
`rpl_semi_sync_slave_trace_level`	N	N	Y
`server_uuid`	N	Y	Global
`server_uuid`	N	N	N
`show-slave-auth-info`	Y	N	Global
`show-slave-auth-info`	Y	N	N
`skip-slave-start`	Y	N	Global
`skip-slave-start`	Y	N	N
`slave_allow_batching`	Y	Y	Global
`slave_allow_batching`	Y	N	Y
`slave-load-tmpdir`	Y	Y	Global
`slave-load-tmpdir`	Y	N	N
`slave-skip-errors`	Y	Y	Global
`slave-skip-errors`	Y	N	N
`slave-checkpoint-group`	Y	N	Global
`slave-checkpoint-group`	Y	N	N
`slave_checkpoint_group`	Y	Y	Global
`slave_checkpoint_group`	Y	N	Y
`slave-checkpoint-period`	Y	N	Global
`slave-checkpoint-period`	Y	N	N
`slave_checkpoint_period`	Y	Y	Global
`slave_checkpoint_period`	Y	N	Y
`slave_compressed_protocol`	Y	Y	Global
`slave_compressed_protocol`	Y	N	Y
`slave-max-allowed-packet`	Y	N	Global
`slave-max-allowed-packet`	Y	N	N
`slave_max_allowed_packet`	N	Y	Global
`slave_max_allowed_packet`	N	N	Y
`slave_net_timeout`	Y	Y	Global
`slave_net_timeout`	Y	N	Y
`slave_parallel_workers`	N	Y	Global
`slave_parallel_workers`	N	N	Y
`slave-parallel-workers`	Y	N	Global
`slave-parallel-workers`	Y	N	N
`slave-pending-jobs-size-max`	Y	N	Global
`slave-pending-jobs-size-max`	N	N	N
`slave_pending_jobs_size_max`	N	Y	Global
`slave_pending_jobs_size_max`	N	N	Y
`slave-rows-search-algorithms`	Y	N	Global
`slave-rows-search-algorithms`	Y	N	N
`slave_rows_search_algorithms`	N	Y	Global
`slave_rows_search_algorithms`	N	N	Y
`slave_transaction_retries`	Y	Y	Global
`slave_transaction_retries`	Y	N	Y
`slave_type_conversions`	Y	Y	Global
`slave_type_conversions`	Y	N	N
`sql_slave_skip_counter`	N	Y	Global
`sql_slave_skip_counter`	N	N	Y
`sync_master_info`	Y	Y	Global
`sync_master_info`	Y	N	Y
`sync_relay_log`	Y	Y	Global
`sync_relay_log`	Y	N	Y
`sync_relay_log_info`	Y	Y	Global
`sync_relay_log_info`	Y	N	Y

Section 16.1.4.2, "Replication Master Options and Variables", provides more detailed information about options and variables relating to replication master servers. For more information about options and variables relating to replication slaves, see Section 16.1.4.3, "Replication Slave Options and Variables".

Table 16.2. Binary Logging Options and Variables: MySQL 5.6

Option or Variable Name	Command Line	System Variable	Scope
Option or Variable Name	Option File	Status Variable	Dynamic
`Binlog_cache_disk_use`	N	N	Global
`Binlog_cache_disk_use`	N	Y	N
`binlog_row_image`	Y	Y	Both
`binlog_row_image`	Y	N	Y
`binlog_rows_query_log_events`	N	Y	Both
`binlog_rows_query_log_events`	N	N	Y
`Binlog_stmt_cache_disk_use`	N	N	Global
`Binlog_stmt_cache_disk_use`	N	Y	N
`Binlog_cache_use`	N	N	Global
`Binlog_cache_use`	N	Y	N
`Binlog_stmt_cache_use`	N	N	Global
`Binlog_stmt_cache_use`	N	Y	N
`Com_show_binlog_events`	N	N	Both
`Com_show_binlog_events`	N	Y	N
`Com_show_binlogs`	N	N	Both
`Com_show_binlogs`	N	Y	N
`binlog-checksum`	Y	N	Global
`binlog-checksum`	Y	N	N
`binlog_checksum`	N	Y	Global
`binlog_checksum`	N	N	Y
`binlog-do-db`	Y	N	Global
`binlog-do-db`	Y	N	N
`binlog-ignore-db`	Y	N	Global
`binlog-ignore-db`	Y	N	N
`binlog-row-event-max-size`	Y	N	Global
`binlog-row-event-max-size`	Y	N	N
`binlog_cache_size`	Y	Y	Global
`binlog_cache_size`	Y	N	Y
`binlog_max_flush_queue_time`	N	Y	Global
`binlog_max_flush_queue_time`	N	N	Y
`binlog_order_commits`	N	Y	Global
`binlog_order_commits`	N	N	Y
`binlog_stmt_cache_size`	Y	Y	Global
`binlog_stmt_cache_size`	Y	N	Y
`binlog_format`	Y	Y	Both
`binlog_format`	Y	N	Y
`binlog-rows-query-log-events`	Y	N	Global
`binlog-rows-query-log-events`	Y	N	N
`binlog_direct_non_transactional_updates`	Y	Y	Both
`binlog_direct_non_transactional_updates`	Y	N	Y
`log_bin_basename`	N	Y	Global
`log_bin_basename`	N	N	N
`log-bin-use-v1-row-events`	Y	Y	Global
`log-bin-use-v1-row-events`	Y	N	N
`log_bin_use_v1_row_events`	Y	Y	Global
`log_bin_use_v1_row_events`	Y	N	N
`master-verify-checksum`	Y	N	Global
`master-verify-checksum`	Y	N	N
`master_verify_checksum`	N	Y	Global
`master_verify_checksum`	N	N	Y
`max-binlog-dump-events`	Y	N	Global
`max-binlog-dump-events`	Y	N	N
`max_binlog_cache_size`	Y	Y	Global
`max_binlog_cache_size`	Y	N	Y
`max_binlog_size`	Y	Y	Global
`max_binlog_size`	Y	N	Y
`max_binlog_stmt_cache_size`	Y	Y	Global
`max_binlog_stmt_cache_size`	Y	N	Y
`slave-sql-verify-checksum`	Y	N	Global
`slave-sql-verify-checksum`	Y	N	N
`slave_sql_verify_checksum`	N	Y	Global
`slave_sql_verify_checksum`	N	N	Y
`sporadic-binlog-dump-fail`	Y	N	Global
`sporadic-binlog-dump-fail`	Y	N	N

Section 16.1.4.4, "Binary Log Options and Variables", provides more detailed information about options and variables relating to binary logging. For additional general information about the binary log, see Section 5.2.4, "The Binary Log".

For a table showing all command-line options, system and status variables used with mysqld, see Section 5.1.1, "Server Option and Variable Reference".