innodb home

innodb engine in mysql-max-3.23.56/mysql-4.0.12

the up-to-date reference manual of innodb

updated april 21, 2003: added notes to section 4.3 that 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 27, 2003: updated section 4.3: starting from mysql-4.0.13, innodb supports drop foreign key
updated march 18, 2003: mysql-4.0.12 is released
updated march 17, 2003: mysql-3.23.56 is released
updated february 25, 2003: mysql-4.0.11 is released; see the changelog from section 16
updated january 23, 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 概述
  • 1.1 mysql/innodb 发布版本间的区别
• 2 innodb 启动选项
• 3 建立一个 innodb 数据库
  • 3.1 在建立数据库时可能发生的几个错误
  • 3.2 关闭 mysql 服务器
• 4 建立 innodb 表
  • 4.1 如何在 innodb 中使用事务
  • 4.2 将 myisam 表转换到 innodb 类型
  • 4.3 外键约束
  • 4.4 自增列(auto-increment)是如何在 innodb 中工作的
  • 4.5 innodb 和 mysql 复制(replication)
• 5 添加与移除 innodb 数据和日志文件
• 6 备份和恢复一个 innodb 数据库
  • 6.1 强制(forcing)恢复
  • 6.2 检查点(checkpoints)
• 7 将 innodb 数据库移动到另一台机器中
• 8 innodb 事务模式与锁定
  • 8.1 consistent read