June 20, 2013

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

MySQL 5.6 is GA, so is our support for it. Check out the Percona Toolkit supported platforms and versions. When you upgrade to MySQL 5.6, be sure to upgrade to Percona Toolkit 2.2, too. We also started beta support for Percona XtraDB Cluster in 2.1… of MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks (Percona Server, MariaDB, Percona XtraDB Cluster, and MariaDB Galera Cluster), upgrades

Post: MySQL alternative Percona Server 5.1.68 -14.6 now available

…for MySQL version 5.1.68-14.6[/caption] Percona is glad to announce the release of Percona Server  5.1….on MySQL 5.1.68, including all the bug fixes in it, Percona Server 5.1.68-14.6, a MySQL alternative… test database when using rpm on server upgrade, even if the database was previously removed. Bug…

Post: Percona Server for MySQL 5.5.30-30.2 now available

MySQL version 5.5.30-30.2[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5… UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko)…. clean RPM installations and not upgrades. We have pushed the fixed packages to the repositories. …

Post: Percona XtraBackup 2.1.2 for MySQL available for download

…-priority bugs since version 2.1 became GA. It’s advised to upgrade your latest 2.1 version to 2.1.2. This release is the latest stable release in the 2.1 series. Bugs… not work correctly for latest Percona Server and MySQL 5.1 releases which could cause innobackupex to fail. Bugs fixed #1181092, #1181099 and #1180905…

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

…restarting following an upgrade — instead, the server would remain stopped after the upgrade was completed regardless…Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when binary…Bychko). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). …

Comment: Solving INFORMATION_SCHEMA slowness

…://bugs.mysql.com/bug.php?id=19588 – reported fixed in MySQL 5.1.21 but many people reported I_S was slow. http://bugs.mysql.com/bug.php?id=56178 – reported fixed in MySQL 5.5.16, 5.6.3. What version are you running? Is it possible you can upgrade to the latest 5.5.x?

Comment: Solving INFORMATION_SCHEMA slowness

MySQL 5.5 to get te fix. It might be possible, however, to backport that fix to 5.1.58, and run a custom build until you can upgrade…-services-how-we-can-help/ You may also be able to work around the issue, depending on what you’re using… developed the database library for Zend Framework, I needed to write a function to discover the structure of a table, its columns…

Post: MySQL 5.5 lock_wait_timeout: patience is a virtue, and a locked server

…permissible values range from 1 to 31536000 (1 year). The default is 31536000. Translation: by default, MySQL 5.5 will “meta-block” for 1 year!  In …attempts to acquire metadata locks,” then why isn’t it called metadata_lock_wait_timeout? In conclusion: be careful when upgrading to MySQL 5.5 because…

Post: MySQL Upgrade Webinar Questions Followup

MySQL 5.0 to 5.5 for MyISAM tables? MyISAM have not been getting any significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5…for upgrade. Q: Upgrading to MySQL 5.5 do we really need all tables changed to Innodb and character set set to utf8? No. MySQL 5.5 continues to