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.
MySQL manual page for correlated subqueries
EXPLAIN cheat sheet
EXPLAIN join types
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".
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