Our old database is MySQL 5.1 server and is four years old. If I uninstall MySQL 5.1 Server and install the latest release and restore the backup, will I gain performance benefits? I guess the new version release says that there are many performance benefits.
MySQL Backup – Restoring to Latest Release
backupMySQL
Related Question
- Db2 – How to restore from a backup of a very old version of DB2 (version 6.1 backup)
- Sql-server – Fail plan on a release to production with differential backup
- MySQL Upgrade on Windows
- MySQL – How to Restore Old Backup Over New Data
- Mysql – How to Recover My database From Old WampServer
- SQL Server – Server Version Error When Restoring Backup with SSMS
- Sql-server – Log error restoring old database to SQL Server 2017
Best Answer
IMHO, when it comes to MySQL 5.5, you will definitely see much better performance from InnoDB than in past releases because dirty pages in the InnoDB Buffer Pool do not linger as long. Those dirty pages are flushed more robustly.
You also have the luxury of creating multiple InnoDB Buffer Pools (See innodb_buffer_pool_instances and innodb_buffer_pool_size). To reduce thread locking amongst the buffer pools, make sure set innodb_thread_concurrency to 0 to let InnoDB storage engine decide best how to handle thread allocation.
CAVEAT ON MIGRATION TO MySQL 5.5
Make sure you mysqldump all databases EXCEPT the mysql schema. There is a cleaner, crisper way to migrate User Grants out of the MySQL Schema. In fact, there are two options for accomplishing this:
OPTION 1 : Use mk-show-grants
This dumps out all the MySQL Grants as SQL statements, which is completely portable to any MySQL 5.x instance.
OPTION 2 : Run these commands (My personal emulation of what mk-show-grants does)