推荐几遍看着不错的文 MySQL存储引擎 http://www.cnblogs.com/gbyukg/archive/2011/11/09/2242271.html 理解MySQL--索引与优化 http://www.cnblogs.com/hustcat/archive/2009/10/28/1591648.html MySQL:索引工作原理 http://blog.csdn.net/iefreer/article/details/15815455