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.
Friday, November 10, 2006
Slashdot ran out of comments
The geek news website Slashdot ran out of comments after it reached 16,777,216 comments in the database! From Slashdot:
Subscribe to:
Post Comments (Atom)
Featured Post
Singapore Haunted: Top 10 Most Haunted Moments Caught On Camera!
A flying ghost at Changi Hospital, a playful tree spirit at Bedok Reservoir and the ghost of a girl who died at the famous Yellow Tower at...
-
You can watch an almost live webcam (30 secs delay) of the Fukushima Daiichi nuclear plant which suffered major damage from the 9.0 earthqu...
-
Meet Xu Rong . She's an Assistant Professor at Nanyang Technological University (NTU) and judging from her photos posted on her blog an...
No comments:
Post a Comment