By com


2012-01-19 09:18:43 8 Comments

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

  • Which version is the most stable and preferred?
  • Which version should I use?

2 comments

@Derek Downey 2012-01-19 17:17:23

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.

@com 2012-01-19 17:50:17

Thanks, moving to 5.5, should I consider changing my.cnf or code with queries?

@Derek Downey 2012-01-19 18:05:38

I highly recommend reading the changelog for MySQL 5.5 and determining that for your use-case. Read-up on innodb performance tuning, and then come back here if you have a specific issue.

@RolandoMySQLDBA 2012-01-19 20:48:17

Sometimes, KISS and If-it-aint-broke-dont-fix-it principles work best for most people. +1 for unless there's a specific feature you are missing.

@RolandoMySQLDBA 2012-01-19 17:03:00

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.

Related Questions

Sponsored Content

1 Answered Questions

[SOLVED] Latest MySQL version for Windows 7

3 Answered Questions

Debian Wheezy to Jessie -- MySQL Dead Slow

  • 2019-04-17 10:16:20
  • Nasir Mahmood
  • 36 View
  • 0 Score
  • 3 Answer
  • Tags:   mysql upgrade

1 Answered Questions

[SOLVED] mysql_upgrade on fresh MySQL/MariaDB installation

1 Answered Questions

Changes between Mysql version 5.1 TO 5.7

1 Answered Questions

Why is MYSQL not starting?

  • 2016-04-06 22:14:40
  • Henri Lower
  • 333 View
  • 2 Score
  • 1 Answer
  • Tags:   mysql

2 Answered Questions

[SOLVED] Which service to use for unoptimized, slow mysql database ?

1 Answered Questions

[SOLVED] Why integer search string is slower on char field?

  • 2015-12-09 14:38:07
  • Gift Rise
  • 1294 View
  • 2 Score
  • 1 Answer
  • Tags:   mysql

Sponsored Content