YMMFI - Determining MySQL database sizes

I'm just a nerd coming to grips with dealing with a chronic illness. I write the occasional quip about technology and cover my journey from the unknown to diagnosis and the effects on my life and that of my friends and family.

Determining MySQL database sizes

mysql> SELECT table_schema “Data Base Name”, sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB”, sum( data_free )/ 1024 / 1024 “Free Space in MB” FROM information_schema.TABLES GROUP BY table_schema;

Always good to know.