How 2 Guru

Feb 25 2009

Check MySQL database size

How to check MySQL database size in your server?
Actually MySQL already provide the information, what you need to do is just do a simple query to retrieve the data.

Below is the query :

^?View Code 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
WHERE table_schema = '&lt;DATABASE NAME&gt;'
GROUP BY table_schema ;

This entry was written by h2Guru and posted on February 25, 2009 at 2:31 pm and filed under MySQL. Bookmark the permalink. Follow any comments here with the RSS feed for this post.

3 Responses to “Check MySQL database size”

Er Crini Says:
May 4th, 2009 at 4:42 pm
Thanks dude, I’ve been locking for this one for a while. I’m impressed that everyone’s recommendation to know the size of a MySQL DB is “Install phpmyadmin and…”

Now, I get the results just fine, except for the Free Space, that one is allways zero. Do you know what that could mean?
nione Says:
June 30th, 2009 at 9:39 am
I trying this gives me the error:

1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),…) with no GROUP columns is illegal if there is no GROUP BY clause
h2Guru Says:
August 28th, 2009 at 2:51 pm
Hi nione,

Thanks for your comments…
I had amend the GROUP BY command in the query.
It should be work now.

Check MySQL database size

3 Responses to “Check MySQL database size”

Leave a Reply