Re:Paul Buchheit: The secret to making things easy: avoid ha...
by paul on Tuesday April 24, 2007 @07:34PM
(#16472)
BTW, in case anyone is thinking, "why would I need more than 167 transactions per second", imagine that you have a web site that displays everyone's "last active" time (for chat maybe). If users are performing some activity once every 30 sec, then you will be pretty much be at your limit with about 5000 simultaneous users.
Robert, did you test MySQL with a parallel load? To give it the best chance at maximizing tps, it will need to be able to combine multiple pending transactions in a single write. Also, can you tell if it's updating it's b-trees? (if not, it may not be able to sustain these rates)
Re:Paul Buchheit: The secret to making things easy: avoid ha...
by rtm on Wednesday April 25, 2007 @02:33AM
(#16574)
I ran the test with 1,000,000 INSERTs (taking 200 seconds),
with the innodb cache size set to only 200,000 bytes.
So there's a fair chance it updated the b-trees on disk.
Robert, did you test MySQL with a parallel load? To give it the best chance at maximizing tps, it will need to be able to combine multiple pending transactions in a single write. Also, can you tell if it's updating it's b-trees? (if not, it may not be able to sustain these rates)