Explaining EXPLAIN: Optimize your SQL Like a Pro

Meeting Description

As CF developers we use SQL all the time, but how many of us have really spent time looking under the hood to see how our favorite RDBMS is taking our SQL and actually executing the query? Most databases provide tools to allow you to do just that. In this talk, you'll learn how to take valuable information provided by MySQL's EXPLAIN tool to optimize your queries. Using examples, you'll learn how you can restructure your SQL and/or use smart indexing to improve query performance, sometimes by orders of magnitude.

About the Speaker

http://photos4.meetupstatic.com/photos/event/c/3/8/4/event_233690052.jpegDan Levine has spent about 15 years working with various database driven applications. His background is in programming using several different languages including ColdFusion. He has experience with SQL Server, Oracle and MySQL. Dan is a Linux enthusiast, which helps with his current role as a MySQL DBA at Vertex Pharmaceuticals. At Vertex, he is part of a team that manages several different types of highly available MySQL environments ranging from single instances to clustered cloud systems. One of his favorite things to do is tune queries and share his knowledge of SQL. He also plays the drums.

Schedule
Refreshments (pizza, soft drinks) will start at 6:30 and the talk will start at 7:00. Beers afterwards down the street at the Atlantic Beer Garden (http://atlanticbeergarden.com/).

When you RSVP: If your Meetup profile name is not your full (First and Last) name, please provide your full name with your response. We'll need those to provide a list to building security on the day of the meeting. Thanks!

Note about parking/public transportation: One Marina Park Drive is located on the South Boston Waterfront, between the Moakley Courthouse and the Institute of Contemporary Art (ICA). Some on-street parking is available near the building (on Seaport Boulevard & Northern Ave). The meters on Seaport Blvd stop at 6 pm, the ones on Northern Ave at 8 pm. There are also several parking lots in the area which charge ~$12-$15. Otherwise you can get there via the T (Silver Line SL1 Courthouse stop), the Number 4 bus (Courthouse stop) (http://www.mbta.com/schedules_and_maps/bus/routes/?route=4), or a 10 minute walk from South Station (https://www.google.com/maps?saddr=South+Station,+Atlantic+Avenue,+Boston,+MA&daddr=ONE+Marina+Park+Drive,+1+Marina+Park+Dr,+Boston,+MA&hl=en&ll=42.353763,-71.050376&spn=0.006351,0.011995&sll=42.352542,-71.050376&sspn=0.006351,0.011995&geocode=FY8-hgIddsjD-ymlls32gXDjiTHRqmPi8ohFTw%3BFZI_hgId4e7D-yFIViKvQ4Ba4ynd_o9DfnDjiTFIViKvQ4Ba4w&oq=one+marin&dirflg=w&mra=ltm&t=m&z=17).