6.12 InnoDB Insert Buffer Activity Metrics

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

Table 6.12 InnoDB Insert Buffer Activity Metrics

Name	Description
Delete Discarded (Delta)	The total number of purge merged operations discarded.
Delete Mark Discarded (Delta)	The total number of deleted merged operations discarded.
Delete Mark Merges (Delta)	The total number of deleted records merged by change buffering.
Delete Merges (Delta)	The total number of times the InnoDB secondary index delete buffer was merged to the InnoDB datafiles.
Free List Len	The number of pages free within the InnoDB secondary index insert buffer.
Inserts (Delta)	The total number of inserts to the InnoDB secondary index insert buffer.
Inserts Discarded (Delta)	The total number of insert merged operations discarded
Merged Recs (Delta)	The total number of records merged from the InnoDB secondary index insert buffer to the InnoDB datafiles.
Merges (Delta)	The total number of times the InnoDB secondary index insert buffer was merged to the InnoDB datafiles.
Seg Size	The total size, in pages, of the InnoDB secondary index insert buffer.
Size	The number of pages used within the InnoDB secondary index insert buffer.