Added new options
--no-tee to the
client. The new corresponding interactive commands are
mysql --help and
the interactive help for more information.
Fixed crash when automatic repair of
MyISAM table failed.
Fixed a major performance bug in the table locking code when
one constantly had a lot of
statements running. The symptom was that the
queries were locked for a long time while new
SELECT statements were executed before
return-found-rows option was ignored.
One can now specify
in the option file that is read by
mysql_options(). This makes it possible
to force programs that run for a long time (like
mysqlhotcopy) to use the
interactive_timeout time instead of the
Added to the slow query log the time and the user name for
each logged query. If you are using
--log-long-format then also queries that do
not use an index are logged, even if the query takes less
Fixed a problem in
LEFT JOIN which caused
all columns in a reference table to be
Fixed a problem when using
Fixed a bug when using a multi-part keys where the first
part was of type
DROP of temporary tables wasn't stored in
the update/binary log.
Fixed a bug where
SELECT DISTINCT * ... LIMIT
row_count only returned one row.
Fixed a bug in the assembler code in
strstr() for SPARC and cleaned up the
global.h header file to avoid a problem
with bad aliasing with the compiler submitted with Red Hat
7.0. (Reported by Trond Eivind Glomsrød)
--skip-networking option now works
properly on NT.
Fixed a long outstanding bug in the
tables when a row with a length of more than 65K was
shortened by a single byte.
Fixed a bug in
MyISAM when running
multiple updating processes on the same table.
Allow one to use
FLUSH TABLE tbl_name.
--replicate-wild-do-table options to
Changed all log files to use our own
IO_CACHE mechanism instead of
FILE to avoid OS problems when there are
many files open.
--timezone options to
Fixed a fatal bug in
CREATE TEMPORARY TABLE ...
Fixed a problem with
CREATE TABLE ... SELECT
Added status variables
Fixed a bug where we didn't allow an index name after the
FOREIGN KEY definition.
TRUNCATE table_name as a synonym
DELETE FROM table_name.
Fixed a bug in a
BDB key compare function
when comparing part keys.
bdb_lock_max variable to
Added more tests to the benchmark suite.
Fixed an overflow bug in the client code when using overly long database names.
mysql_connect() now aborts on Linux if
the server doesn't answer in
SLAVE START did not work if you started
--skip-slave-start and had not
CHANGE MASTER TO.
Fixed the output of
SHOW MASTER STATUS to
be consistent with
SHOW SLAVE STATUS. (It
now has no directory in the log name.)
PURGE MASTER LOGS TO.
SHOW MASTER LOGS.
--safemalloc-mem-limit option to
mysqld to simulate memory shortage when
compiled with the
Fixed several core dumps in out-of-memory conditions.
SHOW SLAVE STATUS was using an
uninitialized mutex if the slave had not been started yet.
Fixed bug in
MAKE_SET() when the query used a
CHANGE MASTER TO without specifying
MASTER_LOG_POS would set it to 0 instead
of 4 and hit the magic number in the master binlog.
ALTER TABLE ... ORDER BY ... syntax
added. This will create the new table with the rows in a
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.