Percona Server for MySQL 5.6.27-76.0

Percona is glad to announce the release of Percona Server for MySQL 5.6.27-76.0 on December 4th, 2015 (Downloads are available here and from the Percona Software Repositories).

Based on MySQL 5.6.27, including all the bug fixes in it, Percona Server for MySQL 5.6.27-76.0 is the current GA release in the Percona Server for MySQL 5.6 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.6.27-76.0 milestone at Launchpad.

New Features

SHOW SLAVE STATUS NOLOCK syntax in 5.6 has been undeprecated. Both SHOW SLAVE STATUS NOLOCK and SHOW SLAVE STATUS NONBLOCKING are now supported. Percona Server for MySQL originally used SHOW SLAVE STATUS NOLOCK syntax for this feature. As of 5.6.20-68.0 release, Percona Server for MySQL implements SHOW SLAVE STATUS NONBLOCKING syntax, which comes from early MySQL 5.7. Current MySQL 5.7 does not have this syntax and regular SHOW SLAVE STATUS is non-blocking.

TokuDB tables can now be automatically analyzed in the background based on a measured change in data.

Percona Server for MySQL has implemented new tokudb_strip_frm_data variable which can be used to assist in TokuDB data recovery. WARNING: Use this variable only if you know what you’re doing otherwise it could lead to data loss.

Bugs Fixed

Setting the tokudb_backup_last_error_string and tokudb_backup_last_error values manually could cause server assertion. Bug fixed #1512464.

Fixed invalid memory accesses when mysqldump was running with --innodb-optimize-keys option. Bug fixed #1517444.

Fixed incorrect filename specified in storage/tokudb/PerconaFT/buildheader/CMakeLists.txt which could cause subsequent builds to fail. Bug fixed #1510085 (Sergei Golubchik).

Fixed multiple issues with TokuDB CMake scripts. Bugs fixed #1510092, #1509219 and #1510081 (Sergei Golubchik).

An upstream fix for upstream bug #76135 might cause server to stall or hang. Bug fixed #1519094 (upstream #79185).

ps_tokudb_admin now prevents Percona TokuBackup activation if there is no TokuDB storage engine on the server. Bug fixed #1520099.

Percona TokuBackup plugin now gets removed during the TokuDB storage engine uninstall process. Bug fixed #1520472.

New --defaults-file option has been implemented for ps_tokudb_admin to specify the MySQL configuration file if it’s not in the default location. Bug fixed #1517021.

Other bugs fixed: #1425480, #1517523, #1515741 and #1513178.