my.info max_user_connexion

Portal Home > Knowledgebase > Articles Database > my.info max_user_connexion

Posted by ilvista, 11-27-2010, 06:33 AM
hi I had recently some trouble with my dedicated server,I was getting an error message"Too many connections",so I increased the value of MAX_USER_CONNEXION,and the error message is gone;BUT now when i try to load a web site using my broser from my server(I've 61 web site on my server),IT 's too slow,and some times I get a blank page. Operating system Linux 2.6.26.8-57.fc8. RAM 3 GB any ideas??? thx in advance
Posted by Ixape, 11-27-2010, 08:23 AM
Hello, Please run the following commands and paste the output here. Thanks, Jack.
Posted by Beast5, 11-27-2010, 09:38 AM
check out your mysql process list , normally this happens when you have a runaway php script that loops the database, or , your server is overloaded and cannot handle the I/O demand for your SQL engine, which leads to hanging process connections to the mySQL server. first of all , restart the mysqld service, after that is done , login to your mysql as root and check out which one of the websites is creating these connections. I would also recommend updating the kernel.
Posted by ldcdc, 11-27-2010, 01:50 PM
Sounds like the old limit was effectively protecting your server from overloading. There may be some MySQL tweaks that a server admin could perform regarding cache settings etc. but I don't know much about that subject. If the applications you're using have cache features (inbuilt, or plugins) you could try using those to diminish the pressure the server is on.
Posted by ServerManagement, 11-27-2010, 03:17 PM
You should setup a slow query logger in mysql, this will track which queries specifically are causing this problem. It will track the user, query, and how long it took. You can then either optimize the specific queries or disable any troublesome queries.
Posted by ilvista, 11-28-2010, 05:47 AM
thx for for the replys and show processlist gives: is this too much for my sql server!!!! Thx
Posted by ilvista, 11-28-2010, 06:24 AM
Also I increased the chache variable value but still have the same problem. I've read something about recmopiling php , I'm not sure.but i'll try it anyway,and also updating the kernel .
Posted by Ixape, 11-28-2010, 06:32 AM
Your CPU seriously looks overloaded. What are the specifications of your server?
Posted by ilvista, 11-28-2010, 09:50 AM
and the memory
Posted by Ixape, 11-28-2010, 09:53 AM
In this case you are definitely overloading your CPU.
Posted by ilvista, 11-29-2010, 08:22 AM
Thx a lot for the help Just one more thing! How can you tell from these files that my CPU is oveloaded. thx again Morad
Posted by Ixape, 11-29-2010, 02:00 PM
The load average is way to high for the hardware you have installed.
Posted by Crashus, 11-29-2010, 03:10 PM
this needs to be tested from the inside, maybe turning mysql cache on will help

Add to Favourites Print this Article