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.
Google Cloud Platform: MySQL at Scale with Reliable HA
Analytical Queries in MySQL - PLO October 2020
MySQL Ecosystem on ARM - Krunal Bauskar - Percona Live ONLINE 2020
How Does Geo-Replication Work in TiDB? - Jay Lee - Percona Live ONLINE
SQL Row Store vs Data Warehouse: Which Is Right for Your Application? - Robert Hodges - PLO October 2020
Introducing Kunlun Distributed Database Cluster - David Zhao Wei - Percona Live ONLINE 2020