I recently was asked how many fsync / sec ( and therefore durable transactions / sec) we can get on FusionIO card.
It should be easy to test, let’s take sysbench fileio benchmark and run, the next command should make it:
./sysbench --test=fileio --file-num=1 --file-total-size=50G --file-fsync-all=on --file-test-mode=seqrewr --max-time=100 --file-block-size=4096 --max-requests=0 run
Operations performed: 0 Read, 922938 Write, 922938 Other = 1845876 Total
Read 0b Written 3.5207Gb Total transferred 3.5207Gb (36.052Mb/sec)
9229.35 Requests/sec executed
So that’s 9229.35 req/sec, which is pretty impressive.
For comparison the same run on PERC 6i RAID10 with BBU:
Operations performed: 0 Read, 4832661 Write, 4832661 Other = 9665322 Total
Read 0b Written 18.435Gb Total transferred 18.435Gb (20.975Mb/sec)
5369.62 Requests/sec executed
which gives us 5369.62 req/sec.
Note this is for single thread, and in MySQL/InnoDB multi-thread load you may get more transactions per second with group commit ( which is back to live in InnoDB-plugin / XtraDB )