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
Hi
MySQL uses the product of the MAX_ROWS and AVG_ROW_LENGTH values for MyISAM
tables, to decide how big the resulting table should. If you don't specify
either option, the maximum size for a table is 65,536TB of data (4GB before
MySQL 5.0.6).
Ref: