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.


I'd say the 666999 milestone is still awesome! :D

int(10) actually only goes up to 2 147 483 647 for unsigned / 4 294 967 295 signed. It's only a display width gimmick without much meaning really. Read http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

D'oh, I mean the (10) is just a gimmick.

Dang. It.

Oh well, it looks like we only have until about the year 50000... which can't come soon enough!

Why can't numbers work the way they should? The largest ten digit number is 9,999,999,999, and that should be the number. Not some random number like 4,294,967,295. (By the way, your user login block looks strange in FF3. See http://skit.ch/bbef.)

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.

you got signed and unsigned mixed up

Yeah, I've been down this road before.

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.