Jump to content

Recommended Posts

Posted
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

Posted

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.

Posted
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?
Posted

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?

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...