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 a bug when using
Fixed a bug when using
HEAP tables with
--mysql-version option to safe_mysqld
InnoDB (because the
INNOBASE name was in use). All configure options and mysqld start options now use
innodb instead of
innobase. This means that before upgrading to this version, you have to change any configuration files where you have used
Fixed bug when using indexes on
CHAR(255) NULL columns.
Slave threads now start even if
master-host is not set, as long as
server-id is set and valid
master.info is present.
Partial updates (terminated with kill) are now logged with a special error code to the binary log. Slave refuses to execute them if the error code indicates the update was terminated abnormally, and has to be recovered with
SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START after a manual sanity check/correction of data integrity.
Fixed bug that erroneously logged a drop of internal temporary table on thread termination to the binary log --- this bug affected replication.
Fixed a bug in
REGEXP on 64-bit machines.
WHERE unique_key_part IS NULL didn't update/delete all rows.
INSERT DELAYED for tables that support transactions.
Fixed bug when using date functions on
BLOB column with wrong date format.
UDFs now also work on Windows. (Patch by Ralph Mason.)
Fixed bug in
ALTER TABLE and
LOAD DATA INFILE that disabled key-sorting. These commands should now be faster in most cases.
Fixed performance bug where reopened tables (tables that had been waiting for
REPAIR TABLE) would not use indexes for the next query.
Fixed problem with
ALTER TABLE to
InnoDB tables on FreeBSD.
Added mysqld variables
Initialize signals early to avoid problem with signals in
Applied patch for the
tis620 character set to make comparisons case-independent and to fix a bug in
LIKE for this character set.
All tables that use the
tis620 character set must be fixed with myisamchk -r or
--skip-safemalloc option to mysqld.