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]
