Percona has improved the MySQL database server and significantly improved its functions and performance compared with MySQL. This version improves the performance of InnoDB under high loads and provides DBA with some useful performance diagnostic tools. In addition, more parameters and commands are available to control server behavior.
Percona Server only contains the MySQL Server version, and does not provide corresponding improvements to MySQL Connector and GUI tools.
Percona Server uses google-mysql-tools, Proven Scaling, and Open Query to transform MySQL.
As you can see, MySQL 5.5.8 GA has brought about great improvements and improvements. This is a very noteworthy version. Percona Server is a derivative version of MySQL, which improves performance, stability, and manageability. So will the release of MySQL 5.5 official version impact Percona Server?
Recently, the Percona team published an article to compare the two in detail. Percona said that it not only considers the performance peak issue, but also includes the performance stability and predictability, percona Server has an adaptive checkpoint algorithm. Percona also said that the version of Percona Server/XtraDB Based on the MySQL 5.5 code baseline will be released. Currently, version 5.5.7 has been released, but it is still in Beta testing status and can be downloaded from LaunchPad.
The platform for Percona testing is a DELL PowerEdge R900 machine that uses a raid 10 disk array and has about 50 GB of test data. Configure the parameters:
Innodb_buffer_pool_size = 24G
Innodb_log_file_size = 2000 M
Innodb_log_files_in_group = 2
Innodb_flush_log_at_trx_commit = 2
Test results after 8 hours:
It can be seen that the performance of Percona Server is less fluctuating.