Jump to content

Problem With Max_User_Connections


midas

Recommended Posts

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?
Link to comment
Share on other sites

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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...