MySQL DBA - Tips and Techniques Magazine

11 Nov 2014

mysql Database size

If you have question in your mind like "How to view the Free space available for my Data Base in MySQL", then run the below query:

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 ;

 

Or "Show table status;"

No comments:

Post a Comment