Ligaya Turmelle (May 20, 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: http://joind.in/184
Slides: MySQL Server Performance Tuning
May 20, 2009, 19:30 by evilangel81
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.
May 21, 2009, 04:25 by jlleblanc
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.
May 27, 2009, 16:17 by philbert
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 :)
Jun 1, 2009, 13:25 by rdohms
Wonderful talk... but all the MySQL are just way too much for one straight talk like this.
Currently not open for comment.
May 20, 2009, 19:02 by elazar
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.