SELECT * FROM `INNODB_BUFFER_PAGE_LRU`
Filter rows: |
POOL_ID | LRU_POSITION | SPACE | PAGE_NUMBER | PAGE_TYPE | FLUSH_TYPE | FIX_COUNT | IS_HASHED | NEWEST_MODIFICATION | OLDEST_MODIFICATION | ACCESS_TIME | TABLE_NAME | INDEX_NAME | NUMBER_RECORDS | DATA_SIZE | COMPRESSED_SIZE | COMPRESSED | IO_FIX | IS_OLD | FREE_PAGE_CLOCK | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 0 | 0 | 444 | UNDO_LOG | 1 | 0 | NO | 3152693 | 0 | 1604975105 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1895 | |
0 | 1 | 0 | 445 | UNDO_LOG | 1 | 0 | NO | 3152737 | 0 | 1604975159 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1895 | |
0 | 2 | 0 | 446 | UNDO_LOG | 1 | 0 | NO | 3152781 | 0 | 1604975540 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1895 | |
0 | 3 | 0 | 447 | UNDO_LOG | 1 | 0 | NO | 3152825 | 0 | 1604977848 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1898 | |
0 | 4 | 0 | 448 | UNDO_LOG | 1 | 0 | NO | 3152869 | 0 | 1604978061 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1899 | |
0 | 5 | 0 | 449 | UNDO_LOG | 1 | 0 | NO | 3152929 | 0 | 1604979007 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1899 | |
0 | 6 | 0 | 450 | UNDO_LOG | 1 | 0 | NO | 3152973 | 0 | 1604979036 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1899 | |
0 | 7 | 0 | 451 | UNDO_LOG | 1 | 0 | NO | 3153017 | 0 | 1604979042 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1899 | |
0 | 8 | 0 | 452 | UNDO_LOG | 1 | 0 | NO | 3153061 | 0 | 1604979281 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1903 | |
0 | 9 | 0 | 453 | UNDO_LOG | 1 | 0 | NO | 3153105 | 0 | 1604979613 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1903 | |
0 | 10 | 0 | 454 | UNDO_LOG | 1 | 0 | NO | 3153149 | 0 | 1604979796 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1903 | |
0 | 11 | 0 | 455 | UNDO_LOG | 1 | 0 | NO | 3153193 | 0 | 1604980284 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1906 | |
0 | 12 | 0 | 456 | UNDO_LOG | 1 | 0 | NO | 3153237 | 0 | 1604980511 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1906 | |
0 | 13 | 1 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 1604937979 | `mysql`.`innodb_table_stats` | PRIMARY | 20 | 1466 | 0 | NO | IO_NONE | NO | 1908 | |
0 | 14 | 0 | 457 | UNDO_LOG | 1 | 0 | NO | 3153281 | 0 | 1604981348 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1908 | |
0 | 15 | 0 | 458 | UNDO_LOG | 1 | 0 | NO | 3153325 | 0 | 1604982321 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1909 | |
0 | 16 | 0 | 459 | UNDO_LOG | 1 | 0 | NO | 3153369 | 0 | 1604982544 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1909 | |
0 | 17 | 29 | 0 | FILE_SPACE_HEADER | 0 | 0 | NO | 0 | 0 | 1604982781 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1909 | |
0 | 18 | 0 | 460 | UNDO_LOG | 1 | 0 | NO | 3153429 | 0 | 1604982853 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1909 | |
0 | 19 | 0 | 461 | UNDO_LOG | 1 | 0 | NO | 3153473 | 0 | 1604982896 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1909 | |
0 | 20 | 0 | 462 | UNDO_LOG | 1 | 0 | NO | 3153517 | 0 | 1604982926 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1909 | |
0 | 21 | 0 | 463 | UNDO_LOG | 1 | 0 | NO | 3153561 | 0 | 1604987352 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1915 | |
0 | 22 | 0 | 464 | UNDO_LOG | 1 | 0 | NO | 3153605 | 0 | 1604987486 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1915 | |
0 | 23 | 0 | 465 | UNDO_LOG | 1 | 0 | NO | 3153649 | 0 | 1604987590 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1915 | |
0 | 24 | 0 | 6 | SYSTEM | 1 | 0 | NO | 3208260 | 0 | 1604987603 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1915 |
Filter rows: |