Hi. I've created the following table, with default value for MAX_ROWS. As the following shows, it has a max. size of 4G. I'm wondering: Is the expected max number of rows in this table = Max_data_length \ Avg_row_length? If not, what might it be? How do I calculate it?

mysql> show table status from foo like 'bar'\G *************************** 1. row *************************** Name: bar Engine: MyISAM Version: 9 Row_format: Dynamic Rows: 15094 Avg_row_length: 121 Data_length: 2001000 Max_data_length: 4294967295 Index_length: 1496064 Data_free: 163680 Auto_increment: 67217 Create_time: 2006-11-01 15:41:20 Update_time: 2006-11-28 11:42:13 Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment:

Thanks, Amit