Bug #71362 number of SUPER connections allowed when max_connections is reached
Submitted: 13 Jan 2014 14:32 Modified: 25 Oct 2018 6:48
Reporter: Jordi Prats (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version:5.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[13 Jan 2014 14:32] Jordi Prats 
Description:
When you reach max_connections, just one extra connection with SUPER privilege is allowed.

This extra connection can be easily occupied by scripts or another team member. 

How to repeat:
Reach max_connections and try to connect with more than one SUPER account

Suggested fix:
It would be useful to have a system variable to allow more than just one connection
[13 Jan 2014 14:32] Jordi Prats 
adds a server variable (max_super_connections)

Attachment: mysql.56.max_super_connections.patch (text/x-patch), 2.45 KiB.
[12 Feb 2014 9:16] Jordi Prats 
same patch

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: mysql.56.max_super_connections.patch (text/x-patch), 2.45 KiB.
[12 Feb 2014 9:19] Jordi Prats 
changing form catagory Server to categoty "server: options"
[4 Apr 2014 11:39] Ståle Deraas 
We will incorporate this contribution into a future release.
[25 Sep 2018 7:01] Daniël van Eeden 
Related:
Bug #5309 	MySQL should reserve a connection for the admin (root) user
Bug #47060 	More reserved connections with SUPER account privileges needed
[25 Oct 2018 6:48] Erlend Dahl 
This has been implemented and will be available in an upcoming release of MySQL.