Artwork

Innhold levert av Machine Learning Archives - Software Engineering Daily. Alt podcastinnhold, inkludert episoder, grafikk og podcastbeskrivelser, lastes opp og leveres direkte av Machine Learning Archives - Software Engineering Daily eller deres podcastplattformpartner. Hvis du tror at noen bruker det opphavsrettsbeskyttede verket ditt uten din tillatelse, kan du følge prosessen skissert her https://no.player.fm/legal.
Player FM - Podcast-app
Gå frakoblet med Player FM -appen!

Automatic Database Tuning with Andy Pavlo

39:54
 
Del
 

Manage episode 343707392 series 1433944
Innhold levert av Machine Learning Archives - Software Engineering Daily. Alt podcastinnhold, inkludert episoder, grafikk og podcastbeskrivelser, lastes opp og leveres direkte av Machine Learning Archives - Software Engineering Daily eller deres podcastplattformpartner. Hvis du tror at noen bruker det opphavsrettsbeskyttede verket ditt uten din tillatelse, kan du følge prosessen skissert her https://no.player.fm/legal.

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.

  continue reading

175 episoder

Artwork
iconDel
 
Manage episode 343707392 series 1433944
Innhold levert av Machine Learning Archives - Software Engineering Daily. Alt podcastinnhold, inkludert episoder, grafikk og podcastbeskrivelser, lastes opp og leveres direkte av Machine Learning Archives - Software Engineering Daily eller deres podcastplattformpartner. Hvis du tror at noen bruker det opphavsrettsbeskyttede verket ditt uten din tillatelse, kan du følge prosessen skissert her https://no.player.fm/legal.

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.

  continue reading

175 episoder

Alle episoder

×
 
Loading …

Velkommen til Player FM!

Player FM scanner netter for høykvalitets podcaster som du kan nyte nå. Det er den beste podcastappen og fungerer på Android, iPhone og internett. Registrer deg for å synkronisere abonnement på flere enheter.

 

Hurtigreferanseguide

Copyright 2024 | Sitemap | Personvern | Vilkår for bruk | | opphavsrett