… 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…
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…
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…
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′…
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…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… often see old MySQL versions not being upgraded to the most recent version in series. It is frequent to see something like MySQL 5.0.44 which… ? 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…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…to some newly purchased hardware. But how to…_id | 1 | | hosting2….5 | | hosting2.wp_usermeta.user_id | 413 | +——————————————–+———–+ 11 rows in set (0…upgrading to a dedicated server because their usage is very high temporarily block users having huge spike in MySQL…
Post: Percona Server security fix releases
May 23, 2010 By 4 Comments
… 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 installation are now under serious risks. If you are interested in backporting patches to 4.0…
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… numbers. Presentation shows how changing various MySQL Server OS and Hardware parameters affect MySQL Performance in DBT2 …
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
…MySQL 5.5 to get stable performance (as you may see from Dimitri’s post, http://dimitrik.free.fr/blog/archives/2010/12/mysql…How can you detect in regular MySQL…upgrade the I/O subsystem. If you are flush list bound, then for MySQL 5.1/InnoDB-plugin or MySQL 5.5…
