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.
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.
pt-query-digest examples spoken about can be seen in a presentation by Sheeri about query reviews.
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.