4 messages in com.mysql.lists.win32Fw: InnoDB Table Size
FromSent OnAttachments
Melissa Dougherty15 Aug 2006 11:05 
Melissa Dougherty15 Aug 2006 11:52 
mathias16 Aug 2006 00:24 
Jorge Bastos16 Aug 2006 01:27 
Subject:Fw: InnoDB Table Size
From:Jorge Bastos (mysq@decimal.pt)
Date:08/16/2006 01:27:01 AM
List:com.mysql.lists.win32

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

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