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 | 13237 | 1494 | INDEX | 0 | 0 | NO | 1903373628013 | 1903373627970 | 246494996 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 227 | 8172 | 0 | NO | IO_NONE | NO | 172188056 | |
0 | 1 | 0 | 225 | SYSTEM | 0 | 0 | NO | 1903373659116 | 1903373659013 | 246495681 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 0 | |
0 | 2 | 13237 | 5071 | INDEX | 0 | 0 | YES | 1903373361755 | 1903373218342 | 246495633 | `fmc_bot`.`data_sc_order_detail` | PRIMARY | 94 | 8235 | 0 | NO | IO_NONE | NO | 172188056 | |
0 | 3 | 13237 | 2644 | INDEX | 1 | 0 | NO | 1903373229071 | 1903373229011 | 246493432 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 433 | 15588 | 0 | NO | IO_NONE | NO | 172188056 | |
0 | 4 | 13237 | 2672 | INDEX | 0 | 0 | NO | 1903373610283 | 1903373257847 | 246495640 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 421 | 15156 | 0 | NO | IO_NONE | NO | 172188056 | |
0 | 5 | 13237 | 1517 | INDEX | 0 | 0 | NO | 1903373569879 | 1903372656251 | 246495494 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 241 | 8676 | 0 | NO | IO_NONE | NO | 172188056 | |
0 | 6 | 0 | 377 | UNDO_LOG | 0 | 0 | NO | 1903373340868 | 1903373306412 | 246495648 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 172188056 | |
0 | 7 | 13237 | 1625 | INDEX | 0 | 0 | YES | 1903373363475 | 1903372932472 | 246495561 | `fmc_bot`.`data_sc_order_detail` | PRIMARY | 115 | 10020 | 0 | NO | IO_NONE | NO | 172188056 | |
0 | 8 | 13237 | 292 | INDEX | 0 | 0 | NO | 1903373581442 | 1903373404685 | 246495691 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 222 | 7992 | 0 | NO | IO_NONE | NO | 172188056 | |
0 | 9 | 13237 | 5137 | INDEX | 0 | 0 | NO | 1903373453783 | 1903373450080 | 246495701 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 216 | 7776 | 0 | NO | IO_NONE | NO | 172188056 | |
0 | 10 | 0 | 318 | IBUF_INDEX | 0 | 0 | NO | 1903373678399 | 1903373495947 | 246495713 | NULL | NULL | 108 | 7020 | 0 | NO | IO_NONE | NO | 172188247 | |
0 | 11 | 0 | 1 | IBUF_BITMAP | 0 | 0 | NO | 0 | 0 | 246482906 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 172188269 | |
0 | 12 | 0 | 530 | IBUF_INDEX | 1 | 0 | NO | 1903373689682 | 1903370809399 | 246491690 | NULL | NULL | 1 | 65 | 0 | NO | IO_NONE | NO | 172188330 | |
0 | 13 | 0 | 487 | IBUF_INDEX | 0 | 0 | NO | 1903373681199 | 1903371451668 | 246495166 | NULL | NULL | 18 | 1170 | 0 | NO | IO_NONE | NO | 172188334 | |
0 | 14 | 13237 | 542 | INDEX | 0 | 0 | NO | 1903373680996 | 1903373659116 | 246496276 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 429 | 15444 | 0 | NO | IO_NONE | NO | 172188336 | |
0 | 15 | 13237 | 3836 | INDEX | 0 | 0 | NO | 1903373671404 | 1903373670289 | 246496277 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 326 | 11736 | 0 | NO | IO_NONE | NO | 172188345 | |
0 | 16 | 13237 | 3837 | INDEX | 0 | 0 | NO | 1903373665690 | 1903373663973 | 246496276 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 348 | 12528 | 0 | NO | IO_NONE | NO | 172188349 | |
0 | 17 | 13237 | 3839 | INDEX | 0 | 0 | NO | 1903373748818 | 1903373671404 | 246496277 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 292 | 10512 | 0 | NO | IO_NONE | NO | 172188355 | |
0 | 18 | 13237 | 1761 | INDEX | 0 | 0 | NO | 1903373693200 | 1903373693098 | 246496280 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 252 | 9072 | 0 | NO | IO_NONE | NO | 172188368 | |
0 | 19 | 13237 | 1762 | INDEX | 0 | 0 | NO | 1903373689808 | 1903373681222 | 246496278 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 277 | 9972 | 0 | NO | IO_NONE | NO | 172188373 | |
0 | 20 | 13237 | 1763 | INDEX | 0 | 0 | NO | 1903373691584 | 1903373682898 | 246496279 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 275 | 9900 | 0 | NO | IO_NONE | NO | 172188373 | |
0 | 21 | 13237 | 1765 | INDEX | 0 | 0 | NO | 1903373692901 | 1903373691892 | 246496280 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 251 | 9036 | 0 | NO | IO_NONE | NO | 172188374 | |
0 | 22 | 13237 | 3144 | INDEX | 0 | 0 | NO | 1903373693557 | 1903373693027 | 246496280 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 324 | 11664 | 0 | NO | IO_NONE | NO | 172188375 | |
0 | 23 | 0 | 378 | UNDO_LOG | 0 | 0 | NO | 1903373659116 | 1903373363843 | 246495681 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 172188379 | |
0 | 24 | 0 | 319 | IBUF_INDEX | 0 | 0 | NO | 1903373670251 | 1903371272079 | 246495096 | NULL | NULL | 78 | 5070 | 0 | NO | IO_NONE | NO | 172188388 |
Filter rows: |