Following my previous benchmark of Samsung 830, today I want to show results for
STEC MACH16 SATA card, 200GB size, this card is based on SLC, and
regarding STEC website, it is an enterprise grade storage.
For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and recently I switched to use async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and second, async mode allows to see maximal possible throughput, it does not show reliable latency though, as it appears there is no a reliable way in the Linux asynchronous IO library to get time metrics for particular IO …[Read more]