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]