September 21, 2014

Percona Server 5.6.17-65.0 is now available

Percona Server version 5.6.17-65.0

Percona Server version 5.6.17-65.0

Percona is glad to announce the release of Percona Server 5.6.17-65.0 on May 6th, 2014. Downloads are available here and from the Percona Software Repositories.

Based on MySQL 5.6.17, including all the bug fixes in it, Percona Server 5.6.17-65.0 is the current GA release in the Percona Server 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.17-65.0 milestone at Launchpad.

New Features:

  • Percona Server now supports Metrics for scalability measurement.
  • Percona Server now supports Audit Log Plugin.
  • Percona Server parser and query optimizer now support Multiple Clustering Keys when TokuDB engine is used.
  • Storage engine handler interface has been extended with new calls to notify the storage engine of imminent table or index scan. The calls are used by TokuDB to improve performance of these operations.
  • Percona Server packages are now available for Ubuntu 14.04.

Bugs Fixed:

  • Percona Server couldn’t be built with Bison 3.0. Bug fixed #1262439, upstream #71250 (Ryan Gordon).
  • Fixed the inadequate background LRU flushing for write workloads with InnoDB compression that could lead to lower performance. Bug fixed #1295268.
  • Percona Server debug packages were not built for the previous releases. Bug fixed #1298352.
  • Queries that no longer exceed long_query_time were written to the slow query log if they matched the previous long_query_time value when slow_query_log_use_global_control variable was set to all. Bug fixed #1016991.
  • When writing audit plugins it was not possible to get notifications for general-log events without enabling the general-log. Bug fixed #1182535 (upstream #60782).
  • mysqld_safe did not correctly parse flush_caches and numa_interleave options. Bug fixed #1231110.
  • Thread Pool would handle a new client connection without notifying Audit Plugin. Bug fixed #1282008.
  • Fixed a performance issue in extending tablespaces if running under fusionIO with atomic writes enabled. Bug fixed #1286114 (Jan Lindström).
  • Previous implementation of the log_slow_rate_type set to query with log_slow_rate_limit feature would log every nth query deterministically instead of each query having a 1/n probability to get logged. Fixed by randomly selecting the queries to be logged instead of logging every nth query. Bug fixed #1287650.
  • Percona Server source files were referencing Maatkit instead of Percona Toolkit. Bug fixed #1174779.
  • Maximum allowed value for log_slow_rate_limit was ULONG_MAX (ie. either 4294967295 or 18446744073709551615, depending on the platform). As it was unreasonable to configure the slow log for every four billionth session/query, new maximum allowed value is set to 1000. Bug fixed #1290714.

Other bugs fixed #1295523, #1299688 (upstream #72163) and #1272732.

Release notes for Percona Server 5.6.17-65.0 are available in our online documentation. Bugs can be reported on the launchpad bug tracker.

Comments

  1. akrus says:

    So Audit Log Plugin is exactly the same MySQL Enterprise has?

  2. Mateusz Kijowsi says:
  3. Flavian says:

    There was a upstream bug related to memory leak in multi threaded replication. Its fixed in Oracle Build of 5.6.17 but i cant see a fix release in Percona. https://bugs.launchpad.net/percona-server/+bug/1303619

    Can you confirm this please?

  4. AndyA says:

    I installed Percona Server 5.6.17-65.0 from scratch using your debian packages on a virtual machine (Debian Wheezy 64-bit) with 4GB RAM + 1 vCPU. All is working fine, except one thing, the CPU usage reaches 45% frequently ( http://s27.postimg.org/wbd9wx2k1/top.png ) while in another virtual machine with the same database (2 million rows) but using Percona Server 5.6 (first release) it barely reaches 3%. The my.cnf file is the same in both VMs ( http://pastebin.com/tW8dXkTN ). I do not understand what happened, is something changed in 5.6.17-65.0 that can increase the CPU usage ? I have performance_schema set to 0.

  5. patrik says:

    I got the ‘Bug #67179′ in this release on RH6 Linux:
    Installed the Binary 64 version: Percona-Server-5.6.17-rel65.0-587.Linux.x86_64.tar.gz
    Dropping the 5 tables and recreating them fix the problem.

Speak Your Mind

*