如果你用
show index from table;
得到的index_type为:BTREE
但是我们印象中不是应该是B+ 树么?
这个链接里给出了大概的解答:
Does mysql use B-tree,B+tree or both?
B+TREE would be a very bad keyword, because it contains +, which is usually an operator.
That syntax is older than InnoDB. It is probably as old as the ISAM storage engine, which exists no more. It is very possible that B-TREE was used at that time.
一个链接,有空了看
All About Indexes Part 2: MySQL Index Structure and Performance