[Tools]
Datenbank:
`fhem`
Tabelle: `INNODB_BUFFER_PAGE_LRU`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `fhem`.`INNODB_BUFFER_PAGE_LRU`
Datensätze 1 - 30 von insgesamt 7148 << < > >>
| Ansicht: kompakt Die Abfrage enthält 20 Spalten | |||||||||||||||||||||
| # |  POOL_ID | LRU_POSITION | 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 | COMPRESSED | IO_FIX | IS_OLD | FREE_PAGE_CLOCK | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
  | 1. | 0 | 0 | 3027 | 9484 | INDEX | 0 | 0 | NO | 0 | 0 | 232069981 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15113 | 0 | NO | IO_NONE | YES | 0 |
|
| 2. | 0 | 1 | 3027 | 9486 | INDEX | 0 | 0 | NO | 0 | 0 | 232069982 | `fhem`.`history` | GEN_CLUST_INDEX | 143 | 15114 | 0 | NO | IO_NONE | YES | 0 |
|
| 3. | 0 | 2 | 3027 | 9487 | INDEX | 0 | 0 | YES | 0 | 0 | 232069982 | `fhem`.`history` | GEN_CLUST_INDEX | 152 | 15141 | 0 | NO | IO_NONE | YES | 0 |
|
| 4. | 0 | 3 | 3027 | 9488 | INDEX | 0 | 0 | NO | 0 | 0 | 232069982 | `fhem`.`history` | GEN_CLUST_INDEX | 171 | 15034 | 0 | NO | IO_NONE | YES | 0 |
|
| 5. | 0 | 4 | 3027 | 9489 | INDEX | 0 | 0 | YES | 0 | 0 | 232069982 | `fhem`.`history` | GEN_CLUST_INDEX | 149 | 15023 | 0 | NO | IO_NONE | YES | 0 |
|
| 6. | 0 | 5 | 3027 | 9490 | INDEX | 0 | 0 | YES | 0 | 0 | 232069982 | `fhem`.`history` | GEN_CLUST_INDEX | 150 | 15131 | 0 | NO | IO_NONE | YES | 0 |
|
| 7. | 0 | 6 | 3027 | 9491 | INDEX | 0 | 0 | NO | 0 | 0 | 232069982 | `fhem`.`history` | GEN_CLUST_INDEX | 167 | 15098 | 0 | NO | IO_NONE | YES | 0 |
|
| 8. | 0 | 7 | 3027 | 9492 | INDEX | 0 | 0 | YES | 0 | 0 | 232069983 | `fhem`.`history` | GEN_CLUST_INDEX | 149 | 15075 | 0 | NO | IO_NONE | YES | 0 |
|
| 9. | 0 | 8 | 3027 | 9493 | INDEX | 0 | 0 | YES | 0 | 0 | 232069983 | `fhem`.`history` | GEN_CLUST_INDEX | 158 | 15109 | 0 | NO | IO_NONE | YES | 0 |
|
| 10. | 0 | 9 | 3027 | 9494 | INDEX | 0 | 0 | NO | 0 | 0 | 232069983 | `fhem`.`history` | GEN_CLUST_INDEX | 160 | 15078 | 0 | NO | IO_NONE | YES | 0 |
|
| 11. | 0 | 10 | 3027 | 9495 | INDEX | 0 | 0 | YES | 0 | 0 | 232069983 | `fhem`.`history` | GEN_CLUST_INDEX | 143 | 15051 | 0 | NO | IO_NONE | YES | 0 |
|
| 12. | 0 | 11 | 3027 | 9496 | INDEX | 0 | 0 | YES | 0 | 0 | 232069983 | `fhem`.`history` | GEN_CLUST_INDEX | 149 | 15144 | 0 | NO | IO_NONE | YES | 0 |
|
| 13. | 0 | 12 | 3027 | 9497 | INDEX | 0 | 0 | NO | 0 | 0 | 232069984 | `fhem`.`history` | GEN_CLUST_INDEX | 168 | 15121 | 0 | NO | IO_NONE | YES | 0 |
|
| 14. | 0 | 13 | 3027 | 9498 | INDEX | 0 | 0 | YES | 0 | 0 | 232069984 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15020 | 0 | NO | IO_NONE | YES | 0 |
|
| 15. | 0 | 14 | 3027 | 9499 | INDEX | 0 | 0 | NO | 0 | 0 | 232069984 | `fhem`.`history` | GEN_CLUST_INDEX | 162 | 15125 | 0 | NO | IO_NONE | YES | 0 |
|
| 16. | 0 | 15 | 3027 | 9500 | INDEX | 0 | 0 | YES | 0 | 0 | 232069984 | `fhem`.`history` | GEN_CLUST_INDEX | 162 | 15112 | 0 | NO | IO_NONE | YES | 0 |
|
| 17. | 0 | 16 | 3027 | 9501 | INDEX | 0 | 0 | YES | 0 | 0 | 232069984 | `fhem`.`history` | GEN_CLUST_INDEX | 150 | 15056 | 0 | NO | IO_NONE | YES | 0 |
|
| 18. | 0 | 17 | 0 | 1518 | UNDO_LOG | 1 | 0 | NO | 237377549708 | 0 | 231446654 | NULL | NULL | 0 | 0 | 0 | NO | IO_NONE | YES | 3546981 |
|
| 19. | 0 | 18 | 3027 | 9502 | INDEX | 0 | 0 | NO | 0 | 0 | 232069985 | `fhem`.`history` | GEN_CLUST_INDEX | 170 | 15004 | 0 | NO | IO_NONE | YES | 0 |
|
| 20. | 0 | 19 | 3027 | 9503 | INDEX | 0 | 0 | YES | 0 | 0 | 232069985 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15067 | 0 | NO | IO_NONE | YES | 0 |
|
| 21. | 0 | 20 | 3027 | 10880 | INDEX | 0 | 0 | YES | 0 | 0 | 232069985 | `fhem`.`history` | GEN_CLUST_INDEX | 149 | 15138 | 0 | NO | IO_NONE | YES | 0 |
|
| 22. | 0 | 21 | 3027 | 9504 | INDEX | 0 | 0 | NO | 0 | 0 | 232069985 | `fhem`.`history` | GEN_CLUST_INDEX | 169 | 15077 | 0 | NO | IO_NONE | YES | 0 |
|
| 23. | 0 | 22 | 3027 | 9505 | INDEX | 0 | 0 | YES | 0 | 0 | 232069985 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15126 | 0 | NO | IO_NONE | YES | 0 |
|
| 24. | 0 | 23 | 3027 | 9506 | INDEX | 0 | 0 | YES | 0 | 0 | 232069986 | `fhem`.`history` | GEN_CLUST_INDEX | 156 | 15072 | 0 | NO | IO_NONE | YES | 0 |
|
| 25. | 0 | 24 | 3027 | 9507 | INDEX | 0 | 0 | NO | 0 | 0 | 232069986 | `fhem`.`history` | GEN_CLUST_INDEX | 161 | 15037 | 0 | NO | IO_NONE | YES | 0 |
|
| 26. | 0 | 25 | 3027 | 9508 | INDEX | 0 | 0 | YES | 0 | 0 | 232069986 | `fhem`.`history` | GEN_CLUST_INDEX | 146 | 15143 | 0 | NO | IO_NONE | YES | 0 |
|
| 27. | 0 | 26 | 3027 | 9509 | INDEX | 0 | 0 | NO | 0 | 0 | 232069986 | `fhem`.`history` | GEN_CLUST_INDEX | 171 | 15137 | 0 | NO | IO_NONE | YES | 0 |
|
| 28. | 0 | 27 | 3027 | 9510 | INDEX | 0 | 0 | YES | 0 | 0 | 232069986 | `fhem`.`history` | GEN_CLUST_INDEX | 149 | 15090 | 0 | NO | IO_NONE | YES | 0 |
|
| 29. | 0 | 28 | 3027 | 9511 | INDEX | 0 | 0 | YES | 0 | 0 | 232069987 | `fhem`.`history` | GEN_CLUST_INDEX | 148 | 15084 | 0 | NO | IO_NONE | YES | 0 |
|
| 30. | 0 | 29 | 3027 | 9512 | INDEX | 0 | 0 | NO | 0 | 0 | 232069987 | `fhem`.`history` | GEN_CLUST_INDEX | 170 | 15127 | 0 | NO | IO_NONE | YES | 0 |
Datensätze 1 - 30 von insgesamt 7148 << < > >>