…MySQL 4.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: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…to upgrade (it will be worth it anyway 
). You will also need to…From that output you can learn how to run configure command, which needs to be done prior to…to extract the archive: (garfield:~/work) % gzip -c -d mysql-5.0.51a.tar.gz | tar -x -v -f – mysql-5.0.51a/ mysql-5.0.51a/bdb/ mysql-5.0…
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 … 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, Maatkit …
Post: Percona Server security fix releases
May 23, 2010 By 4 Comments
…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…there 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…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…, Tricky Code During MySQL 3.23 and MySQL 4.0 team the small …how many of them use 5.1 vs row level replication or events. I think less than 5% are using both features. MySQL 4.1…comes out. Many will only upgrade on the schedule or …” or “being free from bugs” to run MySQL in production. MySQL as it is…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…to some newly purchased hardware. But how to avoid the undesired situation that you only sort out the least active customers from…upgrading to a dedicated server because their usage is very high temporarily block users having huge spike in MySQL…
Comment: MySQL - to use or not to use
May 29, 2007 By 10 Comments
…’t know how to do proper joins 
Mostly, the new features in MySQL 5.0 seem to be … Speaking of simplicity, the fine thing is from what I see now, you can…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: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…type (usually 5 or 1+0) RAID …to run only MySQL on this box, and you want to ensure your MySQL datadir is separated from the OS in case you ever want to upgrade…to squeeze every last ounce of performance from the box. Fiddling with how to allocate drives and drive space from partition to… su=64k,sw=4 …
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 that your flushing comes from…4…upgrade the I/O subsystem. If you are flush list bound, then for MySQL 5.1/InnoDB-plugin or MySQL 5.5…
Post: Should you name indexes while doing ALTER TABLE ?
May 28, 2008 By 10 Comments
…to specify the key name or omit ? Things what you should be looking at is how MySQL…see what is the index MySQL trying to use from explain, such as …4` (`i`), KEY `i_5` (`i`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0… upgrade process just because somebody was adding custom indexes to the …
