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=1
| Thread |
|---|
| • Fw: InnoDB Table Size | Jorge Bastos | 16 Aug |