Wopular, Ubuntu | featured news

Finally, Got Rid of That Pesky Count Query

Finally, Got Rid of That Pesky Count Query

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.

 

Installing APC on Ubuntu 10.4 (Lucid)

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.

 

Subscribe to this RSS topic: Syndicate content