1,034 subscribers
התחל במצב לא מקוון עם האפליקציה Player FM !
Automatic Database Tuning with Andy Pavlo
Manage episode 343707392 series 1433944
The default configuration in most databases is meant for broad compatibility rather than performance. Database tuning is a process in which the configurations of a database are modified to achieve optimal performance. Databases have hundreds of configuration knobs that control various factors, such as the amount of memory to use for caches or how often the data is written to the storage.
The problem with these knobs is that
- they are not standardized (i.e., two databases may have a different name for the same knob),
- not independent (i.e., changing one knob can impact others),
- and not universal (i.e., what works for one application may be suboptimal for another).
In reality, information about the effects of the knobs typically comes only from (expensive) experience.
OtterTune is automatic database tuning software that promises to overcome these problems. It uses machine learning to tune the configuration knobs of your database automatically to improve performance.
In this episode, we interview Andy Pavlo. Andy is a Database Professor at Carnegie Mellon and Co-Founder of OtterTune.
Sponsorship inquiries: sponsor@softwareengineeringdaily.com
The post Automatic Database Tuning with Andy Pavlo appeared first on Software Engineering Daily.
176 פרקים
Manage episode 343707392 series 1433944
The default configuration in most databases is meant for broad compatibility rather than performance. Database tuning is a process in which the configurations of a database are modified to achieve optimal performance. Databases have hundreds of configuration knobs that control various factors, such as the amount of memory to use for caches or how often the data is written to the storage.
The problem with these knobs is that
- they are not standardized (i.e., two databases may have a different name for the same knob),
- not independent (i.e., changing one knob can impact others),
- and not universal (i.e., what works for one application may be suboptimal for another).
In reality, information about the effects of the knobs typically comes only from (expensive) experience.
OtterTune is automatic database tuning software that promises to overcome these problems. It uses machine learning to tune the configuration knobs of your database automatically to improve performance.
In this episode, we interview Andy Pavlo. Andy is a Database Professor at Carnegie Mellon and Co-Founder of OtterTune.
Sponsorship inquiries: sponsor@softwareengineeringdaily.com
The post Automatic Database Tuning with Andy Pavlo appeared first on Software Engineering Daily.
176 פרקים
Alla avsnitt
×

1 Anaconda and Accelerating AI Development with Rob Futrick 44:21






1 JetBrains AI with Jodie Burchell 55:01


1 AWS re:Invent Special: Sagemaker with Ankur Mehrotra 35:23


1 Pinecone Vector Database with Marek Galovic 39:29




1 GitHub Copilot with Joseph Katsioloudes 50:14


1 Weights & Biases with Chris Van Pelt 38:22






1 GraphAware with Luanne Misquitta 57:51


1 Speechlab and Realtime Translation with Ivan Galea 44:31




1 Stack Overflow in the AI era with Ellen Brandenberger 47:55
ברוכים הבאים אל Player FM!
Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.