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.
Configure updates for Tru64, large file support, and better TCP wrapper support. By Albert Chin-A-Young.
Fixed bug in
Fixed bug in
SHOW LOGS statement.
BDB logs on shutdown.
When creating a table, put
first, followed by
Fixed a bug in
multiple-part keys where you specified all key parts both in
the update and the
WHERE part. In this case
MySQL could try to update a record that didn't match the whole
Changed drop table to first drop the tables and then the
Fixed a bug in the host name cache which caused
mysqld to report the host name as
'' in some error messages.
Changed the default
server-id value to 1
for masters and 2 for slaves to make it easier to use the
Added support for
ANALYZE TABLE of
BDB tables, we now store the number of
rows; this helps to optimize queries when we need an
approximation of the number of rows.
If we get an error in a multiple-row statement, we now only roll back the last statement, not the entire transaction.
If you do a
when you have updated a nontransactional table you get an
error as a warning.
If you do a
DROP DATABASE on a
symbolically linked database, both the link and the original
database are deleted.
DROP DATABASE to work on
Fixed bug when doing a
SELECT DISTINCT ... table1
LEFT JOIN table2 ... when
Fixed replication of temporary tables. Handles everything except slave server restart.
KEYS now shows whether key is
mysql_install_db have been modified to use
my_print_defaults instead of various hacks
to read the
my.cnf files. In addition,
the handling of various paths has been made more consistent
with how mysqld handles them by default.
Automatically remove Berkeley DB transaction logs that no longer are in use.
Fixed bug with several
FULLTEXT indexes in
Applied patches for OS/2 by
flush the index tree to disk properly.
mi_create() to use less stack
Fixed bug with optimizer trying to over-optimize
MATCH() when used with
crash-me and the MySQL benchmarks
to also work with FrontBase.
TABLE to make porting easier.
Reset status variable which could cause problem if one used
connect-timeout as an alias for
timeout for option files read by