OurSQL Episode 79: Removing Evil Queries, part 3

There are a lot of events scheduled for the next few months, we are excited about the international scope and the mix of big and small, paid and free events. This week we finish explaining the output of EXPLAIN. Ear candy is sshfs, at the movies is a presentation on joins and subqueries and how to optimize them.

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

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

Free OTN MySQL Developer Day, Seoul, South Korea, Thursday February 23rd.

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

The Percona Live: MySQL Conference and Expo is from Tuesday, April 10th through Thursday, April 12th. The conference is at the santa clara, california 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. You do not have to be a conference attendee to join, so if you are in the Silicon Valley area on Friday April 13th and want to join a free day-long mini-conference on MySQL topics, we’ll link in the show notes on how to register.

Also on Friday, April 13th in Santa Clara, CA is Drizzle Day - a one-day workshop on all things drizzle. The event is free, but donations are welcome.

Collaborate, the technology and applications forum for the Oracle Community, has 18 MySQL sessions. Collaborate runs from Sunday, April 22nd through Thursday, April 26th, 2012 at the Mandalay Bay Hotel and Casino in Las Vegas Nevada.

The 1st Latin American Conference about MySQL, NoSQL and Cloud technologies will be held in Buenos Aires Wednesday, June 27th through Friday, June 29th at the Puerto Madero Hilton Hotel. It is called the MariaDB NoSQL & Cloud Latin American Conference and we will link to information in the show notes.

The rest of EXPLAIN
Extra
Running EXPLAIN on INFORMATION_SCHEMA

EXPLAIN EXTENDED
EXPLAIN PARTITIONS

pt-visual-explain

SQL Ninja Jay Pipes did some presentations on how to optimize queries and subqueries:
Join-fu: The Art of SQL, Part 1 (PDF slides)
Join-fu: The Art of SQL, Part 2 (PDF slides)
Legend of the Drunken Query Master: The Apprentice's Journey - basically, part 3, but it's not all about joins.

Ear Candy
This week in ear candy we talk about sshfs.

At the Movies
This week we feature a presentation Sheeri did on joins and subqueries, including how to rewrite a subquery as a join. This was a presentation done in January 2010, about 2 years ago, but it is still relevant. http://www.youtube.com/watch?v=YU6QsDvMk1U

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 about VoltDB, a column-based data store.

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