SELECT * FROM `INNODB_BUFFER_PAGE`
ORDER BY `INNODB_BUFFER_PAGE`.`SPACE` DESC
过滤行: |
POOL_ID | BLOCK_ID | SPACE 1 | 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 | 812 | 3217 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 362561085 | `gym`.`README` | PRIMARY | 1 | 438 | 0 | FILE_PAGE | IO_NONE | NO | 250645 | |
0 | 1275 | 3217 | 0 | FILE_SPACE_HEADER | 0 | 0 | NO | 0 | 0 | 348195403 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250638 | |
0 | 1150 | 3217 | 1 | IBUF_BITMAP | 0 | 0 | NO | 0 | 0 | 362561085 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250645 | |
0 | 449 | 3197 | 0 | FILE_SPACE_HEADER | 0 | 0 | NO | 0 | 0 | 373782006 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 486 | 3197 | 4 | INDEX | 0 | 0 | NO | 0 | 0 | 317327313 | `phpmyadmin`.`pma__column_info` | db_name | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250795 | |
0 | 577 | 3083 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 519140118 | `phpmyadmin`.`pma__navigationhiding` | PRIMARY | 1 | 52 | 0 | FILE_PAGE | IO_NONE | NO | 250795 | |
0 | 576 | 3083 | 1 | IBUF_BITMAP | 0 | 0 | NO | 0 | 0 | 519140118 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250795 | |
0 | 248 | 3083 | 0 | FILE_SPACE_HEADER | 0 | 0 | NO | 0 | 0 | 373782006 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 727 | 3075 | 3 | INDEX | 1 | 0 | YES | 2573769808 | 0 | 306120804 | `phpmyadmin`.`pma__recent` | PRIMARY | 1 | 586 | 0 | FILE_PAGE | IO_NONE | NO | 250795 | |
0 | 960 | 3075 | 0 | FILE_SPACE_HEADER | 0 | 0 | NO | 0 | 0 | 373782007 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 139 | 2767 | 0 | FILE_SPACE_HEADER | 0 | 0 | NO | 0 | 0 | 373782006 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 787 | 2767 | 4 | INDEX | 0 | 0 | NO | 0 | 0 | 373782006 | `phpmyadmin`.`pma__history` | username | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 929 | 2767 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 373782006 | `phpmyadmin`.`pma__history` | PRIMARY | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 1002 | 2767 | 2 | INODE | 0 | 0 | NO | 0 | 0 | 373782006 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 378 | 2767 | 1 | IBUF_BITMAP | 0 | 0 | NO | 0 | 0 | 373782006 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 50 | 2643 | 0 | FILE_SPACE_HEADER | 0 | 0 | NO | 0 | 0 | 373782006 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 1156 | 2643 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 306120813 | `phpmyadmin`.`pma__bookmark` | PRIMARY | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250795 | |
0 | 683 | 2579 | 0 | FILE_SPACE_HEADER | 0 | 0 | NO | 0 | 0 | 373782007 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 844 | 2579 | 5 | INDEX | 0 | 0 | NO | 0 | 0 | 373782008 | `phpmyadmin`.`pma__table_coords` | x | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 200 | 2579 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 373782007 | `phpmyadmin`.`pma__table_coords` | PRIMARY | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 530 | 2579 | 4 | INDEX | 0 | 0 | NO | 0 | 0 | 373782007 | `phpmyadmin`.`pma__table_coords` | pdf_page_number | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 608 | 2579 | 2 | INODE | 0 | 0 | NO | 0 | 0 | 373782007 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 179 | 2579 | 1 | IBUF_BITMAP | 0 | 0 | NO | 0 | 0 | 373782007 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 251 | 741 | 0 | FILE_SPACE_HEADER | 0 | 0 | NO | 0 | 0 | 373782007 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 16 | 741 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 320592135 | `phpmyadmin`.`pma__relation` | PRIMARY | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250808 |
过滤行: |