MySQL Enterprise Testing

We will now look at an enterprise-oriented MySQL setup 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 information 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. 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 ramps up from 2 to 128 (indicated on the bottom of the graph), and the vertical axis of the graph reflects the number of transactions per second. One transaction usually consists of several database queries.