June 19, 2013

Post: 7 Reasons why MySQL Quality will never be the same

December 10, 2008 By 15 Comments

…them use 5.1 vs row level replication or events. I think less than 5% are using both features. MySQL 4.1…as soon as it comes out. Many will only upgrade on the schedule or keep on the same release…general “quality” or “being free from bugs” to run MySQL in production. MySQL as it is now works for a …

Filed Under: Events and Announcements Tagged With:

Post: Percona Server 5.5.18-23.0: Now with Group Commit!

December 19, 2011 By 3 Comments

…). Based on MySQL 5.5.18, including all the bug fixes in it, Percona Server 5.5.18-23….compilation warnings, produced by GCC versions up to and including 4.6, were audited and fixed. Bug…878709(Oleg Tsarev) A missing link was added to the Percona Server upgrade documentation. Bug fixed: #885633(Alexey…

Filed Under: MySQL

Post: MySQL Server Upgrade

August 11, 2006 By 9 Comments

… of 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 are three reasons. First there are number of changes in 5…

Filed Under: Insight for DBAs Tagged With: ,

Post: Even minor upgrades are not always safe

September 4, 2006 By 5 Comments

… systems on MySQL 4.1 still as they will not benefit from MySQL 5.0 features anyway while I do not want to likely loose… MySQL 5.0 (You never know where to expect problems, ie some people reported JOIN breaking by upgrading to 5.0). Yes this stuff is in upgrade… case 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…

Filed Under: Insight for DBAs Tagged With:

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

March 4, 2013 By 7 Comments

… are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning other than to set innodb_ft_min_token_size to 4 (rather than the default of 3) so that it matches MyISAM’s default ft_min_word_length. First, MyISAM, with MySQL 5.5… there are likely going to be people who believe that switching to InnoDB FTS is simply a matter of upgrading to 5.6 and running…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

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

February 21, 2013 By 6 Comments

…x86_64 5.5.29-rel29.4.401….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…upgrade 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…

Filed Under: MySQL Tagged With: , , , , , ,

Comment: MySQL Installation and upgrade scripts.

May 21, 2007 By 3 Comments

… are my 2 cents: I tried to upgrade from 4.1.19 to: 5.0.24a – fast, “check for upgrade” did not trigger table repairs (bad… binlogs (bug #24432) 5.0.36sp1 – slow, with “check for upgrade” repairs, no problems with large merge tables (Unable to open underlying table… fresh to blindly migrate to. — Oh, yes, SELinux had to be disabled. At the present time I decided to upgrade to 5.0.36sp1 (MySQL Enperprise) it seems to…

Filed Under: Insight for DBAs Tagged With: ,

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

Filed Under: MySQL, Percona Software Tagged With:

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 … much 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… close in MySQL 5.0 and 4.1 Hopefully this issue will be fixed sooner or later (I would be even happy to give…

Filed Under: Insight for DBAs Tagged With: , ,

Post: MySQL End Of Life (EOL) Policy

August 22, 2008 By 6 Comments

…MySQL 4.1 are followed we’ll soon see stop in MySQL community releases of MySQL 5.0 most likely before MySQL 5.1 will proven MySQL 5.0 replacement. There is no blame on MySQL – it is no fun to…. We obviously recommend to upgrade when it makes …

Filed Under: Events and Announcements Tagged With: ,
« Older Posts
Newer Posts »