June 18, 2013

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

March 25, 2013 By 2 Comments

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

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

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: MySQL 4 to MySQL 5 Upgrade performance regressions

June 6, 2007 By 8 Comments

… performance 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… 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: Upgrading MySQL

January 5, 2010 By 24 Comments

… 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… 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: Solving RPM installation conflicts in CentOS 5 and CentOS 6

February 21, 2013 By 6 Comments

…mysql-libs packages provided by CentOS/Redhat. So even if the user wants to install PS 5.5 alongside packages that depend on 5.1/5.0…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…

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

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

…to have upgrade testing done in the environment which is maximally close to production. Q: How safe is it to upgrade from MySQL 5.5 to Percona Server 5.5…

Filed Under: Insight for DBAs, MySQL

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

… HT: 5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1 … random writes to them are actually slower than to a mechanical disk. I do not know how it is …new Linux/Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to …

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-comment=FreeBSD port: mysql-client-5.0.67_1‘ ‘–enable-thread-safe-… coming from building client package. It needs to be…

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: , , , , ,
« Older Posts