Changed sort order for 'German'; all tables created with
'German' sortorder must be repaired with
myisamchk before use!
--core-file option to
mysqld to get a core file on Linux if
mysqld dies on the
mysql now starts with option
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, etc.! Long format
commands still work from the first line.
Fixed a problem when using many pending
TABLE statements at the same time.
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
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.
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
-lmysqlclient) and threaded
-lmysqlclient_r) libraries are built.
Users who linked against a threaded
-lmysqlclient will need to link against
RENAME TABLE command.
NULL values in
INFILE on empty tables and
SELECT ... on empty tables to create non-unique
indexes in a separate batch with sorting. This will make the
above calls much faster when you have many indexes.
ALTER TABLE now logs the first used
Fixed crash when adding a default value to a
Fixed a bug with
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 only affects systems that don't have the
When deleting rows with a non-unique 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 work with
INSERT INTO bdb_table ... SELECT to
CHECK TABLE now updates key statistics
for the table.
ANALYZE TABLE will now only update tables
that have been changed since the last
ANALYZE. Note that this is a new feature
and tables will not be marked to be analysed 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
Fixed some minor privilege problems with
CHANGE MASTER TO statement.
EXTENDED check types to
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 will not return until the
slave thread actually exits.
Full-text search via the
FULLTEXT index type (for
MyISAM files). This makes
FULLTEXT a reserved word.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.