t;
Sent: Wednesday, 11 June, 2003 16:33
Subject: Re: tables size in mysql database
I got these :
| Name | Type | Row_format | Rows| Avg_row_length
| Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_ti
me | Update_time | Check_time | Create
I got these :
| Name | Type | Row_format | Rows| Avg_row_length
| Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_ti
me | Update_time | Check_time | Create_options | Comment
I guess Data_length shows the size in bytes of the table. if
On Wed, Jun 11, 2003 at 10:08:47AM +0500, Sohail Hasan wrote:
> Hi there,
>
> How can I see per table size of all tables in a particular database.
SHOW TABLE STATUS
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.
