List:General Discussion« Previous MessageNext Message »
From:matt_lists Date:November 30 2004 3:28pm
Subject:myisamchk sort buffer too small, check table has ran 1 week and no
end in sight
View as plain text  
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


Thread
myisamchk sort buffer too small, check table has ran 1 week and noend in sightmatt_lists30 Nov
  • Re: myisamchk sort buffer too small, check table has ran 1 week and no end in sightGleb Paharenko30 Nov
    • Re: myisamchk sort buffer too small, check table has ran 1 week andno end in sightmatt_lists30 Nov
      • Re: myisamchk sort buffer too small, check table has ran 1 week and no end in sightGleb Paharenko3 Dec
        • Re: myisamchk sort buffer too small, check table has ran 1 week andno end in sightmatt_lists6 Dec