MySQL 5.1.66 is a bug fix and security release, no new features have been added
InnoDB: Certain information_schema tables originally introduced in MySQL 5.6 are now also available in MySQL 5.5 and MySQL 5.1: INNODB_BUFFER_PAGE, INNODB_BUFFER_PAGE_LRU, and INNODB_BUFFER_POOL_STATS. (Bug #13113026)
A query for a FEDERATED table could return incorrect results when the underlying table had a compound index on two columns and the query included an AND condition on the columns. (Bug #12876932)
The official Release Notes for MySQL 5.1.66 are available here - http://dev.mysql.com/doc/refman/5.1/en/news-5-1-66.html
MySQL 5.1.61 is a bug fix and security release, no new features have been added.
InnoDB Storage Engine: This fix improves the performance of operations on VARCHAR columns in InnoDB tables, where N is declared as a large value but the actual string values in the table are short. (Bug #12835650)
InnoDB Storage Engine: The DATALENGTH column in the INFORMATIONSCHEMA.TABLES table now correctly reports the on-disk sizes of tablespaces for InnoDB compressed tables. (Bug #12770537)
The official Release Notes for MySQL 5.1.61 are available here - http://dev.mysql.com/doc/refman/5.1/en/news-5-1-61.html
MySQL 5.1.57 is a bug fix release, no new features have been added.
The official Release Notes for MySQL 5.1.57 are available here - http://dev.mysql.com/doc/refman/5.1/en/news-5-1-57.html
The official Release Notes for MySQL 5.1.56 are available here - http://dev.mysql.com/doc/refman/5.1/en/news-5-1-56.html
Before upgrading MySQL, make a backup of your databases. Instructions for ISPmanager are here - http://support.eapps.com/ispmgr/mysql5#backing_up_your_mysql_databases, and instructions for Webmin are here - http://support.eapps.com/apps/mysql#backing_up_your_mysql_databases. |
To update MySQL in ISPmanager, you will need to connect to your Virtual Machine via SSH, using either the MindTerm SSH client, or a regular SSH client. More information can be found in the User Guide: SSH and MindTerm - http://support.eapps.com/ispmgr/ssh
Once you are connected to the Virtual Machine, you will need to run the following commands as the root user: yum clean all and yum -y update mysql-server
[root@example ~]# yum clean all Loaded plugins: fastestmirror, priorities, remove-with-leaves Cleaning up Everything Cleaning up list of fastest mirrors [root@example ~]# [root@example ~]# yum -y update mysql-server |
You will know that MySQL 5.1.61 is installed when you see a Complete! message and you are returned to the command prompt. Once the installation has completed, restart MySQL with the service mysqld restart command.
[root@example ~]# service mysqld restart Stopping MySQL: [ OK ] Starting MySQL: [ OK ] [root@example ~]# |
To upgrade the application, go to the Control Panel > Applications > MySQL Server > Updates Available -> Update application
This will upgrade the MySQL Server and restart the service.