Problem With Max_User_Connections

[midas]

Hi, I'm having a problem connecting users simultaneously. is it possible to set MAX_USER_CONNECTIONS to 30? or 15?

if the answer is yes, how can I do this?

 

i'm using a Jhonny ,

host: midas.heliohost.org

email rogiviela@gmail.com

 

tnks

[wolstech]

Is there a reason you need so many connections? Most users who see this error are seeing it because their code doesn't properly close connections when it's done using them.

 

Our limit is I believe 4 concurrent connections per user.

[midas]

thanks for the answer. I have already reviewed the code, even closing all the connections but I still get the error. I would need to increase the number of connections because I have several applications feeding the Database at the same time.

Is there no other way to solve this?

[Krydos]

The reason we have a max connections value set is so that one person can't hog the entire server and cause everyone else's mysql connections to fail due to lack of resources. You have to understand that you're on a shared server with 13,000 other accounts. If everyone else on the server allowed their poorly written code to have 30 open connections then your well written code wouldn't be able to connect at all. Would it be possible for your code to just catch the max_user_connections error and enter a loop to wait for it's turn to connect?