Drupal | featured news

Cron Jobs and Feed Updates

RSS

Lately, we’ve been adding more local news feeds to the site. Eventually, I want to have most of the major cities across the U.S. covered. What I had noticed since starting this local news project was that the more feeds we've added to the site, the slower the feeds on the homepage updated.

 

Launched a New Movie Site Called MoviesWithButter.com

Launched a New Movie Site Called MoviesWithButter.com

I just launched a new movie site with my Rotten Tomatoes buddy Binh Ngo. It’s called MoviesWithButter.com, a website that tracks upcoming movies through various stages of development by aggregating scoops from the top movie sites on the web.

 

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.

 

Pressflow, Locked Tables & Hang Time

Pressflow, Locked Tables & Hang Time

I just installed Pressflow and simultaneously updated Drupal late last week. Pressflow is a modified version of Drupal that allows it to scale more easily. For sites with huge traffic and databases, it's essential. It supports database replication, Squid and Varnish reverse-proxy caching, and is optimized for MySQL and PHP 5.

 

BookTeller Booth at ANCCS & Drupal Showcase

BookTeller Booth at ANCCS & Drupal Showcase

This past couple weeks, I was involved in a couple marketing initiatives for BookTeller.com. First, there was an event for a Chinese School association that I had to prep for since we had a booth there. That took up most of my time for the past three weeks. Second, there was a write-up I wanted to do for the Drupal Showcase on Drupal.org.

 

Drupal Boost & APC

Drupal Boost & APC

I was testing a couple of caching software to stablize the site. Wopular used to crash 3-8 times a day. I had thought the main culprit was mysql because whenever resources become low, there is a logjam of queries waiting to be processed. They eventually pile up and consume all available resources and crash the site. Since I was able to set the server to reboot whenever it's near the melting point I didn't mind it too much because it only takes about 2-5 minutes.

 

Subscribe to this RSS topic: Syndicate content