Andy Pavlo's guest appearances

Andy Pavlo

Software Engineering Daily

Machine Learning Archives - Software Engineering Daily

Podcast Archives - Software Engineering Daily

Orchestrate all the Things podcast: Connecting the Dots with George Anadiotis

Big Ideas in App Architecture

OwlTail

This week, we’re with one of those masters of database building, Andy Pavlo, an Associate Professor with indefinite tenure of databaseology in the computer science department at Carnegie Mellon University and the Co-Founder of OtterTune. Andy discusses how his introduction to “databaseology” changed the way databases are not only built but also studied for more efficiency at companies. From optimizing databases for efficient testing and usage to building effective databases using the right knobs and building blocks, Andy shares his insights and expertise on how to improve the performance and reliability of your applications. Join as we discuss:The emerging field of databaseology and its importance for efficient testing and usage.The design and implementation of effective databases using the right knobs and building blocks.Latest trends and techniques in database management and design that can improve application performance.Be sure to rate the podcast on your favorite podcast platform like Apple and Spotify! You can also watch every episode of Big Ideas in App Architecture by going to our YouTube page!

This week, we’re with one of those masters of database building, <a href="https://www.cs.cmu.edu/~pavlo/" rel="noreferrer noopener nofollow" target="_blank">Andy Pavlo</a>, an Associate Professor with indefinite tenure of databaseology in the computer science department at Carnegie Mellon University and the Co-Founder of <a href="https://ottertune.com/" rel="noreferrer noopener nofollow" target="_blank">OtterTune</a>. Andy discusses how his introduction to “databaseology” changed the way databases are not only built but also studied for more efficiency at companies. From optimizing databases for efficient testing and usage to building effective databases using the right knobs and building blocks, Andy shares his insights and expertise on how to improve the performance and reliability of your applications. Join as we discuss: <ul><li>The emerging field of databaseology and its importance for efficient testing and usage.</li><li>The design and implementation of effective databases using the right knobs and building blocks.</li><li>Latest trends and techniques in database management and design that can improve application performance.</li></ul>Be sure to rate the podcast on your favorite podcast platform like <a href="https://podcasts.apple.com/us/podcast/big-ideas-in-app-architecture/id1670998452" rel="noreferrer noopener nofollow" target="_blank">Apple</a> and <a href="https://open.spotify.com/show/7cy7mIyFCRd5GTTa40hR0g?si=b46adf77f4774dc8" rel="noreferrer noopener nofollow" target="_blank">Spotify</a>! You can also watch every episode of Big Ideas in App Architecture by going to our <a href="https://www.youtube.com/playlist?list=PL_QaflmEF2e_qCul_43FZ76FPEPodRScX" rel="noreferrer noopener nofollow" target="_blank">YouTube</a> page!

Database Benchmarking Efficiency with OtterTune’s Andy Pavlo

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.

<a href="https://i1.wp.com/softwareengineeringdaily.com/wp-content/uploads/2022/09/Andy-Pavlo.png" rel="nofollow" target="_blank"></a>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 <ul> <li>they are not standardized (i.e., two databases may have a different name for the same knob),</li> <li> not independent (i.e., changing one knob can impact others), </li> <li>and not universal (i.e., what works for one application may be suboptimal for another). </li> </ul> In reality, information about the effects of the knobs typically comes only from (expensive) experience. <a href="https://ottertune.com/" rel="nofollow" target="_blank">OtterTune</a> 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<a href="https://twitter.com/andy_pavlo?lang=en" rel="nofollow" target="_blank"> Andy Pavlo</a>. Andy is a Database Professor at Carnegie Mellon and Co-Founder of OtterTune. Sponsorship inquiries: <a href="mailto:sponsor@softwareengineeringdaily.com" rel="noopener noreferrer">sponsor@softwareengineeringdaily.com</a> The post <a href="https://softwareengineeringdaily.com/2022/09/22/automatic-database-tuning/" rel="nofollow" target="_blank">Automatic Database Tuning with Andy Pavlo</a> appeared first on <a href="https://softwareengineeringdaily.com" rel="nofollow" target="_blank">Software Engineering Daily</a>.

Automatic Database Tuning with Andy Pavlo

Tuning databases is key to application performance and stability, but it's a hard job. Auto-tuning helps, but it was reserved for the Oracles and Microsofts of the world till now. OtterTune wants to democratize this capability Databases are the substrate on which most applications run. Although different applications have different needs served by different databases, they all have one thing in common: they are complex systems that need continuous fine tuning to work optimally. Databases come with a plethora of parameters that can be tuned by "turning knobs". Traditionally, this has been the job of Database Administrators (DBAs). Their job is a hard one, as they need to know the specifics of the database, the hardware it's running on, and the workloads it serves. Some database vendors like IBM, Microsoft and Oracle have taken steps to automate this work. OtterTune is a startup that wants to democratize this capability. Today OtterTune is announcing the private beta of its new automatic database tuning service, as well as an initial $2.5 million seed funding round led by Accel. Article published on ZDNet

Tuning databases is key to application performance and stability, but it's a hard job. Auto-tuning helps, but it was reserved for the Oracles and Microsofts of the world till now. OtterTune wants to democratize this capability Databases are the substrate on which most applications run. Although different applications have different needs served by different databases, they all have one thing in common: they are complex systems that need continuous fine tuning to work optimally. Databases come with a plethora of parameters that can be tuned by "turning knobs". Traditionally, this has been the job of Database Administrators (DBAs). Their job is a hard one, as they need to know the specifics of the database, the hardware it's running on, and the workloads it serves. Some database vendors like IBM, Microsoft and Oracle have taken steps to automate this work. OtterTune is a startup that wants to democratize this capability. Today OtterTune is announcing the private beta of its new automatic database tuning service, as well as an initial $2.5 million seed funding round led by Accel. <a href="https://www.zdnet.com/article/ottertune-sets-out-to-auto-tune-all-the-databases/" rel="nofollow" target="_blank">Article published on ZDNet</a>