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.
Changed sort order for 'German'; all tables created with 'German' sortorder must be repaired with
REPAIR TABLE or myisamchk before use!
--core-file option to mysqld to get a core file on Linux if mysqld dies on the
MySQL client mysql now starts with option
-g) by default. This option can be disabled with
-G). This may cause incompatibility problems in some cases, for example, in SQL scripts that use named commands without a semicolon! Long format commands still work from the first line.
Fixed a problem when using many pending
DROP TABLE statements at the same time.
Optimizer didn't use keys properly when using
LEFT JOIN on an empty table.
Added shorter help text when invoking mysqld with incorrect options.
free() bug in mysqlimport.
Fixed bug in
MyISAM index handling of
Fixed a bug in concurrent insert in
MyISAM tables. In some contexts, usage of
MAX(key_part) returned an empty set.
Updated mysqlhotcopy to use the new
FLUSH TABLES table_list syntax. Only tables which are being backed up are flushed now.
Changed behavior of
--enable-thread-safe-client so that both nonthreaded (
-lmysqlclient) and threaded (
-lmysqlclient_r) libraries are built. Users who linked against a threaded
-lmysqlclient need to link against
RENAME TABLE command.
Do not count
NULL values in
LOAD DATA INFILE on empty tables and
INSERT ... SELECT ... on empty tables to create nonunique indexes in a separate batch with sorting. This makes these statements much faster when you have many indexes.
ALTER TABLE now logs the first used insert_id correctly.
Fixed crash when adding a default value to a
Fixed a bug with
DATE_ADD/DATE_SUB where it returned a datetime instead of a date.
Fixed a problem with the thread cache which made some threads show up as
Fixed a lock in our thr_rwlock code, which could make selects that run at the same time as concurrent inserts crash. This affects only systems that don't have the
When deleting rows with a nonunique key in a
HEAP table, all rows weren't always deleted.
Fixed bug in range optimizer for
HEAP tables for searches on a part index.
SELECT on part keys to work with
INSERT INTO bdb_table ... SELECT to work with
CHECK TABLE now updates key statistics for the table.
ANALYZE TABLE now only updates tables that have been changed since the last
ANALYZE TABLE. Note that this is a new feature and tables are not marked to be analyzed until they are updated in any way with 3.23.23 or newer. For older tables, you have to do
CHECK TABLE to update the key distribution.
Fixed some minor privilege problems with
REPAIR TABLE and
SHOW CREATE statements.
CHANGE MASTER TO statement.
EXTENDED check types to
Changed myisamchk so that
--check-only-changed are also honored with
Fixed fatal bug in
LOAD TABLE FROM MASTER that did not lock the table during index re-build.
LOAD DATA INFILE broke replication if the database was excluded from replication.
More variables in
SHOW SLAVE STATUS and
SHOW MASTER STATUS.
SLAVE STOP now does not return until the slave thread actually exits.
Full-text search using the
MATCH() function and
FULLTEXT index type (for
MyISAM files). This makes
FULLTEXT a reserved word.