Dear MySQL users,
MySQL Server 5.1.67, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.67 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html For information on installing MySQL 5.1.67 on new servers or upgrading to MySQL 5.1.67 from previous MySQL releases, please see http://dev.mysql.com/doc/refman/5.1/en/installing.html MySQL Server is available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ Not all mirror sites may be up to date at this point in time, so if you can't find this version on some mirror, please try again later or choose another download site. We welcome and appreciate your feedback, bug reports, bug fixes, patches, etc: http://forge.mysql.com/wiki/Contributing For information on open issues in MySQL 5.1, please see the errata list at http://dev.mysql.com/doc/refman/5.1/en/bugs.html The following section lists the changes in the MySQL source code since the previous released version of MySQL 5.1. It may also be viewed online at http://dev.mysql.com/doc/relnotes/mysql/5.1/en/news-5-1-67.html Enjoy! ======================================================================= A.1.1. Changes in MySQL 5.1.67 (Not yet released) Bugs Fixed * Performance: InnoDB: The timing values for low-level InnoDB read operations were adjusted for better performance with fast storage devices, such as SSD (http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_ssd ). This enhancement primarily affects read operations for BLOB columns in compressed (http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_com pression) tables. (Bug #13702112, Bug #64258) * InnoDB: An online DDL operation for an InnoDB table incorrectly reported an empty value ('') instead of the correct key value when it reported a duplicate key error for a unique index using an index prefix. (Bug #14729221) * InnoDB: If a CREATE TABLE statement failed due to a disk full error, some memory allocated during the operation was not freed properly. (Bug #14708715) * InnoDB: If the server crashed at the specific point when a change buffer (http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_cha nge_buffer) entry was being merged into a buffer pool page, the transaction log and the change buffer were left in an inconsistent state. After a restart, MySQL could crash after reading the corresponding secondary index page. The problem was more likely to occur in MySQL 5.5 or later, where the original insert buffering (http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_ins ert_buffering) mechanism was generalized to cover other operations. (Bug #14636528, Bug #66819, Bug #58571, Bug #61104, Bug #65443) * InnoDB: In rare circumstances, MySQL could apply InnoDB undo (http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_und o) records out of order during a ROLLBACK (http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_rol lback) of an operation that modified a BLOB column. This issue could cause an assertion error in debug builds: !bpage->file_page_was_freed (Bug #13249921) * Replication: Updates writing user variables whose values were never set on a slave while using --replicate-ignore-table could cause the slave to fail. (Bug #14597605) References: This bug was introduced by Bug #14275000. * Replication: Backtick (`) characters were not always handled correctly in internally generated SQL statements, which could sometimes lead to errors on the slave. (Bug #14548159) * Replication: Following an insert into a nontransactional table that failed due to insufficient disk space, the server did not properly clean up all pending events, leading to an assert or possibly to other errors. (Bug #11750014) * Very long database names in queries could cause the server to exit. (Bug #15912213) * Within a stored procedure, executing a multiple-table DELETE statement that used a very long table alias could cause the server to exit. (Bug #15954896) * Attempting to create an auto-increment (http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_aut o_increment) column in an InnoDB table with a NULL type attribute could cause a serious error. (Bug #14758479) * A DELETE statement for an InnoDB table could write incorrect transaction metadata into a record, causing the server to halt with an error. To work around this issue, reduce the specified length of the primary key to less than 1K bytes. (Bug #14731482) * Repeated execution of a query containing a subquery that used MAX() could result in increasing memory consumption. (Bug #14683676) * USE dbname could fail with Unknown database when dbname contained multiple backtick (`) characters. (Bug #14645196) * SHOW PROFILE could be used to cause excessive server memory consumption. (Bug #14629232) * The thread cache implementation worked in LIFO rather than FIFO fashion and could result in a thread being denied service (although this was a remote possibility). (Bug #14621627) * CREATE USER and DROP USER could fail to flush the privileges, requiring FLUSH PRIVILEGES to be used explicitly. (Bug #13864642) * A memory leak could occur for queries containing a subquery that used GROUP BY on an outer column. (Bug #13724099) * The number of connection errors from a given host as counted by the server was periodically reset, with the result that max_connect_errors was never reached and invalid hosts were never blocked from trying to connect. (Bug #11753779) References: See also Bug #38247, Bug #43006, Bug #45584, Bug #45606. * During optimization, ZEROFILL values may be converted to string constants. However, CASE expressions did not handle switching data types after the planning stage, leading to CASE finding a null pointer instead of its argument. (Bug #57135, Bug #11764313) * On Windows, the Perl version of mysql_install_db created system tables in the mysql database that were not populated properly. (Bug #65584, Bug #14181049) * mysqld_safe ignored the value of the UMASK environment variable, leading to behavior different from mysqld with respect to the access mode of created files. Now mysqld_safe (and mysqld_multi) attempt to approximate the same behavior as mysqld. (Bug #57406, Bug #11764559) * LAST_INSERT_ID(expr) did not work for expr values greater than the largest signed BIGINT value. (Bug #20964, Bug #11745891) Thanks, On Behalf of Oracle MySQL RE Team Akhil Mohan MySQL Release Engineer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql