Ligaya Turmelle , Ray Deroo (19.May.2011 at 09:30)
Talk at Dutch PHP Conference 2011 (English - US)
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.
Quicklink: https://joind.in/3215
Track(s): Track 4 / Uncon
Slides: Optimizing MySQL Essentials
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?
20.May.2011 at 07:00 by Steven VAN POECK (14 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!
20.May.2011 at 09: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.
20.May.2011 at 09:54 by Derick Rethans (69 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.
20.May.2011 at 10:14 by Robin Speekenbrink (9 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 :)
22.May.2011 at 13: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.
22.May.2011 at 18:21 by Anonymous
As entertaining as educational.
Know of an event happening? Let us know! We love to get the word out about events the community would be interested in and you can help us spread the word!
Is this your talk? Claim it! By doing so it lets us know you are the speaker. Once your claim is verified by event administration it will be linked to your account.
19.May.2011 at 17:32 by Geoff Davis (2 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.