I personally like PCIe based Flash, but from a pricing point our
customers are looking for cheaper alternatives. SATA SSD is an
options. There is many products based on MLC technology, and
Intel 320 I would say is the most popular. I do not particularly
like its write performance – I wrote about it before, that’s why I am looking for
comparable alternatives. Samsung 830 256GB looked like a good
product, that’s why I decided to test it.
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 …[Read more]