Walk Tall, Kick Ass

    WTKA_hst-border

Tags

'Berg (66) Animals (13) Art (9) BabyLove (21) Bodymore Murderland (171) Booze (45) C/O Mer (10) Concerts (11) Cooking (7) Family (20) Fashion (30) FREE (9) Frickin' Awesome (196) Gardening (9) Gifts (25) Go Ravens HON (21) Going Green (2) Gonzo (9) Gossip (27) Happy Birthday (11) Holidays (51) Interweb (75) Jewythings (54) Literary (7) Maps (8) Media (36) Mi Casa (7) Movies (12) Music (52) Neat (28) Nerd (28) News (53) NIFW (3) Nuptials (38) Photos (171) Politics (47) Pony (5) Pr0n (20) ROTFLOL (141) Sail Fast (22) Smart Things (44) Telecom (3) The Network Pub (27) The New Black (14) Things You Eat (144) Travel (16) TV (87) Videos (127) What's Hotter Than Hip-Hop? (60) White Slavery (4) Why I am ashamed to be an American sometimes (45) WTF (15) WTKA (12)

Slashdot phucks up.


Slashdot had to suspend all coments today... oops.

Last night we crossed over 16,777,216 comments in the database. The wise amongst you might note that this number is 2^24, or in MySQLese an unsigned mediumint. Unfortunately, like 5 years ago we changed our primary keys in the comment table to unsigned int (32 bits, or 4.1 billion) but neglected to change the index that handles parents. We're awesome! Fixing is a simple ALTER TABLE statement... but on a table that is 16 million rows long, our system will take 3+ hours to do it, during which time there can be no posting. So today, we're disabling threading and will enable it again later tonight. Sorry for the inconvenience. We shall flog ourselves appropriately.

0 comments:



Twitter

F8

Followers

Reader

Friendroll

Dopplr