Information Schema INNODB_CHANGED_PAGES Table
The Information Schema
INNODB_CHANGED_PAGES Table contains data about modified pages from the bitmap file. It is updated at checkpoints by the log tracking thread parsing the log, so does not contain real-time data.
The number of records is limited by the value of the innodb_max_changed_pages system variable.
PROCESS privilege is required to view the table.
It has the following columns:
|Modified page space id|
|Modified page id|
|Interval start after which page was changed (equal to checkpoint LSN)|
|Interval end before which page was changed (equal to checkpoint LSN)|