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 http://serverfault.com/questions/362388/mysql-5-1-vs-mysql-5-5-5-1-twice-as-fast/362706#362706
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?