Percona Server 5.0 Release Notes

Released on February 18, 2011 (Downloads are available here and from the Percona Software Repositories.)

Please note that active maintenance has ended on the MySQL Server 5.0-series product, as well on Percona Server versions based on 5.0-series releases.

This release contains security fixes in MySQL Server only (see Changes in MySQL 5.0.92). Other than porting the Percona Server code to run on this release, no additional changes have been made by Percona.

• The build is based on MySQL-5.0.91
• You can download binaries and source here

• The build is based on MySQL-5.0.90

Fixed bugs:

• Fixed Bug #539190 Percona-XtraDB package doesn't allow libmysqlclient15off
• Fixed Bug #479106 mysql-5.0.87 + patches-5.0.86 compile fail in ubuntu 9.10 (karmic)
• Fixed tests mysql, mysql_upgrade, ssl*

• The build is based on MySQL-5.0.87
• innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3
• To be compatible with RedHat RPM repository, the naming scheme has changed to

<rpm name>-<mysql version>-<percona build version>.<buildnumber>.<redhat version>.<architecture>.rpm

Example:

MySQL-server-percona-5.0.87-b20.29.rhel5.x86_64.rpm

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.86
• Fix from Neil Katin to userstatv2.patch
• small perfomance hack at row_search_for_mysql

Fixed bugs in the build:

• Bug #413858 in Percona patches: “Crash from failed assertion in dict0dict.c”

Comparing to the previous release it has following new features:

• The build is based on MySQL-5.0.84
• Fixed the issue with CLIENT_STATISTICS
• New patch innodb_recovery_patches.patch greatly improves recovery time

Fixed bugs in the build:

• Bug #407117 in Percona patches: “any mysql-test fails with a warning “master.err: ctype_ucs2_def: InnoDB: Warning: some resources were not cleaned up in shutdown:””
• Bug #352840 in Percona patches: “INNODB_BUFFER_POOL_CONTENT privacy issue”

New features in the release:

• MySQL-5.0.83 is taken as the basis
• The new patch innodb_use_sys_malloc.patch is added
• The new patch innodb_split_buf_pool_mutex.patch is added

This patch splits the single global InnoDB buffer pool mutex into several mutexes for different purposes. This reduces mutex contention. It may help if you suffer performance loss when the working set does not fit in memory. You can detect buffer pool mutex contention by examining the output of SHOW INNODB STATUS and looking at the first section, SEMAPHORES.

• Google's style IO - innodb_io_patches.patch

* profiling_slow.patch

 This patch adds information from SHOW PROFILE to query information in slow.log output.
 profiling_server. This variable ( ON / OFF ) enables profiling of all queries (in all connections).
 profiling_use_getrusage. This variable ( ON / OFF ) enables usage of getrusage function in profiling.
 Be careful, enabling profiling_server may cause performance degradation, especially with profiling_use_getrusage.

* innodb_extra_rseg.patch

 innodb_extra_rsegments. The number of extra user rollback segments created when new db is created.
 New information_schema table innodb_rseg shows information about all rollback segments

* innodb_thread_concurrency_timer_based.patch

 This patch provides the configuration variable backport from MySQL 5.4.

Fixed bugs:

• Bug #382778: mysql-test variables fails on 5.0.77 with –with-debug
• Bug #381430: mysql-test profiling fails on 5.0.77
• Bug #375494: log_slow_rate_limit logs all queries on a connection after a >1s query
• Bug #378761: compilation fails on 5.0.77
• Bug #381900: mysql-test information_schema fails on 5.0.77 with –with-debug
• Bug #382783: compilation fails on 5.0.82

* profiling_slow.patch

 This patch adds information from SHOW PROFILE to query information in slow.log output.
 profiling_server. This variable ( ON / OFF ) enables profiling of all queries (in all connections).
 profiling_use_getrusage. This variable ( ON / OFF ) enables usage of getrusage function in profiling.
 Be careful, enabling profiling_server may cause performance degradation, especially with profiling_use_getrusage.

* innodb_extra_rseg.patch

 innodb_extra_rsegments. The number of extra user rollback segments created when new db is created.
 New information_schema table innodb_rseg shows information about all rollback segments

* innodb_thread_concurrency_timer_based.patch

 This patch provides the configuration variable backport from MySQL 5.4.

Fixed bugs:

• Bug #382778: mysql-test variables fails on 5.0.77 with –with-debug
• Bug #381430: mysql-test profiling fails on 5.0.77
• Bug #375494: log_slow_rate_limit logs all queries on a connection after a >1s query
• Bug #378761: compilation fails on 5.0.77
• Bug #381900: mysql-test information_schema fails on 5.0.77 with –with-debug
• Bug #382783: compilation fails on 5.0.82