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.
Added documentation for
embedded MySQL server library. Also added example programs (a
mysql client and
mysqltest test program) which use
Removed all Gemini hooks from MySQL server.
Support for communication packets > 16MB. In 4.0.1 we
MyISAM to be able to handle these.
Secure connections (with SSL).
New character set
latin1_de which provides
correct German sorting.
STRCMP() now uses the current
character set when doing comparisons, which means that the
default comparison behavior now is case insensitive.
TRUNCATE TABLE and
are now separate
functions. One bonus is that
now returns the
number of deleted rows, rather than zero.
Added support for
Added support for multiple-table
HANDLER interface to
Added support for
MERGE tables. Patch from Benjamin
WEEK(date,0) to match
the calendar in the USA.
COUNT(DISTINCT) is about 30%
Speed up all internal list handling.
Full-text index creation now is much faster.
Tree-like cache to speed up bulk inserts and
Optimized queries of type:
SELECT DISTINCT * FROM
tbl_name ORDER by
SHOW CREATE TABLE now shows all
ORDER BY ... DESC can now use keys.
LOAD DATA FROM MASTER
“automatically” sets up a slave.
Renamed safe_mysqld to mysqld_safe to make this name more in line with other MySQL scripts/commands.
Added support for symbolic links to
tables. Symlink handling is now enabled by default for
FOUND_ROWS(). This makes it
possible to know how many rows a query would have returned
Changed output format of
SELECT expression LIMIT ....
SHOW INDEXES is now a synonym for
ALTER TABLE and
tbl_name ENABLE KEYS
Permit use of
IN as a synonym for
Permit standard SQL syntax
Cleaned up global lock handling for
FLUSH TABLES WITH READ
Fixed problem with
DATETIME = constant in
Added script mysql_explain_log.sh to distribution. (Thanks to mobile.de).