Analysing full text index

If you are using a lot of Full Text indexes, there is a way to know more about the words those are being indexed. myisam_ftdump is the command that can be used for the same.

# myisam_ftdump /var/lib/mysql/db/tbl_company 2
Key 2 in table /var/lib/mysql/d_jds/tbl_company_master is not a FULLTEXT key

# myisam_ftdump /var/lib/mysql/db/tbl_company 27
Total rows: 1047196
Total words: 265644
Unique words: 124584
Longest word: 36 chars (chemoxhse1stflrhospiltallanemumbai20)
Median length: 8
Average global weight: 13.580585
Most common word: 191281 times, weight: 1.498428 (road)

# myisam_ftdump /var/lib/mysql/db/tbl_company 22 -c | more
1 13.8616257 abohar
2 13.1684776 adilabad
1 13.8616257 adoni
21 10.8170842 agra
1480 6.5604150 ahmedabad

# myisam_ftdump /var/lib/mysql/db/tbl_company 22 -d | more
175d800 0.9886308 abohar
2b612cc 0.9886308 adilabad
12c02df0 0.9886308 adilabad
c91f0ec 0.9886308 adoni
e826ec 0.9886308 agra

# myisam_ftdump /var/lib/mysql/db/tbl_company 22 -l | more
3: 49 2.38% 49 2.4%
4: 74 3.59% 123 6.0%
5: 175 8.50% 298 14.5%
6: 381 18.50% 679 33.0%