Max_data_length is Zero

Hi All,

show table status\G*************************** 1. row *************************** Name: name_table Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 259956366 Avg_row_length: 128 Data_length: 33460714548Max_data_length: 0 Index_length: 44122680320 Data_free: 3640 Auto_increment: NULL Create_time: 2008-10-06 14:59:57 Update_time: 2008-10-16 12:19:30 Check_time: 2008-10-06 15:32:38 Collation: latin1_swedish_ci Checksum: NULL Create_options: partitioned Comment:

I have almost 260 millions of records with 73 GB disk capacity. What does actually “Max_data_length is zero” mean? How can I increase that?


It means you didn’t set a max_data_length explicitly when you created the table. This controls the size of the internal pointers for row offsets, etc.