… traditional InnoDB log flushing, which can cause downward spikes in performance. Other then that, I have also disabled query cache to… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and… important things to consider when you are concerned with write performance is using partitioning to reduce the size of the B…

…Andy, I am not testing IO performance and instead trying to optimize writes, also the durability requirements …

…’s a theory that seems to explain the performance you are seeing. The periodic performance variation corresponds to filling up a partition…’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the partition switches. So performance gets worse…

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?

… periodic drops in performance which might be the result of the insert buffer filling up and then decreasing performance until some space… your test. Mark Callaghan over at Facebook has seen big performance difference on insertion rate when increased insert buffer flushing was…