Lists the InnoDB Thread Activity metrics and provides a brief description of each.
Table 4.15 InnoDB Thread Activity Metrics
Name | Description |
---|---|
Main Thd Log Flush Writes (Delta) | The number of times InnoDB redo logs are written and synced to disk by the master thread. |
Main Thd Loops Background (Delta) | The number of times the InnoDB main thread did background tasks, such as flushing dirty pages, purging and insert buffer merging, more aggresively when the server is idle. |
Main Thd Loops Flush (Delta) | The number of times the InnoDB main thread aggressively flusheddirty pages, whilst there was no server activity. |
Main Thd Loops One Sec (Delta) | The number of times the InnoDB main thread has entered itsone second loop structure, to flush dirty pages or drop tablesin the background or insert buffer merging. |
Main Thd Loops Sleeps (Delta) | The number of times the InnoDB main thread was put to sleep, due to no flushing being required within the one second loop. |
Main Thd Loops Srv Active (Delta) | The number of times the InnoDB main thread has entered itsactive loop structure. |
Main Thd Loops Srv Idle (Delta) | The number of times the InnoDB main thread has entered itsidle loop structure. |
Main Thd Loops Srv Shutdown (Delta) | The number of times the InnoDB main thread has entered itsshutdown loop structure. |
Main Thd Loops Ten Sec (Delta) | The number of times the InnoDB main thread has entered itsten second loop structure, to manage purge operations. |
Main Thd State (Total) | The current state of the main InnoDB thread. |