June 20, 2013

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

March 25, 2013 By 2 Comments

…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… on by default In 2.1.4, released September/October 2012, we …1 for the full list.  If you upgrade from 2.1 to 2.2, be sure to re-read tools’ documentation to…

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

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

… 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… you go over normal upgrade checks you should be fine. Q: What are the key concerns upgrading MySQL 4.1 to MySQL 5.5? This is jumping…

Filed Under: Insight for DBAs, MySQL

Post: Implications of Metadata Locking Changes in MySQL 5.5

February 1, 2013 By 9 Comments

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

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

Comment: Upgrading MySQL

January 5, 2010 By 24 Comments

… binary (in-place) upgrade without dumping and reloading tables, you cannot upgrade directly from MySQL 4.1 to 5.1. This occurs due to an incompatible change in the MyISAM table index format in MySQL 5.0. Upgrade from MySQL 4.1 to 5…

Filed Under: Insight for DBAs, MySQL

Post: MySQL 4 to MySQL 5 Upgrade performance regressions

June 6, 2007 By 8 Comments

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

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Server Upgrade

August 11, 2006 By 9 Comments

… the bugs in MySQL 4.1.12 so there was a need for upgrade. Which Version did I upgrade to ? I Upgraded to MySQL 4.1.21. Why Did not I go with MySQL 5.0 ? There are… workloads have higher chance of problems on MySQL 5.0 than on 4.1 This is upgrade strategy I follow for this server which…

Filed Under: Insight for DBAs Tagged With: ,

Post: The story of one MySQL Upgrade

October 8, 2010 By 8 Comments

… is hard to archive experience. Also problems you encounter 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.1…

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

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

March 4, 2013 By 7 Comments

… there are likely going to be people who believe that switching to InnoDB FTS is simply a matter of upgrading to 5.6 and running… is exactly the same with a setting of 1 versus a setting of 4. This may or may not be the case… result of a major MySQL version upgrade before rolling it into production! Percona has tools (pt-upgrade and Percona Playback) that can…

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

Post: Even minor upgrades are not always safe

September 4, 2006 By 5 Comments

… on MySQL 4.1 still as they will not benefit from MySQL 5.0 features anyway while I do not want to likely loose… 5.0 (You never know where to expect problems, ie some people reported JOIN breaking by upgrading to 5.0). Yes this stuff is in upgrade… case during 4.1 upgrade which is old stable version which is not as actively changed as 5.0 I upgraded MySQL 4.1.19 to 4.1.21 couple…

Filed Under: Insight for DBAs Tagged With:

Post: MySQL Installation and upgrade scripts.

May 21, 2007 By 3 Comments

… you need to get back you just swap binaries to the old version. I think it was great. In MySQL 4.1 and later… tip to mention – upgrading to the new major version make sure you upgrade to latest current version at first. Ie upgrade to recent MySQL 5.0 before upgrading to MySQL 5.1 – this makes sure you will be at somewhat tested upgrade…

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