Election 2012: Twitter Breaks Records with MySQL

Twitter VP of Infrastructure Operations Engineering Mazen Rawashdeh shared news and numbers yesterday on his blog:

"Last night, the world tuned in to Twitter to share the election results as U.S. voters chose a president and settled many other campaigns. Throughout the day, people sent more than 31 million election-related Tweets (which contained certain key terms and relevant hashtags). And as results rolled in, we tracked the surge in election-related Tweets at 327,452 Tweets per minute (TPM). These numbers reflect the largest election-related Twitter conversation during our 6 years of existence, though they don’t capture the total volume of all Tweets yesterday."

"Last night, Twitter averaged about 9,965 TPS from 8:11pm to 9:11pm PT, with a one-second peak of 15,107 TPS at 8:20pm PT and a one-minute peak of 874,560 TPM. Seeing a sustained peak over the course of an entire event is a change from the way people have previously turned to Twitter during live events. Now, rather than brief spikes, we are seeing sustained peaks for hours."

Congrats to Jeremy Cole, Davi Arnaut and the rest of the team at Twitter for their excellent work!

Jeremy recently held a keynote presentation at MySQL Connect describing how MySQL powers Twitter, and why they chose and continue to rely on MySQL for their operations. You can watch the presentation here. He also went into more details during another presentation later that day and you can access the slides here.

Below a couple of tweets from Jeremy after what have surely been hectic days...

 Keep up the good work guys!




Comments:

How was this measured? Simple sql queries? Full ACID transactions? I don't need the sql but some idea of rows returned, sorts, joins would be helpful.

Posted by Mark Grennan on November 08, 2012 at 10:51 PM GMT #

Hi Mark, thanks for the comment. The information came from this blog: http://engineering.twitter.com/2012/11/bolstering-our-infrastructure.html. This is what Twitter shared.

Posted by guest on November 09, 2012 at 07:54 AM GMT #

Note that TPS in this case is Tweets Per Second, not MySQL transactions or any other kind of transactions. (transactions per second of course is way higher than tweets written)

Posted by Henrik Ingo on November 09, 2012 at 12:00 PM GMT #

Post a Comment:
Comments are closed for this entry.
About

Get the latest updates on products, technology, news, events, webcasts, customers and more.

Twitter


Facebook

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
5
6
9
10
11
12
13
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today