Hi!
>>>>> "mmokrejs" == mmokrejs <iso-8859-2> writes:
mmokrejs> On Thu, 30 Aug 2001, Michael Widenius wrote:
mmokrejs> Hi,
mmokrejs> yes this patch *fixes* all of my problems, except one table which is/was
mmokrejs> probably too big? I haven't found any options that would make myisamchk to
mmokrejs> ask for less memory.
mmokrejs> /usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes)
mmokrejs> /usr/local/mysql/bin/myisamchk: error: 12 when opening MyISAM-table
'/data/mysql/Celegans/rep.MYI'
mmokrejs> /usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes)
mmokrejs> /usr/local/mysql/bin/myisamchk: error: 12 when opening MyISAM-table
'/data/mysql/Celegans/rep.MYI'
No tables should ever be too big for myisamchk.
What options did you use with myisamchk ?
<cut>
mmokrejs> Well, the other rep tables are fine. I'm a bit angry about myself,
mmokrejs> because I dropped the Celegans.rep tables:!!!
:(
<cut>
mmokrejs> I managed successfully to run "myisamchk -rq" on it, myisampack and again
mmokrejs> "myisamchk -rq". So now I can only tell you that broken datafile can cause
mmokrejs> myisamchk to ask for too much memory. :(
As you can guess, this doesn't help me to find out where the problem
is :(
<cut>
mmokrejs> So unfortunately, I don't have the "broken" table anymore, only the
mmokrejs> screen dumps (size od .MYD and .MYI differed). It seems the
mmokrejs> "broken" datafile had 6 bytes more, "broken" index was much smaller.
mmokrejs> That's all I can tell you. ;)
mmokrejs> Maybe it helps.
Unfortunately this doesn't help me to solve this.
If you ever get this problem again, save the tables so that we can
repeat it and fix the problem!
Regards,
Monty
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
