June 19, 2013

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

March 25, 2013 By 2 Comments

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

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

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 discuss what these implications exactly are. To…, starting MySQL 5.5.3. Let’s see how this works now. Metadata Locking behavior starting MySQL 5.5.3 Starting with 5.5.3 …

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

Post: Upgrading MySQL

January 5, 2010 By 24 Comments

… when 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 just because so much more people have followed that road. So how do…

Filed Under: Insight for DBAs, MySQL

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… to live with it, most likely MySQL 5.0 and 5.1 would not get any fixes for this problem, so lets see who is affected, how to check you’re affected and how to…

Filed Under: Insight for DBAs 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: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…to recover from disasters? We also want to know what the operating parameters are. Can we suggest upgrades…5 5 iostat -dx 5 5 If you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL…

Filed Under: Insight for Developers Tagged With:

Post: Rebuilding MySQL with same options

April 8, 2010 By 4 Comments

…MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available ? MySQL…’ ‘–with-low-memory’ ‘–with-comment=FreeBSD port: mysql-client-5.0.67_1‘ ‘–enable-thread-safe-client’ ‘–with-charset=cp1251′…

Filed Under: Insight for DBAs, MySQL

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

March 4, 2013 By 7 Comments

…0 Warnings: 0 As far as I can tell, this little gotcha doesn’t appear to be mentioned anywhere in the MySQL 5…to be people who believe that switching to InnoDB FTS is simply a matter of upgrading to 5…

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

Post: Percona Welcomes MySQL 5.6!

February 25, 2013 By Leave a Comment

…how to re-architect, develop, and tune your application to take advantage of MySQL 5.6′s features; create an in-depth upgrade…MySQL 5.6 integration with Percona Software. Percona Toolkit 2.1 already supports MySQL 5…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software, Percona Toolkit

Post: The story of one MySQL Upgrade

October 8, 2010 By 8 Comments

…replication issues in MySQL 5.0. There are number of ways the problem can be solved but first we decide to see how broad …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 Also…

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