6.17 InnoDB Thread Activity Metrics

Lists the InnoDB Thread Activity metrics and provides a brief description of each.

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