Web Hosting Talk







View Full Version : a cPanel system problem


Yong
12-02-2003, 02:18 PM
english

Main problem: because at the same time too many processes to mysql, so mysql automatic restart
The system disposition: p2.4 CPU 1G memory RedHat9 with cPanel.
Detailed: Only have one forum on the server, about 500 online people. Because the server was comewith cPanel when it installed, so, I do not know why, I guess is the 500 processes make the mysql processes so high and then automatic restart. And some time the forum online is more than 1000 people's online, the mysql system start each every ten minutes.
So please help me if u are familiar with RH9 + cPanel

WCHost
12-02-2003, 02:40 PM
Because the default settings for MySQL is 500 connections
so you will need to congifure your my.cnf inside etc folder
/etc/my.cnf

open it with pico or vi

Go to Rackshack forum, and search for my.cnf
you will find some details on it how to config it.

Well, the mysql system start every ten minutes is because the people keep the connections where the mysql only support 500 connections. You need to set the timeout so it will release a connection once it pass the time!

Thanks

Yong
12-02-2003, 03:03 PM
not this problem, i am already changed it to 10000 connections

deltawolf
12-03-2003, 04:12 AM
Yesh...lotta people on a forum. Be sure to set a timeout or your server will go down along with mysql next time...

WCHost
12-03-2003, 04:52 AM
put as 1000 is enough
and the timeout is a must because the default is like 1000s+