[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 | 3759 | 4339 | INDEX | 0 | 0 | NO | 0 | 0 | 114360620 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15089 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 2. | 0 | 1 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 3. | 0 | 2 | 3759 | 17033 | INDEX | 0 | 0 | NO | 0 | 0 | 111861387 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 10374113 |
|
| 4. | 0 | 3 | 3759 | 130 | INDEX | 0 | 0 | NO | 0 | 0 | 112462178 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15068 | 0 | FILE_PAGE | IO_NONE | NO | 10374658 |
|
| 5. | 0 | 4 | 3759 | 2786 | INDEX | 0 | 0 | NO | 0 | 0 | 114359842 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15113 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 6. | 0 | 5 | 3759 | 989 | INDEX | 0 | 0 | NO | 0 | 0 | 108636264 | `fhem`.`history` | GEN_CLUST_INDEX | 159 | 15102 | 0 | FILE_PAGE | IO_NONE | NO | 10374757 |
|
| 7. | 0 | 6 | 3759 | 14909 | INDEX | 0 | 0 | NO | 0 | 0 | 105030569 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | NO | 10374113 |
|
| 8. | 0 | 7 | 3759 | 18146 | INDEX | 1 | 0 | NO | 347350399663 | 0 | 114559591 | `fhem`.`history` | Search_Idx | 355 | 15269 | 0 | FILE_PAGE | IO_NONE | NO | 10379364 |
|
| 9. | 0 | 8 | 3759 | 14230 | INDEX | 0 | 0 | NO | 0 | 0 | 101103093 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | YES | 10374113 |
|
| 10. | 0 | 9 | 3759 | 4349 | INDEX | 0 | 0 | NO | 0 | 0 | 114360625 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15074 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 11. | 0 | 10 | 3759 | 4282 | INDEX | 0 | 0 | NO | 0 | 0 | 114360592 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15148 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 12. | 0 | 11 | 3759 | 14757 | INDEX | 0 | 0 | NO | 0 | 0 | 100680273 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | NO | 10374113 |
|
| 13. | 0 | 12 | 3759 | 17480 | INDEX | 0 | 0 | NO | 0 | 0 | 111861732 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | NO | 10374113 |
|
| 14. | 0 | 13 | 3754 | 103 | BLOB | 0 | 0 | NO | 0 | 0 | 114438561 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 10379326 |
|
| 15. | 0 | 14 | 3759 | 16847 | INDEX | 0 | 0 | NO | 0 | 0 | 107192828 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 10374113 |
|
| 16. | 0 | 15 | 3759 | 18745 | INDEX | 0 | 0 | NO | 0 | 0 | 108630105 | `fhem`.`history` | Search_Idx | 410 | 15990 | 0 | FILE_PAGE | IO_NONE | NO | 10374365 |
|
| 17. | 0 | 16 | 3759 | 17969 | INDEX | 0 | 0 | NO | 0 | 0 | 112344512 | `fhem`.`history` | Search_Idx | 349 | 16054 | 0 | FILE_PAGE | IO_NONE | NO | 10374261 |
|
| 18. | 0 | 17 | 3759 | 17153 | INDEX | 0 | 0 | NO | 0 | 0 | 110794829 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 10374113 |
|
| 19. | 0 | 18 | 3759 | 15500 | INDEX | 0 | 0 | NO | 0 | 0 | 105031042 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | NO | 10374113 |
|
| 20. | 0 | 19 | 3759 | 15711 | INDEX | 0 | 0 | NO | 0 | 0 | 107192077 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | NO | 10374113 |
|
| 21. | 0 | 20 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 22. | 0 | 21 | 3759 | 508 | INDEX | 0 | 0 | NO | 0 | 0 | 112462001 | `fhem`.`history` | GEN_CLUST_INDEX | 169 | 15038 | 0 | FILE_PAGE | IO_NONE | NO | 10374680 |
|
| 23. | 0 | 22 | 3759 | 3390 | INDEX | 0 | 0 | NO | 0 | 0 | 114360148 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15123 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 24. | 0 | 23 | 3759 | 959 | INDEX | 0 | 0 | NO | 0 | 0 | 112462025 | `fhem`.`history` | GEN_CLUST_INDEX | 170 | 15107 | 0 | FILE_PAGE | IO_NONE | NO | 10374749 |
|
| 25. | 0 | 24 | 3759 | 3209 | INDEX | 0 | 0 | NO | 0 | 0 | 114360056 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15155 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 26. | 0 | 25 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 27. | 0 | 26 | 3759 | 3298 | INDEX | 0 | 0 | NO | 0 | 0 | 114360101 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15082 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 28. | 0 | 27 | 3759 | 17128 | INDEX | 0 | 0 | NO | 0 | 0 | 110794807 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 10374113 |
|
| 29. | 0 | 28 | 3759 | 3174 | INDEX | 0 | 0 | NO | 0 | 0 | 114360039 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15142 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 30. | 0 | 29 | 3759 | 15628 | INDEX | 0 | 0 | NO | 0 | 0 | 111860675 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | NO | 10374113 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>