SELECT * FROM `INNODB_BUFFER_PAGE`
ORDER BY `INNODB_BUFFER_PAGE`.`INDEX_NAME` DESC
过滤行: |
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 1 | NUMBER_RECORDS | DATA_SIZE | COMPRESSED_SIZE | PAGE_STATE | IO_FIX | IS_OLD | FREE_PAGE_CLOCK | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 465 | 22 | 4 | INDEX | 0 | 0 | NO | 0 | 0 | 344878916 | `phpmyadmin`.`pma__export_templates` | u_user_type_template | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250825 | |
0 | 996 | 19 | 4 | INDEX | 0 | 0 | NO | 0 | 0 | 373782007 | `phpmyadmin`.`pma__savedsearches` | u_savedsearches_username_dbname | 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 | 577 | 3083 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 519140118 | `phpmyadmin`.`pma__navigationhiding` | PRIMARY | 1 | 52 | 0 | FILE_PAGE | IO_NONE | NO | 250795 | |
0 | 779 | 21 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 373782006 | `phpmyadmin`.`pma__designer_settings` | PRIMARY | 1 | 96 | 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 | 1110 | 16 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 373782008 | `phpmyadmin`.`pma__users` | PRIMARY | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 53 | 7 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 373782007 | `phpmyadmin`.`pma__pdf_pages` | PRIMARY | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 727 | 3075 | 3 | INDEX | 1 | 0 | YES | 2573782799 | 0 | 306120804 | `phpmyadmin`.`pma__recent` | PRIMARY | 1 | 593 | 0 | FILE_PAGE | IO_NONE | NO | 250795 | |
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 | 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 | 109 | 19 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 373782007 | `phpmyadmin`.`pma__savedsearches` | PRIMARY | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 347 | 15 | 3 | INDEX | 0 | 0 | YES | 0 | 0 | 519124545 | `phpmyadmin`.`pma__userconfig` | PRIMARY | 1 | 283 | 0 | FILE_PAGE | IO_NONE | NO | 250793 | |
0 | 1139 | 10 | 3 | INDEX | 1 | 0 | NO | 2573783250 | 2573783076 | 519140098 | `phpmyadmin`.`pma__table_uiprefs` | PRIMARY | 100 | 10518 | 0 | FILE_PAGE | IO_NONE | NO | 250795 | |
0 | 812 | 3217 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 362561085 | `gym`.`README` | PRIMARY | 1 | 438 | 0 | FILE_PAGE | IO_NONE | NO | 250645 | |
0 | 364 | 13 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 328967464 | `phpmyadmin`.`pma__table_info` | PRIMARY | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250818 | |
0 | 16 | 741 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 320592135 | `phpmyadmin`.`pma__relation` | PRIMARY | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250808 | |
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 | 720 | 279 | 3 | INDEX | 0 | 0 | NO | 0 | 0 | 345208526 | `mysql`.`yzkrkl` | GEN_CLUST_INDEX | 1 | 25 | 0 | FILE_PAGE | IO_NONE | NO | 250629 | |
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 | 1033 | 7 | 4 | INDEX | 0 | 0 | NO | 0 | 0 | 373782007 | `phpmyadmin`.`pma__pdf_pages` | db_name | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 250657 | |
0 | 140 | 0 | 8 | INDEX | 0 | 0 | NO | 0 | 0 | 519273630 | `SYS_TABLES` | CLUST_IND | 26 | 2173 | 0 | FILE_PAGE | IO_NONE | NO | 250802 | |
0 | 991 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 | |
0 | 225 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
过滤行: |