On 24 Feb 2004 at 22:01, Alison W wrote:

> Yes: MAX_ROWS is a *guidance* to the system in setting up the table
> and not a *limit* in any way.

Well, it is a limit in one way.  MySQL uses it (in MyISAM tables) to 
calculate the size of the pointer used for positions within the data 
file.  If the data file becomes larger than can be handled by that 
size of pointer, then you can't add any more records to the table 
(unless you increase MAX_ROWS or AVG_ROW_LENGTH so that the pointer 
size is increased).

-- 
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to