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

strict round-robin scheduling of XA events to improve parallel slave performance

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Won't Do
    • 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4, 11.5(EOL)
    • N/A
    • Replication, XA
    • None

    Description

      This ticket aims to advance the optimistic parallel slave performance with
      allowing the XA-PREPARE:d part of an XA transaction be executed potentially in parallel with XA-COMMIT (ROLLBACK).
      While the two are being executed in parallel there should be guaranteed that

      • XA-COMMIT can't race first to the XA transaction xid,
      • it may in some "unlikely" cases wait for xid release, as well as
      • duplicate xid XA events are handled correctly.

      Currently bb-10.6-MDEV-31949_ver0_opt branch holds this type of solution.
      https://github.com/MariaDB/server/commits/bb-10.6-MDEV-31949_ver0_opt/

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33673 Parallel replica threads lockup when using many XA threads in bb-10.6-MDEV-31949_ver0

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33673 Parallel replica threads lockup when using many XA threads in bb-10.6-MDEV-31949_ver0

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          split from

          New Feature - A new feature of the product, which has yet to be developed. MDEV-31949 slow parallel replication of user xa

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

          Activity

            Ascending order - Click to sort in descending order
            Elkin Andrei Elkin added a comment - - edited

            This ticket is filed by monty 's request. It duplicates MENT-1905 for the CS.

            Elkin Andrei Elkin added a comment - - edited This ticket is filed by monty 's request. It duplicates MENT-1905 for the CS.
            Elkin Andrei Elkin added a comment -

            knielsen fyi.

            Elkin Andrei Elkin added a comment - knielsen fyi.
            Roel Roel Van de Paar added a comment - - edited

            Created MDEV-33673 Parallel replica threads lockup when using many XA threads in bb-10.6-MDEV-31949_ver0

            Roel Roel Van de Paar added a comment - - edited Created MDEV-33673 Parallel replica threads lockup when using many XA threads in bb-10.6-MDEV-31949_ver0
            Roel Roel Van de Paar added a comment -

            After performance testing, this ticket is being closed out in favor of MDEV-33668.

            Roel Roel Van de Paar added a comment - After performance testing, this ticket is being closed out in favor of MDEV-33668 .

            People

              Unassigned Unassigned
              Elkin Andrei Elkin
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.