frjo's archive October 2009

Converting your Drupal MySQL databas from MyISAM to InnoDB

In Drupal 7 InnoDB will replace MyISAM as the default storage engine for increased scalability and data integrity. Most big sites are already using InnoDB, drupal.org does since some time.

InnoDB is generally a better choice for Drupal so why wait for Drupal 7. Lets go ahead and convert our Drupal 6 tables to InnoDB.

Results of running Lighttpd as a static file server for Drupal 6

Google webmaster tools - Time spent downloading a page (in milliseconds)

In my blog post Running Lighttpd as a static file server for Drupal 6 on a Debian GNU/Linux server I describe how I set up a static file server here on xdeb.org. I mentioned there that I have not done any benchmarking on the improvements. I still haven’t, but I found some interesting information on Google webmaster tools.

I use Google webmaster tools to submit my sitemaps. One or two times a year I go there to see if everything is in order. They have done some updates since I was there last and this time I found “Crawl stats” under “Diagnostics” (they may very well have been there for a long time but i found them now).

The image show the chart for “Time spent downloading a page (in milliseconds)”. Notice the big drop in late July. That’s when I implemented Lighttpd as static file server.

The average time Google spent on downloading a page went from well over 1000 ms to around 600 ms. I’m very pleased with that result.