Optimizing MySQL Configuration

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.

Join or login to comment.

  • Rolf

    Long drive but a great talk. Thanks to Peter for keeping the open source spirit alive!

    February 24, 2012

  • Ritz (Rethesh G.

    Great points.. pretty helpful for anyone working on tuning mysql apps

    February 23, 2012

  • A former member
    A former member

    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

  • Jason H.

    The slides are now available in the Files section of this meetup.

    February 23, 2012

  • Jason H.

    Thanks to those who came out tonight! A very good talk!

    February 22, 2012

51 went

Our Sponsors

  • Red Ventures

    QCPHP's primary event sponsor.

  • O'Reilly

    Provides members 40% off print books and 50% off ebooks.

People in this
Meetup are also in:

Sometimes the best Meetup Group is the one you start

Get started Learn more
Katie

I'm surprised by the level of growth I've seen since becoming an organizer, it's given me more confidence in my abilities.

Katie, started NYC ICO

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy