SELECT table_schema "Database Name",
sum( data_length) / 1024 "data size in MB",
sum( index_length) / 1024 "index size in MB",
sum( data_free )/ 1024 / 1024 "free space in MB"
FROM information_schema.TABLES GROUP BY table_schema;

mysqlcheck -o -A