[Solved] Disable max_user_connections

[thaian]

I need to disable this because i have many services need to run on a mysql database

[wolstech]

This is by design to help keep load low and cannot be disabled.

 

Properly written code should not need a lot of connections anyway. The limit is 6 for Tommy and 3 for the other servers, per user. If your code is well-written, it will open and use the same connection for the duration of its run, and close the connection as soon as it's done with it, so you shouldn't ever hit this limit because the connections only exist for a fraction of a second while the script runs.

[Krydos]

The limit is 6 for Tommy and 3 for the other servers, per user.

Close, it's actually.

Tommy=6

Ricky=4

Johnny=4