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 | 321 | IBUF_INDEX | 0 | 0 | NO | 1768566374144 | 1768566374094 | 2744236061 | NULL | NULL | 141 | 9165 | 0 | NO | IO_WRITE | NO | 96379655 | |
0 | 1 | 12553 | 324 | INDEX | 0 | 0 | NO | 1768566365234 | 1768566364944 | 2744236344 | `fmc_bot`.`data_sc_order_detail` | PRIMARY | 133 | 11609 | 0 | NO | IO_WRITE | NO | 96379655 | |
0 | 2 | 0 | 473 | IBUF_INDEX | 1 | 0 | NO | 1768566372495 | 1768566372445 | 2744236891 | NULL | NULL | 162 | 10530 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 3 | 0 | 420 | IBUF_INDEX | 1 | 0 | NO | 1768566339682 | 0 | 2744233298 | NULL | NULL | 213 | 13845 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 4 | 12553 | 0 | FILE_SPACE_HEADER | 1 | 0 | NO | 1768566344883 | 0 | 2744233301 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 5 | 12553 | 2 | INODE | 1 | 0 | NO | 1768566344883 | 0 | 2744233301 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 6 | 12553 | 7307 | INDEX | 1 | 0 | NO | 1768566344883 | 0 | 2744236892 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 218 | 7848 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 7 | 0 | 319 | IBUF_INDEX | 1 | 0 | NO | 1768566363086 | 0 | 2744226543 | NULL | NULL | 229 | 14885 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 8 | 12553 | 4415 | INDEX | 1 | 0 | NO | 1768566357270 | 0 | 2744236892 | `fmc_bot`.`data_sc_order_detail` | PRIMARY | 167 | 14566 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 9 | 0 | 663 | IBUF_INDEX | 1 | 0 | NO | 1768566345610 | 0 | 2744231830 | NULL | NULL | 149 | 9685 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 10 | 0 | 396 | IBUF_INDEX | 1 | 0 | NO | 1768566345610 | 0 | 2744236893 | NULL | NULL | 120 | 7800 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 11 | 12553 | 3307 | INDEX | 1 | 0 | NO | 1768566361811 | 0 | 2744236894 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 248 | 8928 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 12 | 12553 | 3308 | INDEX | 1 | 0 | NO | 1768566363274 | 0 | 2744236894 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 236 | 8496 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 13 | 12553 | 3309 | INDEX | 1 | 0 | NO | 1768566347414 | 0 | 2744236894 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 254 | 9144 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 14 | 12553 | 3310 | INDEX | 1 | 0 | NO | 1768566372667 | 1768566372636 | 2744236894 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 248 | 8928 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 15 | 12553 | 2389 | INDEX | 1 | 0 | NO | 1768566360687 | 0 | 2744235298 | `fmc_bot`.`data_sc_order_detail` | PRIMARY | 138 | 12015 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 16 | 12553 | 327 | INDEX | 1 | 0 | NO | 1768566360174 | 0 | 2744236895 | `fmc_bot`.`data_sc_order_detail` | PRIMARY | 46 | 4006 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 17 | 0 | 388 | IBUF_INDEX | 1 | 0 | NO | 1768566355363 | 0 | 2744234814 | NULL | NULL | 233 | 15145 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 18 | 12553 | 2444 | INDEX | 1 | 0 | NO | 1768566358925 | 0 | 2744235059 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 310 | 11160 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 19 | 12553 | 2401 | INDEX | 1 | 0 | NO | 1768566355141 | 0 | 2744236897 | `fmc_bot`.`data_sc_order_detail` | PRIMARY | 116 | 10115 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 20 | 0 | 670 | IBUF_INDEX | 1 | 0 | NO | 1768566364329 | 1768566364279 | 2744229181 | NULL | NULL | 122 | 7930 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 21 | 12553 | 1254 | INDEX | 1 | 0 | NO | 1768566356914 | 0 | 2744233567 | `fmc_bot`.`data_sc_order_detail` | DEVICE_ID | 273 | 9828 | 0 | NO | IO_NONE | NO | 96379655 | |
0 | 22 | 12553 | 3 | INDEX | 1 | 0 | NO | 1768566226980 | 0 | 2744148878 | `fmc_bot`.`data_sc_order_detail` | PRIMARY | 8 | 160 | 0 | NO | IO_NONE | NO | 96379774 | |
0 | 23 | 12553 | 5465 | INDEX | 1 | 0 | NO | 1768566364666 | 0 | 2744236404 | `fmc_bot`.`data_sc_order_detail` | PRIMARY | 115 | 10046 | 0 | NO | IO_NONE | NO | 96379774 | |
0 | 24 | 0 | 497 | UNDO_LOG | 1 | 0 | NO | 1768566375009 | 1768566364329 | 2744235297 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | NO | 96379774 |
Filter rows: |