Drupal.org approaching 1,000,000 nids!

I noticed a few months ago that we hit the mid-950,000 range for posts... since then, I've forgotten to mark down the numbers through time (I wanted to try plotting the exact day when we'd cross over to 1,000,000 posts).

Today (December 14), we were at node #998,346 (obviously, some nodes have been deleted, and database causes notwithstanding... but the count still advances!). Predictions as to when we'll hit this milestone? It'd be awesome if we could hit it exactly on the Drupal 7.0 release announcement, but I'm not holding my breath for that!

The better question is, "How many nodes can a drupal site have before the node table runs out of room (i.e. the nid column runs out of space?). The answer is 9,999,999,999 4,294,967,295 (as of Drupal version 7), and that, my friends, is a very large number. Of course, you could increase the length of that field (and related fields) on one of your sites to add more room, but I calculated it out, and it would take adding 10,000 new nodes every day for the next 2,740 ~1,200 years before you'd have to worry about hitting the nid limit!

That means drupal.org shouldn't have to worry about increasing the size (int(10)) nid column until the year 102009 ~50000 (with a linear increase)! I would bet we won't be using MySQL by that time... and I'm guessing we'll have reached at least Drupal version 1,000 or so.

Updated based on comments below.


Sadly we are actually not there yet. We currently have 666990 nodes. The nid number doesn't reflect the actual number of nodes on most HA drupal sites, due to mysql's use of auto_increment offsets in active/passive DB pairs.

I do look forward to the time where we over-run INT.


Hmm... still working on the theme actively (I'm using Boron as a base theme - first time in a year I'm not using Zen, Genesis or Blueprint!). Thanks for the screenshot! Reminds me to check out FireFox every now and then :P

It's not a random number, it is 2^32, or to put it in other terms it is the number of possibilities you can have in 32 bits. That means it uses 4 bytes (32/8) to store the value. Google 'data type ranges' if you want to know more.

Well, we hit a million sometime today or yesterday. We're currently at 1000880

Yes that's right it's still working on the theme actively and I am also using Boron as a base theme. Bundles of thanks for such a wonderful content. I really appreciate your effort.