See Twitter's SQL.

It seems like twitter is taking fail to new levels every day.

They really weren't kidding when they said that they'd mistakenly built it as a CMS instead of as a messaging platform.

Did anyone get a screenshot before they disabled it?

here's a screenshot. i didn't include the table stuffs. <a href="http://skitch.com/thomasswift/xef3/twitter" rel="nofollow">http://skitch.com/thomasswift/xef3/twitter</a>

I dimed this out and had it disabled. Twitter doesn't need people poking through its' SQL. Imagine what we'd find if we were poking through yours...

these queries are not optimised at all. first of all, every page gives of MySQL warnings...and second, there are alot of SELECT count(*)...instead of SELECT count(1). This may not seem like it would increase speed alot but given the number of users and the amount of times that query is executed, it will speed up twitter by a bit. There are a few other things that i have noticed...they should really clean up their sql

Wish I'd taken a screenshot now.<p>It was basically a semi-transparent box in the top left of the screen which showed you the query as well as which DB served the data (for me they came from db007, and the friend data from some shards), and two links, one for a popdown box with info about the query, and another with the file trace infomation.<p>Quite intresting, shame they have removed it.

I give up. How do I enable the analyzer?

Seems like this was a mistake by twitter: <a href="http://getsatisfaction.com/twitter/topics/staging_twitter_com?utm_medium=widget&#38;utm_source=widget_twitter" rel="nofollow">http://getsatisfaction.com/twitter/topics/staging_twitter_co...</a><p>Some profile pages are being linked to the staging server.

Thanks to Twitter's chief architect for giving me a good laugh :)

Wouldn't a working service be more interesting than this thing? Or are they expecting us to fix their code?

Too bad we can't run 'explain plan' on them :)

Before being acuired by Google, does anyone know Jaiku's uptime and other stats? Were they too this bad as Twitter?

Yeesh. This does not seem safe.<p>At least maybe (big maybe) some good will come of this?

Mmmm... this should be juicy hacker fun for a few days!