Fw: InnoDB Table Size

Fw: InnoDB Table Size

am 16.08.2006 10:27:24 von Jorge Bastos

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

----- Original Message -----
From: "mathias"
To: "'Melissa Dougherty'" ;
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@cse-corp.com]
Sent: mardi 15 août 2006 20:53
To: win32@lists.mysql.com
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@lists.mysql.com
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@decimal.pt



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org