Jump to content

Recommended Posts

Posted

I have been getting errors due to "max_user_connections" being reached, and can find no setting in cPanel for this to be upped. I researched it, and it seems to be a sitewide thing.

 

Is there any way we could get an increase of 1-2 more users? It would be more than enough for my needs.

Posted

Why does your site need that much? You're probably using persistent MySQL connections, which are unnecessary for most purposes.

Posted

I actually am using HeidiSQL to look at my database and modify it as well as make php scripts for it. I also have a laptop next to me for an extra screen (probably unneccesary) and it doesnt like me connecting to the database on both computers. I understand that it is probably unnecessary as an addition, but I fail to see any negative consequences of having more connections allowed. I just thought it might be nice as an addition.

 

Thanks for your time though.

Posted

The negative consequence is that it allows everyone to have one more connection, thereby causing load levels to spike. You really don't need more than 10 connections, which is the current per-user limit. Either your web application is using persistent connections, or you have more than ten connections open at once.

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