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 | 13236 | 1341 | INDEX | 0 | 0 | NO | 1902731117042 | 1902730380399 | 243594288 | `fmc_bot`.`data_mydita_order_detail` | PRIMARY | 73 | 16123 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 1 | 0 | 553 | IBUF_INDEX | 0 | 0 | NO | 1902731493354 | 1902730380727 | 243594288 | NULL | NULL | 264 | 14494 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 2 | 13236 | 990 | INDEX | 0 | 0 | NO | 1902731255512 | 1902730384034 | 243594296 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 449 | 14817 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 3 | 13236 | 991 | INDEX | 0 | 0 | NO | 1902731923389 | 1902730384084 | 243594296 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 558 | 14517 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 4 | 13236 | 4146 | INDEX | 0 | 0 | NO | 1902731114398 | 1902730395276 | 243594299 | `fmc_bot`.`data_mydita_order_detail` | PRIMARY | 47 | 10239 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 5 | 13236 | 3804 | INDEX | 0 | 0 | YES | 1902731113726 | 1902730395704 | 243594300 | `fmc_bot`.`data_mydita_order_detail` | PRIMARY | 58 | 12452 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 6 | 13236 | 2149 | INDEX | 0 | 0 | NO | 1902731111104 | 1902730396571 | 243594301 | `fmc_bot`.`data_mydita_order_detail` | PRIMARY | 50 | 11272 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 7 | 13236 | 2566 | INDEX | 0 | 0 | NO | 1902731117320 | 1902730397400 | 243594302 | `fmc_bot`.`data_mydita_order_detail` | PRIMARY | 69 | 14353 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 8 | 13236 | 3805 | INDEX | 0 | 0 | YES | 1902731116128 | 1902730397709 | 243594303 | `fmc_bot`.`data_mydita_order_detail` | PRIMARY | 58 | 12649 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 9 | 13236 | 1351 | INDEX | 0 | 0 | NO | 1902731115305 | 1902730398153 | 243594304 | `fmc_bot`.`data_mydita_order_detail` | PRIMARY | 57 | 12268 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 10 | 13236 | 21 | INDEX | 0 | 0 | YES | 1902731114244 | 1902730398619 | 243594305 | `fmc_bot`.`data_mydita_order_detail` | PRIMARY | 54 | 11909 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 11 | 13236 | 346 | INDEX | 0 | 0 | NO | 1902730401009 | 1902730400236 | 243594493 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 262 | 8646 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 12 | 0 | 522 | IBUF_INDEX | 0 | 0 | NO | 1902731957620 | 1902730398958 | 243594493 | NULL | NULL | 258 | 14876 | 0 | NO | IO_NONE | YES | 171563403 | |
0 | 13 | 13236 | 347 | INDEX | 0 | 0 | NO | 1902730691090 | 1902730417391 | 243594495 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 359 | 11847 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 14 | 13236 | 348 | INDEX | 0 | 0 | NO | 1902731252094 | 1902730402090 | 243594494 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 411 | 13563 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 15 | 13236 | 349 | INDEX | 0 | 0 | NO | 1902731736801 | 1902730399030 | 243594493 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 367 | 12111 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 16 | 0 | 491 | IBUF_INDEX | 0 | 0 | NO | 1902731957620 | 1902731957579 | 243594493 | NULL | NULL | 245 | 15297 | 0 | NO | IO_NONE | YES | 171563403 | |
0 | 17 | 13236 | 350 | INDEX | 0 | 0 | NO | 1902731956916 | 1902730401059 | 243594493 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 375 | 12375 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 18 | 13236 | 351 | INDEX | 0 | 0 | NO | 1902731951785 | 1902730414881 | 243594495 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 353 | 11649 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 19 | 0 | 687 | IBUF_INDEX | 0 | 0 | NO | 1902730508324 | 1902730401009 | 243594493 | NULL | NULL | 85 | 5440 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 20 | 13236 | 3640 | INDEX | 0 | 0 | NO | 1902730408277 | 1902730401009 | 243594493 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 337 | 11121 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 21 | 13236 | 3641 | INDEX | 0 | 0 | NO | 1902730419601 | 1902730418600 | 243594495 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 346 | 11418 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 22 | 13236 | 3642 | INDEX | 0 | 0 | NO | 1902730417391 | 1902730415909 | 243594495 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 350 | 11550 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 23 | 13236 | 3643 | INDEX | 0 | 0 | NO | 1902730420684 | 1902730419601 | 243594496 | `fmc_bot`.`data_mydita_order_detail` | ORDER_CODE | 323 | 10659 | 0 | NO | IO_WRITE | YES | 171563403 | |
0 | 24 | 0 | 476 | IBUF_INDEX | 0 | 0 | NO | 1902730420668 | 1902730403101 | 243594494 | NULL | NULL | 211 | 13071 | 0 | NO | IO_WRITE | YES | 171563403 |
Filter rows: |