This is the MySQL™ Reference Manual. It documents MySQL 3.23 through MySQL 4.1.25.
End of Product Lifecycle. Active development and support for MySQL Database Server versions 3.23, 4.0, and 4.1 has ended. For details, see http://www.mysql.com/about/legal/lifecycle/#calendar. Please consider upgrading to a recent version. Further updates to the content of this manual will be minimal. All formats of this manual will continue to be available until 31 Dec 2010.
MySQL 3.23, 4.0, and 4.1 features. This manual describes features that are not included in every edition of MySQL 3.23, MySQL 4.0, and MySQL 4.1; such features may not be included in the edition of MySQL 3.23, MySQL 4.0, or MySQL 4.1; licensed to you. If you have any questions about the features included in your edition of MySQL 3.23, MySQL 4.0, or MySQL 4.1, refer to your MySQL 3.23, MySQL 4.0, or MySQL 4.1 agreement or contact your Oracle sales representative.
For release notes detailing the changes in each release of MySQL 3.23, 4.0, and 4.1, see Appendix C, MySQL Release Notes.
For legal information, see the Legal Notice.
Document generated on: 2014-02-18 (revision: 37764)
Table of Contents [+/-]
MyISAMTable Maintenance and Crash Recovery [+/-]
GROUP BYClauses [+/-]
MyISAMStorage Engine [+/-]
InnoDBStorage Engine [+/-]
InnoDBin MySQL 3.23
InnoDBStartup Options and System Variables
InnoDBData and Log Files
InnoDBDatabase to Another Machine
InnoDBTransaction Model and Locking
InnoDBTable and Index Structures
InnoDBDisk I/O and File Space Management
InnoDBPerformance Tuning and Troubleshooting
MERGEStorage Engine [+/-]
HEAP) Storage Engine
BerkeleyDB) Storage Engine [+/-]