On Fri, 31 Aug 2001, Michael Widenius wrote:
> >>>>> "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 ?
/usr/local/mysql/bin/myisamchk -f -d /data/mysql/$db/$table.MYI
But even /usr/local/mysql/bin/myisamchk /data/mysql/$db/$table.MYI or with
only -S or only -a. Just "everything sensible".
> mmokrejs> Well, the other rep tables are fine. I'm a bit angry about myself,
> mmokrejs> because I dropped the Celegans.rep tables:!!!
>
> :(
Well, intentionally. :(
> 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 :(
I know.
> 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!
Sure! Thanks.
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics <http://mips.gsf.de>
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
---------------------------------------------------------------------
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
