Functionality added or changed:
mysqld no longer reads options from
world-writeable config files.
Integer values between 9223372036854775807 and 9999999999999999999 are now regarded as unsigned longlongs, not as floats. This makes these values work similar to values between 10000000000000000000 and 18446744073709551615.
SHOW PROCESSLIST will now include the
client TCP port after the hostname to make it easier to know
from which client the request originated.
mysqld crash on extremely small
INSERT INTO u SELECT ... FROM t was
written too late to the binary log if t was very frequently
updated during the execution of this query. This could cause
a problem with
replication. The master must be upgraded, not the slave.
Fixed checking of random part of
Fixed a bug with multiple-table updates with
InnoDB tables. This bug occurred as, in
InnoDB tables cannot be
updated ``on the fly,'' but offsets to the records have to
be stored in a temporary table.
Added missing file
mysql_secure_installation to the
server RPM subpackage. (Bug#141)
Fixed MySQL (and
myisamchk) crash on
BACKUP TABLE to overwrite
Fixed a bug with multiple-table
statements when user had all privileges on the database
where tables are located and there were any entries in
tables_priv table, that is,
grant_option was true.
Fixed a bug that allowed a user with table or column grants
on some table,
TRUNCATE any table in the
Fixed deadlock when doing
DROP TABLE in the same
thread. In this case one could still kill the thread with
LOAD DATA LOCAL INFILE was not properly
written to the binary log (hence not properly replicated).
RAND() entries were not read correctly by
mysqlbinlog from the binary log which
caused problems when restoring a table that was inserted
INSERT INTO t1
VALUES(RAND()). In replication this worked ok.
SET SQL_LOG_BIN=0 was ignored for
INSERT DELAYED queries. (Bug#104)
SHOW SLAVE STATUS reported too old
Exec_Master_Log_Pos) for the last
executed statement from the master, if this statement was
COMMIT of a transaction. The master
must be upgraded for that, not the slave. (Bug#52)
LOAD DATA INFILE was not replicated by
the slave if
replicate_*_table was set on
the slave. (Bug#86)
RESET SLAVE, the coordinates
SHOW SLAVE STATUS looked
un-reset (though they were, but only internally). (Bug#70)
Fixed query cache invalidation on
Fixed memory leak on
Fixed a bug in handling
that could cause incorrect results from the query.
Fixed rare bug with incorrect initialization of
AUTO_INCREMENT column, as a secondary
column in a multi-column key (see
AUTO_INCREMENT の使用」), when data was
INSERT ... SELECT or
LOAD DATA into an empty table.
STOP SLAVE didn't stop the
slave until the slave got one new command from the master
(this bug has been fixed for MySQL 4.0.11 by releasing
updated 4.0.11a Windows packages, which include this
individual fix on top of the 4.0.11 sources). (Bug#69)
Fixed a crash when no database was selected and
LOAD DATA command was issued with full
table name specified, including database prefix.
Fixed a crash when shutting down replication on some platforms (for example, Mac OS X).
Fixed a portability bug with
pthread_attr_getstacksize on HP-UX 10.20
(Patch was also included in 4.0.11a sources).
bigint test to not fail on some
platforms (for example, HP-UX and Tru64) due to different
return values of the
rpl_rotate_logs test to not
fail on certain platforms (e.g. Mac OS X) due to a too long
file name (changed
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.