[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 | 3765 | 16503 | INDEX | 0 | 0 | NO | 0 | 0 | 130752973 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 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 | 3765 | 15885 | INDEX | 0 | 0 | NO | 0 | 0 | 134973096 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | YES | 12197008 |
|
| 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 | 3765 | 6475 | INDEX | 0 | 0 | NO | 0 | 0 | 138164404 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15101 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 6. | 0 | 5 | 3765 | 16529 | INDEX | 0 | 0 | NO | 0 | 0 | 130752998 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 7. | 0 | 6 | 3765 | 18314 | INDEX | 0 | 0 | NO | 0 | 0 | 133397309 | `fhem`.`history` | Search_Idx | 457 | 15995 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 8. | 0 | 7 | 0 | 3007 | UNDO_LOG | 1 | 0 | NO | 347693071685 | 0 | 138188045 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 9. | 0 | 8 | 3765 | 17543 | INDEX | 0 | 0 | NO | 0 | 0 | 133396484 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 10. | 0 | 9 | 3765 | 5608 | INDEX | 0 | 0 | NO | 0 | 0 | 138163958 | `fhem`.`history` | GEN_CLUST_INDEX | 173 | 15103 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 11. | 0 | 10 | 3765 | 5692 | INDEX | 0 | 0 | NO | 0 | 0 | 138164001 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15155 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 12. | 0 | 11 | 3765 | 17140 | INDEX | 0 | 0 | NO | 0 | 0 | 133396087 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 13. | 0 | 12 | 3765 | 2500 | INDEX | 0 | 0 | NO | 0 | 0 | 135127344 | `fhem`.`history` | GEN_CLUST_INDEX | 147 | 15132 | 0 | FILE_PAGE | IO_NONE | NO | 12197916 |
|
| 14. | 0 | 13 | 3765 | 11433 | INDEX | 0 | 0 | NO | 0 | 0 | 138158012 | `fhem`.`history` | GEN_CLUST_INDEX | 157 | 15069 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 15. | 0 | 14 | 3765 | 18544 | INDEX | 0 | 0 | NO | 0 | 0 | 133397128 | `fhem`.`history` | Search_Idx | 243 | 8019 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 16. | 0 | 15 | 3765 | 2225 | INDEX | 0 | 0 | NO | 0 | 0 | 135127344 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15092 | 0 | FILE_PAGE | IO_NONE | NO | 12197836 |
|
| 17. | 0 | 16 | 3765 | 15108 | INDEX | 0 | 0 | NO | 0 | 0 | 128127237 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | YES | 12197008 |
|
| 18. | 0 | 17 | 3765 | 15842 | INDEX | 0 | 0 | NO | 0 | 0 | 134973056 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | YES | 12197008 |
|
| 19. | 0 | 18 | 3765 | 18752 | INDEX | 0 | 0 | NO | 0 | 0 | 133397019 | `fhem`.`history` | Search_Idx | 349 | 16054 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 20. | 0 | 19 | 3765 | 1209 | INDEX | 0 | 0 | NO | 0 | 0 | 135126117 | `fhem`.`history` | GEN_CLUST_INDEX | 143 | 15104 | 0 | FILE_PAGE | IO_NONE | NO | 12197056 |
|
| 21. | 0 | 20 | 3765 | 6545 | INDEX | 0 | 0 | NO | 0 | 0 | 138164441 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15081 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 22. | 0 | 21 | 3765 | 16261 | INDEX | 0 | 0 | NO | 0 | 0 | 128946244 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 23. | 0 | 22 | 3765 | 15657 | INDEX | 0 | 0 | NO | 0 | 0 | 128831092 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | YES | 12197008 |
|
| 24. | 0 | 23 | 3765 | 15755 | INDEX | 0 | 0 | NO | 0 | 0 | 128799222 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | YES | 12197008 |
|
| 25. | 0 | 24 | 3765 | 16661 | INDEX | 0 | 0 | NO | 0 | 0 | 130753124 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 26. | 0 | 25 | 3765 | 17723 | INDEX | 0 | 0 | NO | 0 | 0 | 133396658 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 27. | 0 | 26 | 3765 | 19537 | INDEX | 0 | 0 | YES | 0 | 0 | 138158394 | `fhem`.`history` | GEN_CLUST_INDEX | 147 | 15052 | 0 | FILE_PAGE | IO_NONE | NO | 12197008 |
|
| 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 | 3765 | 6425 | INDEX | 0 | 0 | NO | 0 | 0 | 138164379 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15146 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 30. | 0 | 29 | 3765 | 6111 | INDEX | 0 | 0 | NO | 0 | 0 | 138164219 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15117 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>