[+/-]
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.