Optimizing MySQL Configuration

Location: Portland 252 Level: Intermediate
Average rating: ***..
(3.60, 5 ratings)

MySQL’s configuration file is often the focus of too much attention, and too much tweaking of variables that make no difference — or worse, have the potential to negatively impact performance. The sample default configuration files that come with MySQL are unfortunately not very helpful or good, either. You’ll learn a practical approach to generate a sensible configuration file that sets what’s needed and omits what isn’t. The result will be a more stable and performant server that’s resistant to many common problems.

Photo of Peter Zaitsev

Peter Zaitsev

Percona LLC

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master’s Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.

Comments on this page are now closed.


Cameron Ketcham
08/01/2012 2:30am PDT

anyone able to find the slides? thanks

Picture of Michael Shadle
Michael Shadle
07/19/2012 7:13am PDT

If there are slides, could you post them? Thanks :)


For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at (707) 827-7065 or scordesse@oreilly.com.

View a complete list of OSCON contacts