…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…
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…
Post: Upgrading MySQL
January 5, 2010 By 23 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…
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 …
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…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
…MySQL versions not being upgraded to the most recent version in series. It is frequent to see something like MySQL 5.0…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…
Comment: Upgrading MySQL
January 17, 2010 By 23 Comments
From my experience upgrading MySQL can be trivial to rather a pain. Here I’m talking about major version changes such as 5.0 to 5.1. This also depends on various issues one of which is the amount of downtime you can take and also how… theory” an issue with 5.0 to 5.1 upgrades that when you run mysql_upgrade it tries to check and upgrade all tables which need to be changed but fails…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… issues in MySQL 5.0. There are number of ways the problem can be solved but first we decide to see how broad …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 Also, …
Page: Presentations
May 3, 2006 By
…1 and 5.0, showing most important performance improvements and regressions known to our team. Good reading if you’re planing on upgrading to MySQL 5.0 Download Optimizing MySQL…
Post: Percona Server security fix releases
May 23, 2010 By 4 Comments
…-Server-5.0/Percona-Server-5.0.91-22/ Release Percona Server/XtraDB 5.1.45-rel10.2 is available also ( we backported patches from 5.1.47 to 5.1.45… still are many active MySQL 4.0 and MySQL 4.1 installations and we understand how hard it is upgrade 4.0/4.1 to 5.1. With published exploits these…
