Hi Jacco,
Perhaps the manual needs to be enhanced, but it is only a guide,
perhaps the language should be softened or 'error 136' modified that
it could be either problem. Either way I hope this fixes you problem,
my guess would be you have very large rows of data, which is why you
did not hit the error 135 first. I hope this takes care of it for
you, we have created very large tables (150 million rows) and had
good success, as have others. If this does not fix it we may have
dig a little deeper. Let us know.
Best of luck,
Ken
----- Original Message -----
From: "Jacco van Schaik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 06, 2003 12:00 PM
Subject: Re: "No more room in index file"
> So then Ken Menzel says...
> > 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?
>
> We tried it once, but it failed due to an unconnected problem (out
of
> diskspace). The thing is, the manual explicitly states (in para.
> 4.4.6.9) that this is a solution for an error 135 (No more room in
> record file) and that an error 136 (No more room in index file) is
> fixed by a table repair. So we decided to try something different
> first.
> No matter, we've freed up some diskspace now, so we'll try again.
Thanks
> for replying. I'm sure I'll be back if it doesn't work ;-)
>
> Groeten, - Jacco
>
> --
> +-------------------------+
> | IRL: Jacco van Schaik | The time is 17:52 on Monday October 6
2003.
> | mail: [EMAIL PROTECTED] | Here at Frontier HQ it's 13 degrees with
a
> | URL: www.frontier.nl | fresh 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]
