Category Archives: Query Optimization

OurSQL Episode 199: Make It Fast

Posted on August 24, 2017 by Technocation, Inc.

This week, we discuss common MySQL performance tips.
Continue reading →

Posted in Performance, Podcasts, Query Optimization, Server Tuning | Comments Off on OurSQL Episode 199: Make It Fast

OurSQL Episode 190: Server State Monitoring

Posted on June 23, 2014 by podcast

This week we discuss pt-sift and pt-stalk. Ear Candy is about a new tool called Orchestrator, and At the Movies is about Trove on OpenStack to provide open source Database as a Service.
News
Gerry:
In the news, the OurSQL podcast will change to a month… Continue reading →

Posted in Performance, Podcasts, Query Optimization | Comments Off on OurSQL Episode 190: Server State Monitoring

OurSQL Episode 182: Optimizing MariaDB

Posted on April 21, 2014 by podcast

This week we discuss new optimizer improvements in MariaDB 10. Ear Candy is about the MariaDB threadpool, and At the Movies is Oracle’s Tomas Ulin talking about raising the bar with MySQL.
Events
DB Hangops – every other Wednesay at noon Pacific time
U… Continue reading →

Posted in Performance, Podcasts, Query Optimization | Comments Off on OurSQL Episode 182: Optimizing MariaDB

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

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 on OurSQL Episode 113: A JS API with JDD

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 on OurSQL Episode 108: Legendary Searches

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 on OurSQL Episode 96: Talking about Nothing

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 on OurSQL Episode 83: The NewSQL World

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 on OurSQL Episode 79: Removing Evil Queries, part 3

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 on OurSQL Episode 78: Removing Evil Queries, part 2