[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 | 5746 | 1572 | INDEX | 0 | 0 | NO | 0 | 0 | 4117381888 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15092 | 0 | FILE_PAGE | IO_NONE | NO | 23879902 |
|
| 2. | 0 | 1 | 5746 | 23489 | INDEX | 0 | 0 | NO | 0 | 0 | 4100755477 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15068 | 0 | FILE_PAGE | IO_NONE | NO | 23853696 |
|
| 3. | 0 | 2 | 5746 | 41446 | INDEX | 0 | 0 | NO | 0 | 0 | 4127034492 | `fhem`.`history` | Search_Idx | 342 | 16074 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 4. | 0 | 3 | 5746 | 30860 | INDEX | 0 | 0 | NO | 0 | 0 | 4127024346 | `fhem`.`history` | Search_Idx | 411 | 16029 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 5. | 0 | 4 | 5746 | 44165 | INDEX | 1 | 0 | NO | 593035599237 | 0 | 4124125608 | `fhem`.`history` | GEN_CLUST_INDEX | 149 | 15116 | 0 | FILE_PAGE | IO_NONE | NO | 23879860 |
|
| 6. | 0 | 5 | 5746 | 2469 | INDEX | 0 | 0 | NO | 0 | 0 | 4122168711 | `fhem`.`history` | GEN_CLUST_INDEX | 171 | 15090 | 0 | FILE_PAGE | IO_NONE | NO | 23880453 |
|
| 7. | 0 | 6 | 5746 | 44050 | INDEX | 1 | 0 | NO | 593031611925 | 0 | 4117165022 | `fhem`.`history` | GEN_CLUST_INDEX | 149 | 15049 | 0 | FILE_PAGE | IO_NONE | NO | 23865706 |
|
| 8. | 0 | 7 | 5746 | 40700 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033670 | `fhem`.`history` | Search_Idx | 315 | 16065 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 9. | 0 | 8 | 5746 | 20072 | INDEX | 0 | 0 | NO | 0 | 0 | 4100485538 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15094 | 0 | FILE_PAGE | IO_NONE | NO | 23851135 |
|
| 10. | 0 | 9 | 5746 | 30056 | INDEX | 0 | 0 | NO | 0 | 0 | 4127023391 | `fhem`.`history` | Search_Idx | 401 | 16040 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 11. | 0 | 10 | 5746 | 41846 | INDEX | 0 | 0 | NO | 0 | 0 | 4127034987 | `fhem`.`history` | Search_Idx | 433 | 16021 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 12. | 0 | 11 | 5742 | 83 | INDEX | 0 | 0 | NO | 0 | 0 | 4127050114 | `configDB`.`fhemconfig` | GEN_CLUST_INDEX | 116 | 15082 | 0 | FILE_PAGE | IO_NONE | NO | 23898498 |
|
| 13. | 0 | 12 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 14. | 0 | 13 | 5746 | 41271 | INDEX | 0 | 0 | NO | 0 | 0 | 4127034288 | `fhem`.`history` | Search_Idx | 461 | 15995 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 15. | 0 | 14 | 5746 | 42000 | INDEX | 1 | 0 | YES | 593030357592 | 0 | 4100964548 | `fhem`.`history` | Search_Idx | 370 | 15540 | 0 | FILE_PAGE | IO_NONE | NO | 23886435 |
|
| 16. | 0 | 15 | 5746 | 2722 | INDEX | 0 | 0 | NO | 0 | 0 | 4122169009 | `fhem`.`history` | GEN_CLUST_INDEX | 153 | 15053 | 0 | FILE_PAGE | IO_NONE | NO | 23880523 |
|
| 17. | 0 | 16 | 5746 | 30941 | INDEX | 0 | 0 | NO | 0 | 0 | 4127024435 | `fhem`.`history` | Search_Idx | 365 | 16060 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 18. | 0 | 17 | 5746 | 398 | INDEX | 0 | 0 | NO | 0 | 0 | 4100769528 | `fhem`.`history` | GEN_CLUST_INDEX | 134 | 15160 | 0 | FILE_PAGE | IO_NONE | NO | 23879902 |
|
| 19. | 0 | 18 | 5746 | 23006 | INDEX | 0 | 0 | NO | 0 | 0 | 4100755231 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15113 | 0 | FILE_PAGE | IO_NONE | NO | 23853696 |
|
| 20. | 0 | 19 | 5746 | 40347 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033323 | `fhem`.`history` | Search_Idx | 321 | 16050 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 21. | 0 | 20 | 5746 | 30053 | INDEX | 0 | 0 | NO | 0 | 0 | 4127023387 | `fhem`.`history` | Search_Idx | 382 | 16044 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 22. | 0 | 21 | 5746 | 30627 | INDEX | 0 | 0 | NO | 0 | 0 | 4127024064 | `fhem`.`history` | Search_Idx | 411 | 16029 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 23. | 0 | 22 | 5746 | 44181 | INDEX | 1 | 0 | NO | 593036841416 | 0 | 4126165658 | `fhem`.`history` | GEN_CLUST_INDEX | 149 | 15143 | 0 | FILE_PAGE | IO_NONE | NO | 23879892 |
|
| 24. | 0 | 23 | 5746 | 44037 | INDEX | 1 | 0 | NO | 593030570253 | 0 | 4115274882 | `fhem`.`history` | GEN_CLUST_INDEX | 153 | 15083 | 0 | FILE_PAGE | IO_NONE | NO | 23858093 |
|
| 25. | 0 | 24 | 5746 | 21076 | INDEX | 0 | 0 | NO | 0 | 0 | 4100679814 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15096 | 0 | FILE_PAGE | IO_NONE | NO | 23851585 |
|
| 26. | 0 | 25 | 5746 | 41254 | INDEX | 0 | 0 | NO | 0 | 0 | 4127034264 | `fhem`.`history` | Search_Idx | 445 | 16020 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 27. | 0 | 26 | 5746 | 2694 | INDEX | 0 | 0 | NO | 0 | 0 | 4122168979 | `fhem`.`history` | GEN_CLUST_INDEX | 163 | 15127 | 0 | FILE_PAGE | IO_NONE | NO | 23880513 |
|
| 28. | 0 | 27 | 5746 | 44186 | INDEX | 1 | 0 | NO | 593037231709 | 0 | 4126765703 | `fhem`.`history` | GEN_CLUST_INDEX | 152 | 15136 | 0 | FILE_PAGE | IO_NONE | NO | 23897269 |
|
| 29. | 0 | 28 | 5746 | 849 | INDEX | 0 | 0 | NO | 0 | 0 | 4100769775 | `fhem`.`history` | GEN_CLUST_INDEX | 164 | 15081 | 0 | FILE_PAGE | IO_NONE | NO | 23879902 |
|
| 30. | 0 | 29 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>