Buy Percona ServicesBuy Now!
  Thursday, July 28, 2016
   Muhammad Irfan

Top Most-Overlooked MySQL Performance Optimizations

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

Muhammad Irfan
Software Engineer
Muhammad Irfan is vastly experienced in the LAMP Stack. He joined Percona in December 2012 as Support Engineer. Prior to joining Percona, 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. In his spare time, he normally spends time with family and friends and loves to play and watch cricket. He currently lives in Karachi, Pakistan, with his wife and son.

Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.