Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-7607

sync_transaction sends redundant syncs to multi-statement queries

    XMLWordPrintable

Details

    • MXS-SPRINT-280
    • Related to performance
    • Readwritesplit only sends one sync per GTID even if the transaction consists of multiple results.

    Description

      If a multi-statement query commits a transaction and then follows up with more results afterwards, the trailing results trigger a redundant sync on the GTID that was already synchronized. The waiting won't take any time since it's already replicated but there's still the wasted network traffic that should be avoided.

      Attachments

        Issue Links

          Activity

            People

              markus makela markus makela
              markus makela markus makela
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1h
                  1h
                  Remaining:
                  0d
                  Logged:
                  Time Not Required
                  Not Specified

                  Git Integration

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