[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 | 5209 | 2116 | INDEX | 0 | 0 | NO | 0 | 0 | 1719203210 | `fhem`.`history` | GEN_CLUST_INDEX | 155 | 15114 | 0 | FILE_PAGE | IO_NONE | NO | 81557362 |
|
| 2. | 0 | 1 | 5209 | 2228 | INDEX | 0 | 0 | NO | 0 | 0 | 1719203311 | `fhem`.`history` | GEN_CLUST_INDEX | 139 | 15079 | 0 | FILE_PAGE | IO_NONE | NO | 81557362 |
|
| 3. | 0 | 2 | 5209 | 7880 | INDEX | 0 | 0 | NO | 0 | 0 | 1721130021 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15129 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 4. | 0 | 3 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 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 | 5209 | 3191 | INDEX | 0 | 0 | NO | 0 | 0 | 1719835977 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15148 | 0 | FILE_PAGE | IO_NONE | NO | 81557362 |
|
| 7. | 0 | 6 | 5209 | 1535 | INDEX | 0 | 0 | NO | 0 | 0 | 1719202710 | `fhem`.`history` | GEN_CLUST_INDEX | 163 | 15074 | 0 | FILE_PAGE | IO_NONE | NO | 81557362 |
|
| 8. | 0 | 7 | 5209 | 3614 | INDEX | 0 | 0 | NO | 0 | 0 | 1719520719 | `fhem`.`history` | GEN_CLUST_INDEX | 112 | 14751 | 0 | FILE_PAGE | IO_NONE | NO | 81557362 |
|
| 9. | 0 | 8 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 10. | 0 | 9 | 5204 | 153 | BLOB | 0 | 0 | NO | 0 | 0 | 1719999072 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 81560551 |
|
| 11. | 0 | 10 | 0 | 279 | SYSTEM | 1 | 0 | NO | 526811274923 | 0 | 1720621511 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 81560553 |
|
| 12. | 0 | 11 | 0 | 1076 | UNDO_LOG | 1 | 0 | NO | 526811110621 | 0 | 1720711482 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 81560690 |
|
| 13. | 0 | 12 | 5209 | 4727 | INDEX | 0 | 0 | NO | 0 | 0 | 1719941877 | `fhem`.`history` | GEN_CLUST_INDEX | 163 | 15099 | 0 | FILE_PAGE | IO_NONE | NO | 81557362 |
|
| 14. | 0 | 13 | 5209 | 2258 | INDEX | 0 | 0 | NO | 0 | 0 | 1719203337 | `fhem`.`history` | GEN_CLUST_INDEX | 153 | 15130 | 0 | FILE_PAGE | IO_NONE | NO | 81557362 |
|
| 15. | 0 | 14 | 5209 | 1268 | INDEX | 0 | 0 | NO | 0 | 0 | 1719202513 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15152 | 0 | FILE_PAGE | IO_NONE | YES | 81557362 |
|
| 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 | 5209 | 41829 | INDEX | 1 | 0 | NO | 526810788562 | 0 | 1720203009 | `fhem`.`history` | Search_Idx | 190 | 6460 | 0 | FILE_PAGE | IO_NONE | NO | 81560619 |
|
| 18. | 0 | 17 | 5209 | 6733 | INDEX | 0 | 0 | NO | 0 | 0 | 1721128888 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15116 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 19. | 0 | 18 | 5209 | 1598 | INDEX | 0 | 0 | NO | 0 | 0 | 1719096941 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15154 | 0 | FILE_PAGE | IO_NONE | NO | 81557362 |
|
| 20. | 0 | 19 | 5209 | 7831 | INDEX | 0 | 0 | NO | 0 | 0 | 1721129974 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15079 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 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 | 5209 | 3774 | INDEX | 0 | 0 | NO | 0 | 0 | 1719836396 | `fhem`.`history` | GEN_CLUST_INDEX | 159 | 15104 | 0 | FILE_PAGE | IO_NONE | NO | 81557362 |
|
| 23. | 0 | 22 | 5209 | 5060 | INDEX | 0 | 0 | NO | 0 | 0 | 1720152359 | `fhem`.`history` | GEN_CLUST_INDEX | 149 | 15084 | 0 | FILE_PAGE | IO_NONE | NO | 81557362 |
|
| 24. | 0 | 23 | 5209 | 6448 | INDEX | 0 | 0 | NO | 0 | 0 | 1719680734 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15111 | 0 | FILE_PAGE | IO_NONE | NO | 81558122 |
|
| 25. | 0 | 24 | 5209 | 705 | INDEX | 0 | 0 | NO | 0 | 0 | 1720096957 | `fhem`.`history` | GEN_CLUST_INDEX | 163 | 15095 | 0 | FILE_PAGE | IO_NONE | YES | 81557362 |
|
| 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 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 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 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 30. | 0 | 29 | 5209 | 3194 | INDEX | 0 | 0 | NO | 0 | 0 | 1719467965 | `fhem`.`history` | GEN_CLUST_INDEX | 171 | 15090 | 0 | FILE_PAGE | IO_NONE | NO | 81557362 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>