Fw: InnoDB Table Size

Fw: InnoDB Table Size

am 15.08.2006 20:52:45 von Melissa Dougherty

------=_NextPart_000_001E_01C6C07A.7804A030
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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


----- Original Message -----=20
From: Melissa Dougherty=20
To: win32@lists.mysql.com=20
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
------=_NextPart_000_001E_01C6C07A.7804A030--

RE: InnoDB Table Size

am 16.08.2006 09:25:10 von mathias fatene

Hi mellisa,
Data_length minus data_free gives you the data_size_used.

Mathias

-----Original Message-----
From: Melissa Dougherty [mailto:melissa@cse-corp.com]=20
Sent: mardi 15 ao=FBt 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 -----=20
From: Melissa Dougherty=20
To: win32@lists.mysql.com=20
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=20


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