Re: ulimit problem

[J S]

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]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]