elfeffe · April 8, 2016 11:08
diff --git a/Mysql tables size b/Mysql tables size
 SELECT 
     table_schema as `Database`, 
     table_name AS `Table`, 
     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
 FROM information_schema.TABLES 
 ORDER BY (data_length + index_length) DESC;
	SELECT
	table_schema as `Database`,
	table_name AS `Table`,
	round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
	FROM information_schema.TABLES
	ORDER BY (data_length + index_length) DESC;