Minimum Word Length
By default, InnoDB indexes words with 3+ characters (innodb_ft_min_token_size = 3). Short words like "db" are not indexed unless you change this setting.
MySQL
Intermediate
3 min read
Minimum Word Length
Example
-- Check current setting
SHOW VARIABLES LIKE 'innodb_ft_min_token_size';
SHOW VARIABLES LIKE 'ft_min_word_len'; -- MyISAM
-- To index 2-letter words, set in my.cnf:
-- innodb_ft_min_token_size = 2
-- Then restart MySQL and rebuild indexes Pro Tip
Changing min_token_size requires rebuilding all full-text indexes.