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.
To start mysqld as root
,
you must now use the
--user=root
option.
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
FLUSH TABLES
command.
Added the slow_launch_time
variable and the
Slow_launch_threads
status
variable to mysqld. These can be examined
with mysqladmin variables and
mysqladmin extended-status.
Added functions INET_NTOA()
and
INET_ATON()
.
The default type of IF()
now
depends on the second and third arguments and not only on the
second argument.
Fixed case when myisamchk could go into a loop when trying to repair a crashed table.
Do not write INSERT DELAYED
to
update log if sql_log_update =
0
.
Fixed problem with REPLACE
on
HEAP
tables.
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 DELETE
of
many rows on a table with compressed keys where MySQL scanned
the index to find the rows.
Fixed problem with CHECK TABLE
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 AUTO_INCREMENT
key.
Added NULLIF()
function.
Fixed bug when using
LOAD DATA
INFILE
on a table with BLOB/TEXT
columns.
Optimized 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
SELECT
.
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
the ORDER BY
doesn't match the index
exactly, as long as all the unused index parts and all the
extra ORDER BY
columns are constants in the
WHERE
clause. See
Section 7.4.4, “How MySQL Uses Indexes”.
UPDATE
and
DELETE
on a whole unique key in
the WHERE
part are now faster than before.
Changed RAID_CHUNKSIZE
to be in 1024-byte
increments.
Fixed core dump in
LOAD_FILE(NULL)
.
User Comments
Add your own comment.