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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My DB server has MySQL 5.1.58-community-log and I am planning to upgrade it to MySQL 5.6 with specific purpose of improving my system performance and removing the bottleneck issue. So, I have gone through mulitple posts about the differences between MySQL 5.1 and MySQL 5.6

Below article indicates that MySQL 5.1 has better performance than 5.6

There are two versions of MySQL 5.1 as below:

MySQL 5.1 with built-in InnoDB
MySQL 5.1 with InnoDB-plugin
  • What are the differences between these?
  • How will I know that My server has built-in InnoDB or InnoDB-plugin?
  • How to change from built-in InnoDB version to InnoDB-plugin version and vice-versa?
  • Should I not leave my plan to upgrade MySQL?
share|improve this question

If it's a plugin then you'll see variable innodb_version:

mysql> show variables like 'innodb_version';
| Variable_name  | Value          |
| innodb_version | 5.5.35-rel33.0 |

InnoDB as a plugin had more features and was more actively developed. That happened due to historical reasons (at that time MySQL was owned by Sun and InnoDB was owned by Oracle).

I wouldn't recommend using 5.1 as it's EOL. 5.1 isn't any faster than 5.5 or 5.6. Why would it be if the huge team in Oracle works on InnoDB and 5.5 and 5.6 are great releases. It reminds me common myth "MyISAM is faster than InnoDB".

share|improve this answer
when I run the above command (show variables like 'innodb_version')for MySQL 5.1.58, I got nothing. When I run it for MySQL 5.6, I got Innodb_version = 5.6.15 – ursitesion Mar 13 '14 at 19:59
so, your 5.1.58 comes with base InnoDB and 5.6 with the plugin – akuzminsky Mar 13 '14 at 20:04
For 5.6, what do you mean - Built-in InnoDB or InnoDB-plugin? – ursitesion Mar 13 '14 at 20:08
Since 5.5 Oracle got rid of that confusion and releases with InnoDB plugin only. – akuzminsky Mar 13 '14 at 20:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.