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

protocol change : COM_STMT_PREPARE avoids sending parameters metadata

    XMLWordPrintable

Details

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

    Description

      COM_STMT_PREPARE protocol is :

      • COM_STMT_PREPARE_OK.
      • If number of parameters (count of '?' placeholders) > 0:
        • For each parameter:
          • column definition packet.
        • If !DEPRECATE_EOF eof_packet.
      • If prepared statement returns result set and number of result set columns > 0:
        • For each column:
          • column definition packet.
        • If !DEPRECATE_EOF eof_packet.

      While the parameter count is useful information for connectors, the parameter metadata packets themselves are not. They consistently indicate generic string types and provide no meaningful information for connectors.

      Most connectors already skip these packets.

      The goal of this change is to eliminate the parameter metadata section when a new capability flag is enabled.

      Benchmark results (tested on two local computers using the attached patch):

      • Current implementation: 444.461 operations/second
      • With patch (connector capability enabled): 460.190 operations/second

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            diego dupin Diego Dupin
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.