Performance Analysis and Troubleshooting Methodologies for Databases

Have you heard about the USE Method (Utilization – Saturation – Errors), RED (Rate – Errors – Duration), or Golden Signals (Latency – Traffic – Errors – Saturations)? In this presentation, we will talk briefly about these different, but similar “focuses” and discuss how we can apply them to the data infrastructure performance analysis troubleshooting, and monitoring. We will use MySQL as an example but most of the talk will apply to other database technologies as well. Outline to use if needed. – Introduce the Challenge of Troubleshooting by Random Googling (1min) – Introduce USE Method, how it applies to databases (5 min) – Introduce RED Method, how it applies to databases (5 min) – Introduce Golden Signals (4 min) – Provide a High-Level Comparison of Methods as a takeaway (4 min)

17 Minutes
Peter Zaitsev

Peter Zaitsev, CEO and Co-Founder of Percona

Peter Zaitsev is the co-founder and CEO of Percona, a provider of open-source enterprise-class MySQL, MongoDB, MariaDB and PostgreSQL software, solutions, and services. Co-author of High Performance MySQL: Optimization, Backups, and Replication, and the ebook Practical MySQL Performance Optimization, Zaitsev blogs regularly on the Percona Database Performance Blog and speaks frequently at conferences worldwide. Peter lives in North Carolina with his wife and two children and enjoys travel and spending time outdoors.

Register for 2 days of keynotes & interactive tech talks on all things P99.

Virtual Event

October 19-20, 2022

Share on social with #p99conf and a link to p99conf.io for a chance to win $500.