[Tools]
Datenbank:
`information_schema`
Tabelle: `INNODB_SYS_INDEXES`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `information_schema`.`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. | 1624 | GEN_CLUST_INDEX | 1323 | 1 | 0 | 3 | 1308 | 50 |
|
| 16. | 1625 | GEN_CLUST_INDEX | 1324 | 1 | 0 | 3 | 1309 | 50 |
|
| 17. | 1627 | GEN_CLUST_INDEX | 1326 | 1 | 0 | 3 | 1311 | 50 |
|
| 18. | 1628 | GEN_CLUST_INDEX | 1327 | 1 | 0 | 3 | 1312 | 50 |
|
| 19. | 1629 | GEN_CLUST_INDEX | 1328 | 1 | 0 | 3 | 1313 | 50 |
|
| 20. | 1630 | Search_Idx | 1328 | 0 | 3 | 4 | 1313 | 50 |
|
| 21. | 1631 | GEN_CLUST_INDEX | 1329 | 1 | 0 | 3 | 1314 | 50 |
Datensätze 1 - 21 von insgesamt 21 << < > >>