If you run a popular Drupal site, you'll sometimes find more queries in your MySQL server's slow query log than you really want to.

Sometimes the unruly queries can be eliminated easily by adding an index or two. Sometimes, they can be avoided alltogether (for example, the query in theme_forum_topic_navigation can be avoided by overriding the function with an empty one in your theme).

We've already counted close to 40000 downloads in only three days!

For comparison: There were about 67000 downloads of all Drupal 5 releases combined in January 2008. There were about 60000 downloads of all Drupal 5 releases in January 2007 when Drupal 5 was released.

This is to announce that Andy Kirkham (AjK) of the Drupal security team and myself will be attending FOSDEM from the 22nd to the 25th. Meet us at the Beer event or in the Drupal developer room.

As outlined in the previous post, drupal.org got over 850k referalss from search engines' result pages in January 2008. Thanks to awstats we've got some statistics to share about people's favourite search words.

What's the relevance of the title of this blog post for Drupal you might ask yourself? Actually, this post is about how it is not relevant.

While Yahoo is a valued Drupal user and supporter, Drupal users don't seem to use them much. I've had a look at the search referrer stats that we've collected during January 2008. Unless the stats are totally made up because everybody forges their referrer, Yahoo contributed only 1.7% (or 14942 pages) to the total of 864844 links we got from search machine results. You may wonder who got the lion's share?

Hint: It isn't MSN (0.1% or 1649 pages) nor AOL (0.3% or 3104).

(from an earlier post to the infrastructure mailing list)

You'll maybe remember the problems we had with googlebot in summer. It had crawled about 150k pages per day and that caused problems on our servers. I then asked google (via the webmaster tools, thanks to Morbus Iff) to crawl less often and it went down to below 10k pages per day. This setting expired in November and as of December googlebot

Today, there was some loss of electricity at the Open Source Lab. An electrical fire somewhere else on their campus led to their power being turned off for some time.

That's usually bad for computers, but wasn't bad at all for drupal.org's infrastructure. Why? Because the OSUOSL data centre has a backup generator! So drupal.org continued to serve pages. About 40k during the roughly 2 hours of the outage. Thanks OSUOSL!