gamma", if it makes a difference.
>
> Jon Ribbens <[EMAIL PROTECTED]> wrote:
>> I am getting Error 136 "No more room in index file" on a table,
>> but the table does not appear to be full in any way. As you can see
>> from the "myisamchk -dv"
Does nobody have any ideas on this? It's quite perplexing.
It's MySQL "Ver 14.6 Distrib 4.1.5-gamma", if it makes a difference.
Jon Ribbens <[EMAIL PROTECTED]> wrote:
> I am getting Error 136 "No more room in index file" on a table,
> but the table doe
I am getting Error 136 "No more room in index file" on a table,
but the table does not appear to be full in any way. As you can see
from the "myisamchk -dv" output below, both the datafile length and
the keyfile length are much smaller than their respective maximums.
The tabl
So Ken Menzel says:
> 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
acco 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 = #
>
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 a
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")
