MySQL EXPLAIN: Explained

Adrian Hardy (22.Nov.2008 at 06:00)
Talk at PHP North West 2008 (English - US)

Rating: 5 of 5

Once you have your query returning the correct results, speed becomes an important factor. Speed can either be an issue from the outset, or can creep in as your dataset grows. Understanding the EXPLAIN command is essential to helping you solve and even anticipate slow queries.

Who are you?

Claim talk

By clicking this button you are declaring that you are the speaker responsible for it and a claim request will be sent to the administrator of the event.

If the claim is approved you will be able to edit the information for this talk.

Are you sure?

 
Comments closed.

Comments

Rating: 5 of 5

22.Nov.2008 at 11:35 by

It was really good, as an amateur to Regex it was good to see it explained better than any resource I have found online so far.

Rating: 5 of 5

22.Nov.2008 at 11:36 by

Whoops wrong talk.
But this one was good too, I never knew about EXPLAIN, so was happy to see a talk on something I knew nothing about.
I'm sitting and starting to debug my queries on my website now :-)

Rating: 4 of 5

22.Nov.2008 at 11:49 by

Wish talk was longer ith more info about mysql optimisation in general :-)

info in 30 minutes was helpful though

Rating: 5 of 5

22.Nov.2008 at 15:44 by

Thanks Adrian,

A most excellent talk, very well presented with good slides.

I'll look forward to using EXPLAIN :)

Thanks,

Chris

Rating: 4 of 5

24.Nov.2008 at 09:21 by David Goodwin

Useful talk - if only it had been longer! :-)

Well presented and good content.

Rating: 5 of 5

24.Nov.2008 at 18:23 by Stefan Koopmanschap

Excellent talk, well presented, well explained. Very clear.

Rating: 4 of 5

25.Nov.2008 at 09:00 by

Excellent talk. With such a lot to get through in the 30 min time slot I felt that this talk could have replaced some of the hour ones, giving the speaker time to 'explain' in a little more detail.

Rating: 5 of 5

25.Nov.2008 at 09:10 by Anthony Doherty

A very coherent, well presented talk with lots of practical examples. Seeing the performance boost you get from these simple steps was pretty stunning too. I look forward to putting the practices described to use.

Cloud server hosting by Combell Combell      © Joind.in 2012