Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb
HTML Download (TGZ) - 223.8Kb
HTML Download (Zip) - 231.3Kb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Metrics  /  InnoDB Insert Buffer Activity Metrics

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

NameDescription
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 LenThe 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 SizeThe total size, in pages, of the InnoDB secondary index insert buffer.
SizeThe number of pages used within the InnoDB secondary index insert buffer.