MySQL Community Server 5.1.67 has been released

[Akhil Mohan]

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 (21 December 2012)

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