Bug #58883 "SHOW VARIABLES" in heavy server is slow
Submitted: 11 Dec 2010 17:12 Modified: 21 Feb 2011 20:49
Reporter: Moshe Lampert Email Updates:
Status: Closed Impact on me:
Category:Connector / NET Severity:S5 (Performance)
Version:5.1.31 OS:Any
Assigned to: CPU Architecture:Any

[11 Dec 2010 17:12] Moshe Lampert
I am running a heavy-queried server. I have large numbers of connects/disconnects, on Application load or restarts.

When I use some MySQL profiler - I see "SHOW VARIABLES" as the top heavy-running query, as the other queries was optimized/cached/rewroted.

How to repeat:
Open large number of connections to heavy server.

Suggested fix:
In Driver.cs, line 209 - Configure function, When using pooling, serverProps Hashtable can be reused from other connections. this will minimize load and network usage.

It can be done where ConnectionReset variable is false.
[21 Feb 2011 20:49] Reggie Burnett
Implemented as internal worklog and scheduled for release with 6.4.0