…Toolkit version just released work for regular community MySQL 5.5.23 or does it only work (or work …version, to “upgrade“? 3. Thirdly, thanks for your help and information. I just made the MySQL, apache2 and…to INNOdb tables really slowed down mySQL as measured by qps, in the last 4-6 months? Best …
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
Upgrading MySQL Server is a very interesting task as you can approach … 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… MySQL 4.1 or changing JOIN evaluation in 5.0 (which could both cause different result set or make query not runnable in MySQL 5…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… 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… to fix, But why is not it mentioned in MySQL 4.1 to 5.0 upgrade notes ? ? Furthermore if there were no good ideas… you should stay on MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0 can offer…
Post: Even minor upgrades are not always safe
September 4, 2006 By 5 Comments
… keep most of my systems on MySQL 4.1 still as they will not benefit from MySQL 5.0 features anyway while I do… introduced in MySQL 5.0 (You never know where to expect problems, ie some people reported JOIN breaking by upgrading to 5.0). Yes… during 4.1 upgrade which is old stable version which is not as actively changed as 5.0 I upgraded MySQL 4.1.19 to 4.1…
Post: MySQL Server Upgrade
August 11, 2006 By 9 Comments
Today I’ve upgraded MySQL Server on the host running MySQL Performance Blog. MySQL 4.1.12 was running here for well over a year… the bugs in MySQL 4.1.12 so there was a need for upgrade. Which Version did I upgrade to ? I Upgraded to MySQL 4.1.21. Why Did not I go with MySQL 5.0 ? There…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… 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 Installation and upgrade scripts.
May 21, 2007 By 3 Comments
…old version. I think it was great. In MySQL 4.1 and later more caution is required … forced to change a lot of applications. MySQL 5.0 added more issues to the pile …MySQL install script but simply I find no mysql user after upgrade. MySQL Does not start after upgrade This is simply result of upgrade…
Post: Percona Server security fix releases
May 23, 2010 By 4 Comments
… know MySQL ® announced 5.0.91 and 5.1.47 with serious security fixes, so we provide binary releases of Percona Server 5.0… 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… you are interested in backporting patches to 4.0 / 4.1 or to older 5.0 and 5.1 releases, it is available under…
Post: More Gotchas with MySQL 5.0
July 27, 2007 By 23 Comments
Working on large upgrade of MySQL 4.1 running Innodb to MySQL 5.0 and doing oprofile analyzes we found very interesting issue … of seconds being considered fast operation, as it is in MySQL 4.1 But why buf_get_latched_pages_number ? Because this… higher for MySQL 5.0 compared to MySQL 4.1 It was something like 2-3 for MySQL 4.1 vs 40-60 for MySQL 5.0 At…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… of them use 5.1 vs row level replication or events. I think less than 5% are using both features. MySQL 4.1 was out for years and yet I would say no more than 5% of… release as soon as it comes out. Many will only upgrade on the schedule or keep on the same release until…
