Lists the InnoDB Insert Buffer Activity metrics and provides a brief description of each.
Table 4.10 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 (Total) | 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 secondaryindex 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 (Total) | The total size, in pages, of the InnoDB secondary index insert buffer. |
| Size (Total) | The number of pages used within the InnoDB secondary index insert buffer. |