---
title: Top Most-Overlooked MySQL Performance Optimizations
---

Search

Search

![percona-logo](https://learn.percona.com/hs-fs/hubfs/percona-logo.png?width=280&height=58&name=percona-logo.png)

 

Search

Search

## 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

### Registration Form

- PERCONA
- [Performance Blog](https://www.percona.com/blog/)
- [Forums](https://www.percona.com/forums/)
- [Online Tools](https://tools.percona.com/)
- [Percona Live](https://www.percona.com/live/conferences)
- [Support Portal](https://www.percona.com/services/support/contact)
- Contact

- [Services](https://www.percona.com/services)
- [Support](https://www.percona.com/services/support)
- [Managed Services](https://www.percona.com/services/managed-services)
- [Consulting](https://www.percona.com/services/consulting)
- [Training](https://www.percona.com/training)

- [Software](https://www.percona.com/software)
- [MySQL Software](https://www.percona.com/software/mysql-database)
- [MongoDB Software](https://www.percona.com/software/mongo-database)
- [PostgreSQL Distribution](https://www.percona.com/software/postgresql-distribution)
- [Percona Monitoring & Management](https://www.percona.com/software/database-tools/percona-monitoring-and-management)
- [Open Source Database Tools](https://www.percona.com/software/mysql-tools)

- [Resources](https://www.percona.com/resources)
- [Datasheets](https://www.percona.com/resources/datasheets)
- [Solution Briefs](https://www.percona.com/resources/solution-brief)
- [White Papers](https://www.percona.com/resources/white-papers)
- [Webinars](https://www.percona.com/resources/webinars)
- [Case Studies](https://www.percona.com/about-percona/case-studies)

**[CONTACT US](https://www.percona.com/about-percona/contact)**  
[(888) 316-9775 (USA)](tel:(888)%20316-9775)  
[(208) 473-2904 (USA)](tel:(208)%20473-2904)  
[+44 203 608 6727 (UK)](tel:+44%20203%20608%206727)  
[0-800-051-8984 (UK)](tel:0-800-051-8984)  
[0-800-724-4569 (GER)](tel:0-800-724-4569)

- [Community](https://www.percona.com/community)
- [Forums](https://www.percona.com/forums/)
- [Database Performance Blog](https://www.percona.com/blog/)
- [YouTube](https://www.youtube.com/channel/UCLJ0Ok4HeUBrRYF4irturVA)
- [GitHub](https://github.com/percona)

- [Conferences](https://www.percona.com/live/conferences)
- [Percona Live](https://www.percona.com/live/conferences)
- [Other Events](https://www.percona.com/community/events)

- [About](https://www.percona.com/about-percona)
- [Team](https://www.percona.com/about-percona/team)
- [Careers](https://www.percona.com/about-percona/careers)
- [Contact](https://www.percona.com/about-percona/contact)

[Twitter](https://twitter.com/percona) [Facebook](https://www.facebook.com/Percona?fref=ts) [LinkedIn](https://www.linkedin.com/company/percona) [Launch](https://launchpad.net/percona-project)

![](https://learn.percona.com/hubfs/layout/sm-logo.png)

MySQL and InnoDB are trademarks of Oracle Corp. Proudly running Percona Server. Copyright © 2006-2026 Percona LLC.

[Copyright, Trademark, and Privacy Policy](https://www.percona.com/about-percona/policies)

![](https://px.ads.linkedin.com/collect/?pid=95128&fmt=gif)