jesgs · April 16, 2019 14:53
diff --git a/table-size-calc.sql b/table-size-calc.sql
 SELECT 
    table_name AS `Table`, 
    round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
 FROM information_schema.TABLES 
 WHERE table_schema NOT IN ('performance_schema', 'mysql', 'information_schema')
 ORDER BY (data_length + index_length) DESC;
	SELECT
	table_name AS `Table`,
	round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
	FROM information_schema.TABLES
	WHERE table_schema NOT IN ('performance_schema', 'mysql', 'information_schema')
	ORDER BY (data_length + index_length) DESC;