Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Top Most-Overlooked MySQL Performance Optimizations

Top Most-Overlooked MySQL Performance Optimizations

 20 April 04:30 PM - 05:20 PM @ Ballroom C
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Architecture/Design
Scalability/Performance
Topics:
MySQL
Optimization

Description

MySQL is lightweight, stable and fast. But it is not uncommon to meet people having performance issues with MySQL -- even when the workload is moderate. What happened to them? Did they have excessive expectations about MySQL performance and scalability? Did they misconfigure their system? Or did they simply forget some prerequisites? Talking about simple items that you you need to know before deployment is the goal of this talk. We will discuss (among other things): - How to configure MySQL to get good performance without spending weeks adjusting the my.cnf file - How to find missing indexes and useless duplicate indexes - How to design tables: normalization vs denormalization, partitioning - How to choose hardware depending for the expected workload - How to find the queries that hurt performance

Speakers

Muhammad Irfan's picture

Muhammad Irfan

Support Engineer, Percona

Biography:

Muhammad Irfan is vastly experienced in LAMP Stack. Prior to joining Percona Support, he worked in the role of MySQL DBA & LAMP Administrator, maintained high traffic websites, and worked as a Consultant. His professional interests focus on MySQL scalability and on performance optimization.

Stephane Combaudon's picture

Stephane Combaudon

Database Engineer, Slice Technologies

Biography:

Stephane has worked for almost 15 years in open source environments, and has spent most of the last 10 years solving performance or high-availability problems with MySQL and more recently MongoDB. He is now working for Slice Technologies, a company that helps you keep track of your online purchases. His main role is to automate MySQL and MongoDB operations, and from time to time, he is also very excited to kill a nasty query or add a missing index on a 500GB table. When not in front of a computer, Stéphane likes spending time with his family. He also hopes to become a decent chess player someday.

Share this talk


Slides