[Tools]
Datenbank:
`information_schema`
Tabelle: `PARTITIONS`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `information_schema`.`PARTITIONS`
Datensätze 1 - 30 von insgesamt 82 << < > >>
| Ansicht: kompakt Die Abfrage enthält 25 Spalten | ||||||||||||||||||||||||||
| # |  TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION [BB] | SUBPARTITION_EXPRESSION [BB] | PARTITION_DESCRIPTION [BB] | TABLE_ROWS |  AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
  | 1. | def | information_schema | ALL_PLUGINS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 2. | def | information_schema | CHECK_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 3. | def | information_schema | COLUMNS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 4. | def | information_schema | EVENTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 5. | def | information_schema | OPTIMIZER_TRACE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 6. | def | information_schema | PARAMETERS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 7. | def | information_schema | PARTITIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 8. | def | information_schema | PLUGINS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 9. | def | information_schema | PROCESSLIST | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 10. | def | information_schema | ROUTINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 11. | def | information_schema | SYSTEM_VARIABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 12. | def | information_schema | TRIGGERS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 13. | def | information_schema | VIEWS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 8192 | 4503599627288576 | 8192 | 0 | 2024-05-19 16:55:37 | 2024-05-19 16:55:37 | NULL | NULL | NULL | ||
|
| 14. | def | information_schema | INNODB_FT_BEING_DELETED | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 9 | 0 | 18874368 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 15. | def | information_schema | INNODB_FT_DELETED | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 9 | 0 | 18874368 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 16. | def | information_schema | INNODB_SYS_VIRTUAL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 17 | 0 | 23767717 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 17. | def | information_schema | INNODB_CMP | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 25 | 0 | 26214400 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 18. | def | information_schema | INNODB_CMP_RESET | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 25 | 0 | 26214400 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 19. | def | information_schema | THREAD_POOL_GROUPS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 27 | 0 | 28311552 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 20. | def | information_schema | INNODB_CMPMEM | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 29 | 0 | 30408704 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 21. | def | information_schema | INNODB_CMPMEM_RESET | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 29 | 0 | 30408704 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 22. | def | information_schema | THREAD_POOL_QUEUES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 30 | 0 | 31457280 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 23. | def | information_schema | INNODB_FT_DEFAULT_STOPWORD | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 56 | 0 | 29360128 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 24. | def | information_schema | THREAD_POOL_WAITS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 58 | 0 | 30408704 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 25. | def | information_schema | THREAD_POOL_STATS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 85 | 0 | 32410500 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 26. | def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 195 | 0 | 32715540 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 27. | def | information_schema | KEYWORDS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 195 | 0 | 32715540 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 28. | def | information_schema | SQL_FUNCTIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 195 | 0 | 32715540 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 29. | def | information_schema | INNODB_SYS_FIELDS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 206 | 0 | 33231714 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
|
| 30. | def | information_schema | INNODB_SYS_COLUMNS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 222 | 0 | 33254712 | 0 | 0 | 2024-05-19 16:55:37 | NULL | NULL | NULL | NULL | ||
Datensätze 1 - 30 von insgesamt 82 << < > >>