RE: Finding Table and database size

2003-07-31 Thread Dan Muey
> 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 M

RE: Finding Table and database size

2003-07-31 Thread Dan Muey
e- > From: Terry Riley [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 10:16 AM > To: [EMAIL PROTECTED] > Subject: RE: Finding Table and database size > > > Dan > > What you may be looking for (and I had to hunt around to find > it myself!) > is

RE: Finding Table and database size

2003-07-31 Thread Terry Riley
Dan What you may be looking for (and I had to hunt around to find it myself!) is myisamchk -eis table_name Hope that helps - just because you don't get an answer doesn't mean we don't care - it probably means we don't know. Terry --Original Message- > Ok, if this is th

RE: Finding Table and database size

2003-07-31 Thread Alec . Cawley
| To: <[EMAIL PROTECTED]> | | cc: | | Subje

RE: Finding Table and database size

2003-07-31 Thread Dan Muey
nd '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 > >

RE: Finding Table and database size

2003-07-30 Thread Dan Muey
nesday, 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: > > >

RE: Finding Table and database size

2003-07-30 Thread Dan Muey
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';?? >