In our last 5.5 series release of Percona Server, we included a regression in the RPM packaging that prevented the server from restarting following an upgrade — instead, the server would remain stopped after the upgrade was completed regardless of its state before updating. This caused some problems for some users, especially if automatic upgrading was configured on machines with running database servers.
Percona XtraDB Cluster was also affected by this bug and will also have a re-release very soon.
— More info on Percona Server 5.5.30-30.2 —
libjemalloclibrary. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin)
DROP TABLEimplementation has been improved. (Laurynas Biveinis)
percona-server.specPercona Server rpm packages couldn’t be built on RHEL 5 and CentOS 5. Bug fixed #1144777 (Ignacio Nin).
--innodb-optimize-keysoption it produced invalid SQL for cases when there was an explicitly named foreign key constraint which implied an implicit secondary index with the same name. Fixed by detecting such cases and omitting the corresponding secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov).
CREATE TABLE IF NOT EXISTSstatements on an existing table could wait on a metadata lock instead of failing or returning immediately if there is a transaction that executed a query which opened that table. Bug fixed #1127008 (Sergei Glushchenko).
read_view_create_low()in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187 (Alexey Kopytov).
read_view_open_now()which is another problem originally reported as upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov).
slave_max_allowed_packetvariable. Bug fixed #1135097 (George Ormond Lorch III).
InnoDBParserPerl package from source and Debian installation. Bug fixed #1032139 (Alexey Bychko).
innodb_pass_corrupt_tablevalue checks by optimizing them for better CPU branch prediction. Bug fixed #1125248 (Alexey Kopytov).
dialog.soused by the PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when
plugin-diroption was set in the
[client]section of the
my.cnf. Bug fixed #1155859 (Sergei Glushchenko).
log_flush_order_mutexacquisition. Bug fixed #1163262 (Alexey Kopytov).
--no-dataoptions, all secondary key definitions would be lost. Bug fixed #989253 (Alexey Kopytov).
Other bug fixes: bug fixed #1146621 (Laurynas Biveinis), bug fixed #1050536 (Alexey Bychko), bug fixed #1144059 (Roel Van de Paar), bug fixed #1154962 (Hrvoje Matijakovic), bug fixed #1154959 (Hrvoje Matijakovic), bug fixed #1154957 (Hrvoje Matijakovic), bug fixed #1154954 (Hrvoje Matijakovic).
UPDATE[18-04-2013]: There was a RPM packaging regression introduced with the fix for bug #710799. This regression only affected clean RPM installations and not upgrades. We have pushed the fixed packages to the repositories. Bug fixed #1170024.
Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.
Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.