Percona Server for MySQL 5.6.11-60.3

Percona is glad to announce the first Release Candidate release of Percona Server for MySQL 5.6.11-60.3 on June 3rd, 2013 (Downloads are available here and from the Percona Software Repositories).

Based on MySQL 5.6.11, including all the bug fixes in it, Percona Server for MySQL 5.6.11-60.3 is the first RC 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.11-60.3 milestone at Launchpad.

This release contains all the bug fixes from latest Percona Server for MySQL 5.5 release (currently Percona Server for MySQL 5.5.31-30.3).

New Features

Percona Server for MySQL has implemented Log Archiving for XtraDB. Currently this feature implementation is considered ALPHA.

Ported Features

Percona Server for MySQL has ported priority connection scheduling for the Thread Pool from Percona Server for MySQL 5.5.

Percona Server for MySQL has ported the Atomic write support for Fusion-io devices patch from MariaDB. This feature adds atomic write support for directFS filesystem on Fusion-io devices. This feature implementation is considered BETA quality.

Percona Server for MySQL has ported innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage diagnostics.

Improved InnoDB I/O Scalability has been ported from Percona Server for MySQL 5.5

Improved NUMA support has been ported from Percona Server for MySQL 5.5

Suppress Warning Messages has been ported from Percona Server for MySQL 5.5

Improved MEMORY Storage Engine has been ported from Percona Server for MySQL 5.5

Restricting the number of binlog files has been ported from Percona Server for MySQL 5.5

Too Many Connections Warning has been ported from Percona Server for MySQL 5.5

Error Code Compatibility has been ported from Percona Server for MySQL 5.5

Lock-Free SHOW SLAVE STATUS has been ported from Percona Server for MySQL 5.5

Percona Toolkit UDFs has been ported from Percona Server for MySQL 5.5

Support for Fake Changes has been ported from Percona Server for MySQL 5.5

Kill Idle Transactions has been ported from Percona Server for MySQL 5.5

Enforcing Storage Engine has been ported from Percona Server for MySQL 5.5

Utility user has been ported from Percona Server for MySQL 5.5

Extending the secure-file-priv server option has been ported from Percona Server for MySQL 5.5

Expanded Program Option Modifiers has been ported from Percona Server for MySQL 5.5

XtraDB changed page tracking has been ported from Percona Server for MySQL 5.5

PAM Authentication Plugin has been ported from Percona Server for MySQL 5.5

User Statistics has been ported from Percona Server for MySQL 5.5

Slow Query Log has been ported from Percona Server for MySQL 5.5

Extended Show Engine InnoDB Status has been ported from Percona Server for MySQL 5.5

Count InnoDB Deadlocks has been ported from Percona Server for MySQL 5.5

Log All Client Commands (syslog) has been ported from Percona Server for MySQL 5.5

Show Storage Engines has been ported from Percona Server for MySQL 5.5

Thread Based Profiling has been ported from Percona Server for MySQL 5.5

Bug Fixes

Transaction objects are now allocated calling calloc() directly instead of using InnoDB heap allocation. This may improve write performance for high levels of concurrency. Bug fixed #1185686.

Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop with an I/O error if changed page tracking is enabled. Bug fixed #1184517.

Missing path separator between the directory and file name components in a bitmap file name could stop the server starting if the innodb_data_home_dir variable didn’t have the path separator at the end. Bug fixed #1181887.

Changed page tracking used to hold the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699.

Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values being limited to 32-bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed #714925.

Server would crash if an INNODB_CHANGED_PAGES query is issued that has an empty LSN range and thus does not need to read any bitmap files. Bug fixed #1184427.

Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a bitmap file in the middle of requested LSN range was missing. Bug fixed #1179974.

A warning is now returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040.

The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t running. Bug fixed #1185304.

Fixed the upstream bug #68970 that, in Percona Server for MySQL, would cause small tablespaces to expand too fast around 500KB tablespace size. Bug fixed #1169494.

Fixed the RPM package dependencies issues. Bug fixed #1186831.

Reduced the overhead from Handle Corrupted Tables check as it was missing branch predictor annotations. Bug fixed #1176864.

Other bugs fixed: bug fixed #1184695, bug fixed #1184512, bug fixed #1183585, bug fixed #1178606, bug fixed #1177356, bug fixed #1160895, bug fixed #1182876, bug fixed #1180481, bug fixed #1163135, bug fixed #1157078, bug fixed #1182889, bug fixed #1133926, bug fixed #1165098, bug fixed #1182793, bug fixed #1157075, bug fixed #1183625, bug fixed #1155475, bug fixed #1157037, bug fixed #1182065, bug fixed #1182837, bug fixed #1177780, bug fixed #1154954.