Percona Server moved to https://jira.percona.com/projects/PS 5.5.14-20.5

Based on MySQL 5.5.14, plus various bug fixes.

Milestone information

Project:
Percona Server moved to https://jira.percona.com/projects/PS
Series:
5.5
Version:
5.5.14-20.5
Released:
 
Registrant:
Stewart Smith
Release registered:
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:
7 Alexey Kopytov, 4 Laurynas Biveinis, 2 Oleg Tsarev, 7 Rodrigo Gadea, 2 Stewart Smith
Blueprints:
3 Implemented
Bugs:
4 Invalid, 20 Fix Released

Download files for this release

File Description Downloads

Release notes 

Percona is glad to announce the release of Percona Server 5.5.14-20.5 on August 12, 2011 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.5.14, including all the bug fixes in it, Percona Server 5.5.14-20.5 is now the current stable release in the 5.5 series. All of Percona’s software is open-source and free, all the details of the release can be found in the 5.5.14-20.5 milestone at Launchpad.
Improvements
Performance Improvements

fsync() has been replaced with fdatasync() to improve perfomance where possible. The former is intended to sync the metadata of the file also (size, name, access time, etc.), but for the transaction log and the doublewrite buffer, such sync of metadata isn’t needed. Bug Fixed: #803270 (Yasufumi Kinoshita).
Compatibility Collations

Two new collations, utf8_general50_ci and ucs2_general50_ci, have been to improve compatibility for those upgrading from MySQL 5.0 or 5.1 prior to version 5.1.24.
A fix for a MySQL bug (#27877) introduced an incompatible change in collations in MySQL 5.1.24. If the following collations were used:
utf8_general_ci
ucs2_general_ci
and any of the indexes contained the German letter “U+00DF SHARP S” ‘ß’ (which became equal to ‘s’), when upgrading from 5.0 / 5.1.23 or lower:
any indexes on columns in that situation must be rebuilt after the upgrade, and
unique constrains may get broken after upgrade due to possible duplicates.
This problem is avoided when upgrading to Percona Server by converting the affected tables or columns to the collations introduced:
utf8_general_ci to utf8_general50_ci, and
ucs2_general_ci to utf8_general50_ci.
Blueprint:utf8-general50-ci-5.5 (Alexey Kopytov).
Bug Fixes
When adding a table to the cache, the server may evict and close another if the table cache is full. If the closed table was on the FEDERATED engine and a replication environment, its client connection to the remote server was closed leading to an unappropriated network error and stopping the Slave SQL thread. Bugs Fixed #813587 / #51196 and#61790 in MySQL (Alexey Kopytov).
Querying global_temporary_tables caused the server to crash in some scenarios due to insufficient locking. Fixed by introducing a new mutex to protect from race conditions. Bugs Fixed:#745241 (Alexey Kopytov).
Using the innodb_lazy_drop_table option led to an assertion error when truncating a table in some scenarios. Bug Fixed:#798371 (Yasufumi Kinoshita).
Other Changes
Improvements and fixes on platform-specific distribution:
The compilation of the Response Time Distribution patch has been fixed on Solaris (supported platform) and Windows (experimental). Bug Fixed: #737947 (Laurynas Biveinis)
Improvements and fixes on general distribution: #766266, #794837, #806975 (Laurynas Biveinis, Stewart Smith, Alexey Kopytov)
Improvements and fixes on the Percona Server documentation: #803109, #803106, #803097 (Rodrigo Gadea)

Changelog 

This release does not have a changelog.

3 blueprints and 24 bugs targeted

Blueprint Priority Assignee Delivery
Update to MySQL 5.5.14 base Update to MySQL 5.5.14 base 5 Essential   11 Implemented
Add a collation reproducing the pre-5.1.24 behavior of utf8_general_ci and ucs2_general_ci to Percona Server 5.5 Add a collation reproducing the pre-5.1.24 behavior of utf8_general_ci and ucs2_general_ci to Per... 1 Undefined Alexey Kopytov  11 Implemented
Document utf8_general50_ci collation for 5.5 Document utf8_general50_ci collation for 5.5 1 Undefined Rodrigo Gadea  11 Implemented
Bug report Importance Assignee Status
700965 #700965 Remove all references to autogenerated files in all our patches 3 High Laurynas Biveinis  3 Invalid
700965 #700965 Remove all references to autogenerated files in all our patches 3 High Laurynas Biveinis  3 Invalid
788569 #788569 Some test files has incorrect dir layout 5 Low Oleg Tsarev  3 Invalid
788569 #788569 Some test files has incorrect dir layout 5 Low Oleg Tsarev  3 Invalid
745241 #745241 quering global_temporary_tables causes server crash 2 Critical Alexey Kopytov  10 Fix Released
745241 #745241 quering global_temporary_tables causes server crash 2 Critical Alexey Kopytov  10 Fix Released
766266 #766266 handler/ha_innodb.cc:4952: error: comparison of unsigned expression >= 0 is always true 3 High Laurynas Biveinis  10 Fix Released
766266 #766266 handler/ha_innodb.cc:4952: error: comparison of unsigned expression >= 0 is always true 3 High Laurynas Biveinis  10 Fix Released
798371 #798371 InnoDB: Assertion failure in thread 140616411674384 in file dict/dict0dict.c line 1821 3 High   10 Fix Released
798371 #798371 InnoDB: Assertion failure in thread 140616411674384 in file dict/dict0dict.c line 1821 3 High   10 Fix Released
803097 #803097 fix documentation for "log_slow_timestamp_every/slow_query_log_timestamp_always" 4 Medium Rodrigo Gadea  10 Fix Released
803097 #803097 fix documentation for "log_slow_timestamp_every/slow_query_log_timestamp_always" 4 Medium Rodrigo Gadea  10 Fix Released
803106 #803106 fix documentation for use_global_log_slow_control/slow_query_log_use_global_control" 4 Medium Rodrigo Gadea  10 Fix Released
803106 #803106 fix documentation for use_global_log_slow_control/slow_query_log_use_global_control" 4 Medium Rodrigo Gadea  10 Fix Released
803109 #803109 fix documentation for slow_query_log_microseconds_timestamp/slow_query_log_timestamp_precision 4 Medium Rodrigo Gadea  10 Fix Released
803109 #803109 fix documentation for slow_query_log_microseconds_timestamp/slow_query_log_timestamp_precision 4 Medium Rodrigo Gadea  10 Fix Released
803270 #803270 fdatasync() can be used for transaction log and doublewrite buffer 4 Medium   10 Fix Released
803270 #803270 fdatasync() can be used for transaction log and doublewrite buffer 4 Medium   10 Fix Released
794837 #794837 valgrind warnings in rpl.rpl_heartbeat_basic 'mix' 5 Low Stewart Smith  10 Fix Released
794837 #794837 valgrind warnings in rpl.rpl_heartbeat_basic 'mix' 5 Low Stewart Smith  10 Fix Released
806975 #806975 patch for bug #803270 breaks OS X 1 Undecided Alexey Kopytov  10 Fix Released
806975 #806975 patch for bug #803270 breaks OS X 1 Undecided Alexey Kopytov  10 Fix Released
813587 #813587 Provide fixes for MySQL bugs #51196 / #61790 in Percona Server 1 Undecided Alexey Kopytov  10 Fix Released
813587 #813587 Provide fixes for MySQL bugs #51196 / #61790 in Percona Server 1 Undecided Alexey Kopytov  10 Fix Released
This milestone contains Public information
Everyone can see this information.