There was a problem loading the comments.

Release Notes - MySQL 5 (ISPmanager/Webmin)

Support Portal  »  Knowledgebase  »  Viewing Article

  Print

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

Warning 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.



Share via
Did you find this article useful?  

Related Articles


On-Premise Help Desk Software by SupportPal

Categories

© Cloudscale365