The INNODB_CHANGED_PAGES
table was added in MariaDB 10.0.9.
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.
The PROCESS
privilege is required to view the table.
It has the following columns:
Column | Description |
---|---|
SPACE_ID |
Modified page space id |
PAGE_ID |
Modified page id |
START_LSN |
Interval start after which page was changed (equal to checkpoint LSN) |
END_LSN |
Interval end before which page was changed (equal to checkpoint LSN) |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-innodb_changed_pages-table/