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

[Gleb Paharenko]

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 <matt_lists@stripped> wrote:
> 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 said there was not enough
> 
> 
> 
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com