Optimizing MySQL Configuration

Database Administration
4 December 11:30 - 12:20 @ Orchard 2

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.

Speakers

Peter Zaitsev
CEO, Percona Inc
Speaker Biography: 
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.


Slides