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.
The following list summarizes the features in MySQL Server 4.0 that are not present in previous versions. For a full list of changes, please refer to the changelog sections for individual 4.0 releases.
InnoDB storage engine is now included in
the standard binaries, adding transactions, row-level locking,
and foreign keys. See Section 13.2, “The InnoDB Storage Engine”.
A query cache, offering vastly increased performance for many applications. By caching complete result sets, later identical queries can return instantly. See Section 7.5.3, “The MySQL Query Cache”.
Improved full-text indexing with boolean mode, truncation, and phrase searching. See Section 11.9, “Full-Text Search Functions”.
libmysqld, the embedded server library. See
Section 17.5, “libmysqld, the Embedded MySQL Server Library”.
Dynamic server variables, allowing configuration changes to be made without having to stop and restart the server. See Section 12.4.4, “SET Syntax”.
Improved replication code and features. See Chapter 14, Replication.
Numerous new functions and options.
Changes to existing code for enhanced performance and reliability.
For a full list of changes, please refer to the changelog sections for each individual 4.0.x release.