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
Because when your query locks up so much tables that it brings the whole system down, your system is badly designed and needs an overhaul to handle the load.
for starters, why did running a query against one of the slave db hosts cause the site to go down? said db engineer did run the query against the slave, right? there were multiple slaves that handled only read queries, right???
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.