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

Don't let session commands block new incoming queries

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 2.5.0
    • readwritesplit
    • None

    Description

      Some driver or framework will encapsulate all queries in prepare statement, it doesn't reuse the prepare stmt, just execute once then close it , then prepare it again;
      We found that if there are many backends or some of backend is not health, because session command need route to all, and wait all complete, it will block incoming queries;we already have encountered this situation, that a user use go driver, and one of our backends is slow, so whole cluster is slow;

      So we need a way don't let session commands block new incoming queries,

      Attachments

        Activity

          People

            markus makela markus makela
            dapeng dapeng huang
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.