[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 | 1313 | 6903 | INDEX | 0 | 0 | NO | 0 | 0 | 106906546 | `fhem`.`history` | GEN_CLUST_INDEX | 143 | 15087 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 2. | 0 | 1 | 1313 | 3974 | INDEX | 0 | 0 | NO | 0 | 0 | 64872401 | `fhem`.`history` | GEN_CLUST_INDEX | 153 | 15139 | 0 | FILE_PAGE | IO_NONE | NO | 3846241 |
|
| 3. | 0 | 2 | 1313 | 3955 | INDEX | 0 | 0 | NO | 0 | 0 | 64872384 | `fhem`.`history` | GEN_CLUST_INDEX | 158 | 15061 | 0 | FILE_PAGE | IO_NONE | NO | 3846234 |
|
| 4. | 0 | 3 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 5. | 0 | 4 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | MEMORY | IO_NONE | NO | 0 |
|
| 6. | 0 | 5 | 0 | 1043 | UNDO_LOG | 1 | 0 | NO | 111244205229 | 0 | 70073984 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 3851177 |
|
| 7. | 0 | 6 | 1313 | 2582 | INDEX | 0 | 0 | NO | 0 | 0 | 64137152 | `fhem`.`history` | GEN_CLUST_INDEX | 155 | 15101 | 0 | FILE_PAGE | IO_NONE | NO | 3845596 |
|
| 8. | 0 | 7 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 9. | 0 | 8 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 10. | 0 | 9 | 1308 | 122 | BLOB | 0 | 0 | NO | 0 | 0 | 64690975 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 3850147 |
|
| 11. | 0 | 10 | 1313 | 7189 | INDEX | 0 | 0 | NO | 0 | 0 | 106906855 | `fhem`.`history` | GEN_CLUST_INDEX | 154 | 15057 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 12. | 0 | 11 | 1313 | 6366 | INDEX | 0 | 0 | NO | 0 | 0 | 106906010 | `fhem`.`history` | GEN_CLUST_INDEX | 142 | 15084 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 13. | 0 | 12 | 1313 | 597 | INDEX | 0 | 0 | NO | 0 | 0 | 106900167 | `fhem`.`history` | GEN_CLUST_INDEX | 169 | 15137 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 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 | 0 | 0 | UNKNOWN | 0 | 0 | NO | 0 | 0 | 0 | NULL | NULL | 0 | 0 | 0 | NOT_USED | IO_NONE | NO | 0 |
|
| 16. | 0 | 15 | 0 | 266 | SYSTEM | 1 | 0 | NO | 111244204373 | 0 | 65693728 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 3851177 |
|
| 17. | 0 | 16 | 1313 | 29628 | INDEX | 1 | 0 | YES | 111244372217 | 0 | 110697772 | `fhem`.`history` | Search_Idx | 45 | 2340 | 0 | FILE_PAGE | IO_NONE | NO | 3851274 |
|
| 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 | 238 | SYSTEM | 1 | 0 | NO | 111243652931 | 0 | 65693724 | NULL | NULL | 0 | 0 | 0 | FILE_PAGE | IO_NONE | NO | 3851177 |
|
| 20. | 0 | 19 | 1313 | 800 | INDEX | 0 | 0 | NO | 0 | 0 | 62903321 | `fhem`.`history` | GEN_CLUST_INDEX | 154 | 15125 | 0 | FILE_PAGE | IO_NONE | NO | 3845596 |
|
| 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 | 1313 | 73 | INDEX | 0 | 0 | NO | 0 | 0 | 62955548 | `fhem`.`history` | GEN_CLUST_INDEX | 199 | 15115 | 0 | FILE_PAGE | IO_NONE | NO | 3845596 |
|
| 23. | 0 | 22 | 1313 | 29298 | INDEX | 1 | 0 | YES | 111242725332 | 0 | 73284317 | `fhem`.`history` | Search_Idx | 314 | 16014 | 0 | FILE_PAGE | IO_NONE | NO | 3851337 |
|
| 24. | 0 | 23 | 1313 | 1738 | INDEX | 0 | 0 | NO | 0 | 0 | 63037011 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15105 | 0 | FILE_PAGE | IO_NONE | NO | 3845596 |
|
| 25. | 0 | 24 | 1313 | 336 | INDEX | 0 | 0 | NO | 0 | 0 | 64941748 | `fhem`.`history` | GEN_CLUST_INDEX | 133 | 15135 | 0 | FILE_PAGE | IO_NONE | NO | 3845596 |
|
| 26. | 0 | 25 | 1313 | 2377 | INDEX | 0 | 0 | NO | 0 | 0 | 106901843 | `fhem`.`history` | GEN_CLUST_INDEX | 145 | 15072 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 27. | 0 | 26 | 1313 | 29337 | INDEX | 1 | 0 | NO | 111238536725 | 0 | 109017820 | `fhem`.`history` | Search_Idx | 42 | 2142 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 28. | 0 | 27 | 1313 | 3866 | INDEX | 0 | 0 | NO | 0 | 0 | 64872310 | `fhem`.`history` | GEN_CLUST_INDEX | 146 | 15117 | 0 | FILE_PAGE | IO_NONE | NO | 3846201 |
|
| 29. | 0 | 28 | 1313 | 1791 | INDEX | 0 | 0 | NO | 0 | 0 | 106901340 | `fhem`.`history` | GEN_CLUST_INDEX | 158 | 15036 | 0 | FILE_PAGE | IO_NONE | YES | 0 |
|
| 30. | 0 | 29 | 1313 | 30525 | INDEX | 1 | 0 | YES | 111194121119 | 0 | 67913870 | `fhem`.`history` | GEN_CLUST_INDEX | 155 | 15051 | 0 | FILE_PAGE | IO_NONE | NO | 3844827 |
Datensätze 1 - 30 von insgesamt 8191 << < > >>