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

Add statuses about optimistic parallel replication stalls.

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

          Transition Time In Source Status Execution Times
          Valerii Kravchuk made transition -
          Open Confirmed
          3d 5h 52m 1
          Sachin Setiya (Inactive) made transition -
          Confirmed In Progress
          127d 13h 49m 1
          Sachin Setiya (Inactive) made transition -
          Stalled In Progress
          44d 19h 23m 1
          Sachin Setiya (Inactive) made transition -
          In Progress In Review
          5d 4h 1m 2
          Andrei Elkin made transition -
          In Review Stalled
          415d 4h 53m 2
          Sachin Setiya (Inactive) made transition -
          Stalled Closed
          5d 19h 58m 1

          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.