# Percona Server for MySQL 5.7.18-14 is Now Available

**URL:** <https://forums.percona.com/t/percona-server-for-mysql-5-7-18-14-is-now-available/5599>\
**Category:** Percona Server for MySQL 5.7\
**Created:** [May 15, 2017, 3:25am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-7-18-14-is-now-available/5599 "2017-05-15T03:25:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![hrvojem](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/hrvojem/32/6_2.png) [@hrvojem](https://forums.percona.com/u/hrvojem)\
**Post date:** [May 15, 2017, 3:25am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-7-18-14-is-now-available/5599/1 "2017-05-15T03:25:33Z")

</div>

Percona announces the GA release of [Percona Server for MySQL](https://www.percona.com/software/percona-server) 5.7.18-14 on May 12, 2017. Download the latest version from the [Percona web site](https://www.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.18-14/) or the Percona [Software Repositories](https://www.percona.com/doc/percona-server/5.7/installation.html#using-percona-software-repositories). You can also run Docker containers from the images in the [Docker Hub repository](https://hub.docker.com/r/percona/percona-server/).

Based on [MySQL 5.7.18](http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-18.html), including all the bug fixes in it, Percona Server for MySQL 5.7.18-14 is the current GA release in the Percona Server for MySQL 5.7 series. Percona’s provides completely open-source and free software. Find release details in the [5.7.18-14 milestone at Launchpad](https://launchpad.net/percona-server/+milestone/5.7.18-14). New Features:  
[LIST]  
[_]Percona Server 5.7 packages are now available for Ubuntu 17.04 (Zesty Zapus).  
[_]Percona Server now supports [Prefix Index Queries Optimization](https://www.percona.com/doc/percona-server/5.7/performance/prefix_index_queries_optimization.html#prefix-index-queries-optimization).  
[_]Percona Server has implemented support for [Gap locks detection](https://www.percona.com/doc/percona-server/5.7/myrocks/gap_locks_detection.html#gap-locks-detection) from a Facebook MySQL patch.  
[_]tokudb\_dir\_cmd variable can now be used to [edit the TokuDB files](https://www.percona.com/doc/percona-server/5.7/tokudb/tokudb_file_management.html#editing-tokudb-files-with-tokudb-dir-cmd).  
[/LIST]Bugs Fixed:  
[LIST]  
[_]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](https://www.percona.com/doc/percona-server/5.7/performance/xtradb_performance_improvements_for_io-bound_highly-concurrent_workloads.html#innodb_empty_free_list_algorithm) set to backoffalgorithm. Bug fixed [#1651657](https://bugs.launchpad.net/percona-server/+bug/1651657).  
[_]Fixed a memory leak in [Percona TokuBackup](https://www.percona.com/doc/percona-server/5.7/tokudb/toku_backup.html#toku-backup). Bug fixed [#1669005](https://bugs.launchpad.net/percona-server/+bug/1669005).  
[_][Compressed columns with dictionaries](https://www.percona.com/doc/percona-server/5.7/flexibility/compressed_columns.html#compressed-columns) could not be added to a partitioned table by using ALTER TABLE. Bug fixed [#1671492](https://bugs.launchpad.net/percona-server/+bug/1671492).  
[_]Fixed a memory leak that happened in case of failure to create a multi-threaded slave worker thread. Bug fixed [#1675716](https://bugs.launchpad.net/percona-server/+bug/1675716).  
[_]In-place upgrade from Percona Server 5.6 to 5.7 by using standalone packages would fail if /var/lib/mysqlwasn’t defined as the datadir. Bug fixed [#1687276](https://bugs.launchpad.net/percona-server/+bug/1687276).  
[_]Combination of using any audit API-using plugin, like [Audit Log Plugin](https://www.percona.com/doc/percona-server/5.7/management/audit_log_plugin.html#audit-log-plugin) and [Response Time Distribution](https://www.percona.com/doc/percona-server/5.7/diagnostics/response_time_distribution.html#response-time-distribution), with multi-byte collation connection and PREPARE statement with a parse error could lead to a server crash. Bug fixed [#1688698](https://bugs.launchpad.net/percona-server/+bug/1688698) (upstream [#86209](http://bugs.mysql.com/bug.php?id=86209)).  
[_]Fix for a [#1433432](https://bugs.launchpad.net/percona-server/+bug/1433432) bug caused a performance regression due to suboptimal LRU manager thread flushing heuristics. Bug fixed [#1631309](https://bugs.launchpad.net/percona-server/+bug/1631309).  
[_]Creating [Compressed columns with dictionaries](https://www.percona.com/doc/percona-server/5.7/flexibility/compressed_columns.html#compressed-columns) in MyISAM tables by specifying partition engines would not result in error. Bug fixed [#1631954](https://bugs.launchpad.net/percona-server/+bug/1631954).  
[_]It was not possible to configure basedir as a symlink. Bug fixed [#1639735](https://bugs.launchpad.net/percona-server/+bug/1639735).  
[_]Replication slave did not report Seconds\_Behind\_Master correctly when running in multi-threaded slave mode. Bug fixed [#1654091](https://bugs.launchpad.net/percona-server/+bug/1654091) (upstream [#84415](http://bugs.mysql.com/bug.php?id=84415)).  
[_]DROP TEMPORARY TABLE would create a transaction in binary log on a read-only server. Bug fixed [#1668602](https://bugs.launchpad.net/percona-server/+bug/1668602)(upstream [#85258](http://bugs.mysql.com/bug.php?id=85258)).  
[_]Processing GTIDs in the relay log that were already been executed were causing write/fsync amplification. Bug fixed [#1669928](https://bugs.launchpad.net/percona-server/+bug/1669928) (upstream [#85141](http://bugs.mysql.com/bug.php?id=85141)).  
[_]Text/BLOB fields were not handling sorting of the empty string consistently between InnoDB and filesort. Bug fixed [#1674867](https://bugs.launchpad.net/percona-server/+bug/1674867) (upstream [#81810](http://bugs.mysql.com/bug.php?id=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](https://bugs.launchpad.net/percona-server/+bug/1679155) (upstream [#81814](http://bugs.mysql.com/bug.php?id=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.  
[/LIST]  
Other bugs fixed: [#1629250](https://bugs.launchpad.net/percona-server/+bug/1629250) (upstream [#83245](http://bugs.mysql.com/bug.php?id=83245)), [#1660828](https://bugs.launchpad.net/percona-server/+bug/1660828) (upstream [#84786](http://bugs.mysql.com/bug.php?id=84786)), [#1664519](https://bugs.launchpad.net/percona-server/+bug/1664519) (upstream [#84940](http://bugs.mysql.com/bug.php?id=84940)), [#1674299](https://bugs.launchpad.net/percona-server/+bug/1674299), [#1670588](https://bugs.launchpad.net/percona-server/+bug/1670588) (upstream [#84173](http://bugs.mysql.com/bug.php?id=84173)), [#1672389](https://bugs.launchpad.net/percona-server/+bug/1672389), [#1674507](https://bugs.launchpad.net/percona-server/+bug/1674507), [#1675623](https://bugs.launchpad.net/percona-server/+bug/1675623), [#1650294](https://bugs.launchpad.net/percona-server/+bug/1650294), [#1659224](https://bugs.launchpad.net/percona-server/+bug/1659224), [#1662908](https://bugs.launchpad.net/percona-server/+bug/1662908), [#1669002](https://bugs.launchpad.net/percona-server/+bug/1669002), [#1671473](https://bugs.launchpad.net/percona-server/+bug/1671473), [#1673800](https://bugs.launchpad.net/percona-server/+bug/1673800), [#1674284](https://bugs.launchpad.net/percona-server/+bug/1674284), [#1676441](https://bugs.launchpad.net/percona-server/+bug/1676441), [#1676705](https://bugs.launchpad.net/percona-server/+bug/1676705), [#1676847](https://bugs.launchpad.net/percona-server/+bug/1676847) (upstream [#85671](http://bugs.mysql.com/bug.php?id=85671)), [#1677130](https://bugs.launchpad.net/percona-server/+bug/1677130) (upstream [#85678](http://bugs.mysql.com/bug.php?id=85678)), [#1677162](https://bugs.launchpad.net/percona-server/+bug/1677162), [#1677943](https://bugs.launchpad.net/percona-server/+bug/1677943), [#1678692](https://bugs.launchpad.net/percona-server/+bug/1678692), [#1680510](https://bugs.launchpad.net/percona-server/+bug/1680510) (upstream [#85838](http://bugs.mysql.com/bug.php?id=85838)), [#1683993](https://bugs.launchpad.net/percona-server/+bug/1683993), [#1684012](https://bugs.launchpad.net/percona-server/+bug/1684012), [#1684078](https://bugs.launchpad.net/percona-server/+bug/1684078), [#1684264](https://bugs.launchpad.net/percona-server/+bug/1684264), [#1687386](https://bugs.launchpad.net/percona-server/+bug/1687386), [#1687432](https://bugs.launchpad.net/percona-server/+bug/1687432), [#1687600](https://bugs.launchpad.net/percona-server/+bug/1687600), and [#1674281](https://bugs.launchpad.net/percona-server/+bug/1674281).

The release notes for Percona Server for MySQL 5.7.18-14 are available in the [online documentation](https://www.percona.com/doc/percona-server/5.7/release-notes/Percona-Server-5.7.18-14.html). Please report any bugs on the [launchpad bug tracker](https://bugs.launchpad.net/percona-server/+filebug).
