Percona Server 5.6.16-64.0

Milestone information

Project:
Percona Server
Series:
5.6
Version:
5.6.16-64.0
Released:
2014-03-10  
Registrant:
Hrvoje Matijakovic
Release registered:
2014-03-10
Active:
No. Drivers cannot target bugs and blueprints to this milestone.  

Download RDF metadata

Activities

Assigned to you:
No blueprints or bugs assigned to you.
Assignees:
3 Alexey Bychko, 2 Alexey Kopytov, 1 George Ormond Lorch III, 1 Hrvoje Matijakovic, 16 Laurynas Biveinis, 1 Sergei Glushchenko, 11 Stewart Smith, 1 Tomislav Plavcic, 1 Vlad Lesin
Blueprints:
10 Implemented
Bugs:
29 Fix Released

Download files for this release

File Description Downloads

Release notes 

Changelog 

View the full changelog

New Features

Percona Server has implemented Backup Locks that can be used as a lightweight alternative to FLUSH TABLES WITH READ LOCK for taking physical and logical backups.

Percona Server has split a new LRU manager thread out of the InnoDB cleaner thread, that performs LRU flushes and evictions to refill the free lists.

Percona Server now has server-side support for TokuDB Compression option syntax.

Percona Server has implemented Slow Query Log Rotation and Expiration feature to provide users with better control of slow query log disk space usage.

Ability to change database for mysqlbinlog has been ported from Percona Server 5.1.

In order to comply with Linux distribution packaging standards Percona‘s version of libmysqlclient has been renamed to libperconaserver. The old name was conflicting with the upstream libmysqlclient. Except for packaging, libmysqlclient and libperconaserverclient of the same version do not have any differences. Users wishing to continue using libmysqlclient will have to install the corresponding package of their distribution, such as mysql-lib for CentOS and libmysqlclient18 for Ubuntu/Debian. Users wishing to build software against libperconaserverclient should install libperconaserverclient-dev package. An old version of Percona-built libmysqlclient will be available for download.

Bugs Fixed

The XtraDB version number in univ.i was incorrect. Bug fixed #1277383.

Percona Toolkit UDFs were only shipped with RPM packages. Bug fixed #1159625.

A debug server build will crash if, while performing a bulk insert to a partitioned table, one of the partitions will return a failure for end_bulk_insert handler call. Bug fixed #1204871 (upstream #71270).

Percona Server 5.6 installation on Debian would fail due to default config reference to /etc/mysql/conf.d which didn’t exist. Bug fixed #1206648.

Due to a regression in the buffer pool mutex split, a combination of InnoDB compression, write workload, and multiple active purge threads could lead to a server crash. Bug fixed #1247021.

Server would crash on startup when XA support functions were activated by a second storage engine. Fix for this bug was ported from MariaDB. Bug fixed #1255549 (upstream #47134).

FLUSH STATUS could cause a server crash on the next transaction commit if two XA-supporting storage engines are in use. Fix for this bug was ported from MariaDB. Bugs fixed #1255551 (upstream #70854).

auth_pam.so shared library needed for PAM Authentication Plugin was missing from RPM packages. Bug fixed #1268246.

Fix for bug #1227581, a buffer pool mutex split regression, was not complete, thus a combination of write workload to InnoDB compressed table and a tablespace drop could crash the server. Bug fixed #1269352.

Binary RPM packages couldn’t be built from source tarballs on Fedora 19. Bug fixed #1229598.

Percona Server compilation with Performance Schema turned off would fail due to regression introduced by the 5.6 priority mutex framework. Bug fixed #1272747.

The InnoDB page cleaner thread could have incorrectly decided whether the server is busy or idle on some of its iterations and consequently issue a too big flush list flushing request on a busy server, causing performance instabilities. Bug fixed #1238039 (upstream #71988).

Percona Server had different server version value when installing from Source and from Binary/RPM. Bug fixed #1244178.

InnoDB did not handle the cases of asynchronous and synchronous I/O requests completing partially or being interrupted. Bugs fixed #1262500 (upstream #54430), and #1263087 (Andrew Gaul).

The fix for upstream bug #70768 may cause a high rate of RW lock creations and destructions, resulting in a performance regression on some workloads. Bug fixed #1279671 (upstream #71708).

Debian and Ubuntu packaging has been reworked to meet the packaging standards. Bug fixed #1281261.

Fixed the CMake warnings that were happening when Makefile was generated. Bugs fixed #1274827, upstream bug fixed #71089 and #1274411 (upstream #71094).

On Ubuntu Precise multiple architecture versions of libmysqlclient18 couldn’t be installed side by side. Bug fixed #1052636.

Percona Server source tree has been reorganized to match the MySQL source tree layout closer. Bug fixed #1014477.

Performance schema autosizing heuristics have been updated to account for Percona Server-specific wait/synch/mutex/sql/THD::LOCK_temporary_tables mutex. Bug fixed #1264952.

Other bugs fixed: #1276445, #1005787, #1285064, #1229598, and #1277505 (upstream #71624).

10 blueprints and 29 bugs targeted

Blueprint Priority Assignee Delivery
Merge MySQL 5.6.16 5 Essential Laurynas Biveinis  11 Implemented
Add functionality to Percona Server lightweight locks 4 High Alexey Kopytov  11 Implemented
Document backup locks 4 High Hrvoje Matijakovic  11 Implemented
Problems with Multiple XA Storage Engines in MySQL 5.6 4 High Laurynas Biveinis  11 Implemented
Split LRU flushes to a separate thread 4 High Laurynas Biveinis  11 Implemented
Support TokuDB Compression Algorithms 4 High Laurynas Biveinis  11 Implemented
libperconaserverclient for PS5.6 4 High Stewart Smith  11 Implemented
port --rewrite-db mysqlbinlog option from 5.1 to 5.6 4 High Vlad Lesin  11 Implemented
sync 5.6 debian packaging with Debian MySQL Packaging 4 High Stewart Smith  11 Implemented
Implement slowlog rotation and expiration similar to binlog 3 Medium Sergei Glushchenko  11 Implemented
Bug report Importance Assignee Status
1018291 #1018291 Database administrator password can be seen in plain text if you execute debconf-get-selections 3 High Stewart Smith  10 Fix Released
1159625 #1159625 PT UDFs are only shipped with RPM 3 High Stewart Smith  10 Fix Released
1204871 #1204871 abort in ha_partition::end_bulk_insert | sql/ha_partition.cc:4438: virtual int ha_partition::end_bulk_insert(): Assertion `0' failed. (sig6) 3 High Laurynas Biveinis  10 Fix Released
1206648 #1206648 percona 5.6 install on debian fails due to default config reference to /etc/mysql/conf.d 3 High Stewart Smith  10 Fix Released
1247021 #1247021 Assertion failure in file buf0buf.cc line 3687, buf_page_init_for_read() w/ multiple purge threads and compressed tables 3 High Laurynas Biveinis  10 Fix Released
1255549 #1255549 Crash on startup when XA support functions activated by a second engine 3 High Laurynas Biveinis  10 Fix Released
1255551 #1255551 Tc_log_page_size should be unflushable or server crashes if 2 XA SEs installed 3 High Laurynas Biveinis  10 Fix Released
1268246 #1268246 auth_pam.so shared library missing from RPM 3 High Alexey Bychko  10 Fix Released
1269352 #1269352 InnoDB: failing assertion: buf_page_in_file(bpage) below buf_flush_page_and_try_neighbors() 3 High Laurynas Biveinis  10 Fix Released
1272747 #1272747 5.6 link failure with WITH_PFS=0 3 High Laurynas Biveinis  10 Fix Released
1277383 #1277383 Issue with PERCONA_INNODB_VERSION 3 High Tomislav Plavcic  10 Fix Released
1277505 #1277505 printf size_t results in a fatal warning in 32-bit debug builds 3 High Laurynas Biveinis  10 Fix Released
1099526 #1099526 XtraDB does not scale well on 12 core system for specific all in memory SELECT 4 Medium   10 Fix Released
1229598 #1229598 I can not build rpm from src.rpm for Fedora 19 4 Medium Stewart Smith  10 Fix Released
1238039 #1238039 Spurious innodb_io_capacity-sized flush list flushes on a loaded server 4 Medium Laurynas Biveinis  10 Fix Released
1244178 #1244178 Different Server version value when installing from Source/Binary/RPM 4 Medium Stewart Smith  10 Fix Released
1262500 #1262500 ibd files contain bogus trailing zeros and non-page size file sizes 4 Medium Laurynas Biveinis  10 Fix Released
1263087 #1263087 Percona Server 5.5 / 5.6 do not handle partial / interrupted AIO calls 4 Medium Laurynas Biveinis  10 Fix Released
1279671 #1279671 Upstream fix for http://bugs.mysql.com/bug.php?id=70768 causes RW lock creations and destructions at a high rate during ibuf merge 4 Medium Laurynas Biveinis  10 Fix Released
1281261 #1281261 ubuntu packaging issues for 14.04 4 Medium George Ormond Lorch III  10 Fix Released
1285064 #1285064 MDL_map::m_backup_log and m_binlog_lock are not deallocated 4 Medium Alexey Kopytov  10 Fix Released
1005787 #1005787 main.file_contents failure due to missing INFO_SRC in source tarball 5 Low Stewart Smith  10 Fix Released
1264952 #1264952 Adjust perfschema autosizing for Percona Server mutexes 5 Low Laurynas Biveinis  10 Fix Released
1274411 #1274411 ssl.cmake related warnings 5 Low Alexey Bychko  10 Fix Released
1274827 #1274827 CMake warning when generating Makefile 5 Low Alexey Bychko  10 Fix Released
1276445 #1276445 Various test suite files have execute bit set but aren't executable 5 Low Stewart Smith  10 Fix Released
1014477 #1014477 Percona Server source repository layout does not match that of MySQL 6 Wishlist Stewart Smith  10 Fix Released
1052636 #1052636 Multiple arch installation of libmysqlclient18 broken 6 Wishlist Stewart Smith  10 Fix Released
691601 #691601 SHOW INNODB STATUS reports non-FK errors in the FK section 1 Undecided   10 Fix Released
This milestone contains Public information
Everyone can see this information.