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.
Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.
Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.