Hello Dan, Probably the reason that no-one has replied to you is that on-one feels that they have anything helpful to add to what you already know. A quick check on my system shows that the data and index sizes reported by SHOW TABLE STATUS are the same as the byte sizes of the MYD and MYI files - which is a clue that they may represent the table sizes in bytes. Whether this also applies to InnoDB tables, I have no idea.
SImply checking the manual page http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html will show that there is no syntax for selecting only a few columns from the SHOW STATUS. The fact that no-one else has replied suggests that there is no alternative command. However, unless your number of tables is prodigious, the extra data transferred is hardly likely to be prodigious. If you phrase your question in the style "please tell me more", then you must accept that silence means that there is no more to tell. If this list cannot answer your question, your only alternative is to purchase support from MySQL AB (always a good idea) , and then enquire of the fount of all (MySQL) knowledge. Alec |---------+----------------------------> | | "Dan Muey" | | | <[EMAIL PROTECTED]| | | .com> | | | | | | 31/07/2003 15:15 | | | | |---------+----------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: <[EMAIL PROTECTED]> | | cc: | | Subject: RE: Finding Table and database size | >------------------------------------------------------------------------------------------------------------------------------| 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
