This week we present the basics of MySQL FULLTEXT search. We talk about the myisam_ftdump utility in Ear Candy, and present an introduction to Sphinx in At the Movies.
Percona Live: New York City 2012 will be held from Monday, Oct 1st through Tuesday Oct 2nd.
MySQL FULLTEXT SEARCH
MySQL FULLTEXT manual page
INFORMATION_SCHEMA.STATISTICS table about indexes
Bug 66573 AGAINST allows variables, documentation says it does not
Amarok, a music player for Linux that stores song lyrics. Gerry has played around with the text in Amarok and MySQL FULLTEXT searches.
This week's ear candy talks about the myisam_ftdump utility to gather information about your FULLTEXT indexes.
At the Movies
Introduction to Sphinx for MySQL/MariaDB by Andrew Aksyonoff at the SkySQL MySQL Solutions Day. Sphinx is an alternative to using MySQL's built-in FULLTEXT search.
Where you can see us
Sheeri will be at the September Boston MySQL User Group meeting on Monday September 10th at 7 pm, where Max Mether of SkySQL will talk about "MariaDB - a MySQL replacement?"
Sheeri will speak about monitoring MySQL at NagiosWorld, September 25-28th in Saint Paul, Minnesota.
Sheeri will speak about Database Scaling at Mozilla and Google-Hacking MySQL at MySQL Connect, Saturday Sept 29th and Sunday September 30th. Gerry will also be there with Tokutek.
Sheeri will be at the October Boston MySQL User Group meeting on Monday October 8th at 7 pm, where we'll have a talk by Ori Herrnstadt from Akiban talking about "Renormalize: The Sequel to SQL".
Sheeri will be at CodeConnexx in Indianapolis November 8-9th speaking about "MySQL Query Optimization with EXPLAIN" and "The Art of Cat Herding: How to Manage Geeks".