Automatic MySQL Optimization

OtterTune removes the burden of having to understand all of the MySQL configuration knobs...

Let Machine Learning automate your MySQL tuning

If you’re unfamiliar with the MySQL configuration settings, your database performance and scalability might be suffering. OtterTune solves this problem by using machine learning to automatically optimize 150+ MySQL configuration settings to help keep your database performance optimized for its specific workload.

Webcast Jan. 11: Human-in-the-Loop Control over Auto-tuning

Benchmark: Increase MySQL Performance 4x

Still running with the default MySQL configuration? Tuning MySQL on Amazon RDS with OtterTune boosted transaction throughput over 4x. Get faster application performance, or lower cloud costs by downsizing or consolidating instances.

Read the benchmark

Deep dive: Using Machine Learning to Automatically tune MySQL

In this talk from Percona Live 2021, OtterTune CEO and Co-founder, Andy Pavlo explains the research behind using machine learning (ML) to generate and install optimized MySQL configurations for any application automatically. OtterTune observes the DBMS’s workload through its metrics and then trains recommendation models that select better knob values. He also highlights the lessons learned from real-world installations of OtterTune to tune MySQL.

How does automatic MySQL database tuning work?

1Connect

Securely connect OtterTune to your Amazon RDS or Aurora MySQL database. OtterTune does NOT require access to queries or user data.

2Collect

OtterTune efficiently retrieves information about your MySQL database's hardware, knob configurations, and metrics.

3Optimize

Using machine learning, OtterTune optimizes 150+ MySQL configuration settings to improve your database performance. You can control how and when OtterTune applies changes to MySQL.

What MySQL knobs does OtterTune optimize?

OtterTune removes the burden of having to understand over 150 performance-related MySQL configuration knobs…how they impact performance and cost, how they interact with each other, and how they should change as your MySQL workload changes. OtterTune optimizes dozens of knobs related to:

Caching
Buffering
Paging
Logging
Threading
and others…

View the full list of 150+ MySQL configuration settings OtterTune optimizes…