June 20, 2013

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

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

… directly MySQL 5.0 to 5.5 for MyISAM tables? MyISAM have not been getting any significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5 …you go over normal upgrade checks you should be fine. Q: What are the key concerns upgrading MySQL 4.1 to MySQL 5.5? This is jumping …

Filed Under: Insight for DBAs, MySQL

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

March 4, 2013 By 7 Comments

…0 | | 3 | William Doyle Abbott Jr | 0 | | 5 | Robert Jack Abraham | 0 | | 7 | Mark Allen Abrell | 0 | +——-+————————–+——-+ And with 5.6: mysql…to be people who believe that switching to InnoDB FTS is simply a matter of upgrading to 5…ft_min_token_size to 4. Thus, when InnoDB is…

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

Post: MySQL Installation and upgrade scripts.

May 21, 2007 By 3 Comments

…respect. Major version upgrades become more painful recently. In MySQL 3.22->3.23 upgrades or 3.23->4.0 upgrades you really … tip to mention – upgrading to the new major version make sure you upgrade to latest current version at first. Ie upgrade to recent MySQL 5.0 before upgrading to MySQL 5.1 -…

Filed Under: Insight for DBAs Tagged With: ,

Post: Even minor upgrades are not always safe

September 4, 2006 By 5 Comments

… my 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… in 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 notes… 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.21…

Filed Under: Insight for DBAs Tagged With:

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

February 21, 2013 By 6 Comments

…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.0…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: , , , , , ,

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

December 10, 2008 By 15 Comments

… Team, Tricky Code During MySQL 3.23 and MySQL 4.0 team the small tight …5.1 vs row level replication or events. I think less than 5% are using both features. MySQL 4…it comes out. Many will only upgrade on the schedule or keep …or “being free from bugs” to run MySQL in production. MySQL as it is now …

Filed Under: Events and Announcements Tagged With:

Post: Percona Server security fix releases

May 23, 2010 By 4 Comments

… 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 are now under serious risks. If you are interested in backporting patches to 4.0 / 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 of … 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 the same… close in MySQL 5.0 and 4.1 Hopefully this issue will be fixed sooner or later (I would be even happy to give up…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

… sure. HT: 5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1 has a…. It takes time for the patches to mature. We improved the scalability of InnoDB-5.0.30 in December 2006 with a large… new Linux/Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to 32 GB…

Filed Under: Insight for Developers Tagged With:
« Older Posts
Newer Posts »