From: Jorge Bastos
Date: August 16 2006 8:27am
Subject: Fw: InnoDB Table Size
List-Archive: http://lists.mysql.com/win32/18438
Message-Id: <00b501c6c10d$cd4c8ec0$0301a8c0@hercules.decimalint.pt>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 8bit

you also have "Data_length" in "show table status" command
and you'll have the size in bytes (i think)

----- Original Message ----- 
From: "mathias" <mfatene@stripped>
To: "'Melissa Dougherty'" <melissa@stripped>; <win32@stripped>
Sent: Wednesday, August 16, 2006 8:25 AM
Subject: RE: InnoDB Table Size


Hi mellisa,
Data_length minus data_free gives you the data_size_used.

Mathias

-----Original Message-----
From: Melissa Dougherty [mailto:melissa@stripped]
Sent: mardi 15 août 2006 20:53
To: win32@stripped
Subject: Fw: InnoDB Table Size

Does the DATA_LENGTH column in the TABLES table show the size of the table
in bytes?


----- Original Message ----- 
From: Melissa Dougherty
To: win32@stripped
Sent: Tuesday, August 15, 2006 2:05 PM
Subject: InnoDB Table Size


Is there a way to execute SQL code to get the table name and storage size in
MySQL 5.0?


Melissa


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=mysql.jorge@stripped