SELECT
table_schema 'Database Name',
sum(data_length + index_length) / 1024 / 1024 'Size(MB)'
FROM
information_schema.TABLES
GROUP BY table_schema;
MySQL get size of database
Posted by Niraj Chauhan on
SELECT
table_schema 'Database Name',
sum(data_length + index_length) / 1024 / 1024 'Size(MB)'
FROM
information_schema.TABLES
GROUP BY table_schema;