MySQL Enterprise Testing

We will now look at an enterprise-oriented MySQL database 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. Warehouses will also have to be refilled by moving inventory around. We use MySQL (MariaDB 10.1) with the InnoDB database 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 SQL queries that were completed per second.