InnoDB Thread Activity Metrics
Lists the InnoDB Thread Activity metrics and provides a brief description of each.
| Name | Description |
|---|---|
| Main Thd Log Flush Writes (Delta) | The number of times InnoDB redo logs are written and synced to disk by the source 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 aggressively when the server is idle. |
| Main Thd Loops Flush (Delta) | The number of times the InnoDB main thread aggressively flushed dirty pages, whilst there was no server activity. |
| Main Thd Loops One Sec (Delta) | The number of times the InnoDB main thread has entered its one second loop structure, to flush dirty pages or drop tables in 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 its active loop structure. |
| Main Thd Loops Srv Idle (Delta) | The number of times the InnoDB main thread has entered it sidle loop structure. |
| Main Thd Loops Srv Shutdown (Delta) | The number of times the InnoDB main thread has entered its shutdown loop structure. |
| Main Thd Loops Ten Sec (Delta) | The number of times the InnoDB main thread has entered its ten second loop structure, to manage purge operations. |
| Main Thd State | The current state of the main InnoDB thread. |