7.5 InnoDB Tables

Subsections

• 7.5.1 InnoDB Tables Overview
• 7.5.2 InnoDB in MySQL Version 3.23
• 7.5.3 InnoDB Startup Options
• 7.5.4 Creating InnoDB Tablespace
• 7.5.4.1 If Something Goes Wrong in Database Creation
• 7.5.5 Creating InnoDB Tables
• 7.5.5.1 Converting MyISAM Tables to InnoDB
• 7.5.5.2 Foreign Key Constraints
• 7.5.6 Adding and Removing InnoDB Data and Log Files
• 7.5.7 Backing up and Recovering an InnoDB Database
• 7.5.7.1 Checkpoints
• 7.5.8 Moving an InnoDB Database to Another Machine
• 7.5.9 InnoDB Transaction Model
• 7.5.9.1 Consistent Read
• 7.5.9.2 Locking Reads
• 7.5.9.3 Next-key Locking: Avoiding the Phantom Problem
• 7.5.9.4 Locks Set by Different SQL Statements in InnoDB
• 7.5.9.5 Deadlock Detection and Rollback
• 7.5.9.6 An Example of How the Consistent Read Works in InnoDB
• 7.5.9.7 How to cope with deadlocks?
• 7.5.9.8 Performance Tuning Tips
• 7.5.9.9 The InnoDB Monitor
• 7.5.10 Implementation of Multi-versioning
• 7.5.11 Table and Index Structures
• 7.5.11.1 Physical Structure of an Index
• 7.5.11.2 Insert Buffering
• 7.5.11.3 Adaptive Hash Indexes
• 7.5.11.4 Physical Record Structure
• 7.5.11.5 How an Auto-increment Column Works in InnoDB
• 7.5.12 File Space Management and Disk I/O
• 7.5.12.1 Disk I/O
• 7.5.12.2 File Space Management
• 7.5.12.3 Defragmenting a Table
• 7.5.13 Error Handling
• 7.5.14 Restrictions on InnoDB Tables
• 7.5.15 InnoDB Change History
• 7.5.15.1 MySQL/InnoDB-4.0.14, July 22, 2003
• 7.5.15.2 MySQL/InnoDB-3.23.57, June 20, 2003
• 7.5.15.3 MySQL/InnoDB-4.0.13, May 20, 2003
• 7.5.15.4 MySQL/InnoDB-4.1.0, April 3, 2003
• 7.5.15.5 MySQL/InnoDB-3.23.56, March 17, 2003
• 7.5.15.6 MySQL/InnoDB-4.0.12, March 18, 2003
• 7.5.15.7 MySQL/InnoDB-4.0.11, February 25, 2003
• 7.5.15.8 MySQL/InnoDB-4.0.10, February 4, 2003
• 7.5.15.9 MySQL/InnoDB-3.23.55, January 24, 2003
• 7.5.15.10 MySQL/InnoDB-4.0.9, January 14, 2003
• 7.5.15.11 MySQL/InnoDB-4.0.8, January 7, 2003
• 7.5.15.12 MySQL/InnoDB-4.0.7, December 26, 2002
• 7.5.15.13 MySQL/InnoDB-4.0.6, December 19, 2002
• 7.5.15.14 MySQL/InnoDB-3.23.54, December 12, 2002
• 7.5.15.15 MySQL/InnoDB-4.0.5, November 18, 2002
• 7.5.15.16 MySQL/InnoDB-3.23.53, October 9, 2002
• 7.5.15.17 MySQL/InnoDB-4.0.4, October 2, 2002
• 7.5.15.18 MySQL/InnoDB-4.0.3, August 28, 2002
• 7.5.15.19 MySQL/InnoDB-3.23.52, August 16, 2002
• 7.5.15.20 MySQL/InnoDB-4.0.2, July 10, 2002
• 7.5.15.21 MySQL/InnoDB-3.23.51, June 12, 2002
• 7.5.15.22 MySQL/InnoDB-3.23.50, April 23, 2002
• 7.5.15.23 MySQL/InnoDB-3.23.49, February 17, 2002
• 7.5.15.24 MySQL/InnoDB-3.23.48, February 9, 2002
• 7.5.15.25 MySQL/InnoDB-3.23.47, December 28, 2001
• 7.5.15.26 MySQL/InnoDB-4.0.1, December 23, 2001
• 7.5.15.27 MySQL/InnoDB-3.23.46, November 30, 2001
• 7.5.15.28 MySQL/InnoDB-3.23.45, November 23, 2001
• 7.5.15.29 MySQL/InnoDB-3.23.44, November 2, 2001
• 7.5.15.30 MySQL/InnoDB-3.23.43, October 4, 2001
• 7.5.15.31 MySQL/InnoDB-3.23.42, September 9, 2001
• 7.5.15.32 MySQL/InnoDB-3.23.41, August 13, 2001
• 7.5.15.33 MySQL/InnoDB-3.23.40, July 16, 2001
• 7.5.15.34 MySQL/InnoDB-3.23.39, June 13, 2001
• 7.5.15.35 MySQL/InnoDB-3.23.38, May 12, 2001
• 7.5.16 InnoDB Contact Information

User Comments

I found some thing wrong about auto_increment type
when I use innodb.
I created an auto_increment id in a table .
I did as follows
1.add some data,It was
id,name
===================
1,case
2,bug
3,dog
===================
I delete '3' before restart the database server
and then I restart it.
Continue add the data 'pig'

now id is 3 ,but this issue does not appear in myISAM type
Table
suddy_chang@263.net

Add your own comment.