OurSQL Episode 105: Lost for Words

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.

Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. The schedule is now online.

Percona Live: New York City 2012 will be held from Monday, Oct 1st through Tuesday Oct 2nd.

Training
SkySQL Trainings

Percona Tranings

Oracle's MySQL Trainings

MySQL FULLTEXT SEARCH
MySQL FULLTEXT manual page

Episode 13, which talked about B-tree indexes

INFORMATION_SCHEMA.STATISTICS table about indexes

ft_min_word_len
ft_max_word_len
ft_stopword_file
FULLTEXT stopword list (593 English words)

MySQL FULLTEXT manual page - scroll down to see the comment by Eric Jacolin is the one about ASCII spaces vs. regular Japanese ones.
MySQL FULLTEXT limitations

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.

Natural language search with FULLTEXT
Query expansion with FULLTEXT Natural language search
Boolean search with FULLTEXT

Ear Candy
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".

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast


Fatal error: Class 'CToolsCssCache' not found in /home/sheeri/technocation/includes/cache.inc on line 32