[Resolved] Check database size

[wilku]

Hi

I've got a mysql account at provider's server, and I got a quota on it. How to check with sql query how far I'm from reaching it? In other words how big are two databases I own at that server?

I looked for it in mysql documentation and searched this forum - without any satisfying results (otherwise I wouldn't post this question, would I? 😉 )

[Drakla]

This is probably a really rubbish way of doing it, but run

SHOW TABLE STATUS

Then add up the Data_length, and Index_Length columns for all the rows returned.

If you have Cpanel it may well show your usage in the column on the left hand side.

If I find there's a built in command I'll let you know.

[wilku]

After using some advanced mathematics (too many tables in database to count it by hand ;-) ) this solution works. Thanks.

[Drakla]

I'm still holding out for somebody to come and slam me for being a complete idiot with this solution - Lord Shryuku - save us all!

[DID CONCIENTIOUS CHECK]
Wow, I just checked, and for a half million row table the given index size and data length are exact to their .MYD and .MYI files in the data directory (maybe that's telling me something). So with this you'd only be out by the size of the .frm file, which is about 10k, so maybe this method isn't as rubbish as I'd imagined.