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 does not appear to be full in any way. As you can see
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 output below, both the datafile length and
the keyfile length are much smaller than their respective maximums
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 table is on a Linux ext3
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,
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
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
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
[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