[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 | 1254 | 2173 | INDEX | 0 | 0 | NO | 0 | 0 | 2411878 | `fhem`.`history` | GEN_CLUST_INDEX | 154 | 15093 | 0 | FILE_PAGE | IO_NONE | YES | 1001297 |
|
| 2. | 0 | 1 | 1254 | 35483 | INDEX | 1 | 0 | NO | 108691692104 | 0 | 12722958 | `fhem`.`history` | Search_Idx | 228 | 7752 | 0 | FILE_PAGE | IO_NONE | NO | 1006479 |
|
| 3. | 0 | 2 | 0 | 1083 | UNDO_LOG | 1 | 0 | NO | 108691900402 | 0 | 23823664 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 1006377 |
|
| 4. | 0 | 3 | 1254 | 28784 | INDEX | 1 | 0 | YES | 108681583654 | 0 | 8972610 | `fhem`.`history` | Search_Idx | 259 | 16058 | 0 | FILE_PAGE | IO_NONE | NO | 1005981 |
|
| 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 | 1254 | 7897 | INDEX | 0 | 0 | NO | 0 | 0 | 15440324 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15119 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 7. | 0 | 6 | 1254 | 36066 | INDEX | 0 | 0 | NO | 0 | 0 | 15514254 | `fhem`.`history` | Search_Idx | 375 | 13272 | 0 | FILE_PAGE | IO_NONE | NO | 1005843 |
|
| 8. | 0 | 7 | 1254 | 38756 | INDEX | 0 | 0 | YES | 0 | 0 | 15514208 | `fhem`.`history` | GEN_CLUST_INDEX | 155 | 15137 | 0 | FILE_PAGE | IO_NONE | NO | 1005843 |
|
| 9. | 0 | 8 | 1249 | 160 | BLOB | 0 | 0 | NO | 0 | 0 | 15484445 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 1006361 |
|
| 10. | 0 | 9 | 1254 | 679 | INDEX | 0 | 0 | NO | 0 | 0 | 3753960 | `fhem`.`history` | GEN_CLUST_INDEX | 168 | 15031 | 0 | FILE_PAGE | IO_NONE | YES | 1001297 |
|
| 11. | 0 | 10 | 1254 | 36847 | INDEX | 0 | 0 | NO | 0 | 0 | 14609541 | `fhem`.`history` | Search_Idx | 390 | 15990 | 0 | FILE_PAGE | IO_NONE | YES | 1001284 |
|
| 12. | 0 | 11 | 1254 | 8099 | INDEX | 0 | 0 | NO | 0 | 0 | 15440540 | `fhem`.`history` | GEN_CLUST_INDEX | 140 | 15065 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 13. | 0 | 12 | 1254 | 37094 | INDEX | 1 | 0 | YES | 108691971272 | 0 | 22173543 | `fhem`.`history` | Search_Idx | 219 | 8106 | 0 | FILE_PAGE | IO_NONE | NO | 1006293 |
|
| 14. | 0 | 13 | 1254 | 37100 | INDEX | 1 | 0 | YES | 108691935396 | 0 | 22743620 | `fhem`.`history` | Search_Idx | 53 | 2703 | 0 | FILE_PAGE | IO_NONE | NO | 1006321 |
|
| 15. | 0 | 14 | 1254 | 24895 | INDEX | 1 | 0 | YES | 108685810788 | 0 | 20373470 | `fhem`.`history` | GEN_CLUST_INDEX | 152 | 15063 | 0 | FILE_PAGE | IO_NONE | NO | 1006221 |
|
| 16. | 0 | 15 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 17. | 0 | 16 | 1254 | 22886 | INDEX | 0 | 0 | YES | 0 | 0 | 5314936 | `fhem`.`history` | GEN_CLUST_INDEX | 154 | 15069 | 0 | FILE_PAGE | IO_NONE | NO | 1006372 |
|
| 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 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 20. | 0 | 19 | 1254 | 38770 | INDEX | 0 | 0 | YES | 0 | 0 | 15514209 | `fhem`.`history` | GEN_CLUST_INDEX | 156 | 15122 | 0 | FILE_PAGE | IO_NONE | NO | 1005843 |
|
| 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 | 1254 | 3012 | INDEX | 0 | 0 | NO | 0 | 0 | 2763091 | `fhem`.`history` | GEN_CLUST_INDEX | 160 | 15124 | 0 | FILE_PAGE | IO_NONE | NO | 1001297 |
|
| 23. | 0 | 22 | 1254 | 7900 | INDEX | 0 | 0 | NO | 0 | 0 | 15440327 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15137 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 24. | 0 | 23 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 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 | 1254 | 8018 | INDEX | 0 | 0 | NO | 0 | 0 | 15440448 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15123 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 27. | 0 | 26 | 1254 | 24684 | INDEX | 0 | 0 | YES | 0 | 0 | 15514137 | `fhem`.`history` | GEN_CLUST_INDEX | 156 | 15038 | 0 | FILE_PAGE | IO_NONE | NO | 1005843 |
|
| 28. | 0 | 27 | 1254 | 38760 | INDEX | 0 | 0 | YES | 0 | 0 | 15514309 | `fhem`.`history` | GEN_CLUST_INDEX | 159 | 15143 | 0 | FILE_PAGE | IO_NONE | NO | 1005843 |
|
| 29. | 0 | 28 | 1254 | 36562 | INDEX | 1 | 0 | NO | 108690576170 | 0 | 24754036 | `fhem`.`history` | Search_Idx | 191 | 11460 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 30. | 0 | 29 | 1254 | 36376 | INDEX | 1 | 0 | NO | 108681683927 | 0 | 5372195 | `fhem`.`history` | Search_Idx | 332 | 14585 | 0 | FILE_PAGE | IO_NONE | NO | 1006357 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>