Re: Really Fixed?

[Mikael Ronström]

Hi Marc,

marc steikert wrote:
> Hi Mikael,
> and what is the Difference to an non Partition
> Table??? Avg_row_length looks here correct??!!
>

Hmm, interesting, I'll check into it.

Rgrds Mikael

> mysql> drop table if exists top;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> create table top (id int) engine =
> myisam;
> Query OK, 0 rows affected (0.02 sec)
>
> mysql> insert into top values
> (1),(2),(3),(4),(5),(6),(7),(8),(9);
> Query OK, 9 rows affected (0.00 sec)
> Datensätze: 9 Duplikate: 0 Warnungen: 0
>
> mysql> show table status like 'top'\G
> *************************** 1. row
> ***************************
> Name: top
> Engine: MyISAM
> Version: 10
> Row_format: Fixed
> Rows: 9
> Avg_row_length: 7
> Data_length: 63
> Max_data_length: 1970324836974591
> Index_length: 1024
> Data_free: 0
> Auto_increment: NULL
> Create_time: 2006-06-09 23:32:44
> Update_time: 2006-06-09 23:32:44
> Check_time: NULL
> Collation: utf8_general_ci
> Checksum: NULL
> Create_options:
> Comment:
> 1 row in set (0.01 sec)
>
> mysql> delete from top where id > 5;
> Query OK, 4 rows affected (0.00 sec)
>
> mysql> show table status like 'top'\G
> *************************** 1. row
> ***************************
> Name: top
> Engine: MyISAM
> Version: 10
> Row_format: Fixed
> Rows: 5
> Avg_row_length: 7
> Data_length: 63
> Max_data_length: 1970324836974591
> Index_length: 1024
> Data_free: 28
> Auto_increment: NULL
> Create_time: 2006-06-09 23:32:44
> Update_time: 2006-06-09 23:32:44
> Check_time: NULL
> Collation: utf8_general_ci
> Checksum: NULL
> Create_options:
> Comment:
> 1 row in set (0.00 sec)
>
> mysql> optimize table top;
> +----------+----------+----------+----------+
> | Table | Op | Msg_type | Msg_text |
> +----------+----------+----------+----------+
> | test.top | optimize | status | OK |
> +----------+----------+----------+----------+
> 1 row in set (0.00 sec)
>
> mysql> show table status like 'top'\G
> *************************** 1. row
> ***************************
> Name: top
> Engine: MyISAM
> Version: 10
> Row_format: Fixed
> Rows: 5
> Avg_row_length: 7
> Data_length: 35
> Max_data_length: 1970324836974591
> Index_length: 1024
> Data_free: 0
> Auto_increment: NULL
> Create_time: 2006-06-09 23:32:44
> Update_time: 2006-06-09 23:32:44
> Check_time: 2006-06-09 23:32:44
> Collation: utf8_general_ci
> Checksum: NULL
> Create_options:
> Comment:
> 1 row in set (0.00 sec)