MySQL Spotting Performance Problems 

Get 60% OFF on the Complete Course - MySQL High-Performance Guide Course
www.udemy.com/...
Finding Candidates for Query Optimizations
- Making use of The Performance Schema, which is a gold mine for spotting querying for optimization because it allows us to measure where the time goes
- Finding the few queries that are responsible for most of the load on the system. Checking the top 1000 queries it’s usually not worth your time to optimize.
- How to find the relevant information from the plethora of performance views and metrics available in MySQL
- Understand why UPDATE and DELETE statements are also READS even though they are primarily write statements. This will have an impact on I/O, and therefore the response time.