Mysqld constantly crashing

JamesSmith

Well-Known Member
Sep 17, 2003
185
0
166
UK, Luton
Since the 9.2.0-S29 update a few days ago, one of our web servers is having a problem with mysqld constantly crashing.

Mysqld shoots to 99% cpu / mem, no one can then connect to mysql, databases appear missing in CPanel etc. Restarting it fixes it, but its happening every few hours.

Sometimes theres a few wrapping processes, and mysqldadmin processes on the server when its crashed. Could there be a bug being caused by people accessing CPanel / PHPMyAdmin?

Server is at this minute is running MySQL 4.0.17, I am running fixmysqlbsd, which by the looks of it is updating it to MySQL 4.0.18.

Server is running FreeBSD 4.8 RELEASE.

Anyone have ideas?
 

ehsanix

Member
Mar 3, 2004
13
0
151
I have the same problem on both redhat 9 and enterprize server with cpanel runing.

from yesterday morning I have the exact problem.

As I checked mysqladmin process list at the time of crach there where a lot of processes querying at the same time and doesnt go away !!!!

Also it doesnt let me to restart mysql service. I had to kill mysql proces in WHM !!!!
 

vandal

Member
May 14, 2004
14
0
151
i'm not having this problem, just wondering what happend with resolving this/what was causing this
 

JamesSmith

Well-Known Member
Sep 17, 2003
185
0
166
UK, Luton
Hi,

If I remember rightly caused by a ton of mysql sleep processes by a site with extremely poor coding.

That site was removed from the server.
 

vandal

Member
May 14, 2004
14
0
151
so it had nothing to do with cpanel? was just a fluke that it happend at the same time as a mysql update?
 

Doctor

Well-Known Member
Apr 26, 2003
180
0
166
JamesSmith said:
Since the 9.2.0-S29 update a few days ago, one of our web servers is having a problem with mysqld constantly crashing.

Mysqld shoots to 99% cpu / mem, no one can then connect to mysql, databases appear missing in CPanel etc. Restarting it fixes it, but its happening every few hours.

Sometimes theres a few wrapping processes, and mysqldadmin processes on the server when its crashed. Could there be a bug being caused by people accessing CPanel / PHPMyAdmin?

Server is at this minute is running MySQL 4.0.17, I am running fixmysqlbsd, which by the looks of it is updating it to MySQL 4.0.18.

Server is running FreeBSD 4.8 RELEASE.

Anyone have ideas?
I don't think this is any fluke.

My MySQL crashes after recompiling Apache and upgrading CPanel as well. This happens to all my servers. Apparently, MySQL processes don't die and they just run until the load and memory accumulates to a level that it crashes the MySQL server. Please help.