Basic Internal Troubleshooting Tools for MySQL Server
MySQL Server has many built-in troubleshooting tools. They are always available and can provide many insights on what is happening internally.
Many graphical tools, such as Percona Monitoring and Management (PMM), use built-ins to get data for their nice graphs. Even if you are only going to use graphical tools, it is always good to know what data they can collect so you can see their limitations and won't have incorrect expectations in the heat of battle.
Built-in troubleshooting tools are accessible via SQL commands. Most of them are standard across the server, but details are component-specific.
In this webinar I will discuss how to use them, how to troubleshoot component-specific issues and how to find additional information.
I will cover SHOW commands, Information Schema, status variables and few component-specific syntaxes.
I will NOT cover Performance Schema (there will be a separate webinar on that), and I will use PMM graphs to illustrate the topics whenever possible.