MySQL Bugs: #47060: More reserved connections with SUPER account privileges needed

Bug #47060	More reserved connections with SUPER account privileges needed
Submitted:	2 Sep 2009 12:04	Modified:	2 Sep 2009 14:50
Reporter:	Roger David Nay	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Options	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
There is currently one connection reserved for users with SUPER privileges, which can be used in case of an emergency to connect to the server if max_connections is maxed out. If I already have a SUPER client connected (ex. performing a backup or performing some other task) that us using that connection I can't access the database.

How to repeat:
N/A

Suggested fix:
Make the number of SUPER privilege connections variable (default is 1). For example an option reserved_connections=10 or max_reserved_connections=10.

Thank you for the feature request.

See also Bug#5309.

Related:
Bug #71362 	number of SUPER connections allowed when max_connections is reached