[+/-]
Version 4.0 of the MySQL server includes many enhancements and new features:
          The InnoDB storage engine is now included
          in the standard binaries, adding transactions, row-level
          locking, and foreign keys. See Chapitre 15, Le moteur de 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 12.6, « Recherche en texte intégral (Full-text) dans MySQL ».
        
          Enhanced MERGE tables, now supporting
          INSERT statements and
          AUTO_INCREMENT. See
          Section 14.2, « Tables assemblées MERGE ».
        
          UNION syntax in SELECT.
          See Section 13.1.7.2, « Syntaxe de UNION ».
        
          Multiple-table DELETE statements. See
          Section 13.1.1, « Syntaxe de DELETE ».
        
          libmysqld, the embedded server library. See
          Section 24.2.16, « libmysqld, la bibliothèque du serveur embarqué
        MySQL ».
        
          Additional GRANT privilege options for even
          tighter control and security. See Section 13.5.1.3, « 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 13.5.2.8, « 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.
For a full list of changes, please refer to the changelog sections for each individual 4.0.x release.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.
