Query Analysis in MySQL, PostgreSQL, MongoDB

on YouTube ↗50m

" summary

Describes building a deep query-performance analysis tool for Percona Monitoring and Management that collects query-level data from MySQL, PostgreSQL and MongoDB, stores it in ClickHouse for high-performance queries, and provides ways to analyze and visualize that data to improve performance of highly available systems.

AI-written summary · about

" chapters (8)

1. 0:00Introduction to DB optimization
2. 2:58SRE and performance
3. 7:19Performance issues
4. 16:37Query analysis
5. 27:36Common DB problems
6. 31:07Optimizing specific queries
7. 38:01Processes and tips
8. 39:28Q&A

" related talks

• 57mQuery Performance Analysis in ClickHouseAleksey Milovidov · HighLoad++ Moscow 2018
• 35mBest Practices for MySQL PerformanceRoman Novykov · Highload fwdays'17
• 50mHow To Improve PostgreSQL Monitoring and Observability With PMM - Part 2Charly Batista, Agustin Gallego · Percona Live 2022
• 21mEasy way of application monitoringCihan Tunali · Percona University Istanbul 2022
• 33mMongoDB Monitoring and Alerting With PMMIvan Groenewold · Percona Live 2022
• 51mPostgreSQL Query Performance InsightsHamid Quddus Akhtar · Percona Live 2022
• 03mMonitoring and Management DemoMichael Coburn · Percona Live Open Source Database Conference Europe 2017
• 51mHow to improve PostgreSQL Monitoring and ...Charly Batista, Agustin Gallego · PGConf NYC 2021