The MySQL collector allows to insert the following types of anomalies in an Anomalies profile:Aborted connections
Number of connections aborted because the client died without closing the connection properly.Failed connections
Number of tries to connect to the MySQL Server that failedKey cache hit rate
Percentage of times a key read is handled from the key buffer cache.Key buffer used (%)
Percentage of key buffer cache usedTables opened
Number of opened table. If the number of opened tables is high, your cacheTable locks waited
may be too small (table_cache parameter).
Number of times a table lock could not be acquired immediately and aSelect full join
wait was needed. If this is high, and you have performance problems,
you should first optimise your queries, and then either split your
table(s) or use replication.
The number of joins that do not use indexes.Slow query
Number of queries that have taken more than slow_launch_time to create.Read next row in the datafile
The number of requests to read the next row in the data file. This will be high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.Sort merge pass
The number of merge passes the sort algorithm has had to do. If this value is large, you should consider increasing the value of the
Copyright © AgileLoad. All rights reserved.