Details
-
New Feature
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
Description
Currently, all drivers that need to know the values of some system variables must obtain this information by doing a separate SELECT. This adds latency to the connection creation.
The OK packet that's sent in response to successful authentication could contain initial values of the system variables that are tracked by session_track_system_variables. With this, drivers that support system variable tracking could read these values on startup and avoid the cost of the extra query.
An extension to this would be to provide some information about the status of the server to the drivers. One example of this would be the Threads_connected status variable that could help drivers that have connection pools to spread the load better if one of the servers in a cluster ends up with more connections than the others.
Attachments
Issue Links
- relates to
-
MDEV-15935 Connection Redirection Mechanism in MariaDB Client/Server Protocol
-
- Closed
-
-
MXS-4635 Provide load balancing metadata to connectors
-
- Closed
-
Thanks serg, ptal at the updated commits:
b71adaf94a3 upstream/bb-11.5-mdev-31609 MDEV-31609 Send initial values of system variables in first OK packet
9fdc953edf3 MDEV-31609 mtr: only print session tracking from the last statement