Damon Cortesi's blog

Musings of an entrepreneur.

Sorry if the Site Was Slow

| Comments

The site was really starting to bog down for some reason lately, but I figured out what it was.

Turns out it was what I suspected all along. On my first site, I had some statistics on the pages about how many times they’d been googledbotted as well as any referer’s. However, I was generating that content from my Apache logs which I configured to log directly to MySQL and are now at just over 1,000,000 rows. Being that my server is a virtual colo (thank you, John Companies), the database was getting pegged out pretty easily.

Now that I’ve disabled those queries, it’s running much faster.