Category Archives: Query Optimization

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

OurSQL Episode 113: A JS API with JDD

Posted on October 29, 2012 by podcast

While we were at MySQL Connect last month, we interviewed long-time MySQL developer JD Duncan about integrating NoSQL and JavaScript with MySQL. His team developed the Node.js API for MySQL. This week, we present the interview we did. In Ear Candy, we … Continue reading →

Posted in Performance, Podcasts, Query Optimization | Comments Off

OurSQL Episode 108: Legendary Searches

Posted on September 21, 2012 by podcast

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

OurSQL Episode 96: Talking about Nothing

Posted on June 21, 2012 by podcast

This week we talk about NULLs and how to find the right data type.
Events
OSCon will be held Monday Jul 16th through Friday Jul 20th and has a data track. We did a podcast about OSCon, including a discount code!
MySQL Connect will be held in San Franci… Continue reading →

Posted in Learning, Performance, Podcasts, Query Optimization | Comments Off

OurSQL Episode 83: The NewSQL World

Posted on March 16, 2012 by podcast

This week, we talk with Ori Herrnstadt, CTO of Akiban.
MariaDB announced their 5.3 GA and 5.5 alpha releases.
Oracle will be at DrupalCon in Denver, CO from Monday, March 19th through Friday, March 23rd.
Percona’s XtraDB cluster announcement
read more Continue reading →

Posted in Performance, Podcasts, Query Optimization | Comments Off

OurSQL Episode 79: Removing Evil Queries, part 3

Posted on February 17, 2012 by podcast

There are a lot of events scheduled for the next few months, we are excited about the international scope and the mix of big and small, paid and free events. This week we finish explaining the output of EXPLAIN. Ear candy is sshfs, at the movies is a p… Continue reading →

Posted in Podcasts, Query Optimization | Comments Off

OurSQL Episode 78: Removing Evil Queries, part 2

Posted on February 10, 2012 by podcast

This week, we continue our series on query optimization by talking about how to use EXPLAIN to optimize queries. Part 1 of the series.
Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through… Continue reading →

Posted in Podcasts, Query Optimization | Comments Off

OurSQL Episode 77: Removing Evil Queries, part 1

Posted on February 4, 2012 by podcast

This week, we talk about how to find mysql queries to optimize in part 1 of a series on query optimization.
Registration for Percona Live: MySQL Conference and Expo is open! The conference is from Tuesday, April 10th through Thursday, April 12th. Ear… Continue reading →

Posted in Podcasts, Query Optimization | Comments Off