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

Optimize write to binlog

    XMLWordPrintable

Details

    Description

      The current "legacy" method of writing transactions to binlog involves per-event actions, dealing with changes in the event header, which can be optimized away.

      In particular the event checksum can be computed as early as at ctor and the binlog write be done with one cache-to-cache copy.

      Expected performance gain may vary, and may need to estimated before taking on implementation, but intuitively it looks to be greater for small event size transactions.

      Attachments

        1. OLTP-MDEV-31273-cheetah02.pdf
          33 kB
          Axel Schwenke
        2. OLTP-MDEV-31273-g5.2.pdf
          25 kB
          Axel Schwenke
        3. OLTP-MDEV-31273-g5.pdf
          32 kB
          Axel Schwenke
        4. test_binlog_checksum_precompute_stall.pl
          2 kB
          Kristian Nielsen

        Issue Links

          Activity

            People

              knielsen Kristian Nielsen
              Elkin Andrei Elkin
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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