Monthly Archives: February 2013

OurSQL Episode 128: Your Global ID Please

Posted on February 17, 2013 by podcast

This week, we discuss GTIDs in MySQL 5.6 and how they work with replication. In Ear Candy, we link to an extremely useful resource for complicated MySQL query patterns. In At the Movies, we present The Finer Art of Being a ‘Senior’ Employee.
Events
Ora… Continue reading →

Posted in Podcasts, Server Tuning | Comments Off on OurSQL Episode 128: Your Global ID Please

OurSQL Episode 127: No Sweat Slaves

Posted on February 9, 2013 by podcast

This week we begin to discuss replication features in MySQL 5.6. Ear Candy is a LOAD DATA INFILE bug and using CSV to get beyond it; At the Movies is Suzan Bond talking about “The Art of Self-Sourcing”.
Events
Oracle’s doing more MySQL tech tours. Thes… Continue reading →

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 127: No Sweat Slaves

OurSQL Episode 126: Subqueries and Tracking

Posted on February 3, 2013 by podcast

This week we present part 2 of optimizer enhancements in MySQL 5.6, including subquery optimizations and the new optimizer trace feature. Ear Candy talks about what “hole punching” is with regards to file systems. In At the Movies we present “How to De… Continue reading →

Posted in Podcasts, Query Optimization | Comments Off on OurSQL Episode 126: Subqueries and Tracking