Percona Server for MySQL 5.6.31-77.0

Percona is glad to announce the release of Percona Server for MySQL 5.6.31-77.0 on July 7th, 2016 (Downloads are available here and from the Percona Software Repositories).

Based on MySQL 5.6.31, including all the bug fixes in it, Percona Server for MySQL 5.6.31-77.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.31-77.0 milestone at Launchpad.

New Features

Percona Server for MySQL has implemented protocol support for TLS 1.1 and TLS 1.2. This implementation turns off TLS v1.0 support by default.

TokuDB MTR suite is now part of the default MTR suite in Percona Server for MySQL 5.6.

Bugs Fixed

Querying the GLOBAL_TEMPORARY_TABLES table would cause server crash if temporary table owning threads would execute new queries. Bug fixed #1581949.

Audit Log Plugin would hang when trying to write log record of audit_log_buffer_size length. Bug fixed #1588439.

Audit log in ASYNC mode could skip log records which don’t fit into log buffer. Bug fixed #1588447.

The innodb_log_block_size feature attempted to diagnose the situation where the logs have been created with a log block value that differs from the current innodb_log_block_size setting. But this diagnostics came too late, and a misleading error No valid checkpoints found was produced first, aborting the startup. Bug fixed #1155156.

Some transaction deadlocks did not increase the INFORMATION_SCHEMA.INNODB_METRICS lock_deadlocks counter. Bug fixed #1466414 (upstream #77399).

InnoDB tablespace import would fail when trying to import a table with different data directory. Bug fixed #1548597 (upstream #76142).

Audit Log Plugin was truncating SQL queries to 512 bytes. Bug fixed #1557293.

Regular user extra port connection would fail if max_connections plus one SUPER user were already connected on the main port, even if it connecting would not violate the extra_max_connections. Bug fixed #1583147.

The error log warning Too many connections was only printed for connection attempts when max_connections plus one SUPER have connected. If the extra SUPER is not connected, the warning was not printed for a non-SUPER connection attempt. Bug fixed #1583553.

mysqlbinlog did not free the existing connection before opening a new remote one. Bug fixed #1587840 (upstream #81675).

Fixed memory leaks in mysqltest. Bugs fixed #1582718 and #1588318.

Fixed memory leaks in mysqlcheck. Bug fixed #1582741.

Fixed memory leak in mysqlbinlog. Bug fixed #1582761 (upstream #78223).

Fixed memory leaks in mysqldump. Bug fixed #1587873 and #1588845 (upstream #81714).

Fixed memory leak in non-existing defaults file handling. Bug fixed #1588344.

Fixed memory leak in mysqlslap. Bug fixed #1588361.

Transparent Huge Pages check will now only happen if tokudb_check_jemalloc option is set. Bugs fixed #939 and #713.

Logging in ydb environment validation functions now prints more useful context. Bug fixed #722.

Other bugs fixed: #1588386, #1529885, #1541698 (upstream #80261), #1582681, #1583589, #1587426 (upstream, #81657), #1589431, #956, and #964.