Participate in the State of Distributed Systems Survey | Take Survey

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
Share on facebook
Share on twitter
Share on email
Share on linkedin
Share on facebook
Share on twitter
Share on email
Share on linkedin
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.

P99 CONF OCT. 6-7, 2021

REGISTER FOR YOUR FREE TICKET