[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: normal 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 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 2. | 0 | 1 | 1373 | 34093 | INDEX | 1 | 0 | YES | 117419957592 | 0 | 552637319 | `fhem`.`history` | Search_Idx | 456 | 15960 | 0 | FILE_PAGE | IO_NONE | NO | 15593069 |
|
| 3. | 0 | 2 | 1373 | 988 | INDEX | 0 | 0 | NO | 0 | 0 | 546782268 | `fhem`.`history` | GEN_CLUST_INDEX | 174 | 15130 | 0 | FILE_PAGE | IO_NONE | NO | 15586500 |
|
| 4. | 0 | 3 | 1373 | 34236 | INDEX | 1 | 0 | YES | 117433904170 | 0 | 563498289 | `fhem`.`history` | Search_Idx | 277 | 11081 | 0 | FILE_PAGE | IO_NONE | NO | 15592959 |
|
| 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 | 1373 | 2060 | INDEX | 0 | 0 | NO | 0 | 0 | 562244892 | `fhem`.`history` | GEN_CLUST_INDEX | 153 | 15081 | 0 | FILE_PAGE | IO_NONE | NO | 15586500 |
|
| 7. | 0 | 6 | 1373 | 18547 | INDEX | 0 | 0 | NO | 0 | 0 | 544567837 | `fhem`.`history` | GEN_CLUST_INDEX | 150 | 15129 | 0 | FILE_PAGE | IO_NONE | YES | 15552734 |
|
| 8. | 0 | 7 | 1373 | 812 | INDEX | 0 | 0 | NO | 0 | 0 | 544659031 | `fhem`.`history` | GEN_CLUST_INDEX | 167 | 15131 | 0 | FILE_PAGE | IO_NONE | NO | 15586500 |
|
| 9. | 0 | 8 | 1373 | 33003 | INDEX | 1 | 0 | NO | 117420133141 | 0 | 567608553 | `fhem`.`history` | Search_Idx | 382 | 16044 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 10. | 0 | 9 | 1373 | 779 | INDEX | 0 | 0 | NO | 0 | 0 | 544658933 | `fhem`.`history` | GEN_CLUST_INDEX | 166 | 15052 | 0 | FILE_PAGE | IO_NONE | NO | 15586500 |
|
| 11. | 0 | 10 | 1373 | 33913 | INDEX | 1 | 0 | YES | 117427036442 | 0 | 544957361 | `fhem`.`history` | Search_Idx | 299 | 15548 | 0 | FILE_PAGE | IO_NONE | NO | 15593239 |
|
| 12. | 0 | 11 | 1373 | 1110 | INDEX | 0 | 0 | NO | 0 | 0 | 563748387 | `fhem`.`history` | GEN_CLUST_INDEX | 128 | 15153 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 13. | 0 | 12 | 1373 | 34131 | INDEX | 1 | 0 | YES | 117408885841 | 0 | 555727415 | `fhem`.`history` | Search_Idx | 19 | 988 | 0 | FILE_PAGE | IO_NONE | NO | 15572258 |
|
| 14. | 0 | 13 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 15. | 0 | 14 | 1373 | 21170 | INDEX | 0 | 0 | YES | 0 | 0 | 553587689 | `fhem`.`history` | GEN_CLUST_INDEX | 157 | 15078 | 0 | FILE_PAGE | IO_NONE | NO | 15572061 |
|
| 16. | 0 | 15 | 1373 | 1541 | INDEX | 0 | 0 | NO | 0 | 0 | 549205683 | `fhem`.`history` | GEN_CLUST_INDEX | 151 | 15092 | 0 | FILE_PAGE | IO_NONE | NO | 15586500 |
|
| 17. | 0 | 16 | 1373 | 35543 | INDEX | 1 | 0 | YES | 117397028918 | 0 | 546186754 | `fhem`.`history` | GEN_CLUST_INDEX | 153 | 15088 | 0 | FILE_PAGE | IO_NONE | NO | 15571865 |
|
| 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 | 1373 | 1927 | INDEX | 0 | 0 | NO | 0 | 0 | 559242281 | `fhem`.`history` | GEN_CLUST_INDEX | 146 | 15123 | 0 | FILE_PAGE | IO_NONE | NO | 15586500 |
|
| 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 | 1373 | 8101 | INDEX | 0 | 0 | NO | 0 | 0 | 543611457 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15141 | 0 | FILE_PAGE | IO_NONE | NO | 15591909 |
|
| 23. | 0 | 22 | 1373 | 19564 | INDEX | 0 | 0 | NO | 0 | 0 | 544837899 | `fhem`.`history` | GEN_CLUST_INDEX | 157 | 15031 | 0 | FILE_PAGE | IO_NONE | NO | 15553199 |
|
| 24. | 0 | 23 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | MEMORY | IO_NONE | NO | 0 |
|
| 25. | 0 | 24 | 1373 | 1497 | INDEX | 0 | 0 | NO | 0 | 0 | 549205636 | `fhem`.`history` | GEN_CLUST_INDEX | 156 | 15124 | 0 | FILE_PAGE | IO_NONE | NO | 15586500 |
|
| 26. | 0 | 25 | 1369 | 132 | BLOB | 0 | 0 | NO | 0 | 0 | 544924120 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 15592959 |
|
| 27. | 0 | 26 | 1373 | 18811 | INDEX | 0 | 0 | NO | 0 | 0 | 544567972 | `fhem`.`history` | GEN_CLUST_INDEX | 155 | 15064 | 0 | FILE_PAGE | IO_NONE | NO | 15552810 |
|
| 28. | 0 | 27 | 1373 | 7075 | INDEX | 0 | 0 | NO | 0 | 0 | 563754411 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15130 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 29. | 0 | 28 | 1373 | 15474 | INDEX | 0 | 0 | NO | 0 | 0 | 544388397 | `fhem`.`history` | GEN_CLUST_INDEX | 143 | 15148 | 0 | FILE_PAGE | IO_NONE | YES | 15550240 |
|
| 30. | 0 | 29 | 1373 | 17063 | INDEX | 0 | 0 | NO | 0 | 0 | 544807629 | `fhem`.`history` | GEN_CLUST_INDEX | 146 | 15098 | 0 | FILE_PAGE | IO_NONE | YES | 15551384 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>