[Tools]
Datenbank:
`information_schema`
Tabelle: `INNODB_BUFFER_PAGE_LRU`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `information_schema`.`INNODB_BUFFER_PAGE_LRU`
Datensätze 1 - 30 von insgesamt 7081 << < > >>
| Ansicht: kompakt Die Abfrage enthält 20 Spalten | |||||||||||||||||||||
| # |  POOL_ID | LRU_POSITION | 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 | COMPRESSED | IO_FIX | IS_OLD | FREE_PAGE_CLOCK | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
  | 1. | 0 | 0 | 1313 | 6382 | INDEX | 0 | 0 | NO | 0 | 0 | 106906027 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15156 | 0 | NO | IO_NONE | YES | 0 |
|
| 2. | 0 | 1 | 1313 | 6383 | INDEX | 0 | 0 | NO | 0 | 0 | 106906028 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15089 | 0 | NO | IO_NONE | YES | 0 |
|
| 3. | 0 | 2 | 1313 | 6384 | INDEX | 0 | 0 | NO | 0 | 0 | 106906029 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15080 | 0 | NO | IO_NONE | YES | 0 |
|
| 4. | 0 | 3 | 1313 | 6385 | INDEX | 0 | 0 | NO | 0 | 0 | 106906030 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15118 | 0 | NO | IO_NONE | YES | 0 |
|
| 5. | 0 | 4 | 1313 | 6386 | INDEX | 0 | 0 | NO | 0 | 0 | 106906031 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15154 | 0 | NO | IO_NONE | YES | 0 |
|
| 6. | 0 | 5 | 1313 | 6387 | INDEX | 0 | 0 | NO | 0 | 0 | 106906032 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15122 | 0 | NO | IO_NONE | YES | 0 |
|
| 7. | 0 | 6 | 1313 | 6388 | INDEX | 0 | 0 | NO | 0 | 0 | 106906033 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15120 | 0 | NO | IO_NONE | YES | 0 |
|
| 8. | 0 | 7 | 1313 | 6389 | INDEX | 0 | 0 | NO | 0 | 0 | 106906034 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15068 | 0 | NO | IO_NONE | YES | 0 |
|
| 9. | 0 | 8 | 1313 | 6390 | INDEX | 0 | 0 | NO | 0 | 0 | 106906035 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15052 | 0 | NO | IO_NONE | YES | 0 |
|
| 10. | 0 | 9 | 1313 | 6391 | INDEX | 0 | 0 | NO | 0 | 0 | 106906036 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15118 | 0 | NO | IO_NONE | YES | 0 |
|
| 11. | 0 | 10 | 1313 | 6392 | INDEX | 0 | 0 | NO | 0 | 0 | 106906037 | `fhem`.`history` | GEN_CLUST_INDEX | 143 | 15074 | 0 | NO | IO_NONE | YES | 0 |
|
| 12. | 0 | 11 | 1313 | 6393 | INDEX | 0 | 0 | NO | 0 | 0 | 106906038 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15086 | 0 | NO | IO_NONE | YES | 0 |
|
| 13. | 0 | 12 | 1313 | 6394 | INDEX | 0 | 0 | NO | 0 | 0 | 106906039 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15140 | 0 | NO | IO_NONE | YES | 0 |
|
| 14. | 0 | 13 | 1313 | 6395 | INDEX | 0 | 0 | NO | 0 | 0 | 106906040 | `fhem`.`history` | GEN_CLUST_INDEX | 152 | 15094 | 0 | NO | IO_NONE | YES | 0 |
|
| 15. | 0 | 14 | 1313 | 6396 | INDEX | 0 | 0 | NO | 0 | 0 | 106906041 | `fhem`.`history` | GEN_CLUST_INDEX | 163 | 15060 | 0 | NO | IO_NONE | YES | 0 |
|
| 16. | 0 | 15 | 1313 | 6397 | INDEX | 0 | 0 | NO | 0 | 0 | 106906042 | `fhem`.`history` | GEN_CLUST_INDEX | 148 | 15147 | 0 | NO | IO_NONE | YES | 0 |
|
| 17. | 0 | 16 | 1313 | 6398 | INDEX | 0 | 0 | NO | 0 | 0 | 106906043 | `fhem`.`history` | GEN_CLUST_INDEX | 136 | 15160 | 0 | NO | IO_NONE | YES | 0 |
|
| 18. | 0 | 17 | 1313 | 6399 | INDEX | 0 | 0 | NO | 0 | 0 | 106906044 | `fhem`.`history` | GEN_CLUST_INDEX | 143 | 15142 | 0 | NO | IO_NONE | YES | 0 |
|
| 19. | 0 | 18 | 1313 | 6401 | INDEX | 0 | 0 | NO | 0 | 0 | 106906045 | `fhem`.`history` | GEN_CLUST_INDEX | 140 | 15139 | 0 | NO | IO_NONE | YES | 0 |
|
| 20. | 0 | 19 | 1313 | 6402 | INDEX | 0 | 0 | NO | 0 | 0 | 106906046 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15115 | 0 | NO | IO_NONE | YES | 0 |
|
| 21. | 0 | 20 | 1313 | 6403 | INDEX | 0 | 0 | NO | 0 | 0 | 106906047 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15106 | 0 | NO | IO_NONE | YES | 0 |
|
| 22. | 0 | 21 | 1313 | 6404 | INDEX | 0 | 0 | NO | 0 | 0 | 106906048 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15149 | 0 | NO | IO_NONE | YES | 0 |
|
| 23. | 0 | 22 | 1313 | 6405 | INDEX | 0 | 0 | NO | 0 | 0 | 106906049 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15109 | 0 | NO | IO_NONE | YES | 0 |
|
| 24. | 0 | 23 | 1313 | 6406 | INDEX | 0 | 0 | NO | 0 | 0 | 106906050 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15122 | 0 | NO | IO_NONE | YES | 0 |
|
| 25. | 0 | 24 | 1313 | 6407 | INDEX | 0 | 0 | NO | 0 | 0 | 106906051 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15109 | 0 | NO | IO_NONE | YES | 0 |
|
| 26. | 0 | 25 | 1313 | 6408 | INDEX | 0 | 0 | NO | 0 | 0 | 106906052 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15146 | 0 | NO | IO_NONE | YES | 0 |
|
| 27. | 0 | 26 | 1313 | 6409 | INDEX | 0 | 0 | NO | 0 | 0 | 106906053 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15133 | 0 | NO | IO_NONE | YES | 0 |
|
| 28. | 0 | 27 | 1313 | 6410 | INDEX | 0 | 0 | NO | 0 | 0 | 106906054 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15124 | 0 | NO | IO_NONE | YES | 0 |
|
| 29. | 0 | 28 | 1313 | 6411 | INDEX | 0 | 0 | NO | 0 | 0 | 106906055 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15070 | 0 | NO | IO_NONE | YES | 0 |
|
| 30. | 0 | 29 | 1313 | 6412 | INDEX | 0 | 0 | NO | 0 | 0 | 106906056 | `fhem`.`history` | GEN_CLUST_INDEX | 141 | 15093 | 0 | NO | IO_NONE | YES | 0 |
Datensätze 1 - 30 von insgesamt 7081 << < > >>