オリジナル版:http://dev.mysql.com/doc/falcon/en/news-falcon-6-0-2.html
新たなFalconトランザクションストレージエンジンを持つMySQLデータベースシステムの新バージョンであるMySQL 6.0.2アルファ版がリリースされました。MySQL 6.0リリース用の主要ページは以下になります。
http://www.mysql.com/mysql60/
Falconストレージエンジンの使用が初めての方は、以下のFalcon評価ページをご参照ください。
http://www.mysql.com/why-mysql/white-papers/falcon-getting-started.php
また、Falconホワイトペーパは以下のページです。
http://www.mysql.com/why-mysql/white-papers/storage-engines-falcon.php
警告
Falconはアルファ版であり、本番環境では使用しないでください。Falconは現在MySQL-6.0-falconという、特定のMySQLリリース内でのみサポートされています。このリリースは、製品として使用する準備ができていないと考えています。mysql-6.0-falcon系はFalconストレージエンジンの試験と評価用としてのみ提供しています。
MySQL 6.0.2アルファ版は、http://dev.mysql.com/downloads/mysql/6.0.htmlとミラーサイトのダウンロード・ページから、ソースコード及び多くのプラットフォームのためのバイナリで現在利用可能です。
すべてのミラーサイトが現在、最新であるとは限らないことに注意してください。
あるミラーサイトでこのバージョンを見つけることができない場合は、再度確認を行うか、あるいは別のダウンロード・サイトを選択してください。
さらに、私たちのミラーサイトのいくつかが破損ファイルを提供しているかもしれないという問題が現在あることにご注意ください。この問題解決のためにミラーサイトの管理者と共に努力しています。
バグレポート、バグ修正、パッチ等の情報をお待ちしておりますので、以下のページをご利用ください。
http://forge.mysql.com/wiki/Contributing
以下のセクションはMySQL 6.0の最も最近にリリースされたバージョン以降のFalconストレージエンジンにおける変更を記載しています。以下のオンラインページで見ることもできます。
http://dev.mysql.com/doc/falcon/en/news-falcon-6-0-2.html
以下は、追加または変更された機能です。
Functionality added or changed:
* 64-bit Windows support.
* Mac OS X (Intel) support has been added. Mac OS X is not currently a
supported platform. To build on Mac OS X from the repository sources
you must have the most recent versions of bison, automake, autoconf
and libtool installed.
There are known issues with the Falcon on Mac OS X build. (Bug#30564)
* Support for tablespaces.
* New performance settings, falcon_index_chill_threshold,
falcon_record_chill_threshold, and falcon_log_windows.
* The Falcon record cache parameters have been altered. The
falcon_max_record_memory and falcon_min_record_memory are no longer
supported.
Instead, falcon_record_memory_max, falcon_record_scavenge_threshold,
falcon_record_scavenge_floor and falcon_inital_allocation parameters
are now used to control the caching of records in memory within Falcon.
See Section 3.1, “Configuration Parameters”. (Bug#30083)
The option falcon_initial_allocation has been added to control the
initial size of a Falcon tablespace on disk.
The option falcon_disable_fsync has been added. If set to true, then
the periodic fsync operation is disabled.
Bugs fixed:
* Renaming tables to or from Falcon tablespaces would raise an error.
(Bug#22155)
* Some Falcon variables were marked as status variables. (Bug#29169)
* Under certain situations the Falcon tables and log could become corrupt
and prevent recovery from a crashed version of the files. (Bug#28351)
* Updating a large table without an index would lock all the records
during a transaction and unlock the records individually. (Bug#30124)
* Falcon would incorrectly allow creation of two tables with the same
name but different case sensitivity, without raising an error, but
treat the two tables as the same during further queries. (Bug#30210).
* When loading large datasets into a Falcon table mysqld could crash. An
Out of memory error will now be raised in this situation. (Bug#30251)
* An assertion could be thrown during high number of concurrent updates
of BLOB fields. (Bug#30463)
* Accessing an INFORMATION_SCHEMA table generated by Falcon, when Falcon
has not been enabled would cause mysqld to crash. (Bug#29014)
* Falcon could occasionally report a problem with a duplicate key error
during INSERT when inserting the same data into a unique column on two
or more connections simultaneously. (Bug#29240)
* For debug builds, the server crashed when inserting a negated DECIMAL
value of maximum precision (65 digits), such as for INSERT INTO ...
SELECT -col_val ... (Bug#28810)
* Creating a tablespace with a unique name but using the same datafile
as an existing tablespace results in the re-initialization of the
tablespace and the loss of the data contained in it. Falcon will now
report an error if you the datafile already exists. (Bug#29511)
* DELETE statements could cause a crash when many simultaneous threads
are running. (Bug#26475)
* Using SELECT on a table that uses two INT columns with a single index
would fail to return rows that queried both columns and complex
comparison operators. (Bug#29319)
* Wide DECIMAL columns would show rounding errors during SELECT.
(Bug#29201)
* Inserting into a table with a unique index simultaneously on two
connections in a way that would cause a deadlock would cause MySQL to
hang. The deadlock situation is now identified and an error will be
raised. (Bug#29206)
* Accessing data within DECIMAL columns wider than 18 digits would cause
a crash. (Bug#28725)
* Falcon would fail to build under Mac OS X/Intel. A preliminary patch is
available to allow building under Mac OS X/Intel only (PowerPC support
is not yet available). Note that Mac OS X/Intel is still an unsupported
platform. (Bug#26466)
* Under certain situations, shutting down MySQL using mysqladmin could
cause Falcon to corrupt the database tables and fail to restart
properly. (Bug#26296)
* Queries could fail with a Can't find record in ... error. (Bug#26328)
* DECIMAL columns with large widths did not work, either during INSERT or
SELECT. (Bug#26607).
* Renaming a database would raise error ERROR 1030 (HY000): Got error 157
from storage engine. (Bug#22182)
* Loading certain datasets through a direct import could cause index
problems and crash. (Bug#26930)
* Inserting large numbers of identical columns into a table, followed by
a SELECT or UPDATE could cause a hang or crash. (Bug#27277)
* The value for FALCON_SYSTEM_MEMORY_SUMMARY.TOTAL_SPACE in
INFORMATION_SCHEMA would be reported incorrectly. (Bug#28197)
* Unique indexes on VARCHAR columns are not identified correctly.
(Bug#28500)
* mysqld would crash after a high number of ALTER TABLE, INSERT and
UPDATEstatements. (Bug#22154,Bug#28515)
* Searching for rows within a table with some non-western character sets
would fail to return the right results if the SELECT relied on an
index. (Bug#27697)
* Searches for accented characters in a UTF8 table fail if an index
exists for the column. (Bug#26057)
* Searches using LIKE on a UTF8 table fail if the search relies an
indexed column. (Bug#24921)
* Searches for data on a partial index for a column using the UTF8
character set would fail. (Bug#24858)
* Searches for data using exotic collation/character sets fail if the
search relies on an indexed column. (Bug#23689)
* Inserting rows to a table with a unique index where the unique index
value is identical on two separate connections would block the second
transaction. (Bug#22847)
* Large inserts to a table within a single transaction trigger high
memory usage and may ultimately crash. (Bug#22169)