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. |