Bug #101254 Provide an option like max_readonly_user_connection

• Submitted: 20 Oct 2020 23:00
• Modified: 21 Oct 2020 4:58
• Reporter: Nikunj Bhatt
• Status: Verified
• Category: MySQL Server: Options
• Severity: S4 (Feature request)
• Version: 8.0
• OS: Any
• CPU Architecture: Any
• Tags: 1040, max_user_connection, too many connections

[20 Oct 2020 23:00] Nikunj Bhatt

Description:
There is an option to set max_user_connection. In shared hosting where this is set to very low (around 20-30), there is a common problem of surpassing that limit and getting the error "1040: Too many connections". There are lots of question asked about this error on StackOverflow and on many other sites.

How to repeat:
[not applicable]

Suggested fix:
I recommend to provide an option like max_readonly_user_connection which will allow to open readonly connections. In most cases, only readonly activities happen with database when websites are opened. Through this option, the shared hosting providers will be able to configure servers more optimally, CMSes like WordPress can also benefit from this and more visitors will be able to access unbroken sites.

I had made a Tweet about it: https://twitter.com/nikunjbhatt84/status/1318657890400436225 and Dave Stokes (MySQL Community Manager) advised me to suggest the feature here.

[21 Oct 2020 4:58] MySQL Verification Team

Hello Nikunj,

Thank you for the feature request!

regards,
Umesh