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.
Don't 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
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.5, « Comment MySQL utilise les index ».
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)
.
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.