Ok at least could someone tell me if the SHOW TABLE STATUS fields 'Data_length' and 'Index_length' are in bytes and added together would make the disk size that that table is using up?
Thanks a bunch Dan > -----Original Message----- > From: Dan Muey > Sent: Wednesday, July 30, 2003 4:24 PM > To: [EMAIL PROTECTED] > Subject: RE: Finding Table and database size > > > Is this even possible with mysql then? > > > 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/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
