The title roughly translates to "Oh, to once work with true professionals!"
This is something which I all too often have to think (and sometimes say aloud) when working on client projects. The nature of my work usually results in working for some kind of web agency which has secured a bigger Drupal project that they cannot handle alone. I then work with the agency's employees and other freelancers to complete whatever the project demands.
select count(login) from users where login > 0 and from_unixtime(login) > '2008-08-01 00:00:00' and status= 1;
+--------------+
| count(login) |
+--------------+
| 34626 |
+--------------+
That means that 10% of all drupal.org user accounts are actively used. Not that bad at all.
133257 is the result for the same query if you change the date to 1st of January. That is over50% of the accounts that exist on drupal.org and have been used at least once. Quite impressive.
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.
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.
(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!
