MySQL Bugs: #58883: "SHOW VARIABLES" in heavy server is slow

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:	None
Category:	Connector / NET	Severity:	S5 (Performance)
Version:	5.1.31	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.

Implemented as internal worklog and scheduled for release with 6.4.0