Percona Server 5.7.18-14

Percona is glad to announce the GA (Generally Available) release of Percona Server 5.7.18-14 on May 12, 2017 (Downloads are available here and from the Percona Software Repositories).

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

New Features

Percona Server 5.7 packages are now available for Ubuntu 17.04 (Zesty Zapus).

Percona Server now supports Prefix Index Queries Optimization. This feature was ported from a Facebook MySQL patch.

Percona Server has implemented support for Gap locks detection for transactional storage engines, like MyRocks, that do not support gap locks. This feature was ported from a Facebook MySQL patch.

tokudb_dir_cmd can now be used to edit the TokuDB directory map. This feature is currently considered Experimental.

Bugs Fixed

Deadlock could occur in I/O-bound workloads when server was using several small buffer pool instances in combination with small redo log files and variable innodb_empty_free_list_algorithm set to backoff algorithm. Bug fixed #1651657.

Fixed a memory leak in Percona TokuBackup. Bug fixed #1669005.

Compressed columns with dictionaries could not be added to a partitioned table by using ALTER TABLE. Bug fixed #1671492.

Fixed a memory leak that happened in case of failure to create a multi-threaded slave worker thread. Bug fixed #1675716.

In-Place upgrade from Percona Server 5.6 to 5.7 by using standalone packages would fail if /var/lib/mysql wasn’t defined as the datadir. Bug fixed #1687276.

Combination of using any audit API-using plugin, like Audit Log Plugin and Response Time Distribution, with multi-byte collation connection and PREPARE statement with a parse error could lead to a server crash. Bug fixed #1688698 (upstream #86209).

Fix for a #1433432 bug caused a performance regression due to suboptimal LRU manager thread flushing heuristics. Bug fixed #1631309.

Creating Compressed columns with dictionaries in MyISAM tables by specifying partition engines would not result in error. Bug fixed #1631954.

It was not possible to configure basedir as a symlink. Bug fixed #1639735.

Replication slave did not report Seconds_Behind_Master correctly when running in multi-threaded slave mode. Bug fixed #1654091 (upstream #84415).

DROP TEMPORARY TABLE would create a transaction in binary log on a read-only server. Bug fixed #1668602 (upstream #85258).

Processing GTIDs in the relay log that were already been executed were causing write/fsync amplification. Bug fixed #1669928 (upstream #85141).

Text/BLOB fields were not handling sorting of the empty string consistently between InnoDB and filesort. Bug fixed #1674867 (upstream #81810) by porting a Facebook patch for MySQL.

InnoDB adaptive hash index was using a partitioning algorithm which would produce uneven distribution when the server contained many tables with an identical schema. Bug fixed #1679155 (upstream #81814).

For plugin variables that are signed numbers, doing a SHOW VARIABLES would always show an unsigned number. Fixed by porting a Facebook patch for MySQL.

Other bugs fixed: #1629250 (upstream #83245), #1660828 (upstream #84786), #1664519 (upstream #84940), #1674299, #1670588 (upstream #84173), #1672389, #1674507, #1675623, #1650294, #1659224, #1662908, #1669002, #1671473, #1673800, #1674284, #1676441, #1676705, #1676847 (upstream #85671), #1677130 (upstream #85678), #1677162, #1677943, #1678692, #1680510 (upstream #85838), #1683993, #1684012, #1684078, #1684264, #1687386, #1687432, #1687600, and #1674281.