[Tools]
Datenbank:
`fhem`
Tabelle: `INNODB_BUFFER_PAGE`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `fhem`.`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 | 3481 | 10112 | INDEX | 0 | 0 | NO | 0 | 0 | 354679886 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15142 | 0 | FILE_PAGE | IO_NONE | NO | 71176670 |
|
| 3. | 0 | 2 | 3476 | 222 | BLOB | 0 | 0 | NO | 0 | 0 | 354828032 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 71185071 |
|
| 4. | 0 | 3 | 3481 | 6902 | INDEX | 0 | 0 | NO | 0 | 0 | 354504458 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15121 | 0 | FILE_PAGE | IO_NONE | NO | 71176309 |
|
| 5. | 0 | 4 | 3481 | 7069 | INDEX | 0 | 0 | NO | 0 | 0 | 354509683 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15130 | 0 | FILE_PAGE | IO_NONE | NO | 71176309 |
|
| 6. | 0 | 5 | 3481 | 6289 | INDEX | 0 | 0 | NO | 0 | 0 | 354482375 | `fhem`.`history` | GEN_CLUST_INDEX | 160 | 15138 | 0 | FILE_PAGE | IO_NONE | NO | 71176309 |
|
| 7. | 0 | 6 | 3481 | 17957 | INDEX | 0 | 0 | NO | 0 | 0 | 368573824 | `fhem`.`history` | Search_Idx | 339 | 16055 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 8. | 0 | 7 | 3481 | 6038 | INDEX | 0 | 0 | NO | 0 | 0 | 354473195 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15048 | 0 | FILE_PAGE | IO_NONE | NO | 71176309 |
|
| 9. | 0 | 8 | 3481 | 7331 | INDEX | 0 | 0 | NO | 0 | 0 | 354520260 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15054 | 0 | FILE_PAGE | IO_NONE | NO | 71176309 |
|
| 10. | 0 | 9 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 11. | 0 | 10 | 3481 | 17062 | INDEX | 0 | 0 | NO | 0 | 0 | 368572749 | `fhem`.`history` | Search_Idx | 240 | 16080 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 12. | 0 | 11 | 3481 | 9048 | INDEX | 0 | 0 | NO | 0 | 0 | 354684850 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15143 | 0 | FILE_PAGE | IO_NONE | NO | 71176793 |
|
| 13. | 0 | 12 | 3481 | 17726 | INDEX | 0 | 0 | NO | 0 | 0 | 368573570 | `fhem`.`history` | Search_Idx | 277 | 16066 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 14. | 0 | 13 | 3481 | 19137 | INDEX | 1 | 0 | YES | 330860938158 | 0 | 369412581 | `fhem`.`history` | GEN_CLUST_INDEX | 155 | 15140 | 0 | FILE_PAGE | IO_NONE | NO | 71185820 |
|
| 15. | 0 | 14 | 3481 | 7191 | INDEX | 0 | 0 | NO | 0 | 0 | 354514940 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15081 | 0 | FILE_PAGE | IO_NONE | NO | 71176309 |
|
| 16. | 0 | 15 | 3481 | 7527 | INDEX | 0 | 0 | NO | 0 | 0 | 354528361 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15055 | 0 | FILE_PAGE | IO_NONE | NO | 71176309 |
|
| 17. | 0 | 16 | 3481 | 7958 | INDEX | 0 | 0 | NO | 0 | 0 | 354545363 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15138 | 0 | FILE_PAGE | IO_NONE | NO | 71176309 |
|
| 18. | 0 | 17 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 19. | 0 | 18 | 3481 | 12999 | INDEX | 1 | 0 | NO | 330856937687 | 0 | 356028482 | `fhem`.`history` | Search_Idx | 485 | 16005 | 0 | FILE_PAGE | IO_NONE | NO | 71180776 |
|
| 20. | 0 | 19 | 3481 | 6982 | INDEX | 0 | 0 | NO | 0 | 0 | 354507062 | `fhem`.`history` | GEN_CLUST_INDEX | 153 | 15064 | 0 | FILE_PAGE | IO_NONE | NO | 71176309 |
|
| 21. | 0 | 20 | 3481 | 13086 | INDEX | 0 | 0 | NO | 0 | 0 | 368569105 | `fhem`.`history` | Search_Idx | 391 | 16031 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 22. | 0 | 21 | 3481 | 16691 | INDEX | 0 | 0 | NO | 0 | 0 | 368572398 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 23. | 0 | 22 | 3481 | 18209 | INDEX | 1 | 0 | NO | 330858005067 | 0 | 359749228 | `fhem`.`history` | Search_Idx | 173 | 8131 | 0 | FILE_PAGE | IO_NONE | NO | 71180542 |
|
| 24. | 0 | 23 | 3481 | 17615 | INDEX | 0 | 0 | NO | 0 | 0 | 368573453 | `fhem`.`history` | Search_Idx | 349 | 16054 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 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 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | MEMORY | IO_NONE | NO | 0 |
|
| 27. | 0 | 26 | 3481 | 17529 | INDEX | 0 | 0 | NO | 0 | 0 | 368573365 | `fhem`.`history` | Search_Idx | 349 | 16054 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 28. | 0 | 27 | 3481 | 6847 | INDEX | 0 | 0 | NO | 0 | 0 | 354501946 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15129 | 0 | FILE_PAGE | IO_NONE | NO | 71176309 |
|
| 29. | 0 | 28 | 3481 | 7739 | INDEX | 0 | 0 | NO | 0 | 0 | 354536904 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15091 | 0 | FILE_PAGE | IO_NONE | NO | 71176309 |
|
| 30. | 0 | 29 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>