Drupal sudden excessive memory usage

Question

I'm running my drupal website on a VPS, the server suddenly stops responding and the stats shows a sudden excessive memory usage. I'm not sure if it's Drupal, but my database is hosted on another server.

Can anybody help in this?

Answer 1

Increase memory_limit in php.ini file. Set it to memory_limit = 128M.

Answer 2

http://drupal.org/node/158043

Answer 3

I found that Faceted Search would use up 99% of my server's CPU when it ran every hour (indexing content). And after one hour it wasn't finished, so a second Faceted Search index would begin...

I ended up just removing Faceted Search and going with the basic search (may upgrade to Solr in the future)

Answer 4

You should try enabling cache if you didn't (at site configuration > performance) also make sure that you don't have any "devel" module enabled.

If the problem continues, then you can enabled (and download it if you didn't) the "devel" module so it can log the slow queries, once you have identified the problematic query it will be easier to find a solution.