MySQL Enterprise Testing

We added a new test to our SSD testing suite, which is an enterprise oriented MySQL benchmark.

The benchmark's name is "TPC-C", and it's pretty much an industry standard for this kind of 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 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; one transaction usually consists of several database queries.
We tested with a single drive, no RAID.