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. Early bird pricing ends March 12th, 2012.
Use code PL-pod and save 10% off the early bird prices!.

The 1st Latin American Conference about MySQL, NoSQL and Cloud technologies will be held in Buenos Aires in June. It is called the MariaDB NoSQL & Cloud Latin American Conference and we'll bring you more information as it becomes available.

Free Oracle Technology Network Developer Day for MySQL:
Thursday, February 9th, Frankfurt
Tuesday, February 21st, Singapore

MySQL free Tech Tours:
El Segundo, CA - Wed Feb 8th
Dallas, TX - Wed Feb 8th
Santa Clara - Thu Feb 9th

There will also be a High Availability Solutions for MySQL seminar in Kista near Stockholm, Sweden on Thursday February 23rd 2012 to better understand how to achieve High Availability with MySQL.

Where you can find queries
binary log
Episode 43 where we discussed the different binary log formats.

general log

slow log

Tools for parsing logs
pt-query-digest from the Percona toolkit
--limit feature

pt-query-digest examples spoken about can be seen in a presentation by Sheeri about query reviews.

Ear Candy
This week’s ear candy is about a problem you might have with the Python API. Although SHOW GLOBAL autocommit = ON, INSERTs do not commit until an explicit COMMIT is added.

At the Movies
This week in at the movies, we present last month’s Boston MySQL User Group meeting - SkySQL’s Ivan Zoratti talks about MySQL HA Reloaded: Old tricks and cool new tools to guarantee high availability to your MySQL Servers.

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 speaking at Percona Live: MySQL Conference and Expo from April 10-12th, 2012 in Santa Clara, CA.

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