MySQL hang and crash

[dmtnet]

Ver: mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686)
WHM 9.2.0 cPanel 9.3.0-C4 (CURRENT)
RedHat 9 - WHM X v3.1.0

Problem: I have MySQL running for about 15 mins then it crashes and chksrvd will not restart. This problem seems like it just started. When attempting restart via "service mysql restart" I get ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

In the error log there is nothing before the crash but this is what it reads when I restart manually:

/usr/sbin/mysqld: ready for connections.
Version: '4.0.20-standard' socket: '/tmp/mysql.sock' port: 3306

Number of processes running now: 1
mysqld process hanging, pid 14861 - killed
040524 20:36:05 mysqld restarted
040524 20:36:05 Warning: Asked for 196608 thread stack, but got 126976
040524 20:36:05 Can't start server: Bind on TCP/IP port: Address already in use
040524 20:36:05 Do you already have another mysqld server running on port: 3306 ?
040524 20:36:05 Aborting

040524 20:36:05 /usr/sbin/mysqld: Shutdown Complete

040524 20:36:05 mysqld ended


Things I've tried:
recreating the symbolic link between /tmp/mysql.sock and /var/lib/mysql
changing the mysql config to reflect the exact mysql.sock
upgrading/downgrading chksrvd
upgrading/downgrading MySQL

[jsteel]

Your error shows MysQL 4.0.20 installed and on our C4 installs (even those that just did their UPCP within the last 2 hours), the version installed is 4.0.18. Did you manually install a 4.0.20 upgrade, possibly via an RPM? If so, did you install rather than upgrade such that old 4.0.18 is still running?

[dmtnet]

Originally posted by jsteel
Your error shows MysQL 4.0.20 installed and on our C4 installs (even those that just did their UPCP within the last 2 hours), the version installed is 4.0.18. Did you manually install a 4.0.20 upgrade, possibly via an RPM? If so, did you install rather than upgrade such that old 4.0.18 is still running?

Actually did both and no result same time frame for the crashing.

[dmtnet]

Any ideas?

[dmtnet]

Fixed. Issue was with PRM, which I didnt know the old admin installed. MySQL was heading over its limit and being killed.

Appreciate all the thoughts.

[Roy@ENHOST]

This works for me:

killall -9 mysqld
/etc/init.d/mysql start