Practical Full-Text Search in MySQL
← Back to MySQL University main page
[edit] Practical Full-Text Search in MySQL
- Date and time: December 3, 2009, 16:00 UTC
- To attend, point your browser to this address.
- Presenter: Bill Karwin
- Host: Paul DuBois
- Abstract: Odds are if you develop database applications you have been asked to make a large table of textual data searchable. How can we do this most reliably and efficiently? Bill compares a range of techniques to search text data with MySQL, with a focus on performance.
- Ad hoc searches with the LIKE predicate or regular expressions.
- MySQL FULLTEXT index.
- Lucene search engine
- Sphinx search engine.
- Inverted index, or tagging design.
- Google Custom Search or Yahoo! BOSS.
- Presentation slides: Practical_Full_Text_Search.pdf
- Session recording: (stream) (download)
- Chat transcript