Del
))
Show notes are at https://stevelitchfield.com/sshow/chat.html
…
continue reading
Automatic Database Tuning with Andy Pavlo
Fetch error
Hmmm there seems to be a problem fetching this series right now.
Last successful fetch was on March 18, 2023 22:58 (
What now? This series will be checked again in the next day. If you believe it should be working, please verify the publisher's feed link below is valid and includes actual episode links. You can contact support to request the feed be immediately fetched.
Manage episode 343707392 series 1433944
Av Machine Learning – Software Engineering Daily oppdaget av Player FM og vårt samfunn — opphavsrett er eid av utgiveren, ikke Plaer FM, og lyd streames direkte fra deres servere. Trykk på Abonner knappen for å spore oppdateringer i Player FM, eller lim inn feed URLen til andre podcast apper.
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.
160 episoder
