Monthly Archives: September 2012

OurSQL Episode 109: Starting with the right foot

This week we talk about startup scripts and their gotchas. Ear candy is a startup cache gotcha and at the movies presents an introduction to VoltDB.
Events
Percona Live Santa Clara, 2013 call for papers closes Friday October 12th.
Oracle’s “Scale with … Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 109: Starting with the right foot

OurSQL Episode 108: Legendary Searches

This week we present the Sphinx Storage Engine. Ear Candy is a gotcha about setting variables in the configuration file, and At the Movies is a video about MariaDB.
Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunda… Continue reading

Posted in Performance, Podcasts, Query Optimization, Server Tuning | Comments Off on OurSQL Episode 108: Legendary Searches

OurSQL Episode 107: Staying concurrent

This week we present what Multi-Version Concurrency Control (MVCC) means, as well as how InnoDB implements it to achieve transactionality and ACID compliance. Ear candy is a GROUP BY performance gotcha, and At the Movies is a FULLTEXT webinar from Perc… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 107: Staying concurrent

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 Su… Continue reading

Posted in Learning, Podcasts | Comments Off on OurSQL Episode 106: FULLTEXT on ACID