Online / 6 & 7 February 2021

visit

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.

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

Photo of Peter Zaitsev Peter Zaitsev

Attachments

Links