MySQL课程之MySQL存储引擎入门
5星 · 超过95%的资源 需积分: 14 121 浏览量
2009-02-03
16:40:37
上传
评论
收藏 207KB DOC 举报 
MySQL 课程之 MySQL 存储引擎入门
目 录
1 MySQL 存储引擎概述..........................................................................................................................................1
1.1 存储引擎的概念.........................................................................................................................................1
1.2 存储引擎的分类和特点............................................................................................................................1
1.3 存储引擎的基本操作................................................................................................................................1
2 MyISAM 存储引擎...............................................................................................................................................3
2.1 概述.............................................................................................................................................................3
2.2 创建 MyISAM 表.......................................................................................................................................4
2.3 相关参数配置.............................................................................................................................................7
2.4 MyISAM 锁机制........................................................................................................................................9
2.4.1 如何加表锁......................................................................................................................................9
2.4.2 锁定原理..........................................................................................................................................9
2.4.3 检查锁等待情况...........................................................................................................................10
2.5 MyISAM 的数据备份..............................................................................................................................10
2.6 常见故障和解决办法..............................................................................................................................10
3 InnoDB 存储引擎................................................................................................................................................11
3.1 概述...........................................................................................................................................................11
3.2 InnoDB 存储引擎性能参数配置.............................................................................................................12
3.2.1 innodb_buffer_pool_size 参数说明..............................................................................................12
3.2.2 innodb_flush_log_at_trx_commit 参数说明................................................................................12
3.2.3 innodb_additional_mem_pool_size 参数说明..............................................................................12
3.2.4 innodb_lock_wait_timeout 参数说明...........................................................................................12
3.2.5 innodb_support_xa 参数说明........................................................................................................12
3.2.6 innodb_log_buffer_size 参数说明................................................................................................13
3.2.7 innodb_log_file_size 参数说明.....................................................................................................13
3.3 创建 InnoDB 表空间................................................................................................................................13
3.3.1 InnoDB 表空间配置方法..............................................................................................................13
3.3.2 InnoDB 数据文件管理..................................................................................................................13
3.4 InnoDB 锁机制.........................................................................................................................................14
3.4.1 获取 InnoDB 行锁统计信息.........................................................................................................14
3.4.2 InnoDB 行锁特点..........................................................................................................................15
3.5 InnoDB 外键约束的使用.........................................................................................................................20
3.6 InnoDB 的数据备份.................................................................................................................................22
4 其他存储引擎......................................................................................................................................................22
4.1 MEMORY 存储引擎................................................................................................................................22
4.2 Merge 存储引擎.......................................................................................................................................23
4.3 Federated 存储引擎..................................................................................................................................23
4.4 CSV 存储引擎..........................................................................................................................................24
4.5 BLACKHOLE 存储引擎.........................................................................................................................24
剩余25页未读，继续阅读
资源评论
WUTAOWUTAO2012-04-17不错，短小精悍，适合入门学习
