Blame Canada. Ontario-based Musician Takes Down Slashdot.

Apparently an Ontario musician posted the 16,777,215th comment on Slashdot last night, thus blowing up the comment table on the popular site. Slashdot has its comment index as an unsigned mediumint in MySQL, which maxes out at 2^24, thus putting the maximum size of the table at 16,777,216 rows. Given how Slashdot increments those figures (two databases, one using odd figures, one even), the above comment in the odd table tipped Slashdot over its comment limit.

So, blame Canada. Again.

Related posts:

  1. “The Long Tail” Gets Slashdot-ed
  2. The End of (the) Slashdot (Effect)
  3. Canada as Evil Offshoring Country
  4. Biographies Better than Canada, says Bill Bryson
  5. Offshoring to Canada

Comments

  1. That is right off the geek-o-meter :-)

  2. I know, but I couldn’t resist ….

  3. How Ironic that this kind of thing can happen on Slashdot :) rofl.

  4. MitchAubin says:

    Don’t blame canada, blame the other 16 000 000 us bastard who posted crap…

  5. ha that’s great! Slashdot has bad design that keeps out potential new users, it’s too jargon cluttered!

  6. Alejandro says:

    Well said MitchAubin!…well said!

  7. cease says:

    “ha that’s great! Slashdot has bad design that keeps out potential new users, it’s too jargon cluttered!”
    thats a good thing. Keeps the kiddies out. If you want non-tech articles, and stupid comments, go to digg

  8. day says:

    “thats a good thing. Keeps the kiddies out. If you want non-tech articles, and stupid comments, go to digg”
    how do you think I got here in the first place?

  9. Yeah – really sorry about that guys. I’ll be reserving my posts from now on to jokes aboot farts.

  10. Loco says:

    The maximum number of rows in the comment table is 16,777,216, but since they use separate databases (hence separate comment tables) for the even and odd indexes, they have room for 16,777,216 x 2 = 33,554,432 comments. That means the Ontario musician posted comment #33,554,433

  11. Abe says:

    oh puh-lease! Slashdot has like 1/20 the stories Digg has, and is far more interesting than Slashdot could ever hope to be at this point.

  12. Not correct. :)
    Storing the id 16.777.215 is no problem with 24 bits. It was the NEXT comment that couldn’t be stored and brought everything thumbling down. Unfortunately, there’s probably no way to find out who that might have been.

  13. Keith says:

    Oh my goodness. This is a lesson to learn for those who are intending to venture into site enterprises!

  14. Ahh hahah that is great! Good post here buddy.