{"id":711,"date":"2006-11-10T11:49:09","date_gmt":"2006-11-10T15:49:09","guid":{"rendered":"http:\/\/www.mathewingram.com\/work\/2006\/11\/10\/warning-this-is-off-the-geek-o-meter\/"},"modified":"2006-11-10T11:49:09","modified_gmt":"2006-11-10T15:49:09","slug":"warning-this-is-off-the-geek-o-meter","status":"publish","type":"post","link":"https:\/\/mathewingram.com\/work\/2006\/11\/10\/warning-this-is-off-the-geek-o-meter\/","title":{"rendered":"Warning: this is off the geek-o-meter"},"content":{"rendered":"

Being the geekish sort, I noticed with a smile that Slashdot — the venerable tech-focused chat forum\/social network that currently plays grouchy old grey-haired guy to young whippersnappers like Digg — broke down yesterday<\/a> after someone posted the 16,777,216th comment (which in itself should raise an eyebrow or two). <\/p>\n

Why? Well, obviously it’s because Slashdot’s MySQL database is structured in such a way that a table can only hold 2^24 data points, which is known as “an unsigned mediumint” (but you probably knew that). While the site changed the way it stores some of the comments — to allow as many as 4.1 billion — it didn’t change all of them and the 16,777,216th pushed the database over and broke it. “We shall flog ourselves appropriately,” said Commander Taco.<\/p>\n

\"blame<\/p>\n

But here’s the best part, as pointed out<\/a> by my friend and uber-geek Paul Kedrosky: the final comment came from a Canadian — a fiddle player, no less, with a band called Siobhan (his comment was something related to the Republicans and Democrats in the U.S. election). His nom de plume is Da Ghostface Fiddlah<\/a>. Once again, Canadians rule. Pwned.<\/p>\n

<\/div>","protected":false},"excerpt":{"rendered":"

Being the geekish sort, I noticed with a smile that Slashdot — the venerable tech-focused chat forum\/social network that currently plays grouchy old grey-haired guy to young whippersnappers like Digg — broke down yesterday after someone posted the 16,777,216th comment (which in itself should raise an eyebrow or two). Why? Well, obviously it’s because Slashdot’s … <\/p>\n

Continue reading “Warning: this is off the geek-o-meter”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crsspst_to_mathewingramblogwordpresscom":false,"mf2_syndication":[],"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1],"tags":[],"class_list":["post-711","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/mathewingram.com\/work\/wp-json\/wp\/v2\/posts\/711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mathewingram.com\/work\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mathewingram.com\/work\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mathewingram.com\/work\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mathewingram.com\/work\/wp-json\/wp\/v2\/comments?post=711"}],"version-history":[{"count":0,"href":"https:\/\/mathewingram.com\/work\/wp-json\/wp\/v2\/posts\/711\/revisions"}],"wp:attachment":[{"href":"https:\/\/mathewingram.com\/work\/wp-json\/wp\/v2\/media?parent=711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mathewingram.com\/work\/wp-json\/wp\/v2\/categories?post=711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mathewingram.com\/work\/wp-json\/wp\/v2\/tags?post=711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}