Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
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