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

Add statuses about optimistic parallel replication stalls.

    XMLWordPrintable

Details

    • 10.1.21, 10.1.29, 10.1.30, 10.1.32

    Description

      Hi,

      from the documentation [1], I can read:

      Non-transactional DML and DDL is not safe to optimistically apply in parallel, as it cannot be rolled back in case of conflicts. Thus, in optimistic mode, non-transactional (such as MyISAM) updates are not applied in parallel with earlier events (it is however possible to apply a MyISAM update in parallel with a later InnoDB update). DDL statements are not applied in parallel with any other transactions, earlier or later.

      [1]: https://mariadb.com/kb/en/mariadb/parallel-replication/

      It would be very helpful to have slave-side counters (statuses) for both of those non-transnational updates and DDL statements. This would allow to see if optimistic parallel replication is slowed-down by non-transnational updates and DDL statements.

      Many thanks,

      JFG

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            jeanfrancois.gagne Jean-François Gagné
            Votes:
            2 Vote for this issue
            Watchers:
            11 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.