Архив метки: sql

Размер таблиц в MySQL

Автор: alex | 2017-12-11

SELECT table_schema as "db name", 
round(sum(data_length + index_length) / 1024 / 1024, 1) "db size (MB)"
FROM   information_schema.tables 
GROUP  BY table_schema;

SELECT table_schema as "db name",

round(sum(data_length + index_length) / 1024 / 1024, 1) "db size (MB)"

FROM information_schema.tables

GROUP BY table_schema;