Check out MAX_ROWS = # and AVG_ROW_LENGTH = # options in http://www.mysql.com/doc/en/CREATE_TABLE.html
Set MAX_ROWS to a very very large number You can set these with ALTER TABLE. See section 6.5.4 ALTER TABLE Syntax using table options at the end. You can verify your changes by running SHOW TABLE STATUS before the change then again after the change. Have you done this already? Ken ----- Original Message ----- From: "Jacco van Schaik" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 06, 2003 8:44 AM Subject: "No more room in index file" > Hi, > > We have a database with a table whose data file (.MYD) has grown to 42 > GB and an associated index (.MYI) file that's grown to 17 GB, at which > point MySQL gave us an error 136 (No more room in index file). > > The MySQL manual says (in paragraph 4.4.6.9 "How to Repair Tables") that > this type of error can be fixed with a "repair table", but in our case > that doesn't seem to have helped. The maximum size of the index file, > as reported by myisamchk -d -v is still 17 GB with a keyfile pointer > size of 3 bytes. > > Since then we've tried to drop the index and re-create it, but that > hasn't helped either. The new index file is slightly smaller than it > was before, but it's obviously only a matter of time until we'll run > into the same limitation again. > > Does anyone know what we need to do to force MySQL to start using 4-byte > keyfile pointers? > > Groeten, - Jacco > > -- > +-------------------------+ > | IRL: Jacco van Schaik | The time is 14:20 on Monday October 6 2003. > | mail: [EMAIL PROTECTED] | Here at Frontier HQ it's 15 degrees with a > | URL: www.frontier.nl | strong breeze from the west. > +-------------------------+ > > > -- > 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]