Sphinx: High Performance Full Text Search for MySQL

Ever-increasing amount of diverse text content stored in MySQL databases makes full text search through that content important to the point of being crucial.

Sphinx improves MySQL full-text capabilities in several different areas: speed, relevancy, scalability, compatibility with storage engines other than MyISAM.

This talk will cover Sphinx features from basic searching to advanced capabilities such as efficient filtering, grouping, distributed searching, geo-distance support, and many others.

We will also talk about different special Sphinx uses in conjunction with MySQL: using Sphinx Storage Engine; moving certain non-fulltext queries to Sphinx clusters to offload MySQL; etc.