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

[Gleb Paharenko]

Hello.

There is a variable sort_buffer, which you can set with -O sort_buffer=xxxM or in my.cnf.


matt_lists <matt_lists@stripped> 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 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
> - parallel recovering (with sort) MyISAM-table '321st_stat'
> Data records: 0
> - Fixing index 1
> - Fixing index 2
> - Fixing index 3
> - Fixing index 4
> - Fixing index 5
> - Fixing index 6
> - Fixing index 7
> myisamchk: error: sort_buffer_size is to small
> MyISAM-table '321st_stat' is not fixed because of errors
> Try fixing it by using the --safe-recover (-o), the --force (-f) option 
> or by no
> t using the --quick (-q) flag
> - recovering (with sort) MyISAM-table '321st_stat'
> Data records: 0
> - Fixing index 1
> 3287000
> 
> 
> 


-- 
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