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
Related:
Posted September 17, 2006 by Casey
Categories: Blink, Technology. Tags: full text, full text index, keyword searching, mysql, mysql indexing, Peter Gulutzan, stopwords.
2 Comments
Comments RSS
TrackBack Identifier URI
Leave a comment
User contributed tags for this post:
fulltext mysql (26) - mysql fulltext performance (26) - mysql fulltext slow (22) - mysql fulltext (21) - mysql full text search tips (18) - mysql fulltext tips (14) - mysql full text index (14) - mysql fulltext tuning (12) - mysql fulltext search tips (10) - mysql full text tips (9) - mysql full text catalog (9) - mysql fulltext stopwords (8) - mysql (8) - mysql full text performance (7) - tips on 69 com (7) - F (6) - fulltext slow mysql (6) - mysql exact (6) - mysql5 full text search (6) - mysql fulltext numbers (6) - Full-Text Stopwords (6) - mysql full text (6) - mysql fulltext exact phrase (6) - MySQL Search Tips (5) - tagcloud fulltext (5) - mysql5 fulltext (5) - mysql fulltext vs LIKE (5) - MYSQL FULLTEXT XML (5) - mysql stoplist (5) - mysql slow fulltext (5) - mysql full text slow (5) - mysql full text search performance (5) - mysql xml fulltext (5) - mysql fulltext index join (5) - MySQL Fulltext Keyword (5) - golubchik mysql fulltext search (5) - exact search in mysql (5) - exact search fulltext in mysql (4) - fulltext mysql5 (4) - tuning mysql fulltext (4) - mysql fulltext join (4) - mysql fulltext exact PHRASE search (4) - CREATE FULLTEXT INDEX mysql (4) - php fulltext mysql (4) - php fulltext (4) - MySQL Full-Text Search Rocks My World (4) - mysql fulltext google (4) - mysql fulltext stop words (4) - mysql stop words (4) - mysql xml index full text search (4) - fulltext index mysql (4) - mysql minimum full text performance (4) - mysql fulltext search slow (4) - fulltext mysql 5 (3) - mysql Fulltext union (3) - mysql full text index slow (3) - mysql Sergei Golubchik fulltext arabic (3) - time passing quote (3) - slow mysql full text search (3) - fulltext mysql slow (3) - mysql fulltext relevance (3) - full text catalog mysql (3) - fulltext stopwords (3) - fulltext and mysql join (3) - FULLTEXT MYSQL exact (3) - php mysql full text search (3) - mysql 5 fulltext (3) - mysql full text search exact phrase (3) - golubchik mysql fulltext search 2003 (3) - mysql stopwords (3) - mysql exact phrase (3) - mysql full text index slow create (3) - mysql fulltext performance tuning (3) - MySql indexing Tips (3) - fulltext mysql tips (3) - fulltext tips (3) - golubchik fulltext (3) - mysql fulltext good bad (3) - mysql5 fulltext performance (3) - fulltext index stopwords (2) - mysql fulltext query slow (2) - PHP and MySQL FULLTEXT (category), (2) - mysql FULL TEXT SEARCH related videos (2) - full text mysql tips (2) - sexarabek. (2) - mysql 5 vs 4 fulltext (2) - full text slow (2) - mysql arabic collection (2) - mysql Full-Text Stopwords (2) - mysql5 fulltext search (2) - full text search tips mysql (2) - ian gilfillan mysql fulltext (2) - golubchik mysql fulltext (2) - php mysql stopwords (2) - keyword search arabic mysql (2) - create fulltext index with MYSQL (2) - fulltext tip (2) - mysql 5 fulltext search (2) - mysql full text search arabic (2) - arabic keyword search mysql (2) - tuning mysql full text (2) - mysql fulltext related word (2) - mysql fulltext search is slow tune (2) - mysql fulltext searching tips (2) - php fulltext search (2) - fulltext join mysql (2) - fulltext index mysql5 (2) - fulltext mysql numbers (2) - fulltext tag cloud (2) - find popular tags in mysql (2) - tag cloud mysql collecting tags (2) - mysql full text index slow query (2) - MySQL Full text indexing and seraching exact keywords (2) - mysql min_word_length (2) - mysql phrase (2) - Sergei Golubchik, MySQL Fulltext Search (2) - mysql full text search vs like (2) - tips text search php -engine -engines (2) - keyword index mysql (2) - sexarabek (2) - mysql fulltext 2008 (2) - create full text index in mysql 5 (2) - mysql fulltext exact search (2) - mysql full text stoplist (2) - Tags with MySQL fulltext (2) - stoplist full text search mysql (2) - fulltext in mysql (2) - php mysql relevancy array full text (2) - mysql fulltext index list of tags (2) - stopwords php array (2) - create full text index mysql (2) - full text search php mysql (2) - fulltext search join mysql where (2) - mysql search index fulltext tag (2) - Sergei Golubchik mysql fulltext (2) - fulltext php mysql (2) - mysql xml full text indexing (2) - mysql full text stopwords (2) - php stopwords (2) - FULLTEXT KEYWORD (2) - web pages mysql fulltext stop list (2) - tagcloud stopWords (2) - search php mysql fulltext index (2) - mysql full-text is slow? (2) - mysql full text exact phrase (2) - mysql fulltext search tuning (2) - mysql FULL INDEX tags (2) - fulltext performance (2) - mysql fulltext serach (2) - mysql 3 fulltext (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*