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

Optimize mysql.gtid_slave_pos Update for Worker Threads

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Replication
    • None

    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

        Issue Links

          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-37582 Reduce Slave Lag

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Activity

            People

              Unassigned Unassigned
              bnestere Brandon Nesterenko
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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