FLUSH MASTER and
RESET MASTER and
<> to work properly with
Fixed a problem with
REPLACE(). (Patch by Alexander
CREATE TEMPORARY TABLE IF NOT EXISTS
not to produce an error if the table exists.
If you don't create a
PRIMARY KEY in a
BDB table, a hidden
KEY will be created.
Added read-only-key optimization to
LEFT JOIN in some cases preferred a full
table scan when there was no
--log-slow-queries, don't count
the time waiting for a lock.
Fixed bug in lock code on Windows which could cause the key cache to report that the key file was crashed even if it was okay.
Automatic repair of
MyISAM tables if you
TYPE= keyword from
CHECK options to be combined. (You
can still use
TYPE=, but this usage is
Fixed mutex bug in the binary replication log --- long update queries could be read only in part by the slave if it did it at the wrong time, which was not fatal, but resulted in a performance-degrading reconnect and a scary message in the error log.
Changed the format of the binary log --- added magic number, server version, binlog version. Added the server ID and query error code for each query event.
Replication thread from the slave now will kill all the stale threads from the same server.
Long replication user names were not being handled properly.
--replicate-rewrite-db option to
--skip-slave-start option to
Updates that generated an error code (such as
INSERT INTO foo(some_key) values (1),(1))
erroneously terminated the slave thread.
Added optimization of queries where
DISTINCT is only used on columns from
some of the tables.
Allow floating-point numbers where there is no sign after
the exponent (like
SHOW GRANTS didn't always show all column
--default-extra-file=# option to all
Columns referenced in
now are initialized properly.
UPDATE didn't always work when used with
a range on a timestamp that was part of the key that was
used to find rows.
Fixed a bug in
FULLTEXT index when
Changed to use
mkstemp() instead of
tempnam(). Based on a patch from John
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.