Mysql查询数据库表内存占用情况，按照表名分组
SELECT table_schema AS '数据库名称',table_name AS '数据表名' ,table_rows AS '数据条数(条)' ,ROUND((data_length + index_length) / 1024/ 1024, 2) AS '数据库大小(MB)',ROUND((data_length + index_length) / 1024/1024/ 1024, 2) AS '数据库大小(GB)' ,create_time AS '创建时间',update_time AS '最后更新时间' from information_schema.`TABLES` WHERE table_schema='dbname' -- 数据库名称 ORDER BY table_rows desc ;
Mysql查询整个数据库内存占用情况，按照数据库分组
SELECT * from ( SELECT table_schema AS '数据库名称',ROUND(SUM(table_rows ) , 2) AS AllRows,ROUND(SUM(data_length + index_length) / 1024/ 1024, 2) AS '数据库大小(MB)',ROUND(SUM(data_length + index_length) / 1024/1024/ 1024, 2) AS '数据库大小(GB)' from information_schema.`TABLES` gROUP BY table_schema ) as tt ORDER BY tt.AllRows DESC
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。