[CONJ-463] faster connection with bundle first commands in authentication packet Created: 2017-04-25  Updated: 2021-04-08

Status: Stalled
Project: MariaDB Connector/J
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Diego Dupin Assignee: Diego Dupin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-9059 protocol: bundle first command with t... Stalled

 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.


 Comments   
Comment by Diego Dupin [ 2017-05-05 ]

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

Generated at Thu Feb 08 03:15:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.