Replication and Binary Logging Options and Variables • slave_pending_jobs_size_max : Maximum size of replica worker queues holding events not yet applied. • slave_preserve_commit_order : Ensures that all commits by replica workers happen in same order as on source to maintain consistency when using parallel applier threads. • 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_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. • transaction_write_set_extraction : Defines algorithm used to hash writes extracted during transaction. For a listing of all command-line options, system variables, and status variables used with  mysqld , see Section 5.1.4, “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.6.4, “Binary Logging 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” . Binary Logging Options and Variables • 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_encryption : Enable encryption for binary log files and relay log files on this server. • binlog_rotate_encryption_master_key_at_startup : Rotate binary log master key at server startup. • Binlog_cache_disk_use : Number of transactions which used temporary file instead of binary log cache. 3494