SELECT * FROM `INNODB_BUFFER_PAGE_LRU` ORDER BY `FREE_PAGE_CLOCK` 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 | 0 | 1 | 3 | INDEX | 0 | 0 | YES | 0 | 0 | 973468185 | `mysql`.`innodb_table_stats` | PRIMARY | 63 | 4565 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 1 | 1 | 1 | IBUF_BITMAP | 0 | 0 | NO | 0 | 0 | 973468185 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 2 | 2 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 973468185 | `mysql`.`innodb_index_stats` | PRIMARY | 9 | 585 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 3 | 2 | 4 | INDEX | 0 | 0 | YES | 0 | 0 | 973468185 | `mysql`.`innodb_index_stats` | PRIMARY | 124 | 14904 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 4 | 2 | 1 | IBUF_BITMAP | 0 | 0 | NO | 0 | 0 | 973468185 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 5 | 2 | 11 | INDEX | 0 | 0 | YES | 0 | 0 | 973468186 | `mysql`.`innodb_index_stats` | PRIMARY | 3 | 415 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 6 | 2 | 10 | INDEX | 0 | 0 | NO | 0 | 0 | 973468187 | `mysql`.`innodb_index_stats` | PRIMARY | 8 | 1151 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 7 | 2 | 9 | INDEX | 0 | 0 | YES | 0 | 0 | 973468187 | `mysql`.`innodb_index_stats` | PRIMARY | 2 | 235 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 8 | 2 | 7 | INDEX | 0 | 0 | YES | 0 | 0 | 973468187 | `mysql`.`innodb_index_stats` | PRIMARY | 131 | 14399 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 9 | 2 | 12 | INDEX | 0 | 0 | YES | 0 | 0 | 973468187 | `mysql`.`innodb_index_stats` | PRIMARY | 42 | 4002 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 10 | 2 | 6 | INDEX | 0 | 0 | YES | 0 | 0 | 973468187 | `mysql`.`innodb_index_stats` | PRIMARY | 127 | 12668 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 11 | 2 | 8 | INDEX | 0 | 0 | YES | 0 | 0 | 973468188 | `mysql`.`innodb_index_stats` | PRIMARY | 61 | 6325 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 12 | 2 | 5 | INDEX | 0 | 0 | YES | 0 | 0 | 973468199 | `mysql`.`innodb_index_stats` | PRIMARY | 72 | 7889 | 0 | NO | IO_NONE | NO | 1669549 | |
0 | 16 | 14 | 1 | IBUF_BITMAP | 0 | 0 | NO | 0 | 0 | 973492701 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669564 | |
0 | 17 | 0 | 330 | UNDO_LOG | 1 | 0 | NO | 1432970423 | 0 | 973354052 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669564 | |
0 | 18 | 0 | 443 | UNDO_LOG | 1 | 0 | NO | 1432970501 | 0 | 973492736 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669564 | |
0 | 19 | 0 | 1 | IBUF_BITMAP | 0 | 0 | NO | 0 | 0 | 973358992 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669564 | |
0 | 13 | 0 | 323 | INODE | 1 | 0 | NO | 1433129199 | 0 | 973351921 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669564 | |
0 | 14 | 0 | 311 | UNDO_LOG | 1 | 0 | NO | 1433027821 | 0 | 973359940 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669564 | |
0 | 15 | 14 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 973492701 | `phpmyadmin`.`pma__tracking` | PRIMARY | 0 | 0 | 0 | NO | IO_NONE | NO | 1669564 | |
0 | 20 | 0 | 342 | UNDO_LOG | 1 | 0 | NO | 1433114194 | 0 | 973574296 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669567 | |
0 | 21 | 0 | 340 | UNDO_LOG | 1 | 0 | NO | 1433114238 | 0 | 973648097 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669568 | |
0 | 22 | 0 | 315 | UNDO_LOG | 1 | 0 | NO | 1433114282 | 0 | 973649252 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669569 | |
0 | 23 | 0 | 317 | UNDO_LOG | 1 | 0 | NO | 1433114326 | 0 | 973649495 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669570 | |
0 | 24 | 0 | 393 | UNDO_LOG | 1 | 0 | NO | 1433114370 | 0 | 973669333 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 1669571 |
过滤行: |