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

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.

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.