查看mysql数据表大小

SELECT (sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1048576 as sum_m,TABLE_NAME

FROM information_schema.TABLES where TABLE_SCHEMA=’ycsd_wx’ group by TABLE_NAME order by sum_m desc;