June 18, 2013

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

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), upgrades1 for the full list.  If you upgrade from 2.1 to 2.2, be sure to re-read tools’ documentation to

Post: How Percona does a MySQL Performance Audit

to recover from disasters? We also want to know what the operating parameters are. Can we suggest upgrades5 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

Post: MySQL 4 to MySQL 5 Upgrade performance regressions

… 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

Post: Upgrading MySQL

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

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

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.0upgrade 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

Post: MySQL Upgrade Webinar Questions Followup

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

Post: Heikki Tuuri answers to Innodb questions, Part II

… 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

Post: Rebuilding MySQL with same options

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…

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

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