2009.04.19

MySQL

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

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

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

MySQL 5.1.34は、AIX 5.2向けのMySQL 5.1としての最終リリースとなります。AIX 5.2向けのEOL(End of Life) を2009年4月30日に迎える予定です。詳細情報は、以下をご覧ください。

 http://www.mysql.com/support/eol-notice.html

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

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


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

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


MySQL 5.1.34は、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-34.html

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

=======================================================================

Functionality added or changed:

  * Optimizer: The @@optimizer_switch setting was backported from
    MySQL 6.0, with additional switches to turn on/off use of
    index_merge optimizations or a particular index_merge algorithm.
    For more information please seehttp://s.petrunia.net/blog/?p=52

Bugs fixed:

  * Replication: Important Note: Binary logging with
    --binlog_format=ROW failed when a change to be logged included
    more than 251 columns. This issue was not known to occur with
    mixed-format or statement-based logging.
    (Bug#42977:http://bugs.mysql.com/42977)
    See alsoBug#42914:http://bugs.mysql.com/42914.

  * Replication: Assigning an invalid directory for the
    --slave-load-tmpdir caused the replication slave to crash.
    (Bug#42861:http://bugs.mysql.com/42861)

  * Replication: The mysql.procs_priv system table was not
    replicated. (Bug#42217:http://bugs.mysql.com/42217)

  * Replication: An INSERT DELAYED into a TIMESTAMP column issued
    concurrently with a an insert on the same column not using
    DELAYED, but applied after the other insert, was logged using
    the same timestamp as generated by the other (non-DELAYED)
    insert. (Bug#41719:http://bugs.mysql.com/41719)

  * Replication: The MIXED binary logging format did not switch to
    row-based mode for statements containing the LOAD_FILE()
    function. (Bug#39701:http://bugs.mysql.com/39701)

  * Replication: When the server SQL mode included IGNORE_SPACE,
    statement-based replication of LOAD DATA INFILE ... INTO
    tbl_name failed because the statement was read incorrectly
    from the binary log; a trailing space was omitted, causing the
    statement to fail with a syntax error when run on the slave.
    (Bug#22504:http://bugs.mysql.com/22504)
    See alsoBug#43746:http://bugs.mysql.com/43746.

  * An attempt by a user who did not have the SUPER privilege to
    kill a system thread could cause a server crash.
    (Bug#43748:http://bugs.mysql.com/43748)

  * On Windows, incorrectly specified link dependencies in
    CMakeLists.txt resulted in link errors for mysql_embedded,
    mysqltest_embedded, and mysql_client_test_embedded.
    (Bug#43715:http://bugs.mysql.com/43715)

  * mysql crashed if a request for the current database name
    returned an empty result, such as after the client has
    executed a preceding SET sql_select_limit=0 statement.
    (Bug#43254:http://bugs.mysql.com/43254)

  * If the value of the version_comment system variable was too
    long, the mysql client displayed a truncated startup message.
    (Bug#43153:http://bugs.mysql.com/43153)

  * Queries of the following form returned an empty result: SELECT
    ... WHERE ... (col=col AND col=col) OR ... (false expression)
    (Bug#42957:http://bugs.mysql.com/42957)

  * The strings/CHARSET_INFO.txt file was not included in source
    distributions. (Bug#42937:http://bugs.mysql.com/42937)

  * A dangling pointer in mysys/my_error.c could lead to client
    crashes. (Bug#42675:http://bugs.mysql.com/42675)

  * Passing an unknown time zone specification to CONVERT_TZ()
    resulted in a memory leak.
    (Bug#42502:http://bugs.mysql.com/42502)

  * With more than two arguments, LEAST(), GREATEST(), and CASE
    could unnecessarily return Illegal mix of collations errors.
    (Bug#41627:http://bugs.mysql.com/41627)

  * The mysql client could misinterpret its input if a line was
    longer than an internal buffer.
    (Bug#41486:http://bugs.mysql.com/41486)

  * In the help command output displayed by mysql, the description
    for the \c (clear) command was misleading.
    (Bug#41268:http://bugs.mysql.com/41268)

  * The load_defaults(), my_search_option_files() and
    my_print_default_files() functions in the C client library
    were subject to a race condition in multi-threaded operation.
    (Bug#40552:http://bugs.mysql.com/40552)

  * If --basedir was specified, mysqld_safe did not use it when
    attempting to locate my_print_defaults.
    (Bug#39326:http://bugs.mysql.com/39326)

  * When MySQL was configured with the --with-max-indexes=128
    option, mysqld crashed.
    (Bug#36751:http://bugs.mysql.com/36751)

  * Setting the join_buffer_size variable to its minimum value
    produced spurious warnings.
    (Bug#36446:http://bugs.mysql.com/36446)

  * The use of NAME_CONST() can result in a problem for CREATE
    TABLE ... SELECT statements when the source column expressions
    refer to local variables. Converting these references to
    NAME_CONST() expressions can result in column names that are
    different on the master and slave servers, or names that are
    too long to be legal column identifiers. A workaround is to
    supply aliases for columns that refer to local variables.
    Now a warning is issued in such cases that indicate possible
    problems. (Bug#35383:http://bugs.mysql.com/35383)

  * An attempt to check or repair an ARCHIVE table that had been
    subjected to a server crash returned a 144 internal error. The
    data appeared to be irrecoverable.
    (Bug#32880:http://bugs.mysql.com/32880)

  * The Time column for SHOW PROCESSLIST output and the value of
    the TIME column of the INFORMATION_SCHEMA.PROCESSLIST table
    now can have negative values. Previously, the column was
    unsigned and negative values were displayed incorrectly as
    large positive values. Negative values can occur if a thread
    alters the time into the future with SET TIMESTAMP = value or
    the thread is executing on a slave and processing events from
    a master that has its clock set ahead of the slave.
    (Bug#22047:http://bugs.mysql.com/22047)

  * Restoring a mysqldump dump file containing FEDERATED tables
    because the file contained the data for the table. Now only
    the table definition is dumped (because the data is located
    elsewhere). (Bug#21360:http://bugs.mysql.com/21360)