Fw: InnoDB Table Size

------=_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 -----
From: Melissa Dougherty
To: win32 [at] 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
------=_NextPart_000_001E_01C6C07A.7804A030--
Melissa Dougherty [ Di, 15 August 2006 20:52 ] [ ID #1430977 ]

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 [at] cse-corp.com]
Sent: mardi 15 ao=FBt 2006 20:53
To: win32 [at] 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 [at] 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=3Dgcdmw-win32 [at] m.gmane.org
mathias fatene [ Mi, 16 August 2006 09:25 ] [ ID #1432414 ]
Datenbanken » gmane.comp.db.mysql.windows » Fw: InnoDB Table Size

Vorheriges Thema: Fw: InnoDB Table Size
Nächstes Thema: Win32 Server Quits Unexpectedly