In this section of the chapter, we will focus on the MySQL 8 troubleshooting approach. Why do we need to troubleshoot MySQL 8? The reasons for troubleshooting are as follows:
- Faster execution of SQL queries
- Performance enhancement
- Efficient use of resources
The primary set of resources include CPU, disk IO, memory, and network. There are two approaches to measure MySQL performance:
- In a query focused approach, it is important to measure how fast the queries get executed
- In resource focused approach, it is important that the queries use fewer resources.
Let us take a deeper look at ways to troubleshoot MySQL problems.
