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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
