root, you must now use the
Added interface to Berkeley DB. (This is not yet functional; play with it at your own risk!)
Replication between master and slaves.
Fixed bug that other threads could steal a lock when a
thread had a lock on a table and did a
slow_launch_time variable and
Slow_launch_threads status variable
mysqld. These can be examined with
mysqladmin variables and
The default type of
IF() now depends on
the second and third arguments and not only on the second
Fixed case when
myisamchk could go into a
loop when trying to repair a crashed table.
INSERT DELAYED to update log
Fixed problem with
Added possible character sets and time zone to
Fixed bug in locking code that could result in locking problems with concurrent inserts under high load.
Fixed a problem with
DELETE of many rows
on a table with compressed keys where MySQL scanned the
index to find the rows.
Fixed problem with
CHECK on table with
Fixed a bug in reconnect (at the client side) where it didn't free memory properly in some contexts.
Fixed problems in update log when using
LAST_INSERT_ID() to update a table with
Fixed bug when using
LOAD DATA INFILE on
a table with
MyISAM to be faster when
inserting keys in sorted order.
EXPLAIN SELECT ... now also prints out
whether MySQL needs to create a temporary table or use file
sorting when resolving the
Added optimization to skip
ORDER BY parts
where the part is a constant expression in the
WHERE part. Indexes can now be used even
ORDER BY doesn't match the index
exactly, as long as all the unused index parts and all the
ORDER BY columns are constants in
WHERE clause. See
項5.4.3. 「MySQL でのインデックスの使用」.
DELETE on a
whole unique key in the
WHERE part are
now faster than before.
RAID_CHUNKSIZE to be in 1024-byte
Fixed core dump in
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.