I'm running a LNMP stack, and for the second time in as many weeks the mysql server has died. I used the nginx auto installer from http://www.ruchirablog.com/nginx-autoinstaller/

When I try to restart the lnmp stack, I get the following error - " * MySQL manager or server PID file could not be found!"

Last time I was able to get it back up and running again by performing the following steps...
1. Running ps auxf | grep mysqld
2. Killing all running mysql related processes.
3. Rebooting the linode
4. Restarting lnmp.

It doesn't seem to be working this time. Any suggestions?[/list]

Probably ought to figure out why it is dying in the first place...

Is there anything interesting in the system log files (/var/log)? Any ominous-looking kernel errors (dmesg)? Is your disk full (df -h)?

_________________

/* TODO: need to add signature to posts */

It looks like the disk is full...

Filesystem Size Used Avail Use% Mounted on
/dev/xvda 19G 19G 117M 100% /
devtmpfs 249M 112K 249M 1% /dev
none 249M 0 249M 0% /dev/shm
none 249M 36K 249M 1% /var/run
none 249M 0 249M 0% /var/lock
none 249M 0 249M 0% /lib/init/rw

Though I'm not entirely sure what to do with that information.

Delete some files? You can use 'du' to get an idea about where the space hogs are. Something like this:

du -sh *

should produce a summary of the sizes of folders in the current directory. One likely culprit are log files if logrotated is misconfigured or not installed.