MySQL server hangs after approximately 1 month (CentOS)
- by user25061
Hey guys, I've got a web server running Apache/PHP and MySQL (CentOS), and MySQL seems to hang once every month or so. As far as I can tell, there are a few slow queries that are being resolved, but other than that I can't really see any reason why MySQL would hang. I'm having problems determining the problem - nothing is showing up in /var/log/mysqld.log, and again there are a few slow queries, but nothing out of the ordinary. Load is average at the time of the crashes...
Can I please get some hints on how to work out the issue? I can't reproduce on our staging environment, so I'm a little stuck.