Ok....
I think I am a bit confused on how the MAX_ROWS works...
This is the result of SHOW TABLE STATUS \G:
Name: gabe_test
Type: MyISAM
Row_format: Fixed
Rows: 33
Avg_row_length: 5
Data_length: 165
Max_data_length: 327679
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2004-02-24 14:34:30
Update_time: 2004-02-24 14:37:43
Check_time: NULL
Create_options: max_rows=3
Comment:
What values of MAX_ROWS and AVG_ROW_LENGTH would I need so that I could limit this
table to 3 [or n] number of records? How do I calculate this?
Additionally, is there a better way, not using the OS, to limit the size of MyISAM
tables?
Thanks
Gabe
-----Original Message-----
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 5:11 PM
To: [EMAIL PROTECTED]
Subject: Re: MAX_ROWS
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
