SELECT * FROM `INNODB_BUFFER_PAGE`
Filter rows: |
POOL_ID | BLOCK_ID | 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 | PAGE_STATE | IO_FIX | IS_OLD | FREE_PAGE_CLOCK | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 0 | 0 | 300 | SYSTEM | 1 | 0 | NO | 1900908041933 | 0 | 224702194 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 170617911 | |
0 | 1 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 2 | 13227 | 1837 | INDEX | 1 | 0 | YES | 1900910074122 | 0 | 224706578 | `fmc`.`data_re_sales_daily_kpro` | GEN_CLUST_INDEX | 228 | 15048 | 0 | FILE_PAGE | IO_NONE | NO | 170618095 | |
0 | 3 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 4 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 5 | 0 | 232 | SYSTEM | 1 | 0 | NO | 1900910283133 | 0 | 224702193 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 170618095 | |
0 | 6 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | MEMORY | IO_NONE | NO | 0 | |
0 | 7 | 0 | 234 | SYSTEM | 0 | 0 | NO | 1900910534790 | 1900910431671 | 224702193 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 170618113 | |
0 | 8 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 9 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 10 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 11 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 12 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 13 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | MEMORY | IO_NONE | NO | 0 | |
0 | 14 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | MEMORY | IO_NONE | NO | 0 | |
0 | 15 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 16 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 17 | 13227 | 1760 | INDEX | 1 | 0 | YES | 1900907912441 | 0 | 224701881 | `fmc`.`data_re_sales_daily_kpro` | GEN_CLUST_INDEX | 247 | 15067 | 0 | FILE_PAGE | IO_NONE | NO | 170617891 | |
0 | 18 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 19 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 20 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 21 | 13227 | 1830 | INDEX | 1 | 0 | YES | 1900909927462 | 0 | 224706285 | `fmc`.`data_re_sales_daily_kpro` | GEN_CLUST_INDEX | 228 | 15048 | 0 | FILE_PAGE | IO_NONE | NO | 170618091 | |
0 | 22 | 13227 | 1867 | INDEX | 0 | 0 | YES | 1900910931695 | 1900910868316 | 224708471 | `fmc`.`data_re_sales_daily_kpro` | GEN_CLUST_INDEX | 228 | 15048 | 0 | FILE_PAGE | IO_NONE | NO | 170618127 | |
0 | 23 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 24 | 13227 | 1846 | INDEX | 1 | 0 | YES | 1900910431671 | 0 | 224707118 | `fmc`.`data_re_sales_daily_kpro` | GEN_CLUST_INDEX | 228 | 15048 | 0 | FILE_PAGE | IO_NONE | NO | 170618095 |
Filter rows: |