Replication and Binary Logging Options and Variables • 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_group_commit_sync_delay : Sets number of microseconds to wait before synchronizing transactions to disk. • binlog_group_commit_sync_no_delay_count : Sets maximum number of transactions to wait for before aborting current delay specified by binlog_group_commit_sync_delay. • 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_row_metadata : Whether to record all or only minimal table related metadata to binary log when using row-based logging. • binlog_row_value_options : Enables binary logging of partial JSON updates for row-based replication. • 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. • binlog_transaction_compression : Enable compression for transaction payloads in binary log files. • binlog_transaction_compression_level_zstd : Compression level for transaction payloads in binary log files. • binlog_transaction_dependency_tracking : Source of dependency information (commit timestamps or transaction write sets) from which to assess which transactions can be executed in parallel by replica’s multithreaded applier. • binlog_transaction_dependency_history_size : Number of row hashes kept for looking up transaction that last updated some row. • 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. 3495