Loading…
Attending this event?
Back To Schedule
Tuesday, June 22 • 11:00am - 11:45am
OtterTune: An Automatic Database Configuration Tuning Service

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Database management systems (DBMS) expose dozens of configurable knobs that control their runtime behavior. Setting these knobs correctly for an application's workload can improve the performance and efficiency of the DBMS. But such tuning requires considerable efforts from experienced administrators, which is not scalable for large DBMS fleets. This problem has led to research on using machine learning (ML) to devise strategies to optimize DBMS knobs for any application automatically. The OtterTune database tuning service from Carnegie Mellon uses ML to generate and install optimized configurations for Postgres, MySQL, and Oracle DBMSs. OtterTune observes the DBMS's workload through its metrics and then trains recommendation models that select better knob values. It then reuses these models to tune other DBMSs more quickly. 

Speakers
avatar for Andy Pavlo

Andy Pavlo

Associate Professor, Carnegie Mellon University
Andy Pavlo is an Associate Professor of Databaseology in the Computer Science Department at Carnegie Mellon University. His (unnatural) infatuation with database systems has inadvertently caused him to incur several distinctions, such as the NSF CAREER (2019), a Sloan Fellowship (2018... Read More →


Tuesday June 22, 2021 11:00am - 11:45am EDT