Peter Gulutzan, author of SQL Performance Tuning, writes in The Full-Text Stuff That We Didn’t Put In The Manual about the particulars of word boundaries, index structure, boolean searching, exact phrase searching, and stopwords, as well as offering a few articles for further reading (Ian Gilfillan’s “Using Fulltext Index in MySQL”, Sergei Golubchik’s “MySQL Fulltext Search”, Joe Stump’s “MySQL FULLTEXT Searching”). It’s one of a number of articles in the MySQL Tech Resources collection.
mysql, full text, keyword searching, full text index, mysql indexing, stopwords, Peter Gulutzan
Posted September 17, 2006 by Casey Bisson
Categories: Blink, Technology. Tags: full text, full text index, keyword searching, mysql, mysql indexing, Peter Gulutzan, stopwords.
3 Comments
Comments RSS
TrackBack Identifier URI
User contributed tags for this post:
mysql fulltext performance (41) - fulltext mysql (31) - mysql fulltext slow (31) - mysql fulltext tips (27) - mysql full text search tips (25) - mysql fulltext (22) - mysql full text index (21) - mysql fulltext search tips (20) - mysql fulltext stopwords (19) - mysql fulltext tuning (17) - mysql (16) - mysql full text slow (15) - mysql fulltext index (14) - mysql fulltext exact phrase (14) - MySQL Search Tips (13) - mysql full text performance (13) - mysql full text catalog (11) - mysql full text tips (11) - mysql exact (11) - mysql Fulltext union (10) - mysql exact search (9) - mysql fulltext join (9) - mysql exact phrase (8) - mysql fulltext google (8) - mysql fulltext vs LIKE (8) - mysql stoplist (8) - CREATE FULLTEXT INDEX mysql (8) - mysql xml index (7) - golubchik mysql fulltext search (7) - fulltext slow mysql (7) - tagcloud fulltext (7) - mysql fulltext index slow (7) - mysql slow fulltext (7) - mysql fulltext index join (7) - mysql fulltext numbers (7) - tips on 69 com (7) - mysql fulltext search slow (7) - mysql min_word_length (6) - fulltext index mysql (6) - F (6) - mysql full text (6) - Full-Text Stopwords (6) - fulltext tips (6) - MYSQL FULLTEXT XML (6) - fulltext stopwords (6) - mysql5 full text search (6) - mysql stop words (6) - mysql fulltext stop words (6) - mysql 5 stop words (6) - mysql full text stopwords (5) - create full text index mysql (5) - MySQL Fulltext Keyword (5) - mysql full text search performance (5) - mysql xml fulltext (5) - mysql5 fulltext (5) - fulltext join (5) - fulltext mysql 5 (5) - mysql fulltext exact PHRASE search (5) - full text catalog mysql (5) - exact search in mysql (5) - php fulltext mysql (4) - mysql fulltext relevance (4) - mysql fulltext exact search (4) - tuning mysql fulltext (4) - fulltext mysql slow (4) - mysql stopwords (4) - mysql FULL TEXT join (4) - mysql fulltext serach (4) - mysql xml index full text search (4) - mysql5 fulltext search (4) - performance mysql fulltext (4) - mysql full text search tuning (4) - fulltext mysql5 (4) - exact search fulltext in mysql (4) - mysql minimum full text performance (4) - full text search tips mysql (4) - MySQL Full-Text Search Rocks My World (4) - mysql fulltext adding stop words (4) - php fulltext (4) - mysql fulltext tag cloud (4) - mysql fulltext catalog (4) - mysql xml indexing (3) - MYSQL Full Text Search Slow (3) - mysql full text index slow (3) - text tips in php mysql (3) - mysql phrase (3) - FULLTEXT MYSQL exact (3) - mysql full text tag cloud (3) - MySql indexing Tips (3) - php mysql fulltext (3) - mysql 5 fulltext search (3) - mysql fulltext phrase (3) - golubchik mysql fulltext search 2003 (3) - golubchik fulltext (3) - mysql fulltext good bad (3) - mysql fulltext word boundaries (3) - php mysql stopwords (3) - mysql full text search exact phrase (3) - mysql 5 fulltext (3) - tagcloud stopWords (3) - mysql fulltext performance tuning (3) - mysql create full text index (3) - mysql fulltext stopword (3) - exact phrase search mysql (3) - fulltext join mysql (3) - fulltext tag cloud (3) - mysql full text tuning (3) - mysql fulltext search exact phrase (3) - mysql5 fulltext performance (3) - mysql full text union (3) - slow mysql full text search (3) - dutch mysql stopwords (3) - fulltext mysql tips (3) - php mysql full text search (3) - mysql full text index slow create (3) - mysql union fulltext (3) - fulltext and mysql join (3) - mysql search index fulltext tag (2) - tuning mysql full text (2) - full text mysql stopwords problems (2) - full text search php mysql (2) - Sergei Golubchik mysql fulltext (2) - mysql tips (2) - mysql FULLTEXT index performance (2) - mysql xml full text indexing (2) - mysql full text xml (2) - slow fulltext mysql (2) - stoplist full text search mysql (2) - mysql fulltext stoplist (2) - fulltext search join mysql where (2) - mysql join fulltext (2) - mysql fulltext performance tips (2) - mysql Full-Text Stopwords (2) - mysql stop words list (2) - phrase searching mysql fulltext (2) - full text MySQL catalog (2) - fulltext index stopwords (2) - full text search mysql catalog title 2008 (2) - ian gilfillan mysql fulltext (2) - mysql fulltext keyword search (2) - min_word_length mysql (2) - php mysql fulltext stopwords (2) - stopwords php array (2) -
hi there,
i just want to know whether it is useful to alter the 50% threshold scheme that mysql uses by default ,is it beneficial in any way regarding serach(either by increasing or decreasing its value)or is it good to use default value of 50% only.
thanx in advance
@Amit: I’ve shortened the min_word_length, but never bothered with the threshold. I’ve just not experienced a case where it was an issue. *shrug*
Peter Gulutzan’s – The Full-Text Stuff That We Didn’t Put In The Manual
http://dev.mysql.com/tech-resources/articles/full-text-revealed.html
Sergei Golubchik’s – MySQL Fulltext Search
http://www.scribd.com/doc/8668324/Fulltext-search