htxuankhoa · December 28, 2018 11:57
diff --git a/get_tables_size.sql b/get_tables_size.sql
 SELECT table_schema as 'Database Name',
        sum( data_length + index_length ) as 'Size in Bytes',
        round((sum(data_length + index_length) / 1024 / 1024), 4) as 'Size in MB'
 FROM     information_schema.TABLES
 GROUP BY table_schema;
	SELECT table_schema as 'Database Name',
	sum( data_length + index_length ) as 'Size in Bytes',
	round((sum(data_length + index_length) / 1024 / 1024), 4) as 'Size in MB'
	FROM information_schema.TABLES
	GROUP BY table_schema;