Today on a server of mine mysql keeps crashing and I need to manually restart it over and over, the load as well keeps spiking quite high until I stop mysql for a few minutes. There isn't a extra load of traffic or anything as I have the same amount of users on several other servers doing more then this one.
How do I tell exactly whats happening from then how would I go about fixing it? Basically it mysql crashes and needs to just be manually restarted via ssh.
Please specify your OS flavor: *BSD, Linux, other. Also, as for Linux, the distribution: Debian, CentOS, RedHat, SuSE, ......
you can take a look at my.cnf, but that file can be located on different places, depending on the distribution.
In my case (debian) it is in /etc/mysql/my.cnf , and there you should be able to tell where the logs are. If all the log entries are commented out, it worth looking at /var/log and start browsing (in almost all unix flavors, logs are stored there).
Wow, that server has eaten *all* of its ram. That explains why your mysql is crashing so much.
You *need* to find out why:
1. Run top and the press the "M" key (uppercase M), that will sort the processes by their memory usage, see which are the first one.
After running top and pressing M, wait 7 seconds, and then paste the output here (first 10 lines only).
I hope this helps,
A friend helped me out with this, it seemed like to many mysql connections. It's the type of script that I'm running that eats the ram up though, I have it running on about 20+ servers and only a couple were having this issue. All have the same specs as well.