How does InnoDB do on high IOPs servers? Thanks to SSD, many of us will soon have such servers. I will provide more details in my talks:
The summary is that InnoDB is very effective at using the read capacity of a high IOPs server. It has problems at using enough of the write capacity. Alas, this is InnoDB and the problem is easy to fix. Many of the fixes are in the v3 Google patch. Many are also in the Percona patches and builds. Although there may be one fix in the v3 Google patch that Percona has yet to implement.
Note that I may mention the P word a few times in my talk today and tomorrow.
Wednesday, April 22, 2009
Subscribe to:
Post Comments (Atom)
Posts
Hi - can you provide the slides or a summary of the MySQL perf on EC2 presentation? Thanks!
ReplyDeleteThe summary is that performance is pretty good but you may need a few patches depending on which features you use.
ReplyDeleteSlides are on my blog at http://mysqlha.blogspot.com/2009/04/slides-for-mysql-user-conference-2009.html