Nick Pisarro, aka @highenergybeams, suggested we do a podcast about the MySQL defaults we recommend always having, as MySQL's pre-configured option files are not particularly helpful. So we have put together a 2-part podcast on the options that we change.
Note: We use the term "directive" to refer to the groups of options that begin with [groupname]. Upon reading the manual page again, we realized that the term is actually "option group". (Sheeri takes complete blame for this -- "directive" is actually the term for what !includedir and !include are...)
Video for the presentation at the 2009 MySQL Camp:
by Morgan Tocker
The best way to performance tune a system is to find out what your bottlenecks are, and attacking those first. In the first part of this session, I'll be looking at some of the issues faced with common database workloads. From there, I'll then be showing how you can get more information out of MySQL and your Operating System to find out about your workload. This session is designed for beginner to intermediate MySQL users.