Re: Really Fixed?

[marc steikert]

Hi Mikael,
and what is the Difference to an non Partition Table??? Avg_row_length looks here correct??!!

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)