MySQL查看某个库下所有表对应的数据量

select table_name,table_rows from information_schema.tables where TABLE_SCHEMA = '库名' order by table_rows desc;