MySQL 8 troubleshooting approach
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.
Analyzing queries
EXPLAIN is the SQL statement that provides information for the way MySQL executes the SQL statements. The EXPLAIN statement works with INSERT, UPDATE, REPLACE, DELETE, and SELECT statements. The output of the EXPLAIN statement is a row of information for each table mentioned or used in the SELECT statement. The output lists the tables...
