Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37590

Large Transactions to use Statement Binlog Format

    XMLWordPrintable

Details

    Description

      When replicating large transactions with binlog_format=MIXED, the server will always try to binlog using ROW format because it is safer. However, for large transactions, this can result in significant overheads, e.g. when writing the event data to disk or sending the event data to the slave. This can be optimized with some configurable threshold which would force the slave to log the transaction using STATEMENT binlog format instead.

      Attachments

        Activity

          People

            monty Michael Widenius
            bnestere Brandon Nesterenko
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 5d
                5d
                Remaining:
                Remaining Estimate - 5d
                5d
                Logged:
                Time Spent - Not Specified
                Not Specified

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.