June 19, 2013

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

March 25, 2013 By 2 Comments

…Toolkit supported platforms and versions. When you upgrade to MySQL 5.6, be sure to upgrade to Percona Toolkit 2.2, too. …check is on by default In 2.1.4, released September/October 2012, we introduced a feature….  If you upgrade from 2.1 to 2.2, be sure to re-read tools’ documentation to see what has…

Filed Under: Percona Software, Percona Toolkit Tagged With: , , , , ,

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

April 17, 2013 By 2 Comments

… glad to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are available from the downloads area or from our software…. This regression only affected clean RPM installations and not upgrades. We have pushed the fixed packages to the repositories. Bug fixed #1170024.

Filed Under: MySQL, XtraDB Cluster Tagged With: , ,

Post: Upgrading MySQL

January 5, 2010 By 24 Comments

… in minor version – Upgrade of MySQL 5.0.30 to 5.0.32 is generally likely to expose less issues than 5.0.30 to 5.0.86. The… you upgrade to different major version, especially if you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path than 4.1 to 5.1… unlikely to be affected. If you’re something like SELECT name FROM users WHERE id=5 you can probably go to the earliest MySQL version…

Filed Under: Insight for DBAs, MySQL

Post: Implications of Metadata Locking Changes in MySQL 5.5

February 1, 2013 By 9 Comments

…MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL 5.5, I thought it necessary to…to test; session10 > select * from…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , ,

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

…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…

Filed Under: Insight for DBAs, MySQL

Post: The story of one MySQL Upgrade

October 8, 2010 By 8 Comments

… worked on upgrading MySQL from one of very early MySQL 5.0 versions to Percona Server 5.1. This was a classical upgrade scenario which…during upgrade are very different depending on the upgrade version – upgrade from MySQL 4.1 to 5.0 had a lot of different issues than upgrade from MySQL 5.0 to 5…

Filed Under: Insight for DBAs, MySQL Tagged With: ,

Post: MySQL 4 to MySQL 5 Upgrade performance regressions

June 6, 2007 By 8 Comments

… regression cases when upgrading from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you often… easy to fix, But why is not it mentioned in MySQL 4.1 to 5.0 upgrade notes ? ? Furthermore if there were no good ideas how to make XA to work with group…

Filed Under: Insight for DBAs Tagged With: ,

Post: Solving RPM installation conflicts in CentOS 5 and CentOS 6

February 21, 2013 By 6 Comments

…-Server-shared-compat x86_64 5.5.29-rel29.4.401.rhel6 percona 3.4 M php-mysql x86_64 5.3.3-14.el6_3….4.402.rhel5 percona-testing 993 k … and this will install without problems. Additionally, this has the advantage of allowing an upgrade from 5.1 to 5.5 without uninstalling any software that depended on the old version. # rpm -qa | grep ^Percona Percona-Server-client-51-5…

Filed Under: MySQL Tagged With: , , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… record from Arizona to be towards the top of the list. With 5.5, this is exactly what happens: mysql: SELECT … likely going to be people who believe that switching to InnoDB FTS is simply a matter of upgrading to 5.6 … we’ve set innodb_ft_min_token_size to 4. Thus, when InnoDB is parsing the data and…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: MySQL Installation and upgrade scripts.

May 21, 2007 By 3 Comments

…to Upgrade RedHat RPM binaries to MySQL Community RPM. Of course you may argue MySQL is not responsible for upgrade process from…MySQL install script but simply I find no mysql user after upgrade. MySQL Does not start after upgrade This is simply result of upgrade…

Filed Under: Insight for DBAs Tagged With: ,
« Older Posts