List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 21 2003 3:05pm
Subject:Re: Resume indexing after powerloss?
View as plain text  
In the last episode (Oct 21), Peer Reiser said:
> Someone knows if its possible to resume indexing a base where it left
> due to a power failure? The process was copying to tmp file when the
> power went away, having achieved 5GB of total 6GB in 6 days..

Nope; you'll have to start over.  That's an awful long time to generate
indexes.  You may benefit from raising key_buffer_size and
myisam_sort_buffer_size during the index operation.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Resume indexing after powerloss?Peer Reiser21 Oct
  • Re: Resume indexing after powerloss?Dan Nelson21 Oct