MySQL 5.5.4 in tpcc-like workloadVadim Tkachenko
MySQL-5.5.4 ® is the great release with performance improvements, let’s see how it performs in
The full details are on Wiki page
I took MySQL-5.5.4 with InnoDB-1.1, tpcc-mysql benchmark with 200W ( about 18GB worth of data),
InnoDB log files are 3.8GB size, and run with different buffer pools from 20GB to 6GB. The storage is FusionIO 320GB MLC card with XFS-nobarrier. .
While the raw results are available on Wiki, there are graphical results.
I intentionally put all line on the same graph to show trends.
It seems adaptive_flushing is not able to keep up and you see periodical drops when InnoDB starts flushing. I hope InnoDB team will fix it before 5.5 GA.
I expect reasonable request how it can be compared with Percona Server/XtraDB, so there is
the same load on our server:
As you see our adaptive_checkpoint algorithm is performing much stable.
And to put direct comparison, there is side-to-side results for 10GB buffer_pool case.
So as you see InnoDB is doing great, trying to keep performance even, as in previous release, there was about 1.7x times difference. I expect to see more improvements in 5.5-GA.
I posted results with
innodb_io_capacity=500 and 2000
So when data fits into memory ( buffer_pool=24Gb), it seems innodb_io_capacity=2000 will help to avoid periodical drops in MySQL 5.5.4.
It does not help though when buffer_pool is smaller than dataset.