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]
