2010.11.02

MySQL

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

オリジナル版:http://dev.mysql.com/doc/refman/5.1/en/news-5-1-52.html

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

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

http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html

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

http://dev.mysql.com/doc/refman/5.1/en/installing.html

下記のダウンロードページから、MySQLサーバのソースコード及び多数のプラットフォーム用バイナリが入手可能です

http://dev.mysql.com/downloads/

現時点ですべてのミラーサイトが最新であるとは限らないことに注意してください。
あるミラーサイトで本バージョンを見つけることができない場合は、後日再確認を行うか、別のダウンロード・サイトを選択してください。

フィードバック、バグレポート、バグ修正、パッチ等の情報をお待ちしておりますので、以下のページをご利用ください。

http://forge.mysql.com/wiki/Contributing

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

http://dev.mysql.com/doc/refman/5.1/en/open-bugs.html

以下のセクションは、MySQL5.1の前リリース以降のMySQLソースコードの変更を記載しています。これはオンラインでも閲覧可能です:

http://dev.mysql.com/doc/refman/5.1/en/news-5-1-52.html

以下は、追加または変更された機能です。

      * InnoDB Storage Engine: InnoDB incorrectly reported an error
        when a cascading foreign key constraint deleted more than 250
        rows. (Bug#57255: http://bugs.mysql.com/bug.php?id=57255)

      * InnoDB Storage Engine: A SELECT ... FOR UPDATE statement
        affecting a range of rows in an InnoDB table could cause a
        crash in the debug version of the server.
        (Bug#56716: http://bugs.mysql.com/bug.php?id=56716)

      * InnoDB Storage Engine: Improved the performance of UPDATE
        operations on InnoDB tables, when only non-indexed columns are
        changed. (Bug#56340: http://bugs.mysql.com/bug.php?id=56340)

      * InnoDB Storage Engine: The server could crash on shutdown, if
        started with --innodb-use-system-malloc=0.
        (Bug#55627: http://bugs.mysql.com/bug.php?id=55627)

      * InnoDB Storage Engine: Setting the PACK_KEYS=0 table option
        for an InnoDB table prevented new indexes from being added to
        the table. (Bug#54606: http://bugs.mysql.com/bug.php?id=54606)

      * InnoDB Storage Engine: Changed the locking mechanism for the
        InnoDB data dictionary during ROLLBACK operations, to improve
        concurrency for REPLACE statements.
        (Bug#54538: http://bugs.mysql.com/bug.php?id=54538)

      * InnoDB Storage Engine: InnoDB transactions could be
        incorrectly committed during recovery, rather than rolled
        back, if the server crashed and was restarted after performing
        ALTER TABLE...ADD PRIMARY KEY on an InnoDB table, or some
        other operation that involves copying the entire table.
        (Bug#53756: http://bugs.mysql.com/bug.php?id=53756)

      * Partitioning: Replication: Attempting to execute LOAD DATA on
        a partitioned MyISAM table while using statement-based logging
        mode caused the master to hang or crash.
        (Bug#51851: http://bugs.mysql.com/bug.php?id=51851)

      * Partitioning: Multi-table UPDATE statements involving a
        partitioned MyISAM table could cause this table to become
        corrupted. Not all tables affected by the UPDATE needed to be
        partitioned for this issue to be observed.
        (Bug#55458: http://bugs.mysql.com/bug.php?id=55458)

      * Partitioning: EXPLAIN PARTITIONS returned bad estimates for
        range queries on partitioned MyISAM tables. In addition,
        values in the rows column of EXPLAIN PARTITIONS output did not
        take partition pruning into account.
        (Bug#53806: http://bugs.mysql.com/bug.php?id=53806,
        Bug#46754: http://bugs.mysql.com/bug.php?id=46754)

      * Replication: Backticks used to enclose identifiers for
        savepoints were not preserved in the binary log, which could
        lead to replication failure when the identifier, stripped of
        backticks, could be misinterpreted, causing a syntax or other
        error.
        This could cause problems with MySQL application programs
        making use of generated savepoint IDs. If, for instance,
        java.sql.Connection.setSavepoint() is called without any
        parameters, Connector/J automatically generates a savepoint
        identifier consisting of a string of hexadecimal digits 0-F
        encased in backtick (`) characters. If such an ID took the
        form `NeN` (where N represents a string of the decimal digits
        0-9, and e is a literal uppercase or lowercase "E" character).
        Removing the backticks when writing the identifier into the
        binary log left behind a substring which the slave MySQL
        server tried to interpret as a floating point number, rather
        than as an identifier. The resulting syntax error caused loss
        of replication.
        (Bug#55961: http://bugs.mysql.com/bug.php?id=55961)
        See also Bug#55962: http://bugs.mysql.com/bug.php?id=55962.

      * If a query specified a DATE or DATETIME value in a format
        different from 'YYYY-MM-DD HH:MM:SS', a greater-than-or-equal
        (>=) condition matched only greater-than values in an indexed
        TIMESTAMP column.
        (Bug#55779: http://bugs.mysql.com/bug.php?id=55779)

      * If there was an active SELECT statement, an error arising
        during trigger execution could cause a server crash.
        (Bug#55421: http://bugs.mysql.com/bug.php?id=55421)

      * With an UPDATE IGNORE statement including a subquery that was
        evaluated using a temporary table, an error transferring the
        data from the temporary was ignored, causing an assertion to
        be raised. (Bug#54543: http://bugs.mysql.com/bug.php?id=54543)

      * Row subqueries producing no rows were not handled as UNKNOWN
        values in row comparison expressions.
        (Bug#54190: http://bugs.mysql.com/bug.php?id=54190)

      * In some cases, when the left part of a NOT IN subquery
        predicate was a row and contained NULL values, the query
        result was incorrect.
        (Bug#51070: http://bugs.mysql.com/bug.php?id=51070)

      * For some queries, the optimizer produced incorrect results
        using the Index Merge access method with InnoDB tables.
        (Bug#50402: http://bugs.mysql.com/bug.php?id=50402)

      * EXPLAIN produced an incorrect rows value for queries evaluated
        using an index scan and that included LIMIT, GROUP BY, and
        ORDER BY on a computed column.
        (Bug#50394: http://bugs.mysql.com/bug.php?id=50394)

      * mysql_store_result() and mysql_use_result() are not for use
        with prepared statements and are not intended to be called
        following mysql_stmt_execute(), but failed to return an error
        when invoked that way.
        (Bug#47485: http://bugs.mysql.com/bug.php?id=47485)

      * A malformed packet sent by the server when the query cache was
        in use resulted in lost-connection errors.
        (Bug#42503: http://bugs.mysql.com/bug.php?id=42503)

      * CREATE TABLE failed if a column referred to in an index
        definition and foreign key definition was in different
        lettercases in the two definitions.
        (Bug#39932: http://bugs.mysql.com/bug.php?id=39932)