Every few days my server crashes. The load average and memory usage is very high, until it stops answering to all requests.
Tne strange thing that happen when this happens, is that static pages continues to work great, even with high server load, but pages with mysql queries run slowly or even sometimes do not answer the requests.
I could not find anything that could happen on /var/log/messages
When I type top on the shell I get something suspect like this:
12508 nobody 18 0 214m 19m 12m R 81.8 0.2 4:02.62 httpd
I'm not sure, but this means that there is a httpd process running for over 4 hours?
Other processes also have a high TIME+ value when the server is almost completely crashing.
Could theses processes be the problem?
Is there anyplace where I can find mysql logs? I found nothing on /var/log/mysql
.
Does anyone have any idea about what could be the problem?