I was browsing Hacker News while Twitter was down, and saw this gem of a story from @Pinboard about the early days of Twitter.pic.twitter.com/QAt66cjJ2F
You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more
That's definitely a good way to kill wedged SQL queries.
I've been thinking about this, and I'm pretty sure this could be a unicorn startup idea. ctrl-c-as-a-service: a freemium product that can send a ctrl-c command to a remote terminal window. The paid pro version can do ctrl-alt-delete.
FastCompany website when I took over from the good people that built it had a cron job that would force restart MySQL every hour, otherwise uptime would have been in the nine fives if not nine ones.
Rebooting fixes everything!
In '10 or so, @flo, @lintool, @babak_hamadani and I wrote a paper describing v2 (3?) of the account search system we built at Twitter, where we even handled updating search indices by killing search shards via RPC, letting them restart with new data.
was that the one with offline index generation in Hadoop? (That one probably cost me a few whole weeks of sleep, altogether, and caused a deep-rooted, and likely unfair, dislike of HBase)
Yeah, not really. Twitter was overly-reliant on cache (in MySQL and memcache) in 2008. Rebooting would generally make that even worse. Had to manually warm dB caches before putting them online.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.