Version 4.0 of the MySQL server includes many enhancements and new features:
InnoDB storage engine is now included
in the standard binaries, adding transactions, row-level
locking, and foreign keys. See 項7.5. 「
A query cache, offering vastly increased performance for many applications. By caching complete result sets, later identical queries can return instantly. See 項6.9. 「MySQL クエリキャッシュ」.
Improved full-text indexing with boolean mode, truncation, and phrase searching. See 項6.8. 「MySQL 全文検索」.
MERGE tables, now supporting
INSERT statements and
UNION syntax in
See 項188.8.131.52. 「
DELETE statements. See
libmysqld, the embedded server library. See
項11.1.15. 「組み込み MySQL サーバライブラリ libmysqld」.
GRANT privilege options for even
tighter control and security. See 項4.4.1. 「
Management of user resources in the
system, particularly useful for ISPs and other hosting
providers. See 項4.4.7. 「ユーザリソースの制限」.
Dynamic server variables, allowing configuration changes to be
made without having to stop and restart the server. See
Improved replication code and features. See 項4.11. 「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.