That failed with an err27 as well. How do I set the debug flag on myisamchk
?
--debug=/tmp/debug doesn't work.
JS.
Hi.
Sounds OK, but don't forget to make a backup.
"J S" <[EMAIL PROTECTED]> wrote:
> Thanks for your reply Gleb. I tried running with --safe-recover instead
of
> -qr but that caused some other processes running on the box to hang and
> coredump so I had to kill it off.
>
> I'll try running:
>
> myisamchk -qr --tmpdir=/proxydb/mysql/tmp -O sort=16M -O key=16M -O
read=1M
> -O write=1M --sort-index --analyze internet_usage
>
> Sound OK?
>
> JS.
>>
>>Hi.
>>
>>Usually myisamchk doesn't have the suid bit set, and it seems to be ran
as
>>root.
>>See
>> http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
>>Especially
>> http://dev.mysql.com/doc/mysql/en/myisamchk_memory.html
>>
>>
>>"J S" <[EMAIL PROTECTED]> wrote:
>> > Hi,
>> >
>> > I've run myisampack to compress a table and am now trying to recreate
>>the
>> > index using myisamchk (as root) but I get an error 27.
>> >
>> > # myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp
>> > internet_usage.MYI
>> > - check record delete-chain
>> > - recovering (with sort) MyISAM-table 'internet_usage.MYI'
>> > Data records: 30972875
>> > - Fixing index 1
>> > myisamchk: Error writing file '/proxydb/mysql/tmp/ST3hTDMa' (Errcode:
>>27)
>> > myisamchk: error: 27 when fixing table
>> > MyISAM-table 'internet_usage.MYI' is not fixed because of errors
>> > Try fixing it by using the --safe-recover (-o), the --force (-f)
option
>>or
>> > by not using the --quick (-q) flag
>> > # perror 27
>> > Error code 27: A file cannot be larger than the value set by
ulimit.
>> >
>> > The ulimits are set as follows:
>> >
>> > default:
>> > fsize = 2097151
>> > core = 2097151
>> > cpu = -1
>> > data = 262144
>> > rss = 65536
>> > stack = 65536
>> > nofiles = 2000
>> >
>> > root:
>> > fsize = -1
>> > core = -1
>> > cpu = -1
>> > data = -1
>> > rss = -1
>> > stack = -1
>> > nofiles = 4000
>> >
>> > When I run myisamchk, is it running with root privilidges or as user
>>mysql?
>> > By the way this is a large enabled filesystem.
>> >
>> > Thanks,
>> >
>> > JS.
>> >
>> >
>> >
>>
>>
>>--
>>For technical support contracts, goto
https://order.mysql.com/?ref=ensita
>>This email is sponsored by Ensita.NET http://www.ensita.net/
>> __ ___ ___ ____ __
>> / |/ /_ __/ __/ __ \/ / Gleb Paharenko
>> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
>>/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
>> <___/ www.mysql.com
>>
>>
>>
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>>
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
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]
