Finding Table and database size

[Dan Muey]

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/my***********...ie.nctu.edu.tw