Percona Server with XtraDB

Percona Server 5.1.58-12.9

Update to MySQL 5.1.58 based release plus various bug fixes.

Milestone information

Project:
Percona Server
Series:
5.1
Version:
5.1.58-12.9
Released:
2011-08-12  
Registrant:
Stewart Smith
Release registered:
2011-08-17
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:
14 Alexey Kopytov, 4 Laurynas Biveinis, 7 Oleg Tsarev, 4 Rodrigo Gadea, 2 Stewart Smith
Blueprints:
4 Implemented
Bugs:
6 Invalid, 34 Fix Released

Download files for this release

File Description Downloads

Release notes 

Percona is glad to announce the release of Percona Server 5.1.58-12.9 on August 12, 2011 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.1.58, including all the bug fixes in it, Percona Server 5.1.58-12.9 is now the current stable release in the 5.1 series. All of Percona’s software is open-source and free, all the details of the release can be found in the 5.1.58-12.9 milestone at Launchpad.
Highlights
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).
A remaining loop from an unimplemented feature degraded the performance when using compressed tables and has been removed (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (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.1 (Alexey Kopytov).
SHM Buffer Pool has been removed

The ”SHM” buffer pool patch has been removed due to being both invasive and not widely used.
Instead, we recommend using the much safer LRU Dump/Restore patch, which provides similar improvements in restart performance and has the advantage of persisting across machine restarts.
The configuration variables for my.cnf have been kept for compatibility and warnings will be printed for the deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm_checksum) if used.
Instructions for disabling the SHM buffer pool can be found here and for setting up LRU dump/restore here.
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).
Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev).
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).
As the option ignore-builtin-innodb is incompatible with Percona Server with XtraDB, the server will not start and print the corresponding error instead. Bug Fixed: #704216 (Laurynas Biveinis).
Querying INNODB_SYS_TABLES after an ALTER TABLE statement leaded to a server crash. Bug Fixed: #627189 (Yasufumi Kinoshita).
The 64-bit CAS implementation may lead to a server crash on IA32 systems. Bug Fixed: #803865 (Laurynas Biveinis).
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: #806975, #790199, #782391, #802829, #700965, #794840,#766266, (Alexey Kopytov, Oleg Tsarev, Stewart Smith, Laurynas Biveinis)
Improvements and fixes on the Percona Server Test Suite: #790199, #785566, #782391, #800559, #794790,#794780, #800035, #684250, #803140, #803137, #803124, #803110, #803100, #803093, #803088,#803076, #803071 (Oleg Tsarev, Yasufumi Kinoshita, Stewart Smith, Alexey Kopytov).
Improvements and fixes on the Percona Server documentation: #803109, #803106, #803097 (Rodrigo Gadea)
For more information, please see the following links:
Downloads: Binary distributions, Percona Software Repositories
Installation instructions
Consulting, support, training, and custom development
Release notes
Documentation
Developer discussion group

Changelog 

This release does not have a changelog.

4 blueprints and 40 bugs targeted

Blueprint Priority Assignee Delivery
Update to MySQL 5.1.58 base 5 Essential Oleg Tsarev  11 Implemented
Remove buffer_pool shm in PS5.1 4 High   11 Implemented
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.1 1 Undefined Rodrigo Gadea  11 Implemented
Bug report Importance Assignee Status
764507 #764507 5.1.56 test main.mysql fails on el6 2 Critical   3 Invalid
764509 #764509 5.1.56 test main.mysql_upgrade fails on el6 2 Critical   3 Invalid
794799 #794799 main.udf fails in valgring 64bit 2 Critical   3 Invalid
794800 #794800 main.myisam-blob and main.almost_full fail on valgrind 2 Critical   3 Invalid
794804 #794804 main.distinct fails on valgrind 64bit 2 Critical   3 Invalid
788569 #788569 Some test files has incorrect dir layout 5 Low Oleg Tsarev  3 Invalid
627189 #627189 Use of INNODB_SYS_TABLES crashes after ALTER TABLE 2 Critical   10 Fix Released
684250 #684250 test-run and swap_builtin_innodb.patch conflict and run tests for builtin incompatible with plugin with xtradb 2 Critical Alexey Kopytov  10 Fix Released
704216 #704216 The option "ignore-builtin-innodb" is invalid for Percona Server 2 Critical Laurynas Biveinis  10 Fix Released
737947 #737947 Can't compile query_response_time on Windows and Solaris 2 Critical Laurynas Biveinis  10 Fix Released
745241 #745241 quering global_temporary_tables causes server crash 2 Critical Alexey Kopytov  10 Fix Released
794780 #794780 percona_slow_extended-microseconds_in_slow_extended sometimes fails 2 Critical Alexey Kopytov  10 Fix Released
803865 #803865 server crash in main.percona_query_response_time-stored and main.percona_query_response_time-replication 2 Critical Laurynas Biveinis  10 Fix Released
700965 #700965 Remove all references to autogenerated files in all our patches 3 High Oleg Tsarev  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
794840 #794840 federated.federated_archive, federated.federated fails in valgrind 32bit 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
800035 #800035 intermittent rpl_deadlock_innodb failures 3 High Stewart Smith  10 Fix Released
800559 #800559 percona_innodb_deadlock fails 3 High Oleg Tsarev  10 Fix Released
802348 #802348 buf_page_get_zip() should call buf_LRU_free_block() with LRU_list_mutex 3 High   10 Fix Released
794774 #794774 profiling_slow.patch uses uninitialized value when getrusage disabled 4 Medium Oleg Tsarev  10 Fix Released
802825 #802825 buf_LRU_insert_zip_clean can be O(N) on LRU length 4 Medium   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
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
802829 #802829 configure/cmake instructions from make aren't what's used to build 5 Low Stewart Smith  10 Fix Released
803071 #803071 add command-line variable setup test - log_slow_filter 5 Low Alexey Kopytov  10 Fix Released
803076 #803076 add command-line variable setup test - log_slow_slave_statements 5 Low Alexey Kopytov  10 Fix Released
803088 #803088 fix tests for log_slow_sp_statements 5 Low Alexey Kopytov  10 Fix Released
803093 #803093 add test for variable "log_slow_timestamp_every/slow_query_log_timestamp_always" (not command-line version) 5 Low Alexey Kopytov  10 Fix Released
803100 #803100 fix tests for use_global_log_slow_control/slow_query_log_use_global_control" 5 Low Alexey Kopytov  10 Fix Released
803110 #803110 fix tests for slow_query_log_microseconds_timestamp/slow_query_log_timestamp_precision 5 Low Alexey Kopytov  10 Fix Released
803137 #803137 rename percona_slow_extended-slave_innodb_stats.test to percona_slow_extended-log_slow_verbosity-innodb.test 5 Low Alexey Kopytov  10 Fix Released
803140 #803140 percona_slow_extended-min_examined_row_limit.test incorrect 5 Low Alexey Kopytov  10 Fix Released
782391 #782391 install_tests.sh ignores the series file 1 Undecided   10 Fix Released
785566 #785566 main.percona_server_variables fails 1 Undecided Oleg Tsarev  10 Fix Released
790199 #790199 install_tests.sh fails due to bashism 1 Undecided Oleg Tsarev  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
This milestone contains Public information
Everyone can see this information.