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

Optimize mysql.gtid_slave_pos Update for Worker Threads

    XMLWordPrintable

Details

    Description

      The mysql.gtid_slave_pos table is used for crash recovery on slaves. It is updated for each commit with the GTID of the committing transaction. However, for slaves with the binary log enabled, we can just scan the binary log to know the GTID state of the slave. This will speed the slave execution up because it will remove an insert per-transaction.

      Attachments

        Activity

          People

            Unassigned Unassigned
            bnestere Brandon Nesterenko
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.