Re: Repair with key cache

[<sup-mysql]

Benjamin...

	I get a feel for the amount of activity by looking at the
processes running and the amount of cpu time they are using.. (on
linux: ps xu)
	Correct me if I am wrong. I understand that the sort_buffer is the
most important when creating keys... I set the sort buffer to 1000M and
key buffer to 200M.

Ramon

On Sat, 11 May 2002, Benjamin Pflugmann wrote:

> Hi.
> 
> How do you define/determine "activity"?
> 
> The operation is probably I/O bound. From the message you get I assume
> increasing the key cache matter.
> 
> Regards,
> 
> 	Benjamin.
> 
> On Sat, May 11, 2002 at 11:00:11AM -0400, sup-mysql@stripped wrote:
> > When loading large amounts of data into MySQL there is a period oh high
> > server activity followed by a long period of little activity. While on the
> > little activity period, the process list reads "Repair with key cache"...
> > 
> > How can I make the server work harder in this period and get done with
> > loading data faster?
> > 
> > Thanks
> > 
> > Ramon
> 
>