List:General Discussion« Previous MessageNext Message »
From:Benjamin Pflugmann Date:May 11 2002 6:59pm
Subject:Re: Repair with key cache
View as plain text  
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

-- 
benjamin-mysql@stripped
Thread
quick sql questionAugey Mikus10 May
  • Re: quick sql questionPaul DuBois10 May
  • Re: quick sql questionAugey Mikus10 May
    • Re: quick sql questionPaul DuBois10 May
  • Re: quick sql questionAugey Mikus10 May
    • Re: quick sql questionPaul DuBois10 May
  • Re: quick sql questionAugey Mikus11 May
  • Re: quick sql questionAugey Mikus11 May
    • Re: quick sql questionPaul DuBois11 May
      • Repair with key cachesup-mysql11 May
        • Re: Repair with key cacheBenjamin Pflugmann11 May
          • Re: Repair with key cachesup-mysql11 May
            • Re: Repair with key cachePaul DuBois12 May
              • Re: Repair with key cachesup-mysql12 May
              • Re: Repair with key cachesup-mysql12 May
                • Re: Repair with key cachePaul DuBois12 May
                  • Re: Repair with key cachesup-mysql12 May
                    • Re: Repair with key cacheJeremy Zawodny12 May
                      • RE: Repair with key cacheRamon Arias13 May
                        • Re: Repair with key cacheJeremy Zawodny13 May
  • Re: quick sql questionAugey Mikus11 May