5 ms·
MySql can handle that with both hands tied in the back. No sweat.
by TweedHeads 17y ago
MySql can handle that with both hands tied in the back.
No sweat.
- poutine 17y agoUh, some of those 200 tweets per second are being sent to over a million people. Most are sent to hundreds or thousands.
- pietro 17y agoI don't think that actor guy posts every second, and the average number of followers is way lower than thousands.
- adbachman 17y agoThere are 13 users with 1000000+ and the top 100 all have over 450000. (http://twitterholic.com/ http://twitterholic.com/) But, long tail and all that, I hear average follower count is in the 120 range, you're right there. (http://gojko.net/2009/03/16/qcon-london-2009-upgrading-twitter-without-service-disruptions/ http://gojko.net/2009/03/16/qcon-london-2009-upgrading-twitt...)
- decode 17y agoI've always assumed that most people don't get every tweet SMS'd to them. So most of the time, a tweet isn't sent to anybody, it's just returned when people request the tweets that are relevant to them.
- daleharvey 17y agotwitter does not "INSERT INTO tweets VALUES ('me', 'new tweet', DATE())" what mysql can handle doing a completely different thing is pretty irrelevant
- deleted 17y ago[deleted]
- lallysingh 17y agoThe MySQL load is much higher than 200 Hz. Depending on how they do it, what you want to count as dependent load, and how you want to measure it all, you have a scalar for the average number of followers to update per tweet, work to update indices, etc.