2010.03.17

MySQL

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

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


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

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

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


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

  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-45.html

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

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

C.1.1. Changes in MySQL 5.1.45

InnoDB Plugin Notes:

* This release includes InnoDB Plugin 1.0.6. This version is
considered of Release Candidate (RC) quality.
In this release, the InnoDB Plugin is included in source and
binary distributions, except RHEL3, RHEL4, SuSE 9 (x86,
x86_64, ia64), and generic Linux RPM packages. It also does
not work for FreeBSD 6 and HP-UX or for Linux on generic ia64.

Functionality added or changed:

* mysqltest has a new --max-connections option to set a higher
number of maximum allowed server connections than the default
128. This option can also be passed via mysql-test-run.pl.
(Bug#51135: http://bugs.mysql.com/bug.php?id=51135)

* mysql-test-run.pl has a new --portbase option and a
corresponding MTR_PORT_BASE environment variable for setting
the port range, as an alternative to the existing
--build-thread option.
(Bug#50182: http://bugs.mysql.com/bug.php?id=50182)

* mysql-test-run.pl has a new --gprof option that runs the
server through the gprof profiler, much the same way the
currently supported --gcov option runs it through gcov.
(Bug#49345: http://bugs.mysql.com/bug.php?id=49345)

* mysqltest has a new lowercase_result command that converts the
output of the next statement to lowercase. This is useful for
test cases where the lettercase may vary between platforms.
(Bug#48863: http://bugs.mysql.com/bug.php?id=48863)

* mysqltest has a new remove_files_wildcard command that removes
files matching a pattern from a directory.
(Bug#39774: http://bugs.mysql.com/bug.php?id=39774)

Bugs fixed:

* Partitioning: Attempting to drop a partitioned table from one
connection while waiting for the completion of an ALTER TABLE
that had been issued from a different connection, and that
changed the storage engine used by the table, could cause the
server to crash.
(Bug#42438: http://bugs.mysql.com/bug.php?id=42438)

* Replication: Adding an index to a table on the master caused
the slave to stop logging slow queries to the slow query log.
(Bug#50620: http://bugs.mysql.com/bug.php?id=50620)

* Replication: Queries which were written to the slow query log
on the master were not written to the slow query log on the
slave. (Bug#23300: http://bugs.mysql.com/bug.php?id=23300)
See also Bug#48632: http://bugs.mysql.com/bug.php?id=48632.

* mysqld_multi failed due to a syntax error in the script.
(Bug#51468: http://bugs.mysql.com/bug.php?id=51468)

* Referring to a subquery result in a HAVING clause could
produce incorrect results.
(Bug#50995: http://bugs.mysql.com/bug.php?id=50995)

* Use of filesort plus the join cache normally is preferred to a
full index scan. But it was used even if the index is
clustered, in which case, the clustered index scan can be
faster. (Bug#50843: http://bugs.mysql.com/bug.php?id=50843)

* For debug builds, SHOW BINARY LOGS caused an assertion to be
raised if binary logging was not enabled.
(Bug#50780: http://bugs.mysql.com/bug.php?id=50780)

* Incorrect handling of BIT columns in temporary tables could
lead to spurious duplicate-key errors.
(Bug#50591: http://bugs.mysql.com/bug.php?id=50591)

* Full-text queries that used the truncation operator (*) could
enter an infinite loop.
(Bug#50351: http://bugs.mysql.com/bug.php?id=50351)

* mysqltest no longer lets you execute an SQL statement on a
connection after doing a send command, unless you do a reap
first. This was previously accepted but could produce
unpredictable results.
(Bug#49269: http://bugs.mysql.com/bug.php?id=49269)

* For debug builds on Windows, warnings about incorrect use of
debugging directives were written to the error log. The
directives were rewritten to eliminate these messages.
(Bug#49025: http://bugs.mysql.com/bug.php?id=49025)

* Building MySQL on Fedora Core 12 64-bit failed, due to errors
in comp_err.
(Bug#48864: http://bugs.mysql.com/bug.php?id=48864)

* An ARZ file missing from the database directory caused the
server to crash.
(Bug#48757: http://bugs.mysql.com/bug.php?id=48757)

* Slow CALL statements were not always logged to the slow query
log because execution time for multiple-statement stored
procedures was assessed incorrectly.
(Bug#47905: http://bugs.mysql.com/bug.php?id=47905)

* Failure to open a view with a nonexistent DEFINER was
improperly handled and the server would crash later attempting
to lock the view.
(Bug#47734: http://bugs.mysql.com/bug.php?id=47734)

* If EXPLAIN encountered an error in the query, a memory leak
occurred. (Bug#45989: http://bugs.mysql.com/bug.php?id=45989)

* Grouping by a subquery in a query with a DISTINCT aggregate
function led to incorrect and unordered grouping values.
(Bug#45640: http://bugs.mysql.com/bug.php?id=45640)

* Propagation of a large unsigned numeric constant in WHERE
expressions could lead to incorrect results. This also
affected EXPLAIN EXTENDED, which printed incorrect numeric
constants in such transformed WHERE expressions.
(Bug#45360: http://bugs.mysql.com/bug.php?id=45360)

* Valgrind warnings about uninitialized variables in optimizer
code were silenced.
(Bug#45195: http://bugs.mysql.com/bug.php?id=45195)

* flush_cache_records() did not correctly check for errors that
should cause statement execution to stop, leading to a server
crash. (Bug#39022: http://bugs.mysql.com/bug.php?id=39022)

* When building MySQL when using a different target directory
(for example using the VPATH environment variable), the build
of the embedded readline component would fail.
(Bug#35250: http://bugs.mysql.com/bug.php?id=35250)

* INSERT INTO ... VALUES(DEFAULT) failed to insert the correct
value for ENUM columns. For MyISAM tables, an empty value was
inserted. For CSV tables, the table became corrupt.
(Bug#33717: http://bugs.mysql.com/bug.php?id=33717)