Functionality added or changed:
Added option --log-error[=file_name]
to
mysqld_safe
and
mysqld
. This option will force all error
messages to be put in a log file if the option
--console
is not given. On Windows
--log-error
is enabled as default, with a
default name of host_name.err
if the name
is not specified.
Changed some things from Warning:
to
Note:
in the log files.
The mysqld server should now compile on NetWare.
Added optimization that if one does GROUP BY ...
ORDER BY NULL
then result is not sorted.
New --ft-stopword-file
command-line option
for mysqld
to replace/disable the
built-in stopword list that is used in full-text searches.
See 項4.6.8.4. 「SHOW VARIABLES
」.
Changed default stack size from 64K to 192K; This fixes a
core dump problem on Red Hat 8.0 and other systems with a
glibc
that requires a stack size larger
than 128K for gethostbyaddr()
to resolve
a hostname. You can fix this for earlier MySQL versions by
starting mysqld
with
--thread-stack=192K
.
Added mysql_waitpid
to the binary
distribution and the MySQL-client
RPM
subpackage (required for mysql-test-run
).
Renamed the main MySQL
RPM package to
MySQL-server
. When updating from an older
version, MySQL-server.rpm
will simply
replace MySQL.rpm
.
If a slave is configured with
replicate_wild_do_table=db.%
or
replicate_wild_ignore_table=db.%
, these
rules will be applied to CREATE/DROP
DATABASE
, too.
Added timeout value for
MASTER_POS_WAIT()
.
Bugs fixed:
Fixed initialization of the random seed for newly created
threads to give a better rand()
distribution from the first call.
Fixed a bug that caused mysqld
to hang
when a table was opened with the HANDLER
command and then dropped without being closed.
Fixed bug in logging to binary log (which affects
replication) a query that inserts a NULL
in an AUTO_INCREMENT
column and also uses
LAST_INSERT_ID()
.
Fixed an unlikely bug that could cause a memory overrun when
using ORDER BY constant_expression
.
Fixed a table corruption in myisamchk
's
parallel repair mode.
Fixed bug in query cache invalidation on simple table renaming.
Fixed bug in mysqladmin --relative
.
On some 64-bit systems, show status
reported a strange number for Open_files
and Open_streams
.
Fixed incorrect number of columns in
EXPLAIN
on empty table.
Fixed bug in LEFT JOIN
that caused zero
rows to be returned in the case the WHERE
condition was evaluated as FALSE
after
reading const
tables. (Unlikely
condition).
FLUSH PRIVILEGES
didn't correctly flush
table/column privileges when
mysql.tables_priv
is empty.
Fixed bug in replication when using LOAD DATA
INFILE
one a file that updated an
AUTO_INCREMENT
column with
NULL
or 0
. This bug
only affected MySQL 4.0 masters (not slaves or MySQL 3.23
masters). Note: If you have
a slave that has replicated a file with generated
AUTO_INCREMENT
columns then the slave
data is corrupted and you should reinitialize the affected
tables from the master.
Fixed possible memory overrun when sending a
BLOB
value larger than 16M to the client.
Fixed incorrect error message when setting a NOT
NULL
column to an expression that returned
NULL
.
Fixed core dump bug in str LIKE
"%other_str%"
where str
or
other_str
contained characters >= 128.
Fixed bug: When executing on master LOAD
DATA
and InnoDB
failed with
table full
error the binary log was
corrupted.
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.