Category Archives: Query Optimization

OurSQL Episode 190: Server State Monitoring

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

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

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

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

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

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

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

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

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

OurSQL Episode 77: Removing Evil Queries, part 1

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