Fulltext search QuickPoll
? have used MySQL Fulltext Search in production ?
- have at least tried using MySQL Fulltext search ?
- have used fulltext search in other products ?
? are interested in boolean fulltext search ?
- natural language search ?
- in our future plans for fulltext search ?
? are interested in how to tune and optimize your fulltext search application ?
? are interested in how MySQL Fulltext Search works internally?
- have contributed code to Open Source products ?

? 1995–1998
- I was using various fulltext engines. No one could do complex queries on structured data
- Relational DBMSes could do it perfectly, and SQL was very capable – but they had no fulltext search capabilities
- MySQL RDBMS was Open Source and it was known to be very fast. It was MySQL 3.22.7

History of MySQL Fulltext search
? Oct. 1998: First version of fulltext search engine for ISAM
? May 1999: It was rewritten for MyISAM
? Oct. 1999: First public release
? Jun. 2000: MATCH … AGAINST syntax
? Dec. 2001: Boolean fulltext search went public
? Jan. 2003: Major rewrite of the index structure code
? Sep. 2003: Unicode support, query expansion

Download pdf MySQL Fulltext Search