Como obter o tamanho das base em Mysql :
Pelo console, logue no MySQL:
mysql -h SEU-HOST -u SEU-USUARIO -p
Informe sua senha do usuario
mysql> SELECT table_schema "Data Base Name",sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", sum( data_free )/ 1024 / 1024 "Free Space in MB" FROM information_schema.TABLES GROUP BY table_schema ;
OU
mysql> SELECT table_schema "Data Base Name",sum( data_length + index_length ) / 1024 / 1024 /1024 "Data Base Size in GB", sum( data_free )/ 1024 / 1024 "Free Space in MB" FROM information_schema.TABLES GROUP BY table_schema ;
Eu prefiro do modo grosseiro :
Vamos para o diretorio dos bancos :
cd /var/lib/mysql
du |sort -n -rcd
Caso queira descobri o tamanho das tabelas
SELECT table_name AS "Tables", round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" FROM information_schema.TABLES WHERE table_schema = '<< NOME DO BANCO >>t' ORDER BY (data_length + index_length) DESC;