Optimizing MySQL Configuration
- February 22, 2012 · 7:00 PM
DUE TO SCHEDULING CONFLICTS, THIS MEETUP HAS BEEN RESCHEDULED FOR WEDNESDAY, FEBRUARY 22ND. PLEASE UPDATE YOUR PLANS ACCORDINGLY! SORRY FOR THE LATE NOTICE.
Introduction
Optimizing MySQL Configuration 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.
Speaker
Peter Zaitsev
Founder and CEO, Percona
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.
About Percona
Experts in MySQL and InnoDB Performance. Percona is the oldest and largest independent MySQL support and consulting company, with a global 24x7 staff serving more than 1,200 customers in 50+ countries since 2006. Our clients achieve breakthrough results with MySQL: cost savings, faster time to market, higher system uptime, and long-term scalability. With Percona, you can execute with confidence and clarity.
-
Rolf
Long drive but a great talk. Thanks to Peter for keeping the open source spirit alive!
February 24, 2012
-
Rethesh George (Ritz)
Great points.. pretty helpful for anyone working on tuning mysql apps
February 23, 2012
-
David Olson
Although I am a novice developer, I gathered a great deal of information from Peter's presentation last night (and won the book prize!). From my notes:
- Maintain same configuration settings across servers
- Keep records of config settings, including date, using comments
- MySQL in cloud environment not secure
- 'Innoddb_buffer_pool_size'
is most important memory setting (80% of memory allocated here)February 23, 2012
-
-
51 attended
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Clint Berry +1
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
A former member+1 guest
-
A former member+1 guest
-
A former member
-
A former member
Join or login to comment.