Updates 1499 Published by

MySQL 4.0.16 has been released



ChangeLog:

* Write memory allocation information to error log when doing
`mysqladmin debug'. This only works on system that support the
`mallinfo()' call (like newer Linux systems).

* Added the following new server variables to allow more precise
memory allocation: `range_alloc_block_size',
`query_alloc_block_size', `query_prealloc_size',
`transaction_alloc_block_size', and `transaction_prealloc_size'.

* `mysqlbinlog' now reads options files. To make this work one must
now specify `--read-from-remote-server' when reading binary logs
from a MySQL server. (Note that using a remote server is
deprecated and may disappear in future `mysqlbinlog' versions).

* Block `SIGPIPE' also for non-threaded programs. The blocking is
moved from `mysql_init()' to `mysql_server_init()', which is
automatically called on the first call to `mysql_init()'.

* Added `--libs_r' and `--include' options to `mysql_config'.

* New ``>' prompt for `mysql'. This prompt is similar to the `'>'
and `">' prompts, but indicates that an identifier quoted with
backticks was begun on an earlier line and the closing backtick
has not yet been seen.

* Updated `mysql_install_db' to be able to use the local machine's IP
address instead of the host name when building the initial grant
tables if `skip-name-resolve' has been specified in `my.cnf'.
Using this option can be helpful on FreeBSD to avoid thread-safety
problems with the FreeBSD resolver libraries. (Thanks to Jeremy
Zawodny for the patch)

* A documentation change: added a note that when backing up a slave,
one needs to backup the `master.info' and `relay-log.info' files,
and the `SQL-LOAD*' files (which are in the `slave-load-tmpdir'
directory, which defaults to `tmpdir' if unset). All these files
will be needed when the slave resumes replication after you
restore the slave's data.
Download