In this blog post, I’ll discuss changes I’ve made to the
benchmark tool. These changes make it less random and support multi-schema.
This post might only be interesting to performance researchers. The
benchmark to is what I use to test different hardware (as an example, see my previous post: https://www.percona.com/blog/2016/07/26/testing-samsung-storage-in-tpcc-mysql-benchmark-percona-server/).
The first change is support for multiple schemas, rather than just one schema. Supporting only one schema creates too much internal locking in MySQL on the same rows or the same index. Locking is …[Read more]