How Can I view MySql Fulltext Indexes?

2019-08-16 03:37发布

问题:

  1. Does MySql Fulltext search use indexing?
  2. If so, how can I view the Index entries table?

I can view the Index Statistics with VIEW query. But, I just wanted to view the index record entries table.

回答1:

  1. Yes - FULLTEXT indexes, not regular indexes
  2. See Display Full-Text Index information

I linked to the 4.1 MySQL docs, but you can pick the appropriate version in the upper left corner.