Mysql – Verificando tamanho das bases

— tamanho dos databases

SELECT table_schema AS “Database name”, SUM(data_length + index_length) / 1024 / 1024 AS “Size (MB)” FROM information_schema.TABLES GROUP BY table_schema;

 

fontes:

http://www.sysadmin.com.br/mysql-como-saber-o-tamanho-total-de-um-banco-mysql/

http://www.blogporta80.com.br/2012/11/21/artigos-exibir-o-tamanho-de-uma-base-mysql/

http://dev.mysql.com/doc/refman/5.7/en/columns-table.html