Shulou(Shulou.com)06/01 Report--

This article mainly explains "what are the advantages of the latest version of Percona Server". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what are the advantages of the latest version of Percona Server"?

Released from Percona Server 5.5.44-37.3, this version is based on MySQL 5.5.44, including all its bug fixes, and is the latest stable version of the current 5.5 series. This version is now available for download and is also available at Percona Software Repositories.

Bugs repair

Symlinks to libmysqlclient libraries were missing on CentOS 6. Bug fixed # 1408500.

RHEL/CentOS 6.6OpenSSL package (1.0.1e-30.el6_6.9), containing a fix for CVE-2015-4000, changed the DH key sizes to a minimum of 768bits. This caused an issue for MySQL as it uses 512 bit keys. Fixed by backporting an upstream 5.7 fix that increases the key size to 2048 bits. Bug fixed # 1462856 (upstream # 77275).

Innochecksum would fail to check tablespaces in compressed format. The fix for this bug has been ported from Facebook MySQL 5.1 patch. Bug fixed # 1100652 (upstream # 66779).

Issuing SHOW BINLOG EVENTS with an invalid starting binlog position would cause a potentially misleading message in the server error log. Bug fixed # 1409652 (upstream # 75480).

While using max_slowlog_size, the slow query log was rotated every time slow query log was enabled, not really checking if the current slowlog is indeed bigger than max_slowlog_size or not. Bug fixed # 1416582.

If query_response_time_range_base variable was set as a command line option or in a configuration file, its value would not take effect until the first flush was made. Bug fixed # 1453277 (Preston Bennes).

Prepared XA transactions with update undo logs were not properly recovered. Bug fixed # 1468301.

Variable log_slow_sp_statements now supports skipping the logging of stored procedures into the slow log entirely with new OFF_NO_CALLS option. Bug fixed # 1432846.

Other bug fixes: # 1380895 (upstream # 72322). See the release notes for more improvements.

Percona Server 5.6.25-73.0 is released, which is now available on Percona web site and Software Repositories.

This version is based on MySQL 5.6.25, including all its bug fixes, and is the latest GA version of the current 5.6 series.

New features

Percona Server implements the support for PROXY protocol.

Bugs repair

Symlinks to libmysqlclient libraries were missing on CentOS 6. Bug fixed # 1408500.

RHEL/CentOS 6.6OpenSSL package (1.0.1e-30.el6_6.9), containing a fix for CVE-2015-4000, changed the DH key sizes to a minimum of 768bits. This caused an issue for MySQL as it uses 512 bit keys. Fixed by backporting an upstream 5.7 fix that increases the key size to 2048 bits. Bug fixed # 1462856 (upstream # 77275).

Some compressed InnoDB data pages could be mistakenly considered corrupted, crashing the server. Bug fixed # 1467760 (upstream # 73689) Justin Tolmer.

Innochecksum would fail to check tablespaces in compressed format. The fix for this bug has been ported from Facebook MySQL 5.6 patch. Bug fixed # 1100652 (upstream # 66779).

Using concurrent REPLACE, LOAD DATA REPLACE or INSERT ON DUPLICATE KEY UPDATE statements in the READ COMMITTED isolation level or with the innodb_locks_unsafe_for_binlog option enabled could lead to a unique-key constraint violation. Bug fixed # 1308016 (upstream # 76927).

Issuing SHOW BINLOG EVENTS with an invalid starting binlog position would cause a potentially misleading message in the server error log. Bug fixed # 1409652 (upstream # 75480).

While using max_slowlog_size, the slow query log was rotated every time slow query log was enabled, not really checking if the current slowlog is indeed bigger than max_slowlog_size or not. Bug fixed # 1416582.

Fixed possible server assertions when Backup Locks are used. Bug fixed # 1432494.

If query_response_time_range_base variable was set as a command line option or in a configuration file, its value would not take effect until the first flush was made. Bug fixed # 1453277 (Preston Bennes).

Mysqld_safe script is now searching for libjemalloc.so.1 library, needed by TokuDB, in the basedir directory as well. Bug fixed # 1462338.

Prepared XA transactions could cause a debug assertion failure during the shutdown. Bug fixed # 1468326.

Variable log_slow_sp_statements now supports skipping the logging of stored procedures into the slow log entirely with new OFF_NO_CALLS option. Bug fixed # 1432846.

TokuDB HotBackup library is now automatically loaded with mysqld_safe script. Bug fixed # 1467443.

Other bug fixes # 1457113, # 1380895, and # 1413836. See the release notes for more improvements.

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.

Thank you for your reading, the above is the "what are the advantages of the latest version of Percona Server" content, after the study of this article, I believe you have a deeper understanding of the advantages of the latest version of Percona Server, the specific use of the need for you to practice and verify. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.