MySQL Community Server 5.1.67 がリリースされました


最も普及しているオープンソースデータベース管理システムの新バージョンMySQL Community Server 5.1.67がリリースされました。MySQL 5.1.67は、プロダクションシステムでの使用をお勧めします。

MySQL 5.1の新機能の概要については、以下を参照してください。


新たなサーバにMySQL 5.1.67をインストール、または以前のMySQLリリースからMySQL 5.1.61にアップグレードする際の情報については、以下を参照してください。







MySQL 5.1に関するオープンな問題の情報については、以下のエラッタリストを参照してください。





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
        ). This enhancement primarily affects read operations for BLOB
        columns in compressed
        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
        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
        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
        o) records out of order during a ROLLBACK
        lback) of an operation that modified a BLOB column. This issue
        could cause an assertion error in debug builds:
        (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
        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

      * Repeated execution of a query containing a subquery that used
        MAX() could result in increasing memory consumption. (Bug

      * 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

      * 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

      * 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)