Twice now in the last 4 days at some point during the night websites go down because the server is unable to connect to the database. At this point everything else is still running (apache ect) just the database is dead.
When I log into ssh with root to investigate, I have read only permissions everywhere which is what I suspect is the cause of the mysql server dying.
I've checked the mysql logs, system logs, basically every log file I can find, nothing indicates an error anywhere around when the problems starts (or even during the entire day). It is like a switch is just flipped, I then restart the system and things are fine again... until a few days later?
There was 2G of free ram the last time this happened, 1.5G free the first time. Minimal cpu usage (< 30%).