查看MySQL/ MariaDB表大小
查看MySQL/ MariaDB表大小
创建以下两个视图,从视图中查询数据
CREATE OR REPLACE VIEW schema_size AS
SELECT table_schema
, round(SUM(((data_length + index_length) / 1024 / 1024)), 2) table_size_mb
FROM information_schema.tables
WHERE table_schema IN ('dv', 'da', 'hue')
GROUP BY table_schema
ORDER BY table_size_mb DESC;
CREATE OR REPLACE VIEW table_size AS
SELECT table_schema
, table_name
, round(SUM(((data_length + index_length) / 1024 / 1024)), 2) table_size_mb
FROM information_schema.tables
WHERE table_schema IN ('dv', 'da', 'hue')
GROUP BY table_schema
, table_name
ORDER BY table_size_mb DESC;
查询视图
SELECT * FROM schema_size;
SELECT * FROM table_size;