[Tools]
Datenbank:
`information_schema`
Tabelle: `INNODB_BUFFER_PAGE`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `information_schema`.`INNODB_BUFFER_PAGE`
Datensätze 1 - 30 von insgesamt 8191 << < > >>
| Ansicht: kompakt Die Abfrage enthält 20 Spalten | |||||||||||||||||||||
| # |  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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
  | 1. | 0 | 0 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 2. | 0 | 1 | 5209 | 17604 | INDEX | 0 | 0 | NO | 0 | 0 | 1640483097 | `fhem`.`history` | GEN_CLUST_INDEX | 163 | 15109 | 0 | FILE_PAGE | IO_NONE | NO | 80997826 |
|
| 3. | 0 | 2 | 5209 | 43653 | INDEX | 1 | 0 | YES | 526776966436 | 0 | 1690982461 | `fhem`.`history` | Search_Idx | 410 | 15990 | 0 | FILE_PAGE | IO_NONE | NO | 81028688 |
|
| 4. | 0 | 3 | 5209 | 41304 | INDEX | 0 | 0 | NO | 0 | 0 | 1713722237 | `fhem`.`history` | Search_Idx | 500 | 16000 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 5. | 0 | 4 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 6. | 0 | 5 | 5209 | 43808 | INDEX | 1 | 0 | YES | 526768552762 | 0 | 1685401400 | `fhem`.`history` | GEN_CLUST_INDEX | 155 | 15091 | 0 | FILE_PAGE | IO_NONE | NO | 81030151 |
|
| 7. | 0 | 6 | 5209 | 41670 | INDEX | 1 | 0 | NO | 526782046604 | 0 | 1648582782 | `fhem`.`history` | Search_Idx | 155 | 8431 | 0 | FILE_PAGE | IO_NONE | NO | 81019197 |
|
| 8. | 0 | 7 | 5209 | 17990 | INDEX | 0 | 0 | NO | 0 | 0 | 1640483283 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15094 | 0 | FILE_PAGE | IO_NONE | NO | 80997921 |
|
| 9. | 0 | 8 | 5209 | 21499 | INDEX | 0 | 0 | NO | 0 | 0 | 1640842768 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15111 | 0 | FILE_PAGE | IO_NONE | NO | 81000271 |
|
| 10. | 0 | 9 | 5209 | 32939 | INDEX | 0 | 0 | NO | 0 | 0 | 1707936212 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | NO | 81020770 |
|
| 11. | 0 | 10 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 12. | 0 | 11 | 5209 | 32964 | INDEX | 0 | 0 | NO | 0 | 0 | 1707936235 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | NO | 81020779 |
|
| 13. | 0 | 12 | 5209 | 21757 | INDEX | 0 | 0 | NO | 0 | 0 | 1640842893 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15127 | 0 | FILE_PAGE | IO_NONE | NO | 81000367 |
|
| 14. | 0 | 13 | 5209 | 17720 | INDEX | 0 | 0 | NO | 0 | 0 | 1640483153 | `fhem`.`history` | GEN_CLUST_INDEX | 146 | 15084 | 0 | FILE_PAGE | IO_NONE | NO | 80997869 |
|
| 15. | 0 | 14 | 5209 | 40998 | INDEX | 0 | 0 | NO | 0 | 0 | 1713721855 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 16. | 0 | 15 | 5209 | 21356 | INDEX | 0 | 0 | NO | 0 | 0 | 1640842698 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15067 | 0 | FILE_PAGE | IO_NONE | NO | 81000218 |
|
| 17. | 0 | 16 | 5209 | 44047 | INDEX | 1 | 0 | YES | 526777292969 | 0 | 1701514506 | `fhem`.`history` | GEN_CLUST_INDEX | 157 | 15125 | 0 | FILE_PAGE | IO_NONE | NO | 81030151 |
|
| 18. | 0 | 17 | 5209 | 44068 | INDEX | 1 | 0 | YES | 526778985615 | 0 | 1704754740 | `fhem`.`history` | GEN_CLUST_INDEX | 158 | 15131 | 0 | FILE_PAGE | IO_NONE | NO | 81030151 |
|
| 19. | 0 | 18 | 5209 | 32960 | INDEX | 0 | 0 | NO | 0 | 0 | 1707935868 | `fhem`.`history` | Search_Idx | 282 | 16074 | 0 | FILE_PAGE | IO_NONE | NO | 81020627 |
|
| 20. | 0 | 19 | 5209 | 41781 | INDEX | 1 | 0 | YES | 526783967579 | 0 | 1672107117 | `fhem`.`history` | Search_Idx | 280 | 15939 | 0 | FILE_PAGE | IO_NONE | NO | 81030268 |
|
| 21. | 0 | 20 | 0 | 218 | SYSTEM | 1 | 0 | NO | 526783871210 | 0 | 1641891816 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 81030150 |
|
| 22. | 0 | 21 | 5209 | 25974 | INDEX | 1 | 0 | YES | 526749110916 | 0 | 1653263116 | `fhem`.`history` | GEN_CLUST_INDEX | 153 | 15093 | 0 | FILE_PAGE | IO_NONE | NO | 81030151 |
|
| 23. | 0 | 22 | 5209 | 40554 | INDEX | 0 | 0 | NO | 0 | 0 | 1713721330 | `fhem`.`history` | Search_Idx | 349 | 16054 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 24. | 0 | 23 | 5209 | 31339 | INDEX | 1 | 0 | NO | 526751677236 | 0 | 1658154861 | `fhem`.`history` | Search_Idx | 503 | 15993 | 0 | FILE_PAGE | IO_NONE | NO | 81019757 |
|
| 25. | 0 | 24 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 26. | 0 | 25 | 5209 | 21399 | INDEX | 0 | 0 | NO | 0 | 0 | 1640842719 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15122 | 0 | FILE_PAGE | IO_NONE | NO | 81000234 |
|
| 27. | 0 | 26 | 5209 | 21156 | INDEX | 0 | 0 | NO | 0 | 0 | 1640842600 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15074 | 0 | FILE_PAGE | IO_NONE | NO | 81000144 |
|
| 28. | 0 | 27 | 5209 | 17906 | INDEX | 0 | 0 | NO | 0 | 0 | 1640483243 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15068 | 0 | FILE_PAGE | IO_NONE | NO | 80997909 |
|
| 29. | 0 | 28 | 5209 | 40669 | INDEX | 0 | 0 | NO | 0 | 0 | 1713721470 | `fhem`.`history` | Search_Idx | 349 | 16054 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 30. | 0 | 29 | 5209 | 32676 | INDEX | 0 | 0 | NO | 0 | 0 | 1707936033 | `fhem`.`history` | Search_Idx | 282 | 16074 | 0 | FILE_PAGE | IO_NONE | NO | 81020697 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>