Optimizing MySQL Essentials

Ligaya Turmelle , Ray Deroo (19.May.2011 at 09:30)
Talk at Dutch PHP Conference 2011 (English - US)

Rating: 4 of 5

Do you cringe in fear waiting to hear "The database is slow!"? Are you unsure how to prevent it from happening, other than to cache the content in the hopes it "solves" the problem for now? Are you afraid of your database, thinking of it as a black box that you have no clue how to handle?

Have no fear! This tutorial will provide you with the essential knowledge needed (with some examples) to optimize your MySQL server settings and tune your queries to make it a purring team member obedient to your will and needs.

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: 4 of 5

19.May.2011 at 19:32 by Geoff Davis (4 comments)

Great general tips (including religious arguments), but breezed over the reasoning behind some of the query optimizations, and not enough information about indexes based on those optimizations. But an otherwise informative and mostly well presented talk.

Rating: 4 of 5

20.May.2011 at 09:00 by Steven VAN POECK (37 comments)

I've learned a few interesting things mostly on the server configuration part of the presentation.

M Deroo presented his part in a very interactive and humorous manner which I loved.

Ligaya was a bit nervous at first, but then went on nicely with her part. A few more talks and she'll be a great presenter!

Rating: 4 of 5

20.May.2011 at 11:42 by Rene Pot (5 comments)

Very interesting, and very usefull tips. Covered a lot of ground. Both on the configuring server, and optimizing the database and tables itself, and the queries.

Rating: 4 of 5

20.May.2011 at 11:54 by Derick Rethans (71 comments)

I liked it, and I even managed to pick up some things. However, Raymond should probably leave out the parts about hitting people with bats and breaking fingers.

Rating: 3 of 5

20.May.2011 at 12:14 by Robin Speekenbrink (20 comments)

Liked the talk. Reminded me of talks given by mr. Pipes over the years. Mr. DeRoo seemed to steal the show, but ms Turmelle didnt seem to mind though :)

Rating: 3 of 5

22.May.2011 at 15:50 by Adnan Ibrišimbegović (9 comments)

I'll agree with derick. Raymond obviously has lots of in-depth knowledge about MySQL, but I guess it would be more beneficial to his audiences if he could focus more on sharing this knowledge, instead of "breaking the fingers" every two minutes.

Rating: 4 of 5

22.May.2011 at 20:21 by Anonymous

As entertaining as educational.

© Joind.in 2014