OurSQL Episode 106: FULLTEXT on ACID

This week we present InnoDB FULLTEXT search. Ear Candy is about SOUNDEX() and SOUNDS LIKE queries, and At the Movies is about FULLTEXT search throwdown by Bill Karwin.

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.

Confoo Call for Papers is open until Sunday, September 23rd, 2012. Confoo is a developer conference at the Hilton Bonaventure Hotel in Montreal from February 27 to March 1, 2013.

Training
SkySQL Trainings

Oracle's MySQL Trainings

Percona Tranings

InnoDB FULLTEXT search
Episode 105 which talked about the basics of FULLTEXT search.

InnoDB FULLTEXT search tutorial from the official InnoDB blog. Also an article from 9 months ago on the same blog about InnoDB FULLTEXT search in MySQL 5.6.4

Jimmy Yang's blog post about how InnoDB FULLTEXT search works.
InnoDB FULLTEXT search performance blog post by Vinay of the InnoDB team

InnoDB FULLTEXT index from the MySQL manual

document id listing in the MySQL 5.6 manual glossary

innodb_ft_cache_size

innodb_ft_num_word_optimize

innodb_ft_sort_pll_degree

Ear Candy
SOUNDEX
Bug about international characters broken in SOUNDEX

At the Movies
FULLTEXT search throwdown by Bill Karwin

Where you can see us
Sheeri will speak about monitoring MySQL at NagiosWorld, September 25-28th in Saint Paul, Minnesota.

Gerry will be at MySQL Connect, Saturday Sept 29th and Sunday September 30th. Sheeri will be there, speaking about Database Scaling at Mozilla and Google-Hacking MySQL

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

Trackback URL for this post:

http://technocation.org/trackback/1178