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.
Functionality added or changed:
--log-error[= to mysqld_safe and mysqld. This option forces all error messages to be put in a log file if the option
--console is not given. On Windows
--log-error is enabled as default, with a default name of
if the name is not specified.
Changed some messages from
Note: in the log files.
The mysqld server should now compile on NetWare.
Added optimization that if one does
GROUP BY ... ORDER BY NULL then result is not sorted.
ft_stopword_file system variable for mysqld to replace/disable the built-in stopword list that is used in full-text searches. See Section 5.1.3, “Server System Variables”.
Changed default stack size from 64KB to 192KB; This fixes a core dump problem on Red Hat 8.0 and other systems with a
glibc that requires a stack size larger than 128K for
gethostbyaddr() to resolve a host name. You can fix this for earlier MySQL versions by starting mysqld with
Added mysql_waitpid to the binary distribution and the
MySQL-client RPM subpackage (required for mysql-test-run).
Renamed the main
MySQL RPM package to
MySQL-server. When updating from an older version,
MySQL-server.rpm simply replaces
If a slave is configured with
replicate_wild_ignore_table=db.%, these rules are applied to
CREATE/DROP DATABASE, too.
Added timeout value for
Fixed initialization of the random seed for newly created threads to give a better
rand() distribution from the first call.
Fixed a bug that caused mysqld to hang when a table was opened with the
HANDLER statement and then dropped without being closed.
Fixed bug in logging to binary log (which affects replication) a query that inserts a
NULL in an
AUTO_INCREMENT column and also uses
Fixed an unlikely bug that could cause a memory overrun when using
ORDER BY constant_expression.
Fixed a table corruption in myisamchk parallel repair mode.
Fixed bug in query cache invalidation on simple table renaming.
Fixed bug in mysqladmin --relative.
On some 64-bit systems,
show status reported a strange number for
Fixed incorrect number of columns in
EXPLAIN on empty table.
Fixed bug in
LEFT JOIN that caused zero rows to be returned in the case the
WHERE condition was evaluated as
FALSE after reading
const tables. (Unlikely condition).
FLUSH PRIVILEGES didn't correctly flush table/column privileges when
mysql.tables_priv is empty.
Fixed bug in replication when using
LOAD DATA INFILE one a file that updated an
AUTO_INCREMENT column with
0. This bug only affected MySQL 4.0 masters (not slaves or MySQL 3.23 masters).
If you have a slave that has replicated a file with generated
AUTO_INCREMENT columns, the slave data is corrupted and you should reinitialize the affected tables from the master.
Fixed possible memory overrun when sending a
BLOB value larger than 16M to the client.
Fixed incorrect error message when setting a
NOT NULL column to an expression that returned
Fixed core dump bug in
str LIKE "%
other_str contained characters >= 128.
Fixed bug: When executing on master
LOAD DATA and
InnoDB failed with
table full error the binary log was corrupted.