While updating Wopular, I noticed that from time to time, the site would locked up for a couple minutes. Most of the time, I would just wait it out. I finally looked into the slow query log for mysql and found the troublesome query.
I’m working on a new site using Drupal on a LAMP environment. One of the things I want to install is APC - Alternative PHP Cache - for opcode caching. When I did it with Wopular, I’ve noticed the effects immediately. Because the site crashed so often before using APC, I had to have a script to automatically reboot the server, fixed db errors, and reload the site whenever server resources are used up. It works, but sometimes I would end up with a corrupt database and had to spend hours to days fixing it or restoring it from a backup.