MySQL Reference Manual :: C.3 Changements de la version 4.0.x (Production)

The InnoDB storage engine is now included in the standard binaries, adding transactions, row-level locking, and foreign keys. See Chapitre 16, Tables InnoDB.

A query cache, offering vastly increased performance for many applications. By caching complete result sets, later identical queries can return instantly. See Section 5.11, « Cache de requêtes MySQL ».

Improved full-text indexing with boolean mode, truncation, and phrase searching. See Section 13.6, « Recherche en texte intégral (Full-text) dans MySQL ».

Enhanced MERGE tables, now supporting INSERT statements and AUTO_INCREMENT. See Section 15.2, « Tables assemblées MERGE ».

UNION syntax in SELECT. See Section 14.1.7.2, « Syntaxe de UNION ».

Multiple-table DELETE statements. See Section 14.1.1, « Syntaxe de DELETE ».

libmysqld, the embedded server library. See Section 21.2.15, « libmysqld, la bibliothèque du serveur embarqué MySQL ».

Additional GRANT privilege options for even tighter control and security. See Section 14.5.1.2, « Syntaxe de GRANT et REVOKE ».

Management of user resources in the GRANT system, particularly useful for ISPs and other hosting providers. See Section 5.6.4, « Limiter les ressources utilisateurs ».

Dynamic server variables, allowing configuration changes to be made without having to stop and restart the server. See Section 14.5.3.1, « Syntaxe de SET ».

Improved replication code and features. See Chapitre 6, Réplication de MySQL.

Numerous new functions and options.

Changes to existing code for enhanced performance and reliability.