End of Product Lifecycle. Active development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
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
The default type of
depends on the second and third arguments and not only on the
Fixed case when myisamchk could go into a loop when trying to repair a crashed table.
Fixed problem with
Added possible character sets and time zone to
SHOW VARIABLES output.
Fixed bug in locking code that could result in locking problems with concurrent inserts under high load.
Fixed a problem with
many rows on a table with compressed keys where MySQL scanned
the index to find the rows.
Fixed problem with
on table with deleted keyblocks.
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 an
Fixed bug when using
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 if
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 the
WHERE clause. See
Section 7.4.4, “How MySQL Uses Indexes”.
RAID_CHUNKSIZE to be in 1024-byte
Fixed core dump in