17.1.3.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 17.1 Replication Options and Variables: MySQL 5.5

Option or Variable NameCommand LineSystem VariableScope
Option FileStatus VariableDynamic

Com_change_master

NNBoth
NYN

Com_show_master_status

NNBoth
NYN

Com_show_new_master

NNBoth
NYN

Com_show_slave_hosts

NNBoth
NYN

Com_show_slave_status

NNBoth
NYN

Com_slave_start

NNBoth
NYN

Com_slave_stop

NNBoth
NYN

Rpl_semi_sync_master_clients

NNGlobal
NYN

Rpl_semi_sync_master_net_avg_wait_time

NNGlobal
NYN

Rpl_semi_sync_master_net_wait_time

NNGlobal
NYN

Rpl_semi_sync_master_net_waits

NNGlobal
NYN

Rpl_semi_sync_master_no_times

NNGlobal
NYN

Rpl_semi_sync_master_no_tx

NNGlobal
NYN

Rpl_semi_sync_master_status

NNGlobal
NYN

Rpl_semi_sync_master_timefunc_failures

NNGlobal
NYN

Rpl_semi_sync_master_tx_avg_wait_time

NNGlobal
NYN

Rpl_semi_sync_master_tx_wait_time

NNGlobal
NYN

Rpl_semi_sync_master_tx_waits

NNGlobal
NYN

Rpl_semi_sync_master_wait_pos_backtraverse

NNGlobal
NYN

Rpl_semi_sync_master_wait_sessions

NNGlobal
NYN

Rpl_semi_sync_master_yes_tx

NNGlobal
NYN

Rpl_semi_sync_slave_status

NNGlobal
NYN

Rpl_status

NNGlobal
NYN

slave_exec_mode

YYGlobal
YNY

Slave_open_temp_tables

NNGlobal
NYN

Slave_retried_transactions

NNGlobal
NYN

Slave_running

NNGlobal
NYN

abort-slave-event-count

YNGlobal
YNN

disconnect-slave-event-count

YNGlobal
YNN

init_slave

YYGlobal
YNY

log-slave-updates

YYGlobal
YNN

log_slave_updates

YYGlobal
YNN

master-connect-retry

YNGlobal
YNN

master-host

YNGlobal
YNN

master-info-file

YNGlobal
YNN

master-password

YNGlobal
YNN

master-port

YNGlobal
YNN

master-retry-count

YNGlobal
YNN

master-ssl

YNGlobal
YNN

master-ssl-ca

YNGlobal
YNN

master-ssl-capath

YNGlobal
YNN

master-ssl-cert

YNGlobal
YNN

master-ssl-cipher

YNGlobal
YNN

master-ssl-key

YNGlobal
YNN

master-user

YNGlobal
YNN

relay-log

YYGlobal
YNN

relay-log-index

YYGlobal
YNN

relay-log-info-file

YNGlobal
YNN

relay_log_info_file

YYGlobal
YNN

relay_log_index

YYGlobal
YNN

relay_log_purge

YYGlobal
YNY

relay-log-recovery

YNGlobal
YNN

relay_log_recovery

YYGlobal
YNY

relay_log_space_limit

YYGlobal
YNN

replicate-do-db

YNGlobal
YNN

replicate-do-table

YNGlobal
YNN

replicate-ignore-db

YNGlobal
YNN

replicate-ignore-table

YNGlobal
YNN

replicate-rewrite-db

YNGlobal
YNN

replicate-same-server-id

YNGlobal
YNN

replicate-wild-do-table

YNGlobal
YNN

replicate-wild-ignore-table

YNGlobal
YNN

report-host

YYGlobal
YNN

report-password

YYGlobal
YNN

report-port

YYGlobal
YNN

report-user

YYGlobal
YNN

rpl_recovery_rank

NYGlobal
NNY

rpl_semi_sync_master_enabled

NYGlobal
NNY

rpl_semi_sync_master_timeout

NYGlobal
NNY

rpl_semi_sync_master_trace_level

NYGlobal
NNY

rpl_semi_sync_master_wait_no_slave

NYGlobal
NNY

rpl_semi_sync_slave_enabled

NYGlobal
NNY

rpl_semi_sync_slave_trace_level

NYGlobal
NNY

show-slave-auth-info

YNGlobal
YNN

skip-slave-start

YNGlobal
YNN

slave_allow_batching

YYGlobal
YNY

slave-load-tmpdir

YYGlobal
YNN

slave-skip-errors

YYGlobal
YNN

slave_compressed_protocol

YYGlobal
YNY

slave-max-allowed-packet

YNGlobal
YNN

slave_max_allowed_packet

NYGlobal
NNY

slave_net_timeout

YYGlobal
YNY

slave_transaction_retries

YYGlobal
YNY

slave_type_conversions

YYGlobal
YNN

sql_slave_skip_counter

NYGlobal
NNY

sync_binlog

YYGlobal
YNY

sync_master_info

YYGlobal
YNY

sync_relay_log

YYGlobal
YNY

sync_relay_log_info

YYGlobal
YNY

Section 17.1.3.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 17.1.3.3, “Replication Slave Options and Variables”.

Table 17.2 Binary Logging Options and Variables: MySQL 5.5

Option or Variable NameCommand LineSystem VariableScope
Option FileStatus VariableDynamic

Binlog_cache_disk_use

NNGlobal
NYN

Binlog_stmt_cache_disk_use

NNGlobal
NYN

Binlog_cache_use

NNGlobal
NYN

Binlog_stmt_cache_use

NNGlobal
NYN

Com_show_binlog_events

NNBoth
NYN

Com_show_binlogs

NNBoth
NYN

binlog-do-db

YNGlobal
YNN

binlog-ignore-db

YNGlobal
YNN

binlog-row-event-max-size

YNGlobal
YNN

binlog_cache_size

YYGlobal
YNY

binlog_stmt_cache_size

YYGlobal
YNY

binlog_format

YYBoth
YNY

binlog_direct_non_transactional_updates

YYBoth
YNY

log-bin-use-v1-row-events

YYGlobal
YNN

log_bin_use_v1_row_events

YYGlobal
YNN

max-binlog-dump-events

YNGlobal
YNN

max_binlog_cache_size

YYGlobal
YNY

max_binlog_size

YYGlobal
YNY

max_binlog_stmt_cache_size

YYGlobal
YNY

sporadic-binlog-dump-fail

YNGlobal
YNN

Section 17.1.3.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 information about the sql_log_bin and sql_log_off variables, see Section 5.1.4, “Server System Variables”.

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”.