InnoDB Chinese Reference Manual---Catalogue

Reference | Reference Manual | Chinese InnoDB chinese Reference Manual---canine (heart-sail) translator InnoDB home InnoDB Engine in mysql-max-3.23.56/mysql-4.0.12
The up-to-date Reference Manual of InnoDB

Updated April, 2003:added notes to section 4.3 This a self-referential on UPDATE CASCADE and SET NULL convert the rule To RESTRICT if the update cycles to update the SAME TABLE
Updated March 2003:updated Section 4.3:starting from MySQL-4.0.13, InnoDB supports DROP FOREIGN KEY
Updated March 2003:mysql-4.0.12 is released
Updated March 2003:mysql-3.23.56 is released
Updated February, 2003:mysql-4.0.11 is released; The Changelog from section 16
Updated January, 2003:added a new section 4.5 about InnoDB and MySQL replication
Updated January 7, 2003:mysql-4.0.8 is released; Support for on UPDATE CASCADE added

1 InnoDB Tables Overview 1.1 Mysql/innodb release version 2 InnoDB startup option 3 Establish a InnoDB database 3.1 several errors may occur when establishing a database 3.2 shut down MySQL server 4 establish I Nnodb Table 4.1 How to use transaction 4.2 in InnoDB to convert the MyISAM table to InnoDB type 4.3 foreign key constraint 4.4 self-added (auto-increment) is how to work in InnoDB 4.5 InnoDB and MyS QL Replication (replication) 5 Add and remove InnoDB data and log files 6 backup and restore one InnoDB Database 6.1 force (forcing) Restore 6.2 checkpoint (checkpoints) 7 move the InnoDB database to another 8 InnoDB Transaction Mode in machine and locked 8.1 consistent read 8.2 locking reads 8.3 next-key locking:avoiding the ' phantom problem ' 8.4 InnoDB The locking settings for each SQL statement in 8.5 MySQL when implicitly commit (commit) or rollback (rollback) Transaction 8.6 deadlock detection and rollback 8.7 consistent read in InnoDB operation example 8.8 How to deal with deadlock 9 performance tuning Whole Technique 9.1InnoDB Monitor (monitors) multiversioning 11 table and Index structure 11.1 index physical Structure 11.2 insert Buffer 11.3 Adaptive Hash Index 11.4 Record physical Structure 12 file space management and magnetic Disk I/O 12.1 disk I/O and raw devices 12.2 file Space Management 12.3 defragmentation a table 13 error handling 13.1 MySQL returned some error codes 13.2 Some operating system error code InnoDB table limit 15 Obstacle detection and Repair 15.1 discover and fix data dictionary error operation InnoDB version history contact information The GNU GPL License version 2 known bugs And their fixes in oldVersions of InnoDB the TODO list of new features to InnoDB Some books and articles on Mysql/innodb