Automatic Database Tuning with Andy Pavlo

Machine Learning Archives - Software Engineering Daily

Το περιεχόμενο παρέχεται από το Machine Learning Archives - Software Engineering Daily. Όλο το περιεχόμενο podcast, συμπεριλαμβανομένων των επεισοδίων, των γραφικών και των περιγραφών podcast, μεταφορτώνεται και παρέχεται απευθείας από τον Machine Learning Archives - Software Engineering Daily ή τον συνεργάτη της πλατφόρμας podcast. Εάν πιστεύετε ότι κάποιος χρησιμοποιεί το έργο σας που προστατεύεται από πνευματικά δικαιώματα χωρίς την άδειά σας, μπορείτε να ακολουθήσετε τη διαδικασία που περιγράφεται εδώ https://el.player.fm/legal.

3y ago 39:54

MP3•Αρχική οθόνη επεισοδίου

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: [email protected]

The post Automatic Database Tuning with Andy Pavlo appeared first on Software Engineering Daily.

176 επεισόδια

#Data Science #Science #Machine Learning #Tech #Machine Learning Archives Software Engineering Daily