Howdy List!
A couple questions about finding the disk space used by a table/database:

1) First how can I get the size a table is taking up on disk?
        Is it the 'Data_length' field in: SHOW TABLE STATUS FROM db_name LIKE 'wild';??
                If so how can I do a query like the one above and just get Data_length 
returned?
        Otherwise what query can I do to find the disk size of a table?

2) Is there a simple query to get the disk size of a database and all of it's tables? 
Or do I need to do the method I use in question one on each table in the db and add 
them up?

TIA

Dan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to