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!

SkySQL and MariaDB Solutions Day on Friday, April 13th, 2012 in Santa Clara, CA.

The MariaDB, NoSQL and Cloud Latin America Conference will be held in Buenos Aires Sunday, June 17th through Tuesday, June 19th.

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

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

Free MySQL HA solutions seminar in Stockholm on Thursday, Feb 23rd.

Using EXPLAIN
MySQL manual about EXPLAIN
PDF slides of a talk on EXPLAIN, complete with examples.

SHOW TABLE STATUS
ANALYZE

MySQL manual page for correlated subqueries

EXPLAIN cheat sheet
EXPLAIN join types

Covering index

Index merge:
MySQL manual page on index_merge

Baron Schwartz's short rant on index merge

Peter Zaitsev's detailed explanation of using index_merge versus having a multi-column index

Brian Moon's thorough review of the different types of index merges, including him saying "It can only make bad SQL and tables better".

MySQL's FULLTEXT search

Ear Candy
This week’s ear candy is about how to get rid of swap used without restarting your machine using swapoff -a and swapon -a.

At the Movies
This week in at the movies, we present a webinar from Espen Braekken of Percona, about Preventing Downtime in Production MySQL Servers. There's a white paper about the subject as well.

Where you can see us
Gerry will be at the March Seattle MySQL User Group on Monday March 5th from 7 - 9 pm. No subject has been set yet.

Sheeri will be at the March Boston MySQL User Group on Monday March 12th from 7 - 9 pm. The meetup topic is to be announced.

Sheeri will be delivering a tutorial on White-hat Google Hacking and MySQL Security at Percona Live: MySQL Conference and Expo from April 10-12th, 2012 in Santa Clara, CA.

Sheeri will also be speaking at the SkySQL and MariaDB Solutions Day on Friday, April 13th, 2012 in Santa Clara, CA, giving a session on creating a data warehouse.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast

Trackback URL for this post:

http://technocation.org/trackback/1149