Release Notes - MySQL 5 (ISPmanager/Webmin)
- 10/03/2011 8:20 AM
Release Notes - MySQL 5 (ISPmanager/Webmin)
Highlighted Features and Fixes in MySQL 5.1.66
Features
MySQL 5.1.66 is a bug fix and security release, no new features have been added
Fixes
-
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
Highlighted Features and Fixes in MySQL 5.1.61
Features
MySQL 5.1.61 is a bug fix and security release, no new features have been added.
Fixes
-
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
Highlighted Features and Fixes in MySQL 5.1.57
Features
MySQL 5.1.57 is a bug fix release, no new features have been added.
Fixes
- Fix to InnoDB logic that would cause the server to hang if there was a long I/O wait
- Fix for mysqldump not quoting database names properly
- Fix for replication in the InnoDB storage engine column updates
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
Highlighted Features and Fixes in MySQL 5.1.56
Features
- The mysqldump —xml command now displays comments from column definitions.
Fixes
- Fixed a bug where parsing nested regular expressions could lead to recursion resulting in a stack overflow crash.
- The mysql client going into an infinite loop if STDIN was a directory has been fixed.
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
How to upgrade
 |
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. |
ISPmanager Control Panel
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 ~]# |
Webmin Control Panel
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.