Slashdot gets taken down after a random Ontario musician posts the 16,777,215th comment. Since the database could only handle 2^24 comments, slashdot then crashed. They were using the wrong variable type to store the index, and it was a rather simple fix. They would have just needed to ALTER a table and then wait a couple hours while it converts every post over to the new variable type. I should make sure the same thing doesn’t happen to my blog, I am not even sure what WordPress uses for their posts and comments but I sure hope I don’t crash if I hit 16,777,215 comments or posts!! Although, for me, that will never happen! <\/p>\n
read more<\/a> | digg story<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" Slashdot gets taken down after a random Ontario musician posts the 16,777,215th comment. Since the database could only handle 2^24 comments, slashdot then crashed. They were using the wrong variable type to store the index, and it was a rather simple fix. They would have just needed to ALTER a table and then wait a … Continue reading Slashdot Gets Pwned… Taken Down<\/span>