【mysql系】数据库统计各个表的大小、表备注搜索表名

查找数据库表行数以及容量大小

SELECT TABLE_NAME, concat( round( DATA_LENGTH / 1024 / 1024, 3),'MB') as 数据容量占用, concat( round(  INDEX_LENGTH / 1024 / 1024, 3),'MB') as 索引容量占用, TABLE_ROWS
FROM
 information_schema.TABLES 
WHERE
 TABLE_SCHEMA = '数据库名称' 
 and  TABLE_ROWS > 1
ORDER BY
 TABLE_ROWS DESC

通过表名注释来搜索对应表名

SELECT
    table_name '表名',
    TABLE_COMMENT '表注解' 
FROM
    INFORMATION_SCHEMA.TABLES 
WHERE
    table_schema = '数据库名称' 
    AND TABLE_COMMENT LIKE '%角色%';