2015.12.15

MySQL

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

オリジナル版:https://lists.mysql.com/announce/1035

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

MySQL 5.6の特徴としては、以下のようなものがあります。

・InnoDB、オプティマイザ、レプリケーション、パーティショニングの性能向上

・GTID(Global Transaction ID)の実装

・Performance_schemaの機能強化

その他詳細については、下記URLを参照してください。

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

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

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

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

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

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

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

https://wikis.oracle.com/display/mysql/Contributing

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

http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-28.html

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

Changes in MySQL 5.6.28 (2015-12-07):

    Functionality Added or Changed

      * MySQL Server RPM packages now contain a conflict
        indicator for MySQL Connector C, such that an error
        occurs when installing MySQL Server if MySQL Connector C
        is also installed. To install MySQL Server, remove any
        MySQL Connector C packages first. (Bug #21900800)

      * mysql_upgrade now attempts to print more informative
        errors than FATAL ERROR: Upgrade failed. (Bug #21489398)

      * These client programs now support the
        --enable-cleartext-plugin option: mysqlcheck, mysqldump,
        mysqlimport, mysqlshow. This option enables the
        mysql_clear_password cleartext authentication plugin.
        (See The Cleartext Client-Side Authentication Plugin

(http://dev.mysql.com/doc/refman/5.6/en/cleartext-authentication-plugin.html).) 

        (Bug #21235226)

      * Support for building with Solaris Studio 5.13 was added.
        (Bug #21185883)

      * Performance Schema digests in DIGEST_TEXT columns have
        ... appended to the end to indicate when statements
        exceed the maximum statement size and were truncated.
        This is also now done for statement text values in
        SQL_TEXT columns. (Bug #75861, Bug #20519832)

    Bugs Fixed

      * InnoDB: InnoDB returned an invalid corruption-related
        error message during an IMPORT TABLESPACE operation. (Bug
        #21838158, Bug #77321)

      * InnoDB: An old version of numactl headers on the build
        host caused a compilation error when building a MySQL
        version that includes NUMA memory policy support. (Bug
        #21785074)

      * InnoDB: An online ALTER TABLE operation caused a server
        exit. (Bug #21640679)

      * InnoDB: A schema mismatch error occurred when importing a
        tablespace that was altered by DROP INDEX operation on
        the source server. (Bug #21514135, Bug #77659)

      * InnoDB: A duplicate key error that occurred during an
        online DDL operation reported an incorrect key name. (Bug
        #21364096, Bug #77572)

      * InnoDB: An ALTER TABLE operation caused the server to
        exit on disk full. (Bug #21326304, Bug #77497)

      * InnoDB: The system tablespace data file did not extend
        automatically when reaching the file size limit, causing
        startup to fail with a size mismatch error and preventing
        the addition of another system tablespace data file. (Bug
        #21287796, Bug #77128)

      * InnoDB: Altering the letter case of a column introduced
        an inconsistency between the frm file and data dictionary
        resulting in a failed CREATE INDEX operation on the
        altered column. (Bug #20755615)

      * InnoDB: An ALTER TABLE operation that converted a table
        to an InnoDB file-per-table tablespace did not check for
        unknown files with the same name as the destination .idb
        file, permitting an unknown file of the same name to be
        overwritten. (Bug #19218794, Bug #73225)

      * Replication: As binlog_error_action=ABORT_SERVER is the
        default in MySQL 5.7.7 and later it is being used for
        more error situations. The behavior has been adjusted to
        generate a core dump to improve troubleshooting
        possibilities. (Bug #21486161, Bug #77738)

      * Replication: Fatal errors encountered during flushing or
        synchronizing the binary log were being ignored. Such
        errors are now caught and handled depending on the
        setting of binlog_error_action. (Bug #76795, Bug #68953,
        Bug #20938915, Bug #16666407)

      * Internal buffer sizes in resolve_stack_dump were
        increased to accommodate larger symbol space requirements
        for C++ code. (Bug #22071592)

      * MySQL development RPM packages could fail to install if
        MySQL Connector/C development RPM packages were
        installed. (Bug #22005375)

      * Possible buffer overflow from incorrect use of strcpy()
        and sprintf() was corrected. (Bug #21973610)

      * MySQL RPM packages for RHEL5 failed to create the mysql
        system user. (Bug #21950975)

      * For Debian package control files, libnuma-dev was added
        to Build-Depends to enable NUMA support. (Bug #21822631)

      * Selecting DECIMAL values into user-defined variables
        could cause a server exit. (Bug #21819304)

      * Concurrent FLUSH PRIVILEGES and REVOKE or GRANT
        statements could produce a small time window during which
        invalid memory access to proxy user information could
        occur, leading to a server exit. (Bug #21602056)

      * Starting the server with the query_alloc_block_size
        system variable set to certain negative values on a
        machine without enough memory could result in
        out-of-memory errors. (Bug #21503595)

      * Using UNINSTALL PLUGIN to uninstall the daemon_example
        plugin could cause a server exit. (Bug #21467458)

      * FLUSH DES_KEY_FILE failed to reload the DES key file.
        (Bug #21370329)

      * If an error occurred during the setup phase of subquery
        materialization used to compute an IN predicate, cleanup
        of the temporary table did not happen, leading to
        Valgrind errors. (Bug #21346081)

      * Queries rejected by MySQL Enterprise Firewall were
        truncated to 512 characters when written to the error
        log. (Bug #20948270)

      * A server exit could occur for the second execution of a
        prepared statement for which an ORDER BY clause referred
        to a column position. (Bug #20755389)

      * Repeated execution of a prepared statement could cause a
        server exit if the default database was changed. (Bug
        #20447262)

      * Outer references do not work as arguments to MATCH(), but
        the server did not properly detect them. Now it does and
        raises an error. (Bug #20007383)
        References: See also Bug #21140088.

      * Valgrind errors were produced during row comparator
        setup. (Bug #19929406)

      * After failure to create a temporary table during join
        processing and releasing the table descriptor, an attempt
        to access the now-invalid descriptor could cause a server
        exit. (Bug #19918299)

      * Type conversion failure for DECIMAL values could cause a
        server exit. (Bug #19912326, Bug #20013538)

      * INSERT DELAYED could cause a server exit for tables
        partitioned with a character column as the key and for
        which the expression required a character set conversion.
        (Bug #19894161)

      * During a filesort for an UPDATE statement, the optimizer
        could access a stale pointer, resulting in a server exit.
        (Bug #19893908)

      * A server exit could occur when updating a view using an
        ALL comparison operator on a subquery that selects from
        an indexed column in the main table. (Bug #19434916)

      * Some stress test files in the
        mysql-test/suite/innodb_stress directory had the
        executable file mode set although they were not script
        files. (Bug #78403, Bug #21822413)

      * The server initialization script used for the service
        mysql status command on Linux sometimes incorrectly
        reported that the server was stopped. (Bug #77696, Bug
        #21768876)

On Behalf of the MySQL/ORACLE RE Team
Hery Ramilison