Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL 4.0.15 has been released

Newsletters older than 6 months may have links that are out of date. Please use the Search to check for updated links.

MySQL 4.0.15, a new version of the popular Open Source/Free Software Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ (http://www.mysql.com/downloads/) and mirror sites.

Note that not all mirror sites may be up to date at this point in time - if you can't find this version on some mirror, please try again later or choose another download site.

This is a bugfix release for the current production version.

Please refer to our bug database at http://bugs.mysql.com/ for more details about the individual bugs fixed in this version.

News from the ChangeLog:

Functionality added or changed:

* Produce an error message on Windows if a second `mysqld' server is started on the same TCP/IP port as an already running `mysqld' server.

* The `mysqld' server variables `wait_timeout', `net_read_timeout' and `net_write_timeout' now work on Windows.

* Added option `--sql-mode=NO_DIR_IN_CREATE' to make it possible for slaves to ignore `INDEX DIRECTORY' and `DATA DIRECTORY' options given to `CREATE TABLE'. When this is mode is on, `SHOW CREATE TABLE' will not show the given directories.

* `SHOW CREATE TABLE' now shows the `INDEX DIRECTORY' and `DATA DIRECTORY' options, if they were specified when the table was created.

* The `open_files_limit' server variable now shows the real open files limit.

* `MATCH ... AGAINST()' in natural language mode now treats words that are present in more than 2,000,000 rows as stopwords.

* The Mac OS X installation disk images now include an additional `MySQLStartupItem.pkg' package that enables the automatic startup of MySQL on system bootup.

* Most of the documentation included in the binary tarball distributions (`.tar.gz') has been moved into a subdirectory `docs'.

* The manual is now included as an additional `info' file in the binary distributions. (Bug #1019)

* Many binary distributions now include the embedded server library (`libmysqld') by default.

* MySQL can now use range optimisation for `BETWEEN' with non-constant limits. (Bug #991)

* Replication error messages now include the default database, so that users can check which database the failing query was run for.

* Now the slave does not replicate `SET PASSWORD' if it is configured to exclude the `mysql' database from replication (using for example `replicate-wild-ignore-table=mysql.%'). This was already the case for `GRANT' and `REVOKE' since version 4.0.13 (though there was Bug #980 in 4.0.13 & 4.0.14, which has been fixed in 4.0.15).

* Rewrote the information shown in the `State' column of `SHOW PROCESSLIST' for replication threads and for `MASTER_POS_WAIT()' and added the most common states for these threads to the documentation.

* Added a test in replication to detect the case where the master died in the middle of writing a transaction to the binlog; such unfinished transactions now trigger an error message on the slave.