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

Add support for pipelined execution of COM_STMT_PREPARE

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 6.4.7
    • None
    • Protocol

    Description

      The JDBC connector can send a COM_STMT_PREPARE command followed immediately by a COM_STMT_EXECUTE command. Currently MaxScale halts the processing of incoming packets while the COM_STMT_PREPARE is being executed (it's a session command) and only continues with the COM_STMT_EXECUTE once it's done.

      There's no need to do that as all of the information needed to route is known at the time the COM_STMT_PREPARE is read. A COM_STMT_EXECUTE should be an exception and should be routed even if a session command is being executed.

      The benefits of implementing support for this would be lower latency for any connector that uses the "immediate execution" style (e.g. JDBC and ODBC).

      Attachments

        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:

              Git Integration

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