[Tools]
Datenbank:
`information_schema`
Tabelle: `INNODB_BUFFER_PAGE`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `information_schema`.`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 | 4632 | 26065 | INDEX | 1 | 0 | YES | 456167298857 | 0 | 2114017860 | `fhem`.`history` | GEN_CLUST_INDEX | 154 | 15137 | 0 | FILE_PAGE | IO_NONE | NO | 4816768 |
|
| 2. | 0 | 1 | 4632 | 3759 | INDEX | 0 | 0 | NO | 0 | 0 | 2132775549 | `fhem`.`history` | GEN_CLUST_INDEX | 137 | 15131 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 3. | 0 | 2 | 4632 | 19384 | INDEX | 0 | 0 | NO | 0 | 0 | 2112166924 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15065 | 0 | FILE_PAGE | IO_NONE | NO | 4811392 |
|
| 4. | 0 | 3 | 4632 | 19363 | INDEX | 0 | 0 | NO | 0 | 0 | 2112166913 | `fhem`.`history` | GEN_CLUST_INDEX | 161 | 15058 | 0 | FILE_PAGE | IO_NONE | NO | 4811389 |
|
| 5. | 0 | 4 | 4632 | 3807 | INDEX | 0 | 0 | NO | 0 | 0 | 2132775576 | `fhem`.`history` | GEN_CLUST_INDEX | 150 | 15044 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 6. | 0 | 5 | 4632 | 41909 | INDEX | 1 | 0 | NO | 456171520352 | 0 | 2121311493 | `fhem`.`history` | Search_Idx | 245 | 7595 | 0 | FILE_PAGE | IO_NONE | NO | 4793048 |
|
| 7. | 0 | 6 | 4632 | 4078 | INDEX | 0 | 0 | NO | 0 | 0 | 2132775727 | `fhem`.`history` | GEN_CLUST_INDEX | 136 | 15127 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 8. | 0 | 7 | 4632 | 24616 | INDEX | 0 | 0 | NO | 0 | 0 | 2132786866 | `fhem`.`history` | GEN_CLUST_INDEX | 149 | 15051 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 9. | 0 | 8 | 4632 | 4417 | INDEX | 0 | 0 | NO | 0 | 0 | 2132775916 | `fhem`.`history` | GEN_CLUST_INDEX | 169 | 15081 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 10. | 0 | 9 | 4627 | 75 | BLOB | 0 | 0 | NO | 0 | 0 | 2112937295 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 4817798 |
|
| 11. | 0 | 10 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 12. | 0 | 11 | 4632 | 25772 | INDEX | 0 | 0 | NO | 0 | 0 | 2132787562 | `fhem`.`history` | GEN_CLUST_INDEX | 152 | 15068 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 13. | 0 | 12 | 4632 | 24311 | INDEX | 0 | 0 | NO | 0 | 0 | 2132786685 | `fhem`.`history` | GEN_CLUST_INDEX | 161 | 15130 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 14. | 0 | 13 | 0 | 227 | SYSTEM | 1 | 0 | NO | 456179330257 | 0 | 2113027447 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 4817811 |
|
| 15. | 0 | 14 | 4632 | 3938 | INDEX | 0 | 0 | NO | 0 | 0 | 2132775649 | `fhem`.`history` | GEN_CLUST_INDEX | 138 | 15096 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 16. | 0 | 15 | 4632 | 20245 | INDEX | 0 | 0 | NO | 0 | 0 | 2112767064 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15146 | 0 | FILE_PAGE | IO_NONE | NO | 4811629 |
|
| 17. | 0 | 16 | 4632 | 17725 | INDEX | 0 | 0 | NO | 0 | 0 | 2111797713 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15095 | 0 | FILE_PAGE | IO_NONE | NO | 4810866 |
|
| 18. | 0 | 17 | 4632 | 20304 | INDEX | 0 | 0 | NO | 0 | 0 | 2112767094 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15069 | 0 | FILE_PAGE | IO_NONE | NO | 4811651 |
|
| 19. | 0 | 18 | 0 | 3899 | UNDO_LOG | 1 | 0 | NO | 456178978415 | 0 | 2130313613 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 4783270 |
|
| 20. | 0 | 19 | 4632 | 25737 | INDEX | 0 | 0 | NO | 0 | 0 | 2132787541 | `fhem`.`history` | GEN_CLUST_INDEX | 156 | 15149 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 21. | 0 | 20 | 4632 | 25252 | INDEX | 0 | 0 | NO | 0 | 0 | 2132787253 | `fhem`.`history` | GEN_CLUST_INDEX | 155 | 15141 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 22. | 0 | 21 | 4632 | 25072 | INDEX | 0 | 0 | NO | 0 | 0 | 2132787137 | `fhem`.`history` | GEN_CLUST_INDEX | 139 | 15084 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 23. | 0 | 22 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 24. | 0 | 23 | 4632 | 41883 | INDEX | 1 | 0 | NO | 456176025819 | 0 | 2114198069 | `fhem`.`history` | Search_Idx | 161 | 8113 | 0 | FILE_PAGE | IO_NONE | NO | 4792934 |
|
| 25. | 0 | 24 | 4632 | 19444 | INDEX | 0 | 0 | NO | 0 | 0 | 2112166954 | `fhem`.`history` | GEN_CLUST_INDEX | 149 | 15151 | 0 | FILE_PAGE | IO_NONE | NO | 4811400 |
|
| 26. | 0 | 25 | 4632 | 25343 | INDEX | 0 | 0 | NO | 0 | 0 | 2132787307 | `fhem`.`history` | GEN_CLUST_INDEX | 153 | 15054 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 27. | 0 | 26 | 4632 | 3573 | INDEX | 0 | 0 | NO | 0 | 0 | 2132775443 | `fhem`.`history` | GEN_CLUST_INDEX | 159 | 15100 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 28. | 0 | 27 | 4632 | 30112 | INDEX | 0 | 0 | NO | 0 | 0 | 2126036154 | `fhem`.`history` | Search_Idx | 441 | 16022 | 0 | FILE_PAGE | IO_NONE | NO | 4783275 |
|
| 29. | 0 | 28 | 4632 | 19592 | INDEX | 0 | 0 | NO | 0 | 0 | 2112766745 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15068 | 0 | FILE_PAGE | IO_NONE | NO | 4811420 |
|
| 30. | 0 | 29 | 4632 | 4323 | INDEX | 0 | 0 | NO | 0 | 0 | 2132775865 | `fhem`.`history` | GEN_CLUST_INDEX | 144 | 15085 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>