Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
For ages I have been using MySQL 5.1.37.
Recently I noticed that this version is no longer supported in repository, so I need to upgrade mysql.
I assume that changing the version should be complicated process with changes in my.cnf, and may be with the changes in the code.
Questions
I tend to follow the following rule for existing code-base:
If it's working fine, there is no need to upgrade unless there's a specific feature you are missing.
InnoDB does get some nice performance boosts in 5.5, but if your current use-case is not seeing any issues with your install, why upgrade?
If you ran some performance tests on a development server that indicates you are getting near your limit, you could try 5.5 to see if that helps any.
For future projects, I would definitely recommend 5.5, however.
unless there's a specific feature you are missing.
– RolandoMySQLDBA
Jan 19 '12 at 20:48
You need to get away from MySQL 5.1 ASAP
MySQL 5.0 Active Support ended on December 31, 2009 - Now in Extended Support Phase Per the MySQL Support Lifecycle policy, active support for MySQL 5.0 ended on December 31, 2009. MySQL 5.0 is now in the Extended support phase.
Versions have changed rapidly since Oracle stepped in
MySQL 5.1 will soon reach its EOL (End of Life) in terms of Active support and go to Extended support (EOL : TBD). Naturally, that support is commerical. It would not hold my breath for that kind of support for the Community versions.
MySQL 5.5.20 was just released 2012-01-11 and 5.5.19 was just a month ago. As with any upgraded product, always read release notes to see what changes and improvements have come about since the previous stable release.
