Performance comparison between Percona Server and MySQL 5.5

Percona has improved the MySQL database server and has a significant improvement in functionality and performance over MySQL. This release improves the performance of InnoDB in high load situations, provides some very useful performance diagnostic tools for DBAs, and additional parameters and commands to control server behavior.

The Percona server contains only the MySQL server version and does not provide a corresponding improvement to MySQL's Connector and GUI tools.

Percona Server uses some google-mysql-tools, Proven scaling, and Open Query to transform MySQL.

As you can see, MySQL 5.5.8 GA brings a lot of improvement and promotion, which is a very noteworthy version. The Percona Server is a derived version of MySQL that has been improved in performance, stability, and manageability. So will the release of the MySQL 5.5 official version of the Percona Server impact?

A few days ago Percona team published a detailed comparison of the two, Percona said it is not only to consider the peak performance issues, but also includes performance stability and predictability, Percona Server with an adaptive checkpoint algorithm. Percona also said that a Percona server/xtradb version based on the MySQL 5.5 code baseline is about to be released, and 5.5.7 has been released, but it is still beta-tested and can be downloaded from LaunchPad.

The Percona test platform is a DELL PowerEdge R900 machine that uses a RAID10 disk array, approximately 50G of test data, and configuration parameters:

innodb_buffer_pool_size=24g

innodb_log_file_size=2000m

innodb_log_files_in_group=2

innodb_flush_log_at_trx_commit=2

After 8 hours of test results:

　　

The above illustration shows that the Percona Server is less volatile in performance.