mysql查询表的行数及大小
select
concat(TABLE_SCHEMA,'.',TABLE_NAME) as `表名称`,
TABLE_ROWS as `行数`,
concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as `大小MB`,
concat(round(sum(DATA_LENGTH/1024/1024/1024),2),'GB') as `大小GB`
from information_schema.`TABLES`
where table_name like '%log%'
group by TABLE_SCHEMA,TABLE_NAME
order by TABLE_ROWS desc