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

faster connection with bundle first commands in authentication packet

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • N/A
    • performance
    • None

    Description

      Permit faster connection with bundle commands in Client handshake response.

      Driver execute different command on connection :

      • set session info : SET autocommit=%option_autocommit%, sql_mode = concat(@@sql_mode,',STRICT_TRANS_TABLES')
      • get session infos : SELECT @@max_allowed_packet , @@system_time_zone, @@time_zone, @@auto_increment_increment
      • in case of aurora : show global variables like 'innodb_read_only'
      • if createDatabaseIfNotExist option : CREATE DATABASE IF NOT EXISTS <db> and USE <db>
        those queries will be send directly with Client handshake response, avoiding exchanges.

      Attachments

        Issue Links

          is blocked by

          Task - A task that needs to be done. MDEV-9059 protocol: bundle first command with the authentication packet

          • Major - Major loss of function.
          • Stalled

          Activity

            Transition Time In Source Status Execution Times
            Diego Dupin made transition -
            Open In Progress
            		10d 1
            Diego Dupin made transition -
            In Progress Stalled
            		2s 1
            Diego Dupin made transition -
            Stalled Closed
            		2603d 33m 1

            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.