[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 | 4075 | 34299 | INDEX | 0 | 0 | NO | 0 | 0 | 2550066684 | `fhem`.`history` | Search_Idx | 282 | 16074 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 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 | 4075 | 42819 | INDEX | 0 | 0 | NO | 0 | 0 | 2571413519 | `fhem`.`history` | Search_Idx | 349 | 16054 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 4. | 0 | 3 | 4075 | 35502 | INDEX | 0 | 0 | NO | 0 | 0 | 2559417445 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 5. | 0 | 4 | 4075 | 43498 | INDEX | 0 | 0 | NO | 0 | 0 | 2571414281 | `fhem`.`history` | Search_Idx | 457 | 15995 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 6. | 0 | 5 | 4075 | 33383 | INDEX | 0 | 0 | NO | 0 | 0 | 2545256679 | `fhem`.`history` | Search_Idx | 268 | 16080 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 7. | 0 | 6 | 0 | 3870 | UNDO_LOG | 1 | 0 | NO | 380029576026 | 0 | 2570519343 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 53559492 |
|
| 8. | 0 | 7 | 4075 | 32178 | INDEX | 0 | 0 | NO | 0 | 0 | 2570708622 | `fhem`.`history` | Search_Idx | 328 | 16071 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 9. | 0 | 8 | 4075 | 42274 | INDEX | 0 | 0 | NO | 0 | 0 | 2571412972 | `fhem`.`history` | Search_Idx | 321 | 16050 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 10. | 0 | 9 | 4075 | 31567 | INDEX | 0 | 0 | NO | 0 | 0 | 2566009079 | `fhem`.`history` | Search_Idx | 433 | 16021 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 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 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 13. | 0 | 12 | 4075 | 37904 | INDEX | 0 | 0 | NO | 0 | 0 | 2558938845 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | FILE_PAGE | IO_NONE | NO | 53561508 |
|
| 14. | 0 | 13 | 4075 | 34459 | INDEX | 0 | 0 | NO | 0 | 0 | 2557273947 | `fhem`.`history` | Search_Idx | 282 | 16074 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 15. | 0 | 14 | 4075 | 32458 | INDEX | 0 | 0 | NO | 0 | 0 | 2538534741 | `fhem`.`history` | Search_Idx | 365 | 16060 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 16. | 0 | 15 | 4075 | 32473 | INDEX | 0 | 0 | NO | 0 | 0 | 2540518281 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 17. | 0 | 16 | 4075 | 41835 | INDEX | 0 | 0 | NO | 0 | 0 | 2571412568 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 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 | 4075 | 32924 | INDEX | 0 | 0 | NO | 0 | 0 | 2545256283 | `fhem`.`history` | Search_Idx | 357 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 20. | 0 | 19 | 4075 | 37368 | INDEX | 0 | 0 | NO | 0 | 0 | 2558938371 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | FILE_PAGE | IO_NONE | NO | 53561096 |
|
| 21. | 0 | 20 | 4075 | 32621 | INDEX | 0 | 0 | NO | 0 | 0 | 2530575083 | `fhem`.`history` | Search_Idx | 347 | 16040 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 22. | 0 | 21 | 4075 | 33678 | INDEX | 0 | 0 | NO | 0 | 0 | 2538535867 | `fhem`.`history` | Search_Idx | 471 | 16014 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 23. | 0 | 22 | 4075 | 35572 | INDEX | 0 | 0 | NO | 0 | 0 | 2559417514 | `fhem`.`history` | Search_Idx | 287 | 16072 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 24. | 0 | 23 | 4075 | 33803 | INDEX | 0 | 0 | NO | 0 | 0 | 2538535997 | `fhem`.`history` | Search_Idx | 282 | 16074 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 25. | 0 | 24 | 4075 | 32318 | INDEX | 0 | 0 | NO | 0 | 0 | 2570708790 | `fhem`.`history` | Search_Idx | 422 | 16036 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 26. | 0 | 25 | 4075 | 42570 | INDEX | 0 | 0 | NO | 0 | 0 | 2571413260 | `fhem`.`history` | Search_Idx | 457 | 15995 | 0 | FILE_PAGE | IO_NONE | YES | 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 | 4075 | 32928 | INDEX | 0 | 0 | NO | 0 | 0 | 2530575406 | `fhem`.`history` | Search_Idx | 357 | 16065 | 0 | FILE_PAGE | IO_NONE | NO | 53559650 |
|
| 30. | 0 | 29 | 4075 | 38850 | INDEX | 0 | 0 | NO | 0 | 0 | 2571410029 | `fhem`.`history` | Search_Idx | 328 | 16072 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>