Re: Forcing max_rows
Not that I know of. MAX_ROWS and AVG_ROW_LENGTH are used to calculate the myisam_data_pointer_size, which you can also set explicitly since 4.1.2. Only this data pointer size determines a hard limit to the file size. For more information see
http://dev.mysql.com/doc/refman/5.0/en/full-table.html.
In summary you can only place very rough limits on the table size.
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
6263
February 07, 2006 11:28AM
Re: Forcing max_rows
3513
February 08, 2006 04:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.