MySQL 5.5.20 Fixes InnoDB Issues

MySQL has reached today, January 11th, version 5.5.20, bringing various fixes and improvements.

The most prominent fix in MySQL 5.5.20 relates to “Replication”. Setting an empty user in a "CHANGE MASTER TO" statement caused an invalid internal result and is no longer permitted.

Among other bugs fixed we can mention an incorrect InnoDB assertion could cause the server to halt; the handle_segfault() signal-handler code in mysqld could itself crashed because it was calling unsafe functions; access to ARCHIVE tables caused corruption; deadlocks could have occurred when multiple rows were inserted and updated simultaneously by different transactions in inconsistent order.

Other fixes include enabling myisam_use_mmap which could cause the server to crash, concurrent access to ARCHIVE tables which could cause corruption, and locale information for FORMAT() function instances was lost in view definitions.

A complete list of change brought by MySQL 5.5.20 can be found here.

Download MySQL 5.5.20 right now from Softpedia.