MySQL查询某个库中各个表的数据量
SELECT
table_name,
table_rows
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = '要查询的库'
ORDER BY
table_rows DESC;
MySQL查询某个库的数据量
SELECT
sum( table_rows )
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = '要查询的库'