Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-1278

prepared statement caching enablement

    XMLWordPrintable

Details

    Description

      there is a difference between 2.x and 3.x :
      In 2.x caching is enable by option cachePrepStmts (default true) when useServerPrepStmts is enable (default false), while in 3.x, it's only enable with cachePrepStmts value.
      This is an issue, because there is 3 possibles prepare use :

      • prepared statement
      • Callable statement (stored procedure)
      • bulk

      This means that even if useServerPrepStmts is disabled, all callable/bulk statement will be cached, possibly reaching max_prepared_stmt_count while useServerPrepStmts is not set. This is an bug, goal is to have the same cache behavior in 3.x than the existing one in 2.x

      Attachments

        Activity

          People

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