Performance Audits for MySQL

A performance audit is one of Percona's most popular services for MySQL databases. It is a comprehensive review of your MySQL server: configuration, operating system, hardware configuration, application architecture, table design, indexing, queries, capacity, and scaling potential. If performance problems lie outside of MySQL, such as in your web server, we can usually diagnose that too. Most audits lead to substantial performance gains. Audits are for when your MySQL application is already suffering performance problems, or for finding performance problems that you are not aware of.

We inspect your system remotely, and then communicate via phone, chat, and email. We begin with a kickoff call with your key technical staff to understand your goals and pain points. After that our approach is like a physician trying to discover an undiagnosed malady. We scan for anomalies in every aspect of your server. We measure scientifically, prioritize opportunities for improvement, and investigate solutions.

The thoroughness of the audit is up to you. You decide whether you want us to look but don't touch, or fix things as we go and tell you about it later. Most systems need about 10 hours for a good audit, and complex ones might need more. If your budget limits you, we will do our best in the time you desire, but five hours is the minimum length audit we will attempt.

If you are interested in a performance audit of your MySQL database system, you might like to read our white paper on Goal-Driven Performance Optimization, or our blog post about performance audits. You should also read Percona's Access Readiness Checklist. It details preparatory steps to avoid wasted billable time.