:: DEVELOPER ZONE
MySQL Reference Manual :: 15 The InnoDB Storage Engine
Search the MySQL manual:
- Preface
- 1 General Information
- 2 Installing MySQL
- 3 MySQL Tutorial
- 4 Using MySQL Programs
- 5 Database Administration
- 6 Replication in MySQL
- 7 MySQL Optimization
- 8 MySQL Client and Utility Programs
- 9 Language Structure
- 10 Character Set Support
- 11 Column Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 MySQL Storage Engines and Table Types
- 15 The InnoDB Storage Engine
- 15.1 InnoDB Overview
- 15.2 InnoDB Contact Information
- 15.3 InnoDB in MySQL 3.23
- 15.4 InnoDB Configuration
- 15.5 InnoDB Startup Options
- 15.6 Creating the InnoDB Tablespace
- 15.7 Creating InnoDB Tables
- 15.8 Adding and Removing InnoDB Data and Log Files
- 15.9 Backing Up and Recovering an InnoDB Database
- 15.10 Moving an InnoDB Database to Another Machine
- 15.11 InnoDB Transaction Model and Locking
- 15.12 InnoDB Performance Tuning Tips
- 15.13 Implementation of Multi-Versioning
- 15.14 Table and Index Structures
- 15.15 File Space Management and Disk I/O
- 15.16 InnoDB Error Handling
- 15.17 Restrictions on InnoDB Tables
- 15.18 InnoDB Troubleshooting
- 16 MySQL Cluster
- 17 Introduction to MaxDB
- 18 Spatial Extensions in MySQL
- 19 Stored Procedures and Functions
- 20 Triggers
- 21 Views
- 22 The INFORMATION_SCHEMA Information Database
- 23 Precision Math
- 24 MySQL APIs
- 25 MySQL Connectors
- 26 Error Handling in MySQL
- 27 Extending MySQL
- A Problems and Common Errors
- B Credits
- C MySQL and the Future (the TODO)
- D MySQL Change History
- E Porting to Other Systems
- F Environment Variables
- G MySQL Regular Expressions
- H GNU General Public License
- I MySQL FLOSS License Exception
- Index
Additional languages
Additional formats
Table of Contents
- 15.1.
InnoDBOverview - 15.2.
InnoDBContact Information - 15.3.
InnoDBin MySQL 3.23 - 15.4.
InnoDBConfiguration - 15.5.
InnoDBStartup Options - 15.6. Creating the
InnoDBTablespace - 15.7. Creating
InnoDBTables - 15.8. Adding and Removing
InnoDBData and Log Files - 15.9. Backing Up and Recovering an
InnoDBDatabase - 15.10. Moving an
InnoDBDatabase to Another Machine - 15.11.
InnoDBTransaction Model and Locking - 15.11.1.
InnoDBLock Modes - 15.11.2.
InnoDBandAUTOCOMMIT - 15.11.3.
InnoDBandTRANSACTION ISOLATION LEVEL - 15.11.4. Consistent Non-Locking Read
- 15.11.5. Locking Reads
SELECT ... FOR UPDATEandSELECT ... LOCK IN SHARE MODE - 15.11.6. Next-Key Locking: Avoiding the Phantom Problem
- 15.11.7. An Example of How the Consistent Read Works in
InnoDB - 15.11.8. Locks Set by Different SQL Statements in
InnoDB - 15.11.9. When Does MySQL Implicitly Commit or Roll Back a Transaction?
- 15.11.10. Deadlock Detection and Rollback
- 15.11.11. How to Cope with Deadlocks
- 15.11.1.
- 15.12.
InnoDBPerformance Tuning Tips - 15.13. Implementation of Multi-Versioning
- 15.14. Table and Index Structures
- 15.15. File Space Management and Disk I/O
- 15.16. InnoDB Error Handling
- 15.17. Restrictions on
InnoDBTables - 15.18.
InnoDBTroubleshooting
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.