MySQL Enterprise Testing

We added a new enterprise oriented MySQL benchmark to our suite to test storage performance in professional scenarios.

The benchmark's name is "TPC-C", and it's pretty much an industry standard for such testing. You can find more info about it here. It simulates a company with multiple warehouses where several users put in orders, record payments, check their order status, and monitor stock levels at the warehouse. The warehouses will also have to be refilled by moving inventory around. We use MySQL with the InnoDB storage engine and 32 warehouses. The concurrent user count is ramped up from 2 to 128 (indicated on the bottom of the graph). The vertical axis of the graph reflects the number of transactions per second, and one transaction usually consists of several database queries.