You are handled a MySQL, MariaDB, or Percona Server database server and asked to have a look at it, to check if the server is “well-tuned” and whether there is anything obviously wrong with it; where do you start?
This may sound like an overwhelming task for a beginner DBA, and MySQL doesn’t really facilitate much on this front with its dozens of customizable variables. There are, however, multiple ways to approach this challenge.
At Percona Support, we have a method for such an initial assessment, one that has been crafted in the early years of the company and improved by all the Support Engineers, remote DBAs, and Consultants that have worked and still work in the Services team. During this talk, I will walk you through this method, explaining how you can make use of a handful of tools available in the Percona Toolkit to extract the diagnostics data we need from the server and how to interpret the main points.
Speaker: Fernando Laudares Camargos – Percona