[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 7158 << < > >>
| 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 | 5746 | 40171 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033151 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 2. | 0 | 1 | 5746 | 40172 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033151 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 3. | 0 | 2 | 5746 | 40173 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033152 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 4. | 0 | 3 | 5746 | 40174 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033153 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 5. | 0 | 4 | 5746 | 40175 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033154 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 6. | 0 | 5 | 5746 | 40176 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033155 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 7. | 0 | 6 | 5746 | 40177 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033156 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 8. | 0 | 7 | 5746 | 40178 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033157 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 9. | 0 | 8 | 5746 | 40179 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033158 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 10. | 0 | 9 | 5746 | 40180 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033159 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 11. | 0 | 10 | 5746 | 40181 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033160 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 12. | 0 | 11 | 5746 | 40182 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033161 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 13. | 0 | 12 | 5746 | 40183 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033162 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 14. | 0 | 13 | 5746 | 40184 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033163 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 15. | 0 | 14 | 5746 | 40185 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033164 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 16. | 0 | 15 | 5746 | 40186 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033165 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 17. | 0 | 16 | 5746 | 40187 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033166 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 18. | 0 | 17 | 5746 | 40188 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033166 | `fhem`.`history` | Search_Idx | 303 | 16059 | 0 | NO | IO_NONE | YES | 0 |
|
| 19. | 0 | 18 | 5746 | 40189 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033167 | `fhem`.`history` | Search_Idx | 302 | 16099 | 0 | NO | IO_NONE | YES | 0 |
|
| 20. | 0 | 19 | 5746 | 40190 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033168 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | NO | IO_NONE | YES | 0 |
|
| 21. | 0 | 20 | 5746 | 40191 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033169 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | NO | IO_NONE | YES | 0 |
|
| 22. | 0 | 21 | 5746 | 40193 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033170 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | NO | IO_NONE | YES | 0 |
|
| 23. | 0 | 22 | 5746 | 40194 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033171 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | NO | IO_NONE | YES | 0 |
|
| 24. | 0 | 23 | 5746 | 40195 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033172 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | NO | IO_NONE | YES | 0 |
|
| 25. | 0 | 24 | 5746 | 40196 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033173 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | NO | IO_NONE | YES | 0 |
|
| 26. | 0 | 25 | 5746 | 40197 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033174 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | NO | IO_NONE | YES | 0 |
|
| 27. | 0 | 26 | 5746 | 40198 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033175 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | NO | IO_NONE | YES | 0 |
|
| 28. | 0 | 27 | 5746 | 41664 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033176 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | NO | IO_NONE | YES | 0 |
|
| 29. | 0 | 28 | 5746 | 40199 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033177 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | NO | IO_NONE | YES | 0 |
|
| 30. | 0 | 29 | 5746 | 40200 | INDEX | 0 | 0 | NO | 0 | 0 | 4127033177 | `fhem`.`history` | Search_Idx | 298 | 16092 | 0 | NO | IO_NONE | YES | 0 |
Datensätze 1 - 30 von insgesamt 7158 << < > >>