eG Monitoring

Measures reported by MySQLIndexIOTest This test auto-discovers the top indexes that are I/O intensive and for each index, reports the wait time and the read/write latency. Using this test, administrators can figure out the index that is experiencing slowness due to high read and write latencies. Outputs of the test : One set of results for every index in the target MySQL Database instance The measures made by this test are as follows:
Measurement | Description | Measurement Unit | Interpretation
--- | --- | --- | ---
WaitCount | Indicates the number of waits recorded on this index during the last measurement period. | Number |
AverageWaitTime | Indicates the average time spent by a query per wait to fetch data from this index during the last measurement period. | Seconds/Wait |
MinWaitTime | Indicates the minimum time spent by a query per wait to fetch data from this index during the last measurement period. | Seconds/Wait |
MaxWaitTime | Indicates the maximum time spent by a query per wait to fetch data from this index during the last measurement period. | Seconds/Wait | Ideally, the value of this measure should be low. A sudden/gradual increase in the value of this measure is a cause of concern. Compare the value of this measure across indexes to identify the index that is experiencing maximum wait time.
AverageReadLatency | Indicates the average time taken to read from this index during the last measurement period. | Seconds/Read |
MinReadLatency | Indicates the minimum time taken to read from this index during the last measurement period. | Seconds/Read |
MaxReadLatency | Indicates the maximum time taken to read from this index during the last measurement period. | Seconds/Read | Ideally, the value of this measure should be low. A sudden/gradual increase in the value of this measure is a cause of concern. Compare the value of this measure across indexes to identify the index that is experiencing maximum read latency.
AverageWriteLatency | Indicates the average time taken to write into this index during the last measurement period. | Seconds/Write |
MinWriteLatency | Indicates the minimum time taken to write into this index during the last measurement period. | Seconds/Write |
MaxWriteLatency | Indicates the maximum time taken to write into this index during the last measurement period. | Seconds/Write | Ideally, the value of this measure should be low. A sudden/gradual increase in the value of this measure is a cause of concern. Compare the value of this measure across indexes to identify the index that is experiencing maximum write latency.
AverageFetchLatency | Indicates the average time taken to fetch the records from this index during the last measurement period. | Seconds/Fetch |
MinFetchLatency | Indicates the minimum time taken to fetch the records from this index during the last measurement period. | Seconds/Fetch |
MaxFetchLatency | Indicates the maximum time taken to fetch the records from this index during the last measurement period. | Seconds/Fetch | Ideally, the value of this measure should be low. A sudden/gradual increase in the value of this measure is a cause of concern. Compare the value of this measure across indexes to identify the index that is consuming maximum time to fetch records.
AverageInsertLatency | Indicates the average latency noticed while inserting data into this index during the last measurement period. | Seconds/Insert |
MinInsertLatency | Indicates the minimum latency noticed while inserting data into this index during the last measurement period. | Seconds/Insert |
MaxInsertLatency | Indicates the maximum latency noticed while inserting data into this index during the last measurement period. | Seconds/Insert | Ideally, the value of this measure should be low. A sudden/gradual increase in the value of this measure is a cause of concern. Compare the value of this measure across indexes to identify the index that is consuming maximum time while data is inserted into the index.
AverageUpdateLatency | Indicates the average latency noticed while updating this index during the last measurement period. | Seconds/Update |
MinUpdateLatency | Indicates the minimum latency noticed while updating this index during the last measurement period. | Seconds/Update |
MaxUpdateLatency | Indicates the maximum latency noticed while updating this index during the last measurement period. | Seconds/Update | Ideally, the value of this measure should be low. A sudden/gradual increase in the value of this measure is a cause of concern. Compare the value of this measure across indexes to identify the index that is consuming maximum time while updating the index.
AverageDeleteLatency | Indicates the average latency noticed while deleting this index during the last measurement period. | Seconds/Update |
MinDeleteLatency | Indicates the minimum latency noticed while deleting this index during the last measurement period. | Seconds/Update |
MaxDeleteLatency | Indicates the maximum latency noticed while deleting this index during the last measurement period. | Seconds/Update | Ideally, the value of this measure should be low. A sudden/gradual increase in the value of this measure is a cause of concern. Compare the value of this measure across indexes to identify the index that is consuming maximum time while being deleted.