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

share prepared statement cache between connections

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Prepared Statements
    • Labels:
      None

      Description

      Currently a prepared statement works only for the thread/connection that actually prepared it. If a heavily multithreaded application runs the same queries in many threads, this leads to many duplicates in the prepared statement cache.

      Example: sysbench OLTP. This one prepares a total of (2 + 9*number_of_tables) queries. Due to the above limitation it has to do this per thread. With for example 10 tables it cannot spawn more than 178 threads before reaching the default limit of 16K prepared statements.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              axel Axel Schwenke
              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.