Optimizing MySQL Queries

Ever wish you were an SQL ninja? Do you think query optimization is something only DBAs should be worried about? Do you want to know what really happens behind the scenes when you SELECT foo FROM bar?

At Achievers, our dev team is dedicated to building a web app that performs blazingly fast. As a result, we're constantly taking a deeper look at all the queries that get executed in our database and fine-tuning them for optimal performance.

At this talk, CTO Dr. Aris Zakinthinos will deliver a highly technical, hands-on presentation on optimizing MySQL queries. From using the MySQL "explain" function, to truly understanding indexes, we're sure this presentation will provide value to every developer that interacts with a database.

RSVP early as spaces are limited.

Join or login to comment.

  • Alex McCausland

    Great, I learned more than I was expecting. Knowledgeable and interesting

    June 15, 2012

  • Achievers Tech Admin

    The slides and cheat sheet have been posted to the Files section. In the Nav bar, just go to More->Files.

    1 · June 14, 2012

  • A former member
    A former member

    Great talk! learned tons.

    June 14, 2012

  • Juan Rojas

    Thanks for the promptly response Aris, you're right, optimization comes last, is just that when you talked about that precise example my mind went directly to the design aspect of a solution and what a best practice in coding is vs what could be a good improvement on performance (but I don't know the specifics when it comes to php and mysql). But nonetheless it's really clear now. Thanks a lot.

    June 14, 2012

  • Aris Zakinthinos

    Juan, thanks for the question. Optimization should always come after making it work. So if your data needs to have NULL values then I wouldn't force it. Otherwise you will have special NULL checks in your code which makes it less readable. However, if you know that NULL isn't needed, or you don't mind a special NULL value then yes your query will be a bit faster. It also has the added benefit of making your indexing smaller. This could be the difference between it fitting in memory and not.

    June 14, 2012

  • Paul Appleby

    Excellent. But needs a second session on Explain and other similar tools. And a session on actually changing the SQL Query for optimization.

    June 14, 2012

  • Daniel Shakhmundes

    Well presented by Mr. Zakinthinos - a good refresher on matters leading to his explanation of EXPLAIN, and very effective explaining - I left satisfied with the newly gained knowledge, which was complimented by cool people and a nicely catered event by Achievers!

    June 14, 2012

  • Christopher Marlow

    Amazingly paced, Aris introduced and explained all the concepts he presented very thoroughly. I'm sure everyone came away a lot more knowledgeable on the topic :)

    June 14, 2012

  • Juan Rojas

    A nice and complete way to understand how MySQL understands querys and how to improve them, honestly before last night, I've never thought how creating some indexes can affect the overall performance of your apps.

    June 14, 2012

  • Juan Rojas

    Nice conference, I got a question afterwards, and maybe you know the answer. Aris said that null columns take 1 extra byte, and the example was a date column..so my question is, if we use a not null in the column type for dates and start using like a Jan 1 1900 as your "null" value..this will increase the performance of the query?

    June 14, 2012

  • Eric Rogness

    Well explained and engaging. Paced perfectly for me to absorb the information.

    June 14, 2012

  • Adrian Mocanu

    I recall someone mentioning that the slides will be posted. Any idea where? Thanks :)

    June 14, 2012

  • Adrian Mocanu

    One of the best tech talks that I've been to. :) Felt like being in a google talk. The talk makes me want to join the Achievers team!!!

    June 14, 2012

  • Ziemek

    Great presentation and layout!

    June 14, 2012

  • Mackenzie Gray

    Real interesting and well presented. Enjoyed and hope they keep on coming! Thanks Achievers!

    June 14, 2012

  • Alfred Ayache

    Outstanding talk. Clarified a number of optimization issues, as well as the meaning and use of the EXPLAIN results. A lot of it is still black magic, of course; but now I have the book of incantations at hand. Thanks Aris!

    June 14, 2012

  • Ed Peciulis

    I loved the in-depth level of detail and was thankful for the advice based on experience in the trenches.

    June 14, 2012

People in this
Meetup are also in:

illustration

Start the perfect Meetup Group for you

Start a Meetup Group

Log in

Not registered with us yet?

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy