SELECT * FROM `TABLES`
ORDER BY `TABLES`.`TABLE_SCHEMA` ASC
过滤行: |
TABLE_CATALOG | TABLE_SCHEMA 1 | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | gym | README | BASE TABLE | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 0 | NULL | 2024-06-13 12:04:14 | NULL | NULL | utf8_general_ci | NULL | |||
def | information_schema | INDEX_STATISTICS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 1743 | 0 | 16765917 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=9625 | ||
def | information_schema | ROUTINES | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 4503599627288576 | 8192 | 0 | NULL | 2024-06-17 14:25:44 | 2024-06-17 14:25:44 | NULL | utf8_general_ci | NULL | max_rows=576 | ||
def | information_schema | INNODB_BUFFER_POOL_STATS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 257 | 0 | 16332350 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=65280 | ||
def | information_schema | COLUMN_PRIVILEGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2893 | 0 | 16759149 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=5799 | ||
def | information_schema | CLIENT_STATISTICS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 386 | 0 | 16520414 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=43464 | ||
def | information_schema | REFERENTIAL_CONSTRAINTS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 4814 | 0 | 16767162 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=3485 | ||
def | information_schema | INNODB_CMP_RESET | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 25 | 0 | 13107200 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=671088 | ||
def | information_schema | COLUMNS | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 4503599627288576 | 8192 | 0 | NULL | 2024-06-17 14:25:44 | 2024-06-17 14:25:44 | NULL | utf8_general_ci | NULL | max_rows=2799 | ||
def | information_schema | INNODB_SYS_FIELDS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 594 | 0 | 16609428 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=28244 | ||
def | information_schema | PROFILING | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 308 | 0 | 16562084 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=54471 | ||
def | information_schema | INNODB_TABLESPACES_SCRUBBING | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2016 | 0 | 16710624 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=8322 | ||
def | information_schema | INNODB_SYS_FOREIGN_COLS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 1748 | 0 | 16738848 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=9597 | ||
def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 195 | 0 | 16357770 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=86037 | ||
def | information_schema | XTRADB_INTERNAL_HASH_TABLES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 327 | 0 | 16726050 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=51306 | ||
def | information_schema | GEOMETRY_COLUMNS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 4244 | 0 | 16759556 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=3953 | ||
def | information_schema | SPATIAL_REF_SYS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 7691 | 0 | 16758689 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=2181 | ||
def | information_schema | INNODB_FT_DELETED | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 9 | 0 | 9437184 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=1864135 | ||
def | information_schema | INNODB_BUFFER_PAGE_LRU | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 6669 | 0 | 16765866 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=2515 | ||
def | information_schema | COLLATIONS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 231 | 0 | 16704765 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=72628 | ||
def | information_schema | INNODB_TABLESPACES_ENCRYPTION | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2012 | 0 | 16743864 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=8338 | ||
def | information_schema | VIEWS | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 4503599627288576 | 8192 | 0 | NULL | 2024-06-17 14:25:44 | 2024-06-17 14:25:44 | NULL | utf8_general_ci | NULL | max_rows=6019 | ||
def | information_schema | PROCESSLIST | SYSTEM VIEW | Aria | 10 | Page | NULL | 0 | 8192 | 4503599627288576 | 8192 | 0 | NULL | 2024-06-17 14:25:44 | 2024-06-17 14:25:44 | NULL | utf8_general_ci | NULL | max_rows=15391 | ||
def | information_schema | CHARACTER_SETS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 384 | 0 | 16434816 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=43690 | ||
def | information_schema | INNODB_LOCKS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 31244 | 0 | 16746784 | 0 | 0 | NULL | 2024-06-17 14:25:44 | NULL | NULL | utf8_general_ci | NULL | max_rows=536 |
过滤行: |