How many fsync / sec FusionIO can handle

March 4, 2010

Author

Vadim Tkachenko

Benchmarks

MySQL

Share this Post:

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

1	./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

1

2

3

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

1

2

3

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 )