SELECT * FROM `INNODB_BUFFER_PAGE_LRU`
ORDER BY `INNODB_BUFFER_PAGE_LRU`.`FIX_COUNT` ASC
过滤行: |
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 | 162 | 16 | 2 | INODE | 0 | 0 | NO | 0 | 0 | 559995033 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 251024 | |
0 | 112 | 10 | 3 | INDEX | 1 | 0 | NO | 2573970988 | 2573970539 | 536516526 | `phpmyadmin`.`pma__table_uiprefs` | PRIMARY | 100 | 10535 | 0 | NO | IO_NONE | NO | 251004 | |
0 | 59 | 0 | 251 | SYSTEM | 1 | 0 | NO | 2573945430 | 0 | 519111660 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250979 | |
0 | 2 | 0 | 210 | SYSTEM | 1 | 0 | NO | 2573897527 | 0 | 529119992 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250949 | |
0 | 194 | 0 | 296 | SYSTEM | 0 | 0 | NO | 0 | 0 | 560887884 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 251058 | |
0 | 140 | 2767 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 559995032 | `phpmyadmin`.`pma__history` | PRIMARY | 0 | 0 | 0 | NO | IO_NONE | NO | 251024 | |
0 | 96 | 0 | 289 | SYSTEM | 1 | 0 | NO | 2573946282 | 0 | 303646116 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250979 | |
0 | 34 | 0 | 237 | SYSTEM | 1 | 0 | NO | 2573970965 | 2573970855 | 535484724 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250977 | |
0 | 225 | 280 | 2 | INODE | 0 | 0 | NO | 0 | 0 | 583738462 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 251114 | |
0 | 43 | 0 | 495 | INODE | 1 | 0 | NO | 2573945386 | 0 | 536213915 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250979 | |
0 | 178 | 0 | 379 | UNDO_LOG | 1 | 0 | NO | 2573945386 | 0 | 560887883 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 251058 | |
0 | 124 | 0 | 669 | UNDO_LOG | 1 | 0 | NO | 2573945886 | 0 | 538196934 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 251016 | |
0 | 75 | 0 | 267 | SYSTEM | 1 | 0 | NO | 2573945974 | 0 | 264536262 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250979 | |
0 | 80 | 0 | 272 | SYSTEM | 1 | 0 | NO | 2573841966 | 0 | 264536276 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250979 | |
0 | 246 | 0 | 626 | UNDO_LOG | 1 | 0 | NO | 2573962389 | 0 | 594474569 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 251137 | |
0 | 18 | 0 | 221 | SYSTEM | 1 | 0 | NO | 2573957771 | 0 | 530023644 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250961 | |
0 | 209 | 2767 | 0 | FILE_SPACE_HEADER | 0 | 0 | NO | 0 | 0 | 583007727 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 251097 | |
0 | 76 | 0 | 268 | SYSTEM | 1 | 0 | NO | 2573946018 | 0 | 264536265 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250979 | |
0 | 81 | 0 | 273 | SYSTEM | 1 | 0 | NO | 2573670528 | 0 | 264536278 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250979 | |
0 | 247 | 0 | 440 | UNDO_LOG | 1 | 0 | NO | 2573963751 | 0 | 596115387 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 251139 | |
0 | 19 | 0 | 222 | SYSTEM | 1 | 0 | NO | 2573959148 | 0 | 530046577 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250962 | |
0 | 210 | 3083 | 0 | FILE_SPACE_HEADER | 0 | 0 | NO | 0 | 0 | 583007727 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 251097 | |
0 | 163 | 3217 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 560382681 | `gym`.`README` | PRIMARY | 1 | 438 | 0 | NO | IO_NONE | NO | 251055 | |
0 | 113 | 10 | 1 | IBUF_BITMAP | 0 | 0 | NO | 0 | 0 | 536516526 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 251004 | |
0 | 60 | 0 | 252 | SYSTEM | 1 | 0 | NO | 2573788423 | 0 | 303646114 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 250979 |
过滤行: |