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.
Fixed DNS lookups not to use the same mutex as the host name cache. This enables known hosts to be quickly resolved even if a DNS lookup takes a long time.
Removed warnings when running
REPAIR TABLE ...
Fixed a bug that caused a core dump when using
BY on an alias, where the alias was the same as an
existing column name.
SEQUENCE() as an example user-defined
to use the same
syntax as Oracle. Until 4.0 we also allow
to not crash old
Fixed “no found rows” bug in
MyISAM tables when a
BLOB was first part of a
Fixed bug where
CASE didn't work
Fixed bug when using
DISTINCT on results
from functions that referred to a group function, like:
SELECT a, DISTINCT SEC_TO_TIME(SUM(a)) FROM
tbl_nameGROUP BY a, b;
Fixed buffer overrun in
library. Fixed bug in handling
ROTATE event in replication.
Fixed another buffer overrun in
Fixed bug in replication that broke slave server start with
master.info. This fixes a bug
introduced in 3.23.32.
SET SQL_SLAVE_SKIP_COUNTER=n command
to recover from replication glitches without a full database
variable; the binary log is rotated automatically when the
size crosses the limit.
Slave_skip_counter variables to
SHOW SLAVE STATUS.
Fixed bug in
Execute core dump handler on
SIGBUS in addition to
On x86 Linux, print the current query and thread (connection) id, if available, in the core dump handler.
Fixed several timing bugs in the test suite.
Extended mysqltest to take care of the timing issues in the test suite.
ALTER TABLE can now be used to
change the definition for a
Fixed creation of
MERGE tables on Windows.
Portability fixes for OpenBSD and OS/2.
--temp-pool option to
mysqld. Using this option causes most
temporary files created to use a small set of names, rather
than a unique name for each new file. This is to work around a
problem in the Linux kernel dealing with creating a bunch of
new files with different names. With the old behavior, Linux
seems to "leak" memory, as it is being allocated to the
directory entry cache instead of the disk cache.