How to Create a Scalable, High Performance Full-text Search Solution with MySQL

Performance Tuning and Benchmarks
Location: Ballroom E Level: Intermediate
Average rating: **...
(2.67, 3 ratings)

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


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.


Alexander Rubin
10/29/2009 6:19am PDT


You can find presentations on my blog:

Lakshmi Narayana
10/29/2009 6:14am PDT

Hi to all, How can i get the information regarding this fulltext search, here we just have only brief matter. Can anyone suggest me.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.