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

Improve times and states in show processlist for replication

    XMLWordPrintable

Details

    Description

      This shows a typical 'show processlist' when using replication

      | 6 | system user |...| Slave_IO     | 177806 | Waiting for master to send event
      | 8 | system user |...| Slave_worker |      0 | Waiting for prior transaction to commit
      | 9 | system user |...| Slave_worker |      0 | closing tables
      | 7 | system user |...| Slave_SQL    |    259 | Waiting for room in worker thread event queue
      

      There is a couple of problems with the above result:

      • Slave_IO shows the time since SLAVE START, not the time it has been waiting for the master
      • Slave_worker's often have a state 'closing tables', because closing_tables() does not
        revert back to previous state when it is done. This gives a wrong impression of what the Slave_worker is doing.
      • Slave_SQL has a wrong (random time). A better time would be how long it has been waiting for the event.

      Slave_worker threads also does not show if they are waiting for commit or rollback.

      The purpose of this task is to correct the times, fix 'closing tables' and add stages for commit and rollback.

      Attachments

        Activity

          People

            monty Michael Widenius
            monty Michael Widenius
            Votes:
            1 Vote for this issue
            Watchers:
            6 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.