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 | mysql | columns_priv | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_bin | NULL | row_format=DYNAMIC stats_persistent=0 | Column privileges | |
def | mysql | component | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 4194304 | 1 | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC | Components | |
def | mysql | db | BASE TABLE | InnoDB | 10 | Dynamic | 5 | 3276 | 16384 | 0 | 16384 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_bin | NULL | row_format=DYNAMIC stats_persistent=0 | Database privileges | |
def | mysql | default_roles | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_bin | NULL | row_format=DYNAMIC stats_persistent=0 | Default roles | |
def | mysql | engine_cost | BASE TABLE | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC stats_persistent=0 | ||
def | mysql | func | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_bin | NULL | row_format=DYNAMIC stats_persistent=0 | User defined functions | |
def | mysql | general_log | BASE TABLE | CSV | 10 | Dynamic | 2 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | General log | ||
def | mysql | global_grants | BASE TABLE | InnoDB | 10 | Dynamic | 76 | 862 | 65536 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_bin | NULL | row_format=DYNAMIC stats_persistent=0 | Extended global grants | |
def | mysql | gtid_executed | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8mb4_0900_ai_ci | NULL | row_format=DYNAMIC | ||
def | mysql | help_category | BASE TABLE | InnoDB | 10 | Dynamic | 44 | 372 | 16384 | 0 | 16384 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC stats_persistent=0 | help categories | |
def | mysql | help_keyword | BASE TABLE | InnoDB | 10 | Dynamic | 726 | 135 | 98304 | 0 | 98304 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC stats_persistent=0 | help keywords | |
def | mysql | help_relation | BASE TABLE | InnoDB | 10 | Dynamic | 1709 | 47 | 81920 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC stats_persistent=0 | keyword-topic relation | |
def | mysql | help_topic | BASE TABLE | InnoDB | 10 | Dynamic | 557 | 2853 | 1589248 | 0 | 131072 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC stats_persistent=0 | help topics | |
def | mysql | innodb_index_stats | BASE TABLE | InnoDB | 10 | Dynamic | 353 | 185 | 65536 | 0 | 0 | 4194304 | NULL | 2019-10-30 14:09:22 | 2024-09-27 14:02:55 | NULL | utf8_bin | NULL | row_format=DYNAMIC stats_persistent=0 | ||
def | mysql | innodb_table_stats | BASE TABLE | InnoDB | 10 | Dynamic | 60 | 273 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 14:09:22 | 2024-09-27 14:02:55 | NULL | utf8_bin | NULL | row_format=DYNAMIC stats_persistent=0 | ||
def | mysql | password_history | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_bin | NULL | row_format=DYNAMIC stats_persistent=0 | Password history for user accounts | |
def | mysql | plugin | BASE TABLE | InnoDB | 10 | Dynamic | 1 | 16384 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC stats_persistent=0 | MySQL plugins | |
def | mysql | procs_priv | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_bin | NULL | row_format=DYNAMIC stats_persistent=0 | Procedure privileges | |
def | mysql | proxies_priv | BASE TABLE | InnoDB | 10 | Dynamic | 1 | 16384 | 16384 | 0 | 16384 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_bin | NULL | row_format=DYNAMIC stats_persistent=0 | User proxy privileges | |
def | mysql | role_edges | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_bin | NULL | row_format=DYNAMIC stats_persistent=0 | Role hierarchy and role grants | |
def | mysql | server_cost | BASE TABLE | InnoDB | 10 | Dynamic | 6 | 2730 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC stats_persistent=0 | ||
def | mysql | servers | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC stats_persistent=0 | MySQL Foreign Servers table | |
def | mysql | slave_master_info | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC stats_persistent=0 | Master Information | |
def | mysql | slave_relay_log_info | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC stats_persistent=0 | Relay Log Information | |
def | mysql | slave_worker_info | BASE TABLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 4194304 | NULL | 2019-10-30 15:09:29 | NULL | NULL | utf8_general_ci | NULL | row_format=DYNAMIC stats_persistent=0 | Worker Information |
|