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

            Ascending order - Click to sort in descending order
            diego dupin Diego Dupin created issue -
            diego dupin Diego Dupin made changes -
            Field Original Value New Value
            diego dupin Diego Dupin added a comment -

            done in https://github.com/MariaDB/mariadb-connector-j/tree/CONJ-463
            Wait for server review / commit in main branch

            diego dupin Diego Dupin added a comment - done in https://github.com/MariaDB/mariadb-connector-j/tree/CONJ-463 Wait for server review / commit in main branch
            diego dupin Diego Dupin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            diego dupin Diego Dupin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            diego dupin Diego Dupin made changes -
            Description Permit faster connection with bundle commands in Client handshake response.

            Driver execute different command on connection :
            * set session info : SET autocommit=1, sql_mode = concat(@@sql_mode,',STRICT_TRANS_TABLES')
            * get session infos : SELECT @@max_allowed_packet , @@system_time_zone, @@time_zone, @@sql_mode
            * 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.             		Permit faster connection with bundle commands in Client handshake response.

            Driver execute different command on connection :
            * set session info : SET autocommit=1, 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.
            diego dupin Diego Dupin made changes -
            Description Permit faster connection with bundle commands in Client handshake response.

            Driver execute different command on connection :
            * set session info : SET autocommit=1, 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.             		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.
            diego dupin Diego Dupin made changes -
            diego dupin Diego Dupin made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 80465 ] MariaDB v4 [ 128228 ]
            diego dupin Diego Dupin added a comment -

            connection bundle is removed from server. Closing task

            diego dupin Diego Dupin added a comment - connection bundle is removed from server. Closing task
            diego dupin Diego Dupin made changes -
            Component/s performance [ 14519 ]
            Fix Version/s N/A [ 22125 ]
            Resolution Won't Do [ 10201 ]
            Status Stalled [ 10000 ] Closed [ 6 ]

            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.