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
binlog_format
Episode 43 where we discussed the different binary log formats.

general log
log_output

slow log
slow_query_log
slow_query_log_file
long_query_time
log_queries_not_using_indexes
min_examined_row_limit

Tools for parsing logs
mysqldumpslow
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.

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/1148