… sense ? How long older platforms need to be supported ? I think for example it makes sense to support RHEL4 with MySQL 5.1 but support with MySQL 5.5 is not needed as people doing major MySQL upgrade usually would have an option to upgrade operating…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
So lets say you upgraded from MySQL 5.1 to Percona Server 5.5 and instead of expected performance improvement you see your performance … and what thought to be slow down with version upgrade is rather system warming up. You need to compare apples to apples such as… be able to get new version to pick the old plan no matter how you try and you might be forced to change your…
Comment: MySQL - to use or not to use
May 29, 2007 By 10 Comments
… subqueries just didn’t know how to do proper joins 
Mostly, the new features in MySQL 5.0 seem to be unnoticed by the… need them, they are there. I recently started to upgrade my old 4.1 servers to 5.0. One thing I learned the hard way… upgrade script upgrade them, it seemed to be far slower and raised innodb tablespace size severely. The reasons for the upgrade where: – MySQL 4.1…
Post: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…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.1…
Comment: Upgrading MySQL
November 10, 2011 By 24 Comments
How to upgrade mysql from 5.1.47 to 5.1.53 only, not later 5.1.53 or latest version using mysql_upgrade command …
Comment: XtraDB storage engine release 1.0.3-7
August 19, 2009 By 6 Comments
How come when I try to do a rpm upgrade of the XtraDB package I get a conflicting message? Is there a way to…-XtraDB-1.0.3-7-5.1.37-7.rhel5.x86_64 conflicts with file from package Percona-XtraDB-1.0.3-5-5.1.34-5.rhel5…-XtraDB-1.0.3-7-5.1.37-7.rhel5.x86_64 conflicts with file from package Percona-XtraDB-1.0.3-5-5.1.34-5.rhel5…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…fashion. Based on these numbers, we can determine how many bytes back in the transaction log …rows, indexes, etc., while a transaction may modify 1 or millions of rows. Also realize that … on disk. The additional controls in 5.5 and Percona server are excellent reasons to consider an upgrade…
Post: Released: Percona Toolkit 2.1.5
October 12, 2012 By Leave a Comment
…of bugs concerning how pt-table-checksum works with Percona XtraDB Cluster: pt-table-checksum 2.1.4 doesn’…page mentioned in tools was created. Percona Toolkit 2.1.5 is a small release, but if you’re …want to upgrade. Else, you can wait for 2.1.6 which will have these fixes and lots more. Links to …
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
…. If you’re running MySQL 5.1 but the bug is planned to be fixed only in MySQL 5.6, this might not be… you’re running hence helping you to reduce upgrade costs and risks. We even can backport bugfixes to specific minor MySQL versions in… incompatibilities ranging from very subtle to significant. In many cases it is easy to change the application to become compatible with a new…
Post: Drilling down to the source of the problem
November 8, 2008 By 7 Comments
… lock. That would be an easy excuse to blame everything on this lock, suggest upgrading to MySQL 5.1 and call it a day. Learning… patch for it. What is very interesting in this case how true issues can really hide because of layers of false… conferences) conflicting recommendations – some suggest to set 0 to avoid queue blocks, other suggest some low value to reduce internal contention. In reality…
