SELECT * FROM `TABLES`
TABLE_CATALOG | TABLE_SCHEMA | 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 | information_schema | CHARACTER_SETS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 384 | 0 | 16604160 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=43690 | ||
def | information_schema | COLLATIONS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 231 | 0 | 16704765 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=72628 | ||
def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 195 | 0 | 16691610 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=86037 | ||
def | information_schema | COLUMNS | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2024-10-30 23:59:31 | 2024-10-30 23:59:31 | NULL | utf8_general_ci | NULL | max_rows=2794 | ||
def | information_schema | COLUMN_PRIVILEGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2565 | 0 | 16757145 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=6540 | ||
def | information_schema | ENGINES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 490 | 0 | 16709000 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=34239 | ||
def | information_schema | EVENTS | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2024-10-30 23:59:31 | 2024-10-30 23:59:31 | NULL | utf8_general_ci | NULL | max_rows=619 | ||
def | information_schema | FILES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2659 | 0 | 16770313 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=6309 | ||
def | information_schema | GLOBAL_STATUS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | ||
def | information_schema | GLOBAL_VARIABLES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | ||
def | information_schema | KEY_COLUMN_USAGE | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 4637 | 0 | 16762755 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=3618 | ||
def | information_schema | OPTIMIZER_TRACE | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2024-10-30 23:59:31 | 2024-10-30 23:59:31 | NULL | utf8_general_ci | NULL | max_rows=578524 | ||
def | information_schema | PARAMETERS | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2024-10-30 23:59:31 | 2024-10-30 23:59:31 | NULL | utf8_general_ci | NULL | max_rows=6021 | ||
def | information_schema | PARTITIONS | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2024-10-30 23:59:31 | 2024-10-30 23:59:31 | NULL | utf8_general_ci | NULL | max_rows=5596 | ||
def | information_schema | PLUGINS | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2024-10-30 23:59:31 | 2024-10-30 23:59:31 | NULL | utf8_general_ci | NULL | max_rows=11328 | ||
def | information_schema | PROCESSLIST | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2024-10-30 23:59:31 | 2024-10-30 23:59:31 | NULL | utf8_general_ci | NULL | max_rows=23899 | ||
def | information_schema | PROFILING | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 308 | 0 | 16562084 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=54471 | ||
def | information_schema | REFERENTIAL_CONSTRAINTS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 4814 | 0 | 16767162 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=3485 | ||
def | information_schema | ROUTINES | SYSTEM VIEW | MyISAM | 10 | Dynamic | NULL | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2024-10-30 23:59:31 | 2024-10-30 23:59:31 | NULL | utf8_general_ci | NULL | max_rows=583 | ||
def | information_schema | SCHEMATA | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3464 | 0 | 16755368 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=4843 | ||
def | information_schema | SCHEMA_PRIVILEGES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 2179 | 0 | 16767405 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=7699 | ||
def | information_schema | SESSION_STATUS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | ||
def | information_schema | SESSION_VARIABLES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | ||
def | information_schema | STATISTICS | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 5753 | 0 | 16764242 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=2916 | ||
def | information_schema | TABLES | SYSTEM VIEW | MEMORY | 10 | Fixed | NULL | 9441 | 0 | 16767216 | 0 | 0 | NULL | 2024-10-30 23:59:31 | NULL | NULL | utf8_general_ci | NULL | max_rows=1777 |