I believe InnoDB storage engine architecture is great for a lot of online workloads, however, there are no silver bullets in technology and all design choices have their trade offs. In this blog post Im going to talk about one important InnoDB limitation that you should consider. InnoDB is a multiversion concurrency control (MVCC) storage [&]

The post InnoDBs multi-versioning handling can be Achilles’ heel appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/12/17/innodbs-multi-versioning-handling-can-be-achilles-heel/