[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 | 3027 | 14303 | INDEX | 0 | 0 | NO | 0 | 0 | 232300641 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 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 | 3027 | 13303 | INDEX | 0 | 0 | NO | 0 | 0 | 225337697 | `fhem`.`history` | Search_Idx | 433 | 16021 | 0 | FILE_PAGE | IO_NONE | YES | 3568456 |
|
| 4. | 0 | 3 | 3027 | 14377 | INDEX | 0 | 0 | NO | 0 | 0 | 227259253 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 5. | 0 | 4 | 3027 | 12608 | INDEX | 0 | 0 | NO | 0 | 0 | 232299308 | `fhem`.`history` | Search_Idx | 248 | 15128 | 0 | FILE_PAGE | IO_NONE | YES | 3568456 |
|
| 6. | 0 | 5 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 7. | 0 | 6 | 3027 | 1478 | INDEX | 0 | 0 | NO | 0 | 0 | 223899961 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15055 | 0 | FILE_PAGE | IO_NONE | YES | 3558060 |
|
| 8. | 0 | 7 | 3027 | 17489 | INDEX | 0 | 0 | NO | 0 | 0 | 217147024 | `fhem`.`history` | Search_Idx | 411 | 16029 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 9. | 0 | 8 | 3027 | 14096 | INDEX | 0 | 0 | NO | 0 | 0 | 232300503 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 10. | 0 | 9 | 3027 | 15847 | INDEX | 0 | 0 | NO | 0 | 0 | 216425132 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 11. | 0 | 10 | 3027 | 13702 | INDEX | 0 | 0 | NO | 0 | 0 | 226058475 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | YES | 3568456 |
|
| 12. | 0 | 11 | 3027 | 13252 | INDEX | 0 | 0 | NO | 0 | 0 | 232299908 | `fhem`.`history` | Search_Idx | 342 | 16074 | 0 | FILE_PAGE | IO_NONE | YES | 3568456 |
|
| 13. | 0 | 12 | 0 | 3849 | UNDO_LOG | 1 | 0 | NO | 237377950981 | 0 | 232286883 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 14. | 0 | 13 | 3022 | 398 | BLOB | 0 | 0 | NO | 0 | 0 | 232105626 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 15. | 0 | 14 | 3027 | 345 | INDEX | 0 | 0 | NO | 0 | 0 | 217386615 | `fhem`.`history` | GEN_CLUST_INDEX | 105 | 15146 | 0 | FILE_PAGE | IO_NONE | YES | 3547579 |
|
| 16. | 0 | 15 | 3027 | 17525 | INDEX | 0 | 0 | NO | 0 | 0 | 217147075 | `fhem`.`history` | Search_Idx | 411 | 16029 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 17. | 0 | 16 | 3027 | 17421 | INDEX | 0 | 0 | NO | 0 | 0 | 217146956 | `fhem`.`history` | Search_Idx | 214 | 7490 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 18. | 0 | 17 | 3027 | 14499 | INDEX | 0 | 0 | NO | 0 | 0 | 209217850 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 19. | 0 | 18 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 20. | 0 | 19 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 21. | 0 | 20 | 3027 | 15294 | INDEX | 0 | 0 | NO | 0 | 0 | 232301236 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 22. | 0 | 21 | 3027 | 17405 | INDEX | 0 | 0 | NO | 0 | 0 | 217146938 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 23. | 0 | 22 | 3027 | 410 | INDEX | 0 | 0 | NO | 0 | 0 | 217386651 | `fhem`.`history` | GEN_CLUST_INDEX | 170 | 15107 | 0 | FILE_PAGE | IO_NONE | YES | 3547581 |
|
| 24. | 0 | 23 | 3027 | 15484 | INDEX | 0 | 0 | NO | 0 | 0 | 232301409 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 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 | NOT_USED | IO_NONE | NO | 0 |
|
| 27. | 0 | 26 | 3027 | 4 | INDEX | 1 | 0 | NO | 237377955131 | 0 | 232076790 | `fhem`.`history` | Search_Idx | 25 | 1327 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 28. | 0 | 27 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 29. | 0 | 28 | 3027 | 16154 | INDEX | 0 | 0 | NO | 0 | 0 | 216665163 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
|
| 30. | 0 | 29 | 3027 | 17544 | INDEX | 0 | 0 | NO | 0 | 0 | 217147105 | `fhem`.`history` | Search_Idx | 422 | 16036 | 0 | FILE_PAGE | IO_NONE | NO | 3568456 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>