Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "performance comparison between Percona Server and MySQL 5.5". Many people will encounter this dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Percona has made improvements to the MySQL database server, which is significantly better than MySQL in terms of function and performance. This version improves the performance of InnoDB under high load, provides some very useful performance diagnostic tools for DBA, and has more parameters and commands to control server behavior.

Percona Server contains only the server version of MySQL and does not provide corresponding improvements 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 great improvements and enhancements, which is a very noteworthy version. Percona Server is a derivative of MySQL with improvements in performance, stability, and manageability. So will the release of MySQL 5.5 have an impact on Percona Server?

A few days ago, the Percona team published an article to compare the two in detail. Percona said that it considers not only the problem of peak performance, but also the stability and predictability of performance. Percona Server has an adaptive checkpointing algorithm. Percona also said that a version of Percona Server/XtraDB based on the MySQL 5.5 code baseline is about to be released. Version 5.5.7 has been released, but it is still under Beta testing and is available from LaunchPad.

Percona testing platform is a DELL PowerEdge R900 machine, using Raid10 disk array, about 50 GB of test data, 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

This is the end of "performance comparison between Percona Server and MySQL 5.5". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.