Descobrindo o tamanho de um database no MySQL

Pegar o tamanho de todas os databases do MySQL:

SELECT TABLE_SCHEMA AS ‘Database_name’, TABLE_NAME AS ‘=’Table_Name’, CONCAT(ROUND(((DATA_LENGTH + INDEX_LENGTH – DATA_FREE) / 1024 / 1024),” Mb”) AS Size FROM INFORMATION_SCHEMA.TABLES;

Pegar o tamanho de todas as tabelas de uma única database no MySQL:

SELECT TABLE_SCHEMA AS ‘Database_name’, TABLE_NAME AS ‘Table_Name’, CONCAT (ROUND((DATA_LENGTH + INDEX_LENGTH – DATA_FREE) / 1024/ 1024),2), ” MB”) AS Size FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = ‘nome_da_sua_database’;

Pegar o tamanho total de uma única database:

SELECT (SUM(ROUND(((DATA_LENGTH + INDEX_LENGTH – DATA_FREE) / 1024 / 1024), 2)), ” MB”) AS Size FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = ‘nome_da_sua_data_base’;