Full Text Search is a very popular feature nowadays. Many large web sites use Full Text Search with MySQL to search thru the site content (texts, titles, names and etc). However, when the datasets are growing Full Text Search can perform much worse and use much more resources than before. In this presentation we will show how to create a high performance and scalable full text solution with MySQL, which can search thru billions of documents and terabytes of data.
From this presentation you will know:
1. How to scale your full text search
2. How to tune MySQL Full Text Search for maximum performance
3. How to optimize your full text search queries
4. How to integrate MySQL with external search engines (i.e. Sphinx Search)
5. How to perform a Full Text Search with automatic typos correction
Alexander Rubin is a Senior Consultant at MySQL AB.
Alexander has over 8 years industry experience with the MySQL database, and specializes in performance tuning, full text search, high availability and the scale-out of database infrastructures.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com
Download the MySQL Sponsor/Exhibitor Prospectus
Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.
Comments
Lakshmi,
You can find presentations on my blog: www.arubin.org/blog/mysql-f...
Hi to all, How can i get the information regarding this fulltext search, here we just have only brief matter. Can anyone suggest me.