conferences | speakers | series

Performance Analysis and Troubleshooting Methodologies for Databases

home

Performance Analysis and Troubleshooting Methodologies for Databases
FOSDEM 2021

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