开发者

Good documentation/reference for MySQL hash index?

The MySQL documentation refers to the possibility of using a Hash Index in certain situations, see for example:

  • http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html
  • http://dev.mysql.com/doc/refman/5.1/en/index-btree-hash.html
  • http://dev.mysql.com/doc/refman/5.1/en/innodb-adaptive-hash.html

That is, the Hash Index is supported on a MEMORY table (and NDB; see also MySQL Static Hash-index), and tha开发者_开发知识库t InnoDB can adaptively use a Hash Index if beneficial.

However, the above documentation is a bit sparse. Is there any other good documentation/reference for the particular uses/details of Hash Index in MySQL? The basic hashing behavior is implied, but some more particulars would be nice.


You can read this :

  • http://jameshalsall.co.uk/emulating-mysql-hash-indexes-on-myisam-tables/
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜