Query Optimization

OurSQL Episode 194: Common Schema, part 4

This week we continue our series on Common Schema and talk about different ways to look at the processlist, help with the query profiler, and some internal Common Schema tables. Ear Candy is about RHEL 7.0 using MariaDB, and At the Movies is The Human Postmortem.

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 monthly format after episode 200. We love doing the podcast, but it is very time consuming and production is expensive. We will still bring quality episodes, they will just be spaced further apart.

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

Upcoming MySQL events

Training
SkySQL Trainings

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 Deal with Difficult People".

Events
Galera, SkySQL and MariaDB are doing a Road Show in Stockholm on February 7th.

Oracle's doing more MySQL tech tours. These seminars will be in the mornings, and are free. They will be on:
Friday, February 15th near Milan

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 discuss what makes a senior DBA, and in At the Movies we present a ScaleBase webinar.

Events
Oracle's "Scale with MySQL" seminars:
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November

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 Sunday September 30th. The schedule is now online.

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 Francisco on Saturday September 29th and Sunday September 30th. This is a technical conference about MySQL, bringing together MySQL engineers at Oracle and the MySQL Community, and will include sessions about the latest MySQL features and roadmaps. The schedule is now online.

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

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 presentation on joins and subqueries and how to optimize them.

Free OTN MySQL Developer Day, Singapore, Tuesday Feb 21st

Free OTN MySQL Developer Day, Paris, France, Tuesday Feb 21st

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 Thursday, April 12th at the Santa Clara, CA convention center. Early bird pricing ends March 12th, 2012.
Use code PL-pod and save 10% off the early bird prices!
. Check out the tutorial and session schedule!

Pages