I recently started using Percona monitoring tool and I felt some difficult in understanding the metrics and Query Analysis Output like
- MySQL Throughput
- MySQL SelectTypes
- MySQL Command
Also, I need some help in understanding the AvgMYSQL/Queries, AvgMySQL/Select_Scan, 5/95, Min/Max etc.,
Along with the above, when I am monitoring what are the expensive queries under “Queries” tab, I can see different terms like Load, Load%, 95%.
Also, when I execute any query for 1 time on my MYSQL DB server , but percona query monitoring is showing the query execution as 2 …Can any one explain what is the reason for that.
Last but not least, I can understand the File sort, Full Join, Full Scan under the query plan, but I could not able to understand the pecentage values for each operation (filesort,full join, and full scan) for a particular query.
Can any one please help me out in understanding the above items.