Ligaya Turmelle (20.May.2009)
Talk at php|tek 2009 (English - US)
Optimizing the queries you send to the database can greatly increase the database's performance, but what do you know about all those strange MySQL variables that can be played with to get even more power from the database? Join me as we go over some of the basics of the various MySQL settings you can twitch, tweak and massage to get the most out of your MySQL server.
Quicklink: https://joind.in/184
Slides: MySQL Server Performance Tuning
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.2009 at 19:30 by David Murphy
Great presentation, Due to the huge amount of info I understand why using visual feedback slides wouldn't work, tuning mysql could be a day long course easily and she had to condense it. I think she did a great job due to the time constraints. The descriptions of the variables were some of the best I have seen to date I cant wait to review the slides more closely.
20.May.2009 at 20:16 by Ligaya Turmelle
You can find the slides for the talk at http://www.slideshare.net/ligaya/performance-tuning
21.May.2009 at 04:25 by Joseph LeBlanc
This was a good presentation, but it went by quickly. I think she could have showed you how to get the global MySQL config, then focus on three or four of the most common/interesting/misunderstood variables. Definitely a lot of ground to cover.
27.May.2009 at 16:17 by Philip Daly
You needed at least 2 sessions to cover all that information! Perhaps you could have an A + B presentation and divide up materials that way.
Also, although it's impossible to have absolute numbers to offer as 'good' performance values - there most certainly are rules-of-thumb, ratios and percentages that can be generally suggested as performance red-flags that require investigation. Including those in the presentation would help, albeit with a big "YMMV" slapped on them!
My preference is for less wordy slides - but you already acknowledged that you needed them for the presentation, which is fair.
For a first-time presentation I thought you did admirably :)
01.Jun.2009 at 13:25 by Rafael Dohms
Wonderful talk... but all the MySQL are just way too much for one straight talk like this.
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!
20.May.2009 at 19:02 by Matthew Turland
Good presentation. While the technical depth of the slides is good for reading outside of the presentation, they don't provide good visual feedback to the audience while that content is being presented verbally. See the book Presentation Zen. More visuals arranged around problems, causes, and effects might make the slide deck stronger.