@Time Callaghan, I did not test with innodb_flush_log_at_trx_commit=1 because the durability requirements are not that stringent. And following is how I invoked iiBench: iibench -T $tbl_name -D iiBench -r 200000000 -M 1 -s 1000000 -t 100000 -I 1 -a -S

…Andy, I am not testing IO performance and instead trying to optimize writes, also the … loose 1 second worth of data, hence I did not test with innodb_flush_log_at_trx_commit=1. I would…

Interesting results, and well presented. Would you mind sharing the command line you used for your iiBench clients? Also, did you run a test with innodb_flush_log_at_trx_commit = 1?

This benchmark doesn’t test the IO performance of EBS though as you’re not flushing to disks on each commit. What numbers do you get when you set innodb_flush_log_at_trx_commit to 1?

…_accel_rate) which might be interesting to tweak during your test. Mark Callaghan over at Facebook has seen big performance difference…

… I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB options innodb…, for a total of 1 billion rows. I ran the test both with the table purchases_noindex which has no secondary…