MySQL in a Nutshell, 2nd Edition

Name

myisam_ftdump

Synopsis

myisam_ftdump options table index_nbr

This utility displays information related to FULLTEXT indexes on MyISAM tables. It must be run from the server. For the table name, you can give either the name of the table or the name of the table’s index file with its path (e.g., /data/mysql/clients.MYI). The third argument for this utility is the index number. To determine the index number, execute SHOW INDEX FROM table; for the table you want to examine. In the results, the Non_unique field will contain the index numbers:

myisam_ftdump --stats /data/mysql/russell_dyer/articles.MYI 1

Total rows: 98
Total words: 38517
Unique words: 9961
Longest word: 33 chars (mysql_opt_use_embedded_connection)
Median length: 7
Average global weight: 3.826532
Most common word: 83 times, weight: -1.710790 (make)

Here is a list of options available for this utility in alphabetical order:

--count, -c

This option will display a list of all words found in the specified index of the given table with a count of the number of occurrences of each word, along with its weighting in the index.

--dump, -d

This option is used to dump the index, word weighting, and data offsets.

--length, -l

This option returns the distribution length.

--stats, -s

With this option, you can see some statistical information on the index. If no options are given with the utility, this option is assumed.

--help, -h, -?

This option displays basic help information.

--verbose, -v

This option is meant to display more information, but ...