[Tools]
Datenbank:
`fhem`
Tabelle: `INNODB_SYS_INDEXES`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `fhem`.`INNODB_SYS_INDEXES`
Datensätze 1 - 21 von insgesamt 21 << < > >>
| Ansicht: kompakt Die Abfrage enthält 8 Spalten | |||||||||
| # |  INDEX_ID | NAME | TABLE_ID | TYPE | N_FIELDS | PAGE_NO | SPACE | MERGE_THRESHOLD | |
|---|---|---|---|---|---|---|---|---|---|
  | 1. | 11 | ID_IND | 11 | 3 | 1 | 302 | 0 | 50 |
|
| 2. | 12 | FOR_IND | 11 | 0 | 1 | 303 | 0 | 50 |
|
| 3. | 13 | REF_IND | 11 | 0 | 1 | 304 | 0 | 50 |
|
| 4. | 14 | ID_IND | 12 | 3 | 2 | 305 | 0 | 50 |
|
| 5. | 15 | SYS_TABLESPACES_SPACE | 13 | 3 | 1 | 307 | 0 | 50 |
|
| 6. | 16 | SYS_DATAFILES_SPACE | 14 | 3 | 1 | 308 | 0 | 50 |
|
| 7. | 17 | BASE_IDX | 15 | 3 | 3 | 310 | 0 | 50 |
|
| 8. | 20 | PRIMARY | 18 | 3 | 1 | 3 | 3 | 50 |
|
| 9. | 21 | commit_id | 18 | 2 | 1 | 4 | 3 | 50 |
|
| 10. | 22 | begin_timestamp | 18 | 0 | 1 | 5 | 3 | 50 |
|
| 11. | 23 | commit_timestamp | 18 | 0 | 2 | 6 | 3 | 50 |
|
| 12. | 231 | PRIMARY | 176 | 3 | 1 | 3 | 161 | 50 |
|
| 13. | 264 | PRIMARY | 203 | 3 | 3 | 3 | 188 | 50 |
|
| 14. | 290 | PRIMARY | 225 | 3 | 1 | 3 | 210 | 50 |
|
| 15. | 1561 | GEN_CLUST_INDEX | 1264 | 1 | 0 | 3 | 1249 | 50 |
|
| 16. | 1562 | GEN_CLUST_INDEX | 1265 | 1 | 0 | 3 | 1250 | 50 |
|
| 17. | 1563 | GEN_CLUST_INDEX | 1266 | 1 | 0 | 3 | 1251 | 50 |
|
| 18. | 1564 | GEN_CLUST_INDEX | 1267 | 1 | 0 | 3 | 1252 | 50 |
|
| 19. | 1565 | GEN_CLUST_INDEX | 1268 | 1 | 0 | 3 | 1253 | 50 |
|
| 20. | 1566 | GEN_CLUST_INDEX | 1269 | 1 | 0 | 3 | 1254 | 50 |
|
| 21. | 1567 | Search_Idx | 1269 | 0 | 3 | 4 | 1254 | 50 |
Datensätze 1 - 21 von insgesamt 21 << < > >>