Performance Analysis and Troubleshooting Methodologies for Databases
- Track: Monitoring and Observability devroom
- Room: D.monitoring
- Day: Sunday
- Start: 13:00
- End: 13:30
- Video with Q&A: D.monitoring
- Video only: D.monitoring
- Chat: Join the conversation!
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.
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.
- Introduce the Challenge of Troubleshooting by Random Googling
- Introduce USE Method, how it applies to databases
- Introduce RED Method, how it applies to databases
- Introduce Golden Signals
- Provide High-Level Comparison of Methods as a take away
Speakers
Peter Zaitsev |