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 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
 / /|_/ / // /\ \/ /_/ / /__   [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]

Reply via email to