MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log.
The command-line options and system variables in the following list relate to replication source servers and replicas. Section 17.1.4.2, “Replication Source Options and Variables” provides more detailed information about options and variables relating to replication source servers. For more information about options and variables relating to replicas, see Section 17.1.4.3, “Replica Server Options and Variables”.
abort-slave-event-count
:
Option used by mysql-test for debugging and testing of
replication.
auto_increment_increment
:
AUTO_INCREMENT columns are incremented by this value.
auto_increment_offset
:
Offset added to AUTO_INCREMENT columns.
binlog_gtid_simple_recovery
:
Controls how binary logs are iterated during GTID recovery.
Com_change_master
:
Count of CHANGE MASTER TO statements.
Com_show_master_status
:
Count of SHOW MASTER STATUS statements.
Com_show_slave_hosts
:
Count of SHOW REPLICAS and SHOW SLAVE HOSTS statements.
Com_show_slave_status
:
Count of SHOW REPLICA STATUS and SHOW SLAVE STATUS statements.
Com_slave_start
:
Count of START REPLICA and START SLAVE statements.
Com_slave_stop
:
Count of STOP REPLICA and STOP SLAVE statements.
disconnect-slave-event-count
:
Option used by mysql-test for debugging and testing of
replication.
enforce_gtid_consistency
:
Prevents execution of statements that cannot be logged in
transactionally safe manner.
expire_logs_days
:
Purge binary logs after this many days.
gtid_executed
:
Global: All GTIDs in binary log (global) or current transaction
(session). Read-only.
gtid_mode
:
Controls whether GTID based logging is enabled and what type of
transactions logs can contain.
gtid_next
:
Specifies GTID for next statement to execute; see documentation
for details.
gtid_owned
:
Set of GTIDs owned by this client (session), or by all clients,
together with thread ID of owner (global). Read-only.
gtid_purged
:
Set of all GTIDs that have been purged from binary log.
init_slave
:
Statements that are executed when replica connects to source.
log_bin_trust_function_creators
:
If equal to 0 (default), then when --log-bin is used, stored
function creation is allowed only to users having SUPER
privilege and only if function created does not break binary
logging.
master-info-file
:
Location and name of file that remembers source and where I/O
replication thread is in source's binary log.
master-retry-count
:
Number of tries replica makes to connect to source before giving
up.
master_info_repository
:
Whether to write connection metadata repository, containing
source information and replication I/O thread location in
source's binary log, to file or table.
max_relay_log_size
:
If nonzero, relay log is rotated automatically when its size
exceeds this value. If zero, size at which rotation occurs is
determined by value of max_binlog_size.
relay_log
:
Location and base name to use for relay logs.
relay_log_basename
:
Complete path to relay log, including file name.
relay_log_index
:
Location and name to use for file that keeps list of last relay
logs.
relay_log_info_file
:
File name for applier metadata repository in which replica
records information about relay logs.
relay_log_info_repository
:
Whether to write location of replication SQL thread in relay
logs to file or table.
relay_log_purge
:
Determines whether relay logs are purged.
relay_log_recovery
:
Whether automatic recovery of relay log files from source at
startup is enabled; must be enabled for crash-safe replica.
relay_log_space_limit
:
Maximum space to use for all relay logs.
replicate-do-db
:
Tells replication SQL thread to restrict replication to
specified database.
replicate-do-table
:
Tells replication SQL thread to restrict replication to
specified table.
replicate-ignore-db
:
Tells replication SQL thread not to replicate to specified
database.
replicate-ignore-table
:
Tells replication SQL thread not to replicate to specified
table.
replicate-rewrite-db
:
Updates to database with different name from original.
replicate-same-server-id
:
In replication, if enabled, do not skip events having our server
id.
replicate-wild-do-table
:
Tells replication SQL thread to restrict replication to tables
that match specified wildcard pattern.
replicate-wild-ignore-table
:
Tells replication SQL thread not to replicate to tables that
match given wildcard pattern.
report_host
:
Host name or IP of replica to be reported to source during
replica registration.
report_password
:
Arbitrary password which replica server should report to source;
not same as password for replication user account.
report_port
:
Port for connecting to replica reported to source during replica
registration.
report_user
:
Arbitrary user name which replica server should report to
source; not same as name used for replication user account.
Rpl_semi_sync_master_clients
:
Number of semisynchronous replicas.
rpl_semi_sync_master_enabled
:
Whether semisynchronous replication is enabled on source.
Rpl_semi_sync_master_net_avg_wait_time
:
Average time source has waited for replies from replica.
Rpl_semi_sync_master_net_wait_time
:
Total time source has waited for replies from replica.
Rpl_semi_sync_master_net_waits
:
Total number of times source waited for replies from replica.
Rpl_semi_sync_master_no_times
:
Number of times source turned off semisynchronous replication.
Rpl_semi_sync_master_no_tx
:
Number of commits not acknowledged successfully.
Rpl_semi_sync_master_status
:
Whether semisynchronous replication is operational on source.
Rpl_semi_sync_master_timefunc_failures
:
Number of times source failed when calling time functions.
rpl_semi_sync_master_timeout
:
Number of milliseconds to wait for replica acknowledgment.
rpl_semi_sync_master_trace_level
:
Semisynchronous replication debug trace level on source.
Rpl_semi_sync_master_tx_avg_wait_time
:
Average time source waited for each transaction.
Rpl_semi_sync_master_tx_wait_time
:
Total time source waited for transactions.
Rpl_semi_sync_master_tx_waits
:
Total number of times source waited for transactions.
rpl_semi_sync_master_wait_no_slave
:
Whether source waits for timeout even with no replicas.
Rpl_semi_sync_master_wait_pos_backtraverse
:
Total number of times source has waited for event with binary
coordinates lower than events waited for previously.
Rpl_semi_sync_master_wait_sessions
:
Number of sessions currently waiting for replica replies.
Rpl_semi_sync_master_yes_tx
:
Number of commits acknowledged successfully.
rpl_semi_sync_slave_enabled
:
Whether semisynchronous replication is enabled on replica.
Rpl_semi_sync_slave_status
:
Whether semisynchronous replication is operational on replica.
rpl_semi_sync_slave_trace_level
:
Semisynchronous replication debug trace level on replica.
rpl_stop_slave_timeout
:
Number of seconds that STOP REPLICA or STOP SLAVE waits before
timing out.
server_uuid
:
Server's globally unique ID, automatically (re)generated at
server start.
show-slave-auth-info
:
Show user name and password in SHOW REPLICAS and SHOW SLAVE
HOSTS on this source.
simplified_binlog_gtid_recovery
:
Renamed to binlog_gtid_simple_recovery.
skip-slave-start
:
If set, replication is not autostarted when replica server
starts.
slave_load_tmpdir
:
Location where replica should put its temporary files when
replicating LOAD DATA statements.
slave_net_timeout
:
Number of seconds to wait for more data from source/replica
connection before aborting read.
slave-skip-errors
:
Tells replication thread to continue replication when query
returns error from provided list.
slave_checkpoint_group
:
Maximum number of transactions processed by multithreaded
replica before checkpoint operation is called to update progress
status. Not supported by NDB Cluster.
slave_checkpoint_period
:
Update progress status of multithreaded replica and flush relay
log info to disk after this number of milliseconds. Not
supported by NDB Cluster.
slave_compressed_protocol
:
Use compression of source/replica protocol.
slave_exec_mode
:
Allows for switching replication thread between IDEMPOTENT mode
(key and some other errors suppressed) and STRICT mode; STRICT
mode is default, except for NDB Cluster, where IDEMPOTENT is
always used.
Slave_heartbeat_period
:
Replica's replication heartbeat interval, in seconds.
Slave_last_heartbeat
:
Shows when latest heartbeat signal was received, in TIMESTAMP
format.
slave_max_allowed_packet
:
Maximum size, in bytes, of packet that can be sent from
replication source server to replica; overrides
max_allowed_packet.
Slave_open_temp_tables
:
Number of temporary tables that replication SQL thread currently
has open.
slave_parallel_workers
:
Number of applier threads for executing replication transactions
in parallel. 0 disables replica multithreading. Not supported by
MySQL Cluster.
slave_pending_jobs_size_max
:
Maximum size of replica worker queues holding events not yet
applied.
Slave_received_heartbeats
:
Number of heartbeats received by replica since previous reset.
Slave_retried_transactions
:
Total number of times since startup that replication SQL thread
has retried transactions.
slave_rows_search_algorithms
:
Determines search algorithms used for replica update batching.
Any 2 or 3 from this list: INDEX_SEARCH, TABLE_SCAN, HASH_SCAN.
Slave_rows_last_search_algorithm_used
:
Search algorithm most recently used by this replica to locate
rows for row-based replication (index, table, or hash scan).
Slave_running
:
State of this server as replica (replication I/O thread status).
slave_transaction_retries
:
Number of times replication SQL thread retries transaction in
case it failed with deadlock or elapsed lock wait timeout,
before giving up and stopping.
slave_type_conversions
:
Controls type conversion mode on replica. Value is list of zero
or more elements from this list: ALL_LOSSY, ALL_NON_LOSSY. Set
to empty string to disallow type conversions between source and
replica.
sql_log_bin
:
Controls binary logging for current session.
sql_slave_skip_counter
:
Number of events from source that replica should skip. Not
compatible with GTID replication.
sync_master_info
:
Synchronize master.info to disk after every #th event.
sync_relay_log
:
Synchronize relay log to disk after every #th event.
sync_relay_log_info
:
Synchronize relay.info file to disk after every #th event.
For a listing of all command-line options, system variables, and status variables used with mysqld, see Section 5.1.3, “Server Option, System Variable, and Status Variable Reference”.
The command-line options and system variables in the following list relate to the binary log. Section 17.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.4.4, “The Binary Log”.
binlog-checksum
:
Enable/disable binary log checksums.
binlog-do-db
:
Limits binary logging to specific databases.
binlog_format
:
Specifies format of binary log.
binlog-ignore-db
:
Tells source that updates to given database should not be
written to binary log.
binlog-row-event-max-size
:
Binary log max event size.
Binlog_cache_disk_use
:
Number of transactions which used temporary file instead of
binary log cache.
binlog_cache_size
:
Size of cache to hold SQL statements for binary log during
transaction.
Binlog_cache_use
:
Number of transactions that used temporary binary log cache.
binlog_checksum
:
Enable/disable binary log checksums.
binlog_direct_non_transactional_updates
:
Causes updates using statement format to nontransactional
engines to be written directly to binary log. See documentation
before using.
binlog_error_action
:
Controls what happens when server cannot write to binary log.
binlog_max_flush_queue_time
:
How long to read transactions before flushing to binary log.
binlog_order_commits
:
Whether to commit in same order as writes to binary log.
binlog_row_image
:
Use full or minimal images when logging row changes.
binlog_rows_query_log_events
:
When enabled, enables logging of rows query log events when
using row-based logging. Disabled by default. Do not enable when
producing logs for pre-5.6 replicas/readers.
Binlog_stmt_cache_disk_use
:
Number of nontransactional statements that used temporary file
instead of binary log statement cache.
binlog_stmt_cache_size
:
Size of cache to hold nontransactional statements for binary log
during transaction.
Binlog_stmt_cache_use
:
Number of statements that used temporary binary log statement
cache.
binlogging_impossible_mode
:
Deprecated and later removed. Use binlog_error_action instead.
Com_show_binlog_events
:
Count of SHOW BINLOG EVENTS statements.
Com_show_binlogs
:
Count of SHOW BINLOGS statements.
log-bin
:
Base name for binary log files.
log-bin-index
:
Name of binary log index file.
log_bin
:
Whether binary log is enabled.
log_bin_basename
:
Path and base name for binary log files.
log_bin_use_v1_row_events
:
Whether server is using version 1 binary log row events.
log_slave_updates
:
Whether replica should log updates performed by its replication
SQL thread to its own binary log.
master_verify_checksum
:
Cause source to examine checksums when reading from binary log.
max-binlog-dump-events
:
Option used by mysql-test for debugging and testing of
replication.
max_binlog_cache_size
:
Can be used to restrict total size used to cache multi-statement
transaction.
max_binlog_size
:
Binary log is rotated automatically when size exceeds this
value.
max_binlog_stmt_cache_size
:
Can be used to restrict total size used to cache all
nontransactional statements during transaction.
slave-sql-verify-checksum
:
Cause replica to examine checksums when reading from relay log.
slave_sql_verify_checksum
:
Cause replica to examine checksums when reading from relay log.
sporadic-binlog-dump-fail
:
Option used by mysql-test for debugging and testing of
replication.
sync_binlog
:
Synchronously flush binary log to disk after every #th event.
For a listing of all command-line options, system and status variables used with mysqld, see Section 5.1.3, “Server Option, System Variable, and Status Variable Reference”.