5.2 Binary Logs Configuration Metrics

Lists the Binary Logs configuration metrics and provides a brief description of each.

Table 5.1 Binary Logs Configuration Metrics

NameDescription
Binlog Cache Size (Total)The size of the cache to hold changes to the binary log during a transaction. A binary log cache is allocated for each client if the server supports any transactional storage engines and if the server has the binary log enabled.
Binlog Checksum (Total)Causes the master to write checksums for events written to the binary log. Set to NONE to disable, or the name of the algorithm to be used for generating checksums; currently, only CRC32 checksums are supported.
Binlog Direct Non Transactional Updates Enabled (Total)Causes updates to nontransactional tables to be written directly to the binary log, rather than to the transaction cache.
Binlog Do DB (Total)Whether the MySQL server is currently only filtering binary log updates to specific databases only.
Binlog Format (Total)This variable sets the binary logging format, and can be any one of STATEMENT, ROW, or MIXED.
Binlog Ignore DB (Total)Whether the MySQL server is currently ignoring updates to the binary log for specific databases.
Binlog Max Flush Queue Time (Total)How long in microseconds to keep reading transactions from the flush queue before proceeding with the group commit (and syncing the log to disk, if sync_binlog is greater than 0). If the value is 0 (the default), there is no timeout and the server keeps reading new transactions until the queue is empty.
Binlog Order Commits Enabled (Total)If this variable is enabled (the default), transactions are committed in the same order they are written to the binary log. If disabled, transactions may be committed in parallel. In some cases, disabling this variable might produce a performance increment.
Binlog Row Image (Total)When using ROW based or MIXED binary logging, whether to log the full before - pre change - image of the row, or a minimial image of the row if possible (given a unique key on the table), or to only exclude BLOB/TEXT columns from the before image of the row.
Binlog Rows Query Log Events Enabled (Total)Causes the server to write informational log events such as row query log events into its binary log. This information can be used for debugging and related purposes; such as obtaining the original query issued on the master when it cannot be reconstructed from the row updates.
Binlog Stmt Cache Size (Total)Determines the size of the cache for the binary log to hold nontransactional statements issued during a transaction. Separate binary log transaction and statement caches are allocated for each client if the server supports any transactional storage engines and if the server has the binary log enabled.
Binlog Trusts Function Creators Enabled (Total)This variable applies when binary logging is enabled and controls whether stored function creators can be trusted not to create stored functions that will cause unsafe events to be written to the binary log.
Expire Logs Days (Total)The number of days for automatic binary log file removal.
Log Bin Basename (Total)Holds the name and complete path to the binary log file.
Log Bin Enabled (Total)Whether the binary log is enabled.
Log Bin Index (Total)The index file for binary log file names.
Log Bin Use V1 Row Events Enabled (Total)Version 2 binary log row events are used by default beginning with MySQL Cluster NDB 7.2.1; however, Version 2 events cannot be read by previous MySQL Cluster releases. Setting --log-bin-use-v1-row-events to 1 causes mysqld to write the binary log using Version 1 logging events, which is the only version of binary log events used in previous releases, and thus produce binary logs that can be read by older slaves.
Max Binlog Cache Size (Total)If a transaction requires more than this many bytes of memory, the server generates a Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage error.
Max Binlog Size (Total)If a write to the binary log causes the current log file size to exceed the value of this variable, the server rotates the binary logs.
Max Binlog Stmt Cache Size (Total)If nontransactional statements within a transaction require more than this many bytes of memory, the server generates an error. max_binlog_stmt_cache_size sets the size for the statement cache only; the upper limit for the transaction cache is governed exclusively by the max_binlog_cache_size system variable.
SQL Log Bin Enabled (Total)If disabled, no logging is done to the binary log for the client.
Sync Binlog (Total)If the value of this variable is greater than 0, the MySQL server synchronizes its binary log to disk (using fdatasync()) after every sync_binlog writes to the binary log.