- Documentation Library
- Table of Contents
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- D MySQL Change History
- D.1 Changes in release 5.0.0 (Development)
- D.2 Changes in release 4.1.x (Alpha)
- D.3 Changes in release 4.0.x (Production)
- D.3.1 Changes in release 4.0.17 (not released yet)
- D.3.2 Changes in release 4.0.16 (17 Oct 2003)
- D.3.3 Changes in release 4.0.15 (03 Sep 2003)
- D.3.4 Changes in release 4.0.14 (18 Jul 2003)
- D.3.5 Changes in release 4.0.13 (16 May 2003)
- D.3.6 Changes in release 4.0.12 (15 Mar 2003: Production)
- D.3.7 Changes in release 4.0.11 (20 Feb 2003)
- D.3.8 Changes in release 4.0.10 (29 Jan 2003)
- D.3.9 Changes in release 4.0.9 (09 Jan 2003)
- D.3.10 Changes in release 4.0.8 (07 Jan 2003)
- D.3.11 Changes in release 4.0.7 (20 Dec 2002)
- D.3.12 Changes in release 4.0.6 (14 Dec 2002: Gamma)
- D.3.13 Changes in release 4.0.5 (13 Nov 2002)
- D.3.14 Changes in release 4.0.4 (29 Sep 2002)
- D.3.15 Changes in release 4.0.3 (26 Aug 2002: Beta)
- D.3.16 Changes in release 4.0.2 (01 Jul 2002)
- D.3.17 Changes in release 4.0.1 (23 Dec 2001)
- D.3.18 Changes in release 4.0.0 (Oct 2001: Alpha)
- D.4 Changes in release 3.23.x (Recent; still supported)
- D.5 Changes in release 3.22.x (Old; discontinued)
- D.6 Changes in release 3.21.x
- D.7 Changes in release 3.20.x
- D.8 Changes in release 3.19.x
[+/-]
- D.3.1. Changes in release 4.0.17 (not released yet)
- D.3.2. Changes in release 4.0.16 (17 Oct 2003)
- D.3.3. Changes in release 4.0.15 (03 Sep 2003)
- D.3.4. Changes in release 4.0.14 (18 Jul 2003)
- D.3.5. Changes in release 4.0.13 (16 May 2003)
- D.3.6. Changes in release 4.0.12 (15 Mar 2003: Production)
- D.3.7. Changes in release 4.0.11 (20 Feb 2003)
- D.3.8. Changes in release 4.0.10 (29 Jan 2003)
- D.3.9. Changes in release 4.0.9 (09 Jan 2003)
- D.3.10. Changes in release 4.0.8 (07 Jan 2003)
- D.3.11. Changes in release 4.0.7 (20 Dec 2002)
- D.3.12. Changes in release 4.0.6 (14 Dec 2002: Gamma)
- D.3.13. Changes in release 4.0.5 (13 Nov 2002)
- D.3.14. Changes in release 4.0.4 (29 Sep 2002)
- D.3.15. Changes in release 4.0.3 (26 Aug 2002: Beta)
- D.3.16. Changes in release 4.0.2 (01 Jul 2002)
- D.3.17. Changes in release 4.0.1 (23 Dec 2001)
- D.3.18. Changes in release 4.0.0 (Oct 2001: Alpha)
Version 4.0 of the MySQL server includes many enhancements and new features:
The
InnoDBstorage engine is now included in the standard binaries, adding transactions, row-level locking, and foreign keys. See 項7.5. 「InnoDBテーブル」.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 全文検索」.
Enhanced
MERGEtables, now supportingINSERTstatements andAUTO_INCREMENT. See 項7.2. 「MERGEテーブル」.UNIONsyntax inSELECT. See 項6.4.1.2. 「UNION構文」.Multiple-table
DELETEstatements. See 項6.4.5. 「DELETE構文」.libmysqld, the embedded server library. See 項11.1.15. 「組み込み MySQL サーバライブラリ libmysqld」.Additional
GRANTprivilege options for even tighter control and security. See 項4.4.1. 「GRANTおよびREVOKEの構文」.Management of user resources in the
GRANTsystem, 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 項5.5.6. 「
SET構文」.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.
