Abstract
This is the MySQL™ Reference Manual. It documents MySQL 3.23 through MySQL 4.1.25.
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.
Document generated on: 2013-05-17 (revision: 35197)
For legal information, see the Legal Notice.
End of Product LifecycleActive 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.
Table of Contents [+/-]
mysqld ServerAUTO_INCREMENTGROUP BY Clauses [+/-]MyISAM Storage Engine [+/-]InnoDB Storage Engine [+/-]InnoDB Contact InformationInnoDB in MySQL 3.23InnoDB ConfigurationInnoDB Startup Options and System VariablesInnoDB TablesInnoDB Data and Log
FilesInnoDB
DatabaseInnoDB Database to Another MachineInnoDB Transaction Model and LockingInnoDB Multi-VersioningInnoDB Table and Index StructuresInnoDB Disk I/O and File Space ManagementInnoDB Error HandlingInnoDB Performance Tuning and TroubleshootingInnoDB TablesMERGE Storage Engine [+/-]MEMORY (HEAP) Storage EngineBDB (BerkeleyDB) Storage
Engine [+/-]EXAMPLE Storage EngineARCHIVE Storage EngineCSV Storage EngineBLACKHOLE Storage EngineISAM Storage EngineAUTO_INCREMENTDIRECTORY Table OptionsFLUSHLIMITLOAD OperationsMEMORY TablesGeometryPointCurveLineStringSurfacePolygonGeometryCollectionMultiPointMultiCurveMultiLineStringMultiSurfaceMultiPolygonGeometry FunctionsMysql)Mysqli)MySQL (PDO))Mysqlnd)mysqlnd_ms)mysqlnd_qc)mysqlnd_uh)mysqlnd_mux)mysqlnd_memcache)mysql and mysqli in
PHPInnoDB [+/-]