… been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to share…. While with the table having no secondary indexes, you can see that the insert rate is pretty much constant remaining between ~25k to ~26k… ahead to choose a table structure with no secondary indexes. Other important things to consider when you are concerned with write performance is using partitioning to…

…can explain the performance you are seeing. But first I’d like to note that this experiment isn’t…with this partitioning, however since you‘ll have to look in each of the ten partitions to query one of the indexes. If you…%93-the-wait-is-over/) on a newer version of iiBench showed that with 16GB of …

Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.

Justin, I would be doing another benchmark and use ‘innodb_ibuf_accel_rate’ together with tuning other IO related parameters that I can tune to good affect, and I will post my results.

… that stringent and I can afford to loose 1 second worth of data, hence I did not test with innodb_flush_log_at…_commit=1. I would also not recommend running on EBS with innodb_flush_log_at_trx_commit=1, because IO times…