Jump to content

[Solved] Increase max_user_connections


goark

Recommended Posts

This is limited to prevent the server from becoming overloaded. A well-written script shouldn't have any issues with the limits we have set.

 

What are you trying to do, and is your script closing your SQL connections when you're done with them? 

Link to comment
Share on other sites

I have triple checked that all my connections close. The amount of data to be retrieved is large, and the max of 4 is too less. Also, there are several pages where the data needs to be retrieved, so with 4+ users viewing the page at once, we'll have a problem.

Link to comment
Share on other sites

The limit is in place to prevent one user from hogging all of mysql preventing anyone else from being able to connect. If I raised your limit you would likely cause issues for everyone else which is the entire reason we have the limit. Tommy offers a higher number of simultaneous mysql connections than the other servers due to having less users.

Link to comment
Share on other sites

I believe it's 6...It's 4 on the other servers. The server is much faster though, so you also need to consider that the transfers and connections will be finished and closed quicker than on Johnny or Ricky.

 

I run a ton of software myself though, and with the exception of HelioMine's backend (which has a ton of connections due to clients checking for work), I've never needed more than 1 or 2 connections concurrently, even with a significant amount of traffic on the various websites I host.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...