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.
MySQL client mysql now starts with option
-g) by default. This option can be disabled
-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
Optimizer didn't use keys properly when using
JOIN on an empty table.
Added shorter help text when invoking mysqld with incorrect options.
free() bug in
Updated mysqlhotcopy to use the new
FLUSH TABLES table_list syntax. Only tables
which are being backed up are flushed now.
Changed behavior of
so that both nonthreaded (
-lmysqlclient_r) libraries are
built. Users who linked against a threaded
-lmysqlclient need to link against
Do not count
NULL values in
INFILE on empty tables and
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
Fixed bug in range optimizer for
tables for searches on a part index.
SELECT on part keys to
INSERT INTO bdb_table ... SELECT to
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
TABLE to update the key distribution.
CHANGE MASTER TO
EXTENDED check types to
Fixed fatal bug in
LOAD TABLE FROM MASTER
that did not lock the table during index re-build.
INFILE broke replication if the database was
excluded from replication.
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.