Ok, if this is the wrong mysql list could someone tell me which list would best be able to handle my question if no one on this list knows how to get the table and database sizes?
TIA Dan > 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/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
