InnoDB数据库中文参考文档资源-CSDN文库

共20个文件

htm：17个

html：1个

css：1个

InnoDB

需积分: 4 46 浏览量 2009-01-04 19:07:35 上传评论收藏 80KB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

InnoDB数据库_inonodb_zh.rar （20个子文件）

打开方式.htm 7KB

inonodb_zh

14.htm 7KB

9.htm 16KB

images

index.css 5KB

2.htm 21KB

6.htm 13KB

10.htm 3KB

index.html 8KB

1.htm 5KB

7.htm 2KB

4.htm 21KB

13.htm 16KB

15.htm 6KB

5.htm 3KB

16.htm 50KB

11.htm 8KB

12.htm 7KB

8.htm 25KB

3.htm 8KB

爱书吧-全国最大图书-课件免费下载.url 120B

<html> <head> <TITLE>InnoDB 中文参考手册</TITLE> <style> code {color:purple} tt {color:green} samp {color:navy} pre {color:maroon} </style> <META http-equiv="Content-Type" content="text/html; charset=gb2312"> <META name="description" content="InnoDB 中文参考手册"> <META name="keywords" content="MySQL,InnoDB,4.1.0,Shuixin13,MySQL 4.1.0,中文,中文参考手册,犬犬(心帆)"> <LINK rel="shortcut icon" href="shuixin13.ico" /> <LINK href="images/index.css" type=text/css rel=STYLESHEET> <SCRIPT language=javascript src="images/index.js"></SCRIPT> <SCRIPT language=javascript></SCRIPT> <SCRIPT language=JavaScript> var currentpos,timer; function initialize() { timer=setInterval("scrollwindow()",10); } function sc() { clearInterval(timer); } function scrollwindow() { currentpos=document.body.scrollTop; window.scroll(0,++currentpos); if (currentpos != document.body.scrollTop) sc(); } document.onmousedown=sc document.ondblclick=initialize </SCRIPT> </HEAD> <BODY BGCOLOR=#efefff TEXT=#000000 LINK=#101090 VLINK=#7030B0> <a href="http://www.innodb.com/">InnoDB home</a> <hr> <h1><a name="INNOBASE"> InnoDB Engine in MySQL-Max-3.23.56/MySQL-4.0.12</a></h1> 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 <ul> <li><a href="1.htm#InnoDB_overview">1 InnoDB tables 概述</a> <ul> <li><a href="1.htm#InnoDB_distros">1.1 MySQL/InnoDB 发布版本间的区别</a></li> </ul> <li><a href="2.htm#InnoDB_start">2 InnoDB 启动选项</a> <li><a href="3.htm#Creating_an_InnoDB_database">3 建立一个 InnoDB 数据库</a> <ul> <li><a href="3.htm#Wrong_creation">3.1 在建立数据库时可能发生的几个错误</a></li> <li><a href="3.htm#Shutting_down">3.2 关闭 MySQL 服务器</a></li> </ul> <li><a href="4.htm#Using_InnoDB_tables">4 建立 InnoDB 表</a> <ul> <li><a href="4.htm#How_to_use_transactions">4.1 如何在 InnoDB 中使用事务</a></li> <li><a href="4.htm#Altering_InnoDB_tables">4.2 将 MyISAM 表转换到 InnoDB 类型</a></li> <li><a href="4.htm#InnoDB_foreign_keys">4.3 外键约束</a></li> <li><a href="4.htm#InnoDB_auto_inc">4.4 自增列(auto-increment)是如何在 InnoDB 中工作的</a></li> <li><a href="4.htm#InnoDB_replication">4.5 InnoDB 和 MySQL 复制(replication)</a></li> </ul> <li><a href="5.htm#Adding_and_removing">5 添加与移除 InnoDB 数据和日志文件</a> <li><a href="6.htm#Backing_up">6 备份和恢复一个 InnoDB 数据库</a> <ul> <li><a href="6.htm#Forcing_recovery">6.1 强制(Forcing)恢复</a></li> <li><a href="6.htm#Check_point">6.2 检查点(Checkpoints)</a></li> </ul> <li><a href="7.htm#Moving">7 将 InnoDB 数据库移动到另一台机器中</a> <li><a href="8.htm#InnoDB_transaction_model">8 InnoDB 事务模式与锁定</a> <ul> <li><a href="8.htm#SEC273">8.1 Consistent read</a></li> <li><a href="8.htm#SEC274">8.2 Locking reads</a></li> <li><a href="8.htm#SEC275">8.3 Next-key locking: avoiding the 'phantom problem'</a></li> <li><a href="8.htm#SEC276">8.4 InnoDB 中各 SQL 语句的锁定设置</a></li> <li><a href="8.htm#SEC277">8.5 MySQL 什么时候隐含地提交(commit)或回滚(rollback)事务</a></li> <li><a href="8.htm#SEC278">8.6 死锁检测与回滚</a></li> <li><a href="8.htm#SEC279">8.7 consistent read 在 InnoDB 中运作示例</a></li> <li><a href="8.htm#Cope_with_deadlocks">8.8 如何应付死锁</a></li> </ul> <li><a href="9.htm#InnoDB_tuning">9 性能调整技巧</a> <ul> <li><a href="9.htm#InnoDB_Monitor">9.1InnoDB 监视器(Monitors)</a></li> </ul> <li><a href="10.htm#Implementation">10 multiversioning 的实现 </a> <li><a href="11.htm#Table_and_index">11 表和索引结构</a> <ul> <li><a href="11.htm#SEC280">11.1 索引的物理结构</a></li> <li><a href="11.htm#SEC281">11.2 插入缓冲</a></li> <li><a href="11.htm#SEC282">11.3 适应性的散列索引</a></li> <li><a href="11.htm#SEC283">11.4 记录的物理结构</a></li> </ul> <li><a href="12.htm#File_space_management">12 文件空间管理和磁盘 I/O</a> <ul> <li><a href="12.htm#SEC285">12.1 磁盘 I/O 和 raw devices</a></li> <li><a href="12.htm#SEC286">12.2 文件空间管理</a></li> <li><a href="12.htm#SEC287">12.3 碎片整理一个表</a></li> </ul> <li><a href="13.htm#Error_handling">13 出错处理</a> <ul> <li><a href="13.htm#Error_codes">13.1 MySQL 返回的某些错误代码</a></li> <li><a href="13.htm#OS_Error_codes">13.2 某些操作系统的错误编码</a></li> </ul> <li><a href="14.htm#InnoDB_restrictions">14 InnoDB 表的限制</a> <li><a href="15.htm#InnoDB_troubleshooting">15 故障检测与修复</a> <ul> <li><a href="15.htm#InnoDB_troubleshooting_dict">15.1 发现并修复数据字典错误的操作</a></li> </ul> <li><a href="16.htm#InnoDB_history">16 InnoDB version history</a> <li><a href="16.htm#InnoDB_contact_information">17 Contact information</a> <li><a href="16.htm#GNU_GPL_license">18 The GNU GPL License Version 2</a> <li><a href="16.htm#Bugfixes">19 Known bugs and their fixes in old versions of InnoDB</a> <li><a href="16.htm#TODO">20 The TODO list of new features to InnoDB</a> <li><a href="16.htm#Articles">21 Some books and articles on MySQL/InnoDB</a></li> </ul> </body> </html>

评论收藏

内容反馈