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

Avoid executing additional command on connection

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 3.0.3
    • performance
    • None

    Description

      Java driver execute different command after creating connection.
      driver force autocommit to true, sql_mode to set STRICT_TRANS_TABLES for example. Autocommit and STRICT_TRANS_TABLES are required by JDBC, but correspond to the default value of mariadb since a very long time. A better approch is to avoid sending those session value if autocommit option is not explicitly set by option, permitting having faster connection.

      Same for another command "SELECT @@max_allowed_packet, @@wait_timeout".
      Wait_timeout use is for internal pool only (and so must be issued only when using pool).
      max_allowed_packet can be pass as option if needed.
      default max_allowed_packet is 16M, en rarelly decrease. Bulk command implementation split command by 16M packet max when possible ( if a group of parameter size is more than 16M, it will be send in one specific command). So current implementation could avoid requesting this value

      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.