<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="replication-options-reference">
      </a>
      19.1.6.1 Replication and Binary Logging Option and Variable Reference
     </h4>
    </div>
   </div>
  </div>
  <p>
   The following two sections provide basic information about the
      MySQL command-line options and system variables applicable to
      replication and the binary log.
  </p>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h5 class="title">
       <a name="replication-optvars-list">
       </a>
       Replication Options and Variables
      </h5>
     </div>
    </div>
   </div>
   <p>
    The command-line options and system variables in the following list
    relate to replication source servers and replicas.
    <a class="xref" href="replication-options-source.html" title="19.1.6.2 Replication Source Options and Variables">
     Section 19.1.6.2, “Replication Source Options and Variables”
    </a>
    provides more detailed
    information about options and variables relating to replication
    source servers. For more information about options and variables
    relating to replicas, see
    <a class="xref" href="replication-options-replica.html" title="19.1.6.3 Replica Server Options and Variables">
     Section 19.1.6.3, “Replica Server Options and Variables”
    </a>
    .
   </p>
   <div class="itemizedlist">
    <a name="replication-optvar-summary-list">
    </a>
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_auto_increment_increment">
         auto_increment_increment
        </a>
       </code>
       :
        AUTO_INCREMENT columns are incremented by this value.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_auto_increment_offset">
         auto_increment_offset
        </a>
       </code>
       :
        Offset added to AUTO_INCREMENT columns.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Com_xxx">
         Com_change_replication_source
        </a>
       </code>
       :
        Count of CHANGE REPLICATION SOURCE TO and CHANGE MASTER TO
        statements.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Com_xxx">
         Com_replica_start
        </a>
       </code>
       :
        Count of START REPLICA and START SLAVE statements.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Com_xxx">
         Com_replica_stop
        </a>
       </code>
       :
        Count of STOP REPLICA and STOP SLAVE statements.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Com_xxx">
         Com_show_binary_log_status
        </a>
       </code>
       :
        Count of SHOW BINARY LOG STATUS statements; use instead of
        Com_show_master_status.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Com_xxx">
         Com_show_replica_status
        </a>
       </code>
       :
        Count of SHOW REPLICA STATUS and SHOW SLAVE STATUS statements.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Com_xxx">
         Com_show_replicas
        </a>
       </code>
       :
        Count of SHOW REPLICAS and SHOW SLAVE HOSTS statements.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-gtids.html#sysvar_enforce_gtid_consistency">
         enforce_gtid_consistency
        </a>
       </code>
       :
        Prevents execution of statements that cannot be logged in
        transactionally safe manner.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-gtids.html#sysvar_gtid_executed">
         gtid_executed
        </a>
       </code>
       :
        Global: All GTIDs in binary log (global) or current transaction
        (session). Read-only.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-gtids.html#sysvar_gtid_executed_compression_period">
         gtid_executed_compression_period
        </a>
       </code>
       :
        Compress gtid_executed table each time this many transactions
        have occurred. 0 means never compress this table. Applies only
        when binary logging is disabled.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-gtids.html#sysvar_gtid_mode">
         gtid_mode
        </a>
       </code>
       :
        Controls whether GTID based logging is enabled and what type of
        transactions logs can contain.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-gtids.html#sysvar_gtid_next">
         gtid_next
        </a>
       </code>
       :
        Specifies GTID for subsequent transaction or transactions; see
        documentation for details.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-gtids.html#sysvar_gtid_owned">
         gtid_owned
        </a>
       </code>
       :
        Set of GTIDs owned by this client (session), or by all clients,
        together with thread ID of owner (global). Read-only.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-gtids.html#sysvar_gtid_purged">
         gtid_purged
        </a>
       </code>
       :
        Set of all GTIDs that have been purged from binary log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_immediate_server_version">
         immediate_server_version
        </a>
       </code>
       :
        MySQL Server release number of server which is immediate
        replication source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_init_replica">
         init_replica
        </a>
       </code>
       :
        Statements that are executed when replica connects to source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_init_slave">
         init_slave
        </a>
       </code>
       :
        Statements that are executed when replica connects to source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_log_bin_trust_function_creators">
         log_bin_trust_function_creators
        </a>
       </code>
       :
        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.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_log_statements_unsafe_for_binlog">
         log_statements_unsafe_for_binlog
        </a>
       </code>
       :
        Disables error 1592 warnings being written to error log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_master-retry-count">
         master-retry-count
        </a>
       </code>
       :
        Number of tries replica makes to connect to source before giving
        up.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_max_relay_log_size">
         max_relay_log_size
        </a>
       </code>
       :
        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.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_original_commit_timestamp">
         original_commit_timestamp
        </a>
       </code>
       :
        Time when transaction was committed on original source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_original_server_version">
         original_server_version
        </a>
       </code>
       :
        MySQL Server release number of server on which transaction was
        originally committed.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_relay_log">
         relay_log
        </a>
       </code>
       :
        Location and base name to use for relay logs.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_relay_log_basename">
         relay_log_basename
        </a>
       </code>
       :
        Complete path to relay log, including file name.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_relay_log_index">
         relay_log_index
        </a>
       </code>
       :
        Location and name to use for file that keeps list of last relay
        logs.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_relay_log_purge">
         relay_log_purge
        </a>
       </code>
       :
        Determines whether relay logs are purged.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_relay_log_recovery">
         relay_log_recovery
        </a>
       </code>
       :
        Whether automatic recovery of relay log files from source at
        startup is enabled; must be enabled for crash-safe replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_relay_log_space_limit">
         relay_log_space_limit
        </a>
       </code>
       :
        Maximum space to use for all relay logs.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_checkpoint_group">
         replica_checkpoint_group
        </a>
       </code>
       :
        Maximum number of transactions processed by multithreaded
        replica before checkpoint operation is called to update progress
        status. Not supported by NDB Cluster.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_checkpoint_period">
         replica_checkpoint_period
        </a>
       </code>
       :
        Update progress status of multithreaded replica and flush relay
        log info to disk after this number of milliseconds. Not
        supported by NDB Cluster.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_compressed_protocol">
         replica_compressed_protocol
        </a>
       </code>
       :
        Use compression of source/replica protocol.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_exec_mode">
         replica_exec_mode
        </a>
       </code>
       :
        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.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_load_tmpdir">
         replica_load_tmpdir
        </a>
       </code>
       :
        Location where replica should put its temporary files when
        replicating LOAD DATA statements.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_max_allowed_packet">
         replica_max_allowed_packet
        </a>
       </code>
       :
        Maximum size, in bytes, of packet that can be sent from
        replication source server to replica; overrides
        max_allowed_packet.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_net_timeout">
         replica_net_timeout
        </a>
       </code>
       :
        Number of seconds to wait for more data from source/replica
        connection before aborting read.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Replica_open_temp_tables">
         Replica_open_temp_tables
        </a>
       </code>
       :
        Number of temporary tables that replication SQL thread currently
        has open.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_parallel_type">
         replica_parallel_type
        </a>
       </code>
       :
        Tells replica to use timestamp information (LOGICAL_CLOCK) or
        database partitioning (DATABASE) to parallelize transactions.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_parallel_workers">
         replica_parallel_workers
        </a>
       </code>
       :
        Number of applier threads for executing replication
        transactions; when this is 0 or 1, there is only one applier
        thread. NDB Cluster: see documentation.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_pending_jobs_size_max">
         replica_pending_jobs_size_max
        </a>
       </code>
       :
        Maximum size of replica worker queues holding events not yet
        applied.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_preserve_commit_order">
         replica_preserve_commit_order
        </a>
       </code>
       :
        Ensures that all commits by replica workers happen in same order
        as on source to maintain consistency when using parallel applier
        threads.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_skip_errors">
         replica_skip_errors
        </a>
       </code>
       :
        Tells replication thread to continue replication when query
        returns error from provided list.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_transaction_retries">
         replica_transaction_retries
        </a>
       </code>
       :
        Number of times replication SQL thread retries transaction in
        case it failed with deadlock or elapsed lock wait timeout,
        before giving up and stopping.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_type_conversions">
         replica_type_conversions
        </a>
       </code>
       :
        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.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_replicate-do-db">
         replicate-do-db
        </a>
       </code>
       :
        Tells replication SQL thread to restrict replication to
        specified database.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_replicate-do-table">
         replicate-do-table
        </a>
       </code>
       :
        Tells replication SQL thread to restrict replication to
        specified table.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_replicate-ignore-db">
         replicate-ignore-db
        </a>
       </code>
       :
        Tells replication SQL thread not to replicate to specified
        database.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_replicate-ignore-table">
         replicate-ignore-table
        </a>
       </code>
       :
        Tells replication SQL thread not to replicate to specified
        table.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_replicate-rewrite-db">
         replicate-rewrite-db
        </a>
       </code>
       :
        Updates to database with different name from original.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_replicate-same-server-id">
         replicate-same-server-id
        </a>
       </code>
       :
        In replication, if enabled, do not skip events having our server
        id.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_replicate-wild-do-table">
         replicate-wild-do-table
        </a>
       </code>
       :
        Tells replication SQL thread to restrict replication to tables
        that match specified wildcard pattern.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_replicate-wild-ignore-table">
         replicate-wild-ignore-table
        </a>
       </code>
       :
        Tells replication SQL thread not to replicate to tables that
        match given wildcard pattern.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replication_optimize_for_static_plugin_config">
         replication_optimize_for_static_plugin_config
        </a>
       </code>
       :
        Shared locks for semisynchronous replication.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replication_sender_observe_commit_only">
         replication_sender_observe_commit_only
        </a>
       </code>
       :
        Limited callbacks for semisynchronous replication.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_report_host">
         report_host
        </a>
       </code>
       :
        Host name or IP of replica to be reported to source during
        replica registration.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_report_password">
         report_password
        </a>
       </code>
       :
        Arbitrary password which replica server should report to source;
        not same as password for replication user account.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_report_port">
         report_port
        </a>
       </code>
       :
        Port for connecting to replica reported to source during replica
        registration.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_report_user">
         report_user
        </a>
       </code>
       :
        Arbitrary user name which replica server should report to
        source; not same as name used for replication user account.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_rpl_read_size">
         rpl_read_size
        </a>
       </code>
       :
        Set minimum amount of data in bytes which is read from binary
        log files and relay log files.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_clients">
         Rpl_semi_sync_master_clients
        </a>
       </code>
       :
        Number of semisynchronous replicas.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_master_enabled">
         rpl_semi_sync_master_enabled
        </a>
       </code>
       :
        Whether semisynchronous replication is enabled on source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_net_avg_wait_time">
         Rpl_semi_sync_master_net_avg_wait_time
        </a>
       </code>
       :
        Average time source has waited for replies from replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_net_wait_time">
         Rpl_semi_sync_master_net_wait_time
        </a>
       </code>
       :
        Total time source has waited for replies from replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_net_waits">
         Rpl_semi_sync_master_net_waits
        </a>
       </code>
       :
        Total number of times source waited for replies from replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_no_times">
         Rpl_semi_sync_master_no_times
        </a>
       </code>
       :
        Number of times source turned off semisynchronous replication.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_no_tx">
         Rpl_semi_sync_master_no_tx
        </a>
       </code>
       :
        Number of commits not acknowledged successfully.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_status">
         Rpl_semi_sync_master_status
        </a>
       </code>
       :
        Whether semisynchronous replication is operational on source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_timefunc_failures">
         Rpl_semi_sync_master_timefunc_failures
        </a>
       </code>
       :
        Number of times source failed when calling time functions.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_master_timeout">
         rpl_semi_sync_master_timeout
        </a>
       </code>
       :
        Number of milliseconds to wait for replica acknowledgment.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_master_trace_level">
         rpl_semi_sync_master_trace_level
        </a>
       </code>
       :
        Semisynchronous replication debug trace level on source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_tx_avg_wait_time">
         Rpl_semi_sync_master_tx_avg_wait_time
        </a>
       </code>
       :
        Average time source waited for each transaction.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_tx_wait_time">
         Rpl_semi_sync_master_tx_wait_time
        </a>
       </code>
       :
        Total time source waited for transactions.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_tx_waits">
         Rpl_semi_sync_master_tx_waits
        </a>
       </code>
       :
        Total number of times source waited for transactions.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_master_wait_for_slave_count">
         rpl_semi_sync_master_wait_for_slave_count
        </a>
       </code>
       :
        Number of replica acknowledgments source must receive per
        transaction before proceeding.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_master_wait_no_slave">
         rpl_semi_sync_master_wait_no_slave
        </a>
       </code>
       :
        Whether source waits for timeout even with no replicas.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_master_wait_point">
         rpl_semi_sync_master_wait_point
        </a>
       </code>
       :
        Wait point for replica transaction receipt acknowledgment.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_wait_pos_backtraverse">
         Rpl_semi_sync_master_wait_pos_backtraverse
        </a>
       </code>
       :
        Total number of times source has waited for event with binary
        coordinates lower than events waited for previously.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_wait_sessions">
         Rpl_semi_sync_master_wait_sessions
        </a>
       </code>
       :
        Number of sessions currently waiting for replica replies.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_yes_tx">
         Rpl_semi_sync_master_yes_tx
        </a>
       </code>
       :
        Number of commits acknowledged successfully.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_rpl_semi_sync_replica_enabled">
         rpl_semi_sync_replica_enabled
        </a>
       </code>
       :
        Whether semisynchronous replication is enabled on replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_replica_status">
         Rpl_semi_sync_replica_status
        </a>
       </code>
       :
        Whether semisynchronous replication is operational on replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_rpl_semi_sync_replica_trace_level">
         rpl_semi_sync_replica_trace_level
        </a>
       </code>
       :
        Semisynchronous replication debug trace level on replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_rpl_semi_sync_slave_enabled">
         rpl_semi_sync_slave_enabled
        </a>
       </code>
       :
        Whether semisynchronous replication is enabled on replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_slave_status">
         Rpl_semi_sync_slave_status
        </a>
       </code>
       :
        Whether semisynchronous replication is operational on replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_rpl_semi_sync_slave_trace_level">
         rpl_semi_sync_slave_trace_level
        </a>
       </code>
       :
        Semisynchronous replication debug trace level on replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_clients">
         Rpl_semi_sync_source_clients
        </a>
       </code>
       :
        Number of semisynchronous replicas.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_source_enabled">
         rpl_semi_sync_source_enabled
        </a>
       </code>
       :
        Whether semisynchronous replication is enabled on source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_net_avg_wait_time">
         Rpl_semi_sync_source_net_avg_wait_time
        </a>
       </code>
       :
        Average time source has waited for replies from replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_net_wait_time">
         Rpl_semi_sync_source_net_wait_time
        </a>
       </code>
       :
        Total time source has waited for replies from replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_net_waits">
         Rpl_semi_sync_source_net_waits
        </a>
       </code>
       :
        Total number of times source waited for replies from replica.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_no_times">
         Rpl_semi_sync_source_no_times
        </a>
       </code>
       :
        Number of times source turned off semisynchronous replication.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_no_tx">
         Rpl_semi_sync_source_no_tx
        </a>
       </code>
       :
        Number of commits not acknowledged successfully.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_status">
         Rpl_semi_sync_source_status
        </a>
       </code>
       :
        Whether semisynchronous replication is operational on source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_timefunc_failures">
         Rpl_semi_sync_source_timefunc_failures
        </a>
       </code>
       :
        Number of times source failed when calling time functions.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_source_timeout">
         rpl_semi_sync_source_timeout
        </a>
       </code>
       :
        Number of milliseconds to wait for replica acknowledgment.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_source_trace_level">
         rpl_semi_sync_source_trace_level
        </a>
       </code>
       :
        Semisynchronous replication debug trace level on source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_tx_avg_wait_time">
         Rpl_semi_sync_source_tx_avg_wait_time
        </a>
       </code>
       :
        Average time source waited for each transaction.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_tx_wait_time">
         Rpl_semi_sync_source_tx_wait_time
        </a>
       </code>
       :
        Total time source waited for transactions.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_tx_waits">
         Rpl_semi_sync_source_tx_waits
        </a>
       </code>
       :
        Total number of times source waited for transactions.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_source_wait_for_replica_count">
         rpl_semi_sync_source_wait_for_replica_count
        </a>
       </code>
       :
        Number of replica acknowledgments source must receive per
        transaction before proceeding.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_source_wait_no_replica">
         rpl_semi_sync_source_wait_no_replica
        </a>
       </code>
       :
        Whether source waits for timeout even with no replicas.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#sysvar_rpl_semi_sync_source_wait_point">
         rpl_semi_sync_source_wait_point
        </a>
       </code>
       :
        Wait point for replica transaction receipt acknowledgment.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_wait_pos_backtraverse">
         Rpl_semi_sync_source_wait_pos_backtraverse
        </a>
       </code>
       :
        Total number of times source has waited for event with binary
        coordinates lower than events waited for previously.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_wait_sessions">
         Rpl_semi_sync_source_wait_sessions
        </a>
       </code>
       :
        Number of sessions currently waiting for replica replies.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_yes_tx">
         Rpl_semi_sync_source_yes_tx
        </a>
       </code>
       :
        Number of commits acknowledged successfully.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_rpl_stop_replica_timeout">
         rpl_stop_replica_timeout
        </a>
       </code>
       :
        Number of seconds that STOP REPLICA waits before timing out.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_rpl_stop_slave_timeout">
         rpl_stop_slave_timeout
        </a>
       </code>
       :
        Number of seconds that STOP REPLICA or STOP SLAVE waits before
        timing out.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options.html#sysvar_server_uuid">
         server_uuid
        </a>
       </code>
       :
        Server's globally unique ID, automatically (re)generated at
        server start.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#option_mysqld_show-replica-auth-info">
         show-replica-auth-info
        </a>
       </code>
       :
        Show user name and password in SHOW REPLICAS on this source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-source.html#option_mysqld_show-slave-auth-info">
         show-slave-auth-info
        </a>
       </code>
       :
        Show user name and password in SHOW REPLICAS and SHOW SLAVE
        HOSTS on this source.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_skip-replica-start">
         skip-replica-start
        </a>
       </code>
       :
        If set, replication is not autostarted when replica server
        starts.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_skip-slave-start">
         skip-slave-start
        </a>
       </code>
       :
        If set, replication is not autostarted when replica server
        starts.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_slave-skip-errors">
         slave-skip-errors
        </a>
       </code>
       :
        Tells replication thread to continue replication when query
        returns error from provided list.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_checkpoint_group">
         slave_checkpoint_group
        </a>
       </code>
       :
        Maximum number of transactions processed by multithreaded
        replica before checkpoint operation is called to update progress
        status. Not supported by NDB Cluster.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_checkpoint_period">
         slave_checkpoint_period
        </a>
       </code>
       :
        Update progress status of multithreaded replica and flush relay
        log info to disk after this number of milliseconds. Not
        supported by NDB Cluster.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_compressed_protocol">
         slave_compressed_protocol
        </a>
       </code>
       :
        Use compression of source/replica protocol.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_exec_mode">
         slave_exec_mode
        </a>
       </code>
       :
        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.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_load_tmpdir">
         slave_load_tmpdir
        </a>
       </code>
       :
        Location where replica should put its temporary files when
        replicating LOAD DATA statements.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_max_allowed_packet">
         slave_max_allowed_packet
        </a>
       </code>
       :
        Maximum size, in bytes, of packet that can be sent from
        replication source server to replica; overrides
        max_allowed_packet.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_net_timeout">
         slave_net_timeout
        </a>
       </code>
       :
        Number of seconds to wait for more data from source/replica
        connection before aborting read.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Slave_open_temp_tables">
         Slave_open_temp_tables
        </a>
       </code>
       :
        Number of temporary tables that replication SQL thread currently
        has open.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_parallel_type">
         slave_parallel_type
        </a>
       </code>
       :
        Tells replica to use timestamp information (LOGICAL_CLOCK) or
        database partioning (DATABASE) to parallelize transactions.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_parallel_workers">
         slave_parallel_workers
        </a>
       </code>
       :
        Number of applier threads for executing replication transactions
        in parallel; 0 or 1 disables replica multithreading. NDB
        Cluster: see documentation.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_pending_jobs_size_max">
         slave_pending_jobs_size_max
        </a>
       </code>
       :
        Maximum size of replica worker queues holding events not yet
        applied.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_preserve_commit_order">
         slave_preserve_commit_order
        </a>
       </code>
       :
        Ensures that all commits by replica workers happen in same order
        as on source to maintain consistency when using parallel applier
        threads.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Slave_rows_last_search_algorithm_used">
         Slave_rows_last_search_algorithm_used
        </a>
       </code>
       :
        Search algorithm most recently used by this replica to locate
        rows for row-based replication (index, table, or hash scan).
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_transaction_retries">
         slave_transaction_retries
        </a>
       </code>
       :
        Number of times replication SQL thread retries transaction in
        case it failed with deadlock or elapsed lock wait timeout,
        before giving up and stopping.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_type_conversions">
         slave_type_conversions
        </a>
       </code>
       :
        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.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_sql_log_bin">
         sql_log_bin
        </a>
       </code>
       :
        Controls binary logging for current session.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_sql_replica_skip_counter">
         sql_replica_skip_counter
        </a>
       </code>
       :
        Number of events from source that replica should skip. Not
        compatible with GTID replication.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_sql_slave_skip_counter">
         sql_slave_skip_counter
        </a>
       </code>
       :
        Number of events from source that replica should skip. Not
        compatible with GTID replication.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_sync_master_info">
         sync_master_info
        </a>
       </code>
       :
        Synchronize source information after every #th event.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_sync_relay_log">
         sync_relay_log
        </a>
       </code>
       :
        Synchronize relay log to disk after every #th event.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_sync_relay_log_info">
         sync_relay_log_info
        </a>
       </code>
       :
        Synchronize relay.info file to disk after every #th event.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_sync_source_info">
         sync_source_info
        </a>
       </code>
       :
        Synchronize source information after every #th event.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_terminology_use_previous">
         terminology_use_previous
        </a>
       </code>
       :
        Use terminology from before specified version where changes are
        incompatible.
      </p>
     </li>
    </ul>
   </div>
   <p>
    For a listing of all command-line options, system variables, and
    status variables used with
    <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
     <span class="command">
      <strong>
       mysqld
      </strong>
     </span>
    </a>
    , see
    <a class="xref" href="server-option-variable-reference.html" title="7.1.4 Server Option, System Variable, and Status Variable Reference">
     Section 7.1.4, “Server Option, System Variable, and Status Variable Reference”
    </a>
    .
   </p>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h5 class="title">
       <a name="binlog-optvars-list">
       </a>
       Binary Logging Options and Variables
      </h5>
     </div>
    </div>
   </div>
   <p>
    The command-line options and system variables in the following list
    relate to the binary log.
    <a class="xref" href="replication-options-binary-log.html" title="19.1.6.4 Binary Logging Options and Variables">
     Section 19.1.6.4, “Binary Logging Options and Variables”
    </a>
    , provides more
    detailed information about options and variables relating to binary
    logging. For additional general information about the binary log,
    see
    <a class="xref" href="binary-log.html" title="7.4.4 The Binary Log">
     Section 7.4.4, “The Binary Log”
    </a>
    .
   </p>
   <div class="itemizedlist">
    <a name="binlog-optvar-summary-list">
    </a>
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#option_mysqld_binlog-checksum">
         binlog-checksum
        </a>
       </code>
       :
        Enable or disable binary log checksums.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#option_mysqld_binlog-do-db">
         binlog-do-db
        </a>
       </code>
       :
        Limits binary logging to specific databases.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#option_mysqld_binlog-ignore-db">
         binlog-ignore-db
        </a>
       </code>
       :
        Tells source that updates to given database should not be
        written to binary log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#option_mysqld_binlog-row-event-max-size">
         binlog-row-event-max-size
        </a>
       </code>
       :
        Binary log max event size.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Binlog_cache_disk_use">
         Binlog_cache_disk_use
        </a>
       </code>
       :
        Number of transactions which used temporary file instead of
        binary log cache.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_cache_size">
         binlog_cache_size
        </a>
       </code>
       :
        Size of cache to hold SQL statements for binary log during
        transaction.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Binlog_cache_use">
         Binlog_cache_use
        </a>
       </code>
       :
        Number of transactions that used temporary binary log cache.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_checksum">
         binlog_checksum
        </a>
       </code>
       :
        Enable or disable binary log checksums.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_direct_non_transactional_updates">
         binlog_direct_non_transactional_updates
        </a>
       </code>
       :
        Causes updates using statement format to nontransactional
        engines to be written directly to binary log. See documentation
        before using.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_encryption">
         binlog_encryption
        </a>
       </code>
       :
        Enable encryption for binary log files and relay log files on
        this server.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_error_action">
         binlog_error_action
        </a>
       </code>
       :
        Controls what happens when server cannot write to binary log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_expire_logs_auto_purge">
         binlog_expire_logs_auto_purge
        </a>
       </code>
       :
        Controls automatic purging of binary log files; can be
        overridden when enabled, by setting both
        binlog_expire_logs_seconds and expire_logs_days to 0.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_expire_logs_seconds">
         binlog_expire_logs_seconds
        </a>
       </code>
       :
        Purge binary logs after this many seconds.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_format">
         binlog_format
        </a>
       </code>
       :
        Specifies format of binary log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_group_commit_sync_delay">
         binlog_group_commit_sync_delay
        </a>
       </code>
       :
        Sets number of microseconds to wait before synchronizing
        transactions to disk.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_group_commit_sync_no_delay_count">
         binlog_group_commit_sync_no_delay_count
        </a>
       </code>
       :
        Sets maximum number of transactions to wait for before aborting
        current delay specified by binlog_group_commit_sync_delay.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-gtids.html#sysvar_binlog_gtid_simple_recovery">
         binlog_gtid_simple_recovery
        </a>
       </code>
       :
        Controls how binary logs are iterated during GTID recovery.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_max_flush_queue_time">
         binlog_max_flush_queue_time
        </a>
       </code>
       :
        How long to read transactions before flushing to binary log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_order_commits">
         binlog_order_commits
        </a>
       </code>
       :
        Whether to commit in same order as writes to binary log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_rotate_encryption_master_key_at_startup">
         binlog_rotate_encryption_master_key_at_startup
        </a>
       </code>
       :
        Rotate binary log master key at server startup.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_row_image">
         binlog_row_image
        </a>
       </code>
       :
        Use full or minimal images when logging row changes.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_row_metadata">
         binlog_row_metadata
        </a>
       </code>
       :
        Whether to record all or only minimal table related metadata to
        binary log when using row-based logging.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_row_value_options">
         binlog_row_value_options
        </a>
       </code>
       :
        Enables binary logging of partial JSON updates for row-based
        replication.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_rows_query_log_events">
         binlog_rows_query_log_events
        </a>
       </code>
       :
        When enabled, enables logging of rows query log events when
        using row-based logging. Disabled by default..
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Binlog_stmt_cache_disk_use">
         Binlog_stmt_cache_disk_use
        </a>
       </code>
       :
        Number of nontransactional statements that used temporary file
        instead of binary log statement cache.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_stmt_cache_size">
         binlog_stmt_cache_size
        </a>
       </code>
       :
        Size of cache to hold nontransactional statements for binary log
        during transaction.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Binlog_stmt_cache_use">
         Binlog_stmt_cache_use
        </a>
       </code>
       :
        Number of statements that used temporary binary log statement
        cache.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_transaction_compression">
         binlog_transaction_compression
        </a>
       </code>
       :
        Enable compression for transaction payloads in binary log files.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_transaction_compression_level_zstd">
         binlog_transaction_compression_level_zstd
        </a>
       </code>
       :
        Compression level for transaction payloads in binary log files.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_binlog_transaction_dependency_history_size">
         binlog_transaction_dependency_history_size
        </a>
       </code>
       :
        Number of row hashes kept for looking up transaction that last
        updated some row.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Com_xxx">
         Com_show_binlog_events
        </a>
       </code>
       :
        Count of SHOW BINLOG EVENTS statements.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="server-status-variables.html#statvar_Com_xxx">
         Com_show_binlogs
        </a>
       </code>
       :
        Count of SHOW BINLOGS statements.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#option_mysqld_log-bin">
         log-bin
        </a>
       </code>
       :
        Base name for binary log files.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#option_mysqld_log-bin-index">
         log-bin-index
        </a>
       </code>
       :
        Name of binary log index file.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_log_bin">
         log_bin
        </a>
       </code>
       :
        Whether binary log is enabled.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_log_bin_basename">
         log_bin_basename
        </a>
       </code>
       :
        Path and base name for binary log files.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_log_replica_updates">
         log_replica_updates
        </a>
       </code>
       :
        Whether replica should log updates performed by its replication
        SQL thread to its own binary log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_log_slave_updates">
         log_slave_updates
        </a>
       </code>
       :
        Whether replica should log updates performed by its replication
        SQL thread to its own binary log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_master_verify_checksum">
         master_verify_checksum
        </a>
       </code>
       :
        Cause source to examine checksums when reading from binary log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#option_mysqld_max-binlog-dump-events">
         max-binlog-dump-events
        </a>
       </code>
       :
        Option used by mysql-test for debugging and testing of
        replication.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_max_binlog_cache_size">
         max_binlog_cache_size
        </a>
       </code>
       :
        Can be used to restrict total size in bytes used to cache
        multi-statement transactions.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_max_binlog_size">
         max_binlog_size
        </a>
       </code>
       :
        Binary log is rotated automatically when size exceeds this
        value.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_max_binlog_stmt_cache_size">
         max_binlog_stmt_cache_size
        </a>
       </code>
       :
        Can be used to restrict total size used to cache all
        nontransactional statements during transaction.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_replica_sql_verify_checksum">
         replica_sql_verify_checksum
        </a>
       </code>
       :
        Cause replica to examine checksums when reading from relay log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#option_mysqld_slave-sql-verify-checksum">
         slave-sql-verify-checksum
        </a>
       </code>
       :
        Cause replica to examine checksums when reading from relay log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-replica.html#sysvar_slave_sql_verify_checksum">
         slave_sql_verify_checksum
        </a>
       </code>
       :
        Cause replica to examine checksums when reading from relay log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_source_verify_checksum">
         source_verify_checksum
        </a>
       </code>
       :
        Cause source to examine checksums when reading from binary log.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#option_mysqld_sporadic-binlog-dump-fail">
         sporadic-binlog-dump-fail
        </a>
       </code>
       :
        Option used by mysql-test for debugging and testing of
        replication.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        <a class="link" href="replication-options-binary-log.html#sysvar_sync_binlog">
         sync_binlog
        </a>
       </code>
       :
        Synchronously flush binary log to disk after every #th event.
      </p>
     </li>
    </ul>
   </div>
   <p>
    For a listing of all command-line options, system and status
    variables used with
    <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
     <span class="command">
      <strong>
       mysqld
      </strong>
     </span>
    </a>
    , see
    <a class="xref" href="server-option-variable-reference.html" title="7.1.4 Server Option, System Variable, and Status Variable Reference">
     Section 7.1.4, “Server Option, System Variable, and Status Variable Reference”
    </a>
    .
   </p>
  </div>
 </div>
 <br/>
</div>
