[CONJ-366] faster connection with bundle first commands in authentication packet Created: 2016-10-11  Updated: 2017-04-24  Resolved: 2017-04-24

Status: Closed
Project: MariaDB Connector/J
Component/s: Other
Affects Version/s: None
Fix Version/s: 2.0.0-RC

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


 Description   

Permit faster connection executing connection query directly in authentication packet.



 Comments   
Comment by Diego Dupin [ 2016-10-11 ]

commit in : https://github.com/MariaDB/mariadb-connector-j/tree/feature/CONJ-366, waiting for MDEV-9059 validation

Comment by Diego Dupin [ 2017-04-05 ]

Benchmark done to test solution with pipeline (send-send-send then read-read-read) based on assumption that there won't be error/plugins change.

benchmark tested on distant server (local server doesn't really show any difference)

Benchmark                 Mode  Cnt     Score    Error  Units
connect.pipeline          avgt  100   349,047 ±  3,352  ms/op //new solution
connect.pipelineFail      avgt  100   461,312 ±  5,756  ms/op //new solution when pipeline fail (authentication plugin required), then redo without
connect.comMultiAuth      avgt  100   354,806 ±  4,664  ms/op //MDEV-9059
connect.standard          avgt  100   575,437 ±  9,173  ms/op // current 1.5.9 connection
connect.mysqlDriver       avgt  100  1183,953 ± 30,258  ms/op //mysql 5.1.40 driver

So solution work faster than implementing a specific protocol in server, and permit to have that on previous mariadb server / mysql server as well.

Comment by Diego Dupin [ 2017-04-07 ]

reopen issue since pipelining solution has some flaws.
Additionnal data query will wait for complete authentication to avoid any flaws.

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