Re: myisamchk sort buffer too small, check table has ran 1 week and no end in sight

Gleb Paharenko wrote: Hello. I've taken this information from documentation at http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html Did it solve your problem? If didn't, send me you my.cnf file and information about version of MySQL and operating system. The docs are old, they changed th

Re: myisamchk sort buffer too small, check table has ran 1 week and no end in sight

Hello. I've taken this information from documentation at http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html Did it solve your problem? If didn't, send me you my.cnf file and information about version of MySQL and operating system. matt_lists <[EMAIL PROTECTED]> wrote: > Gleb P

Re: myisamchk sort buffer too small, check table has ran 1 week and no end in sight

Gleb Paharenko wrote: Hello. There is a variable sort_buffer, which you can set with -O sort_buffer=xxxM or in my.cnf. myisamchk -o -p -f --sort_key_blocks=512M - -key_cache_block_size=512M it's no longer -O sort_buffer=xxxM it's now --sort_key_blocks and I set it to 512M and it still s

Re: myisamchk sort buffer too small, check table has ran 1 week and no end in sight

Hello. There is a variable sort_buffer, which you can set with -O sort_buffer=xxxM or in my.cnf. matt_lists <[EMAIL PROTECTED]> wrote: > Are these critical errors? It keeps on going, saying it's fixing records > > I tried doing a check table on the main server, it's been running a wee

myisamchk sort buffer too small, check table has ran 1 week and no end in sight

Are these critical errors? It keeps on going, saying it's fixing records I tried doing a check table on the main server, it's been running a week and who knows how long that'll take myisamchk -o -p -f --sort_key_blocks=512M - -key_cache_block_size=512M --read_buffer_size=8M 321st_stat - paralle