List:General Discussion« Previous MessageNext Message »
From:<sup-mysql Date:May 12 2002 12:39am
Subject:Re: Repair with key cache
View as plain text  
Ah! ok, I get your point. I am working with a pretty big database so I
had to add a lot of horse power to that machine.

Paul, do you have any idea what this "Repair with keycache" state, is all
about. I am looking at the processes and basically mysql is doing nothing
while on this stage, however it does not release the database until it is
done with it.

Thanks for you comments

Ramon

On Sat, 11 May 2002, Paul DuBois wrote:

> At 20:20 -0400 5/11/02, <sup-mysql@stripped> wrote:
> >Paul,
> >	I dont quite understand what you mean when you say "I guess you
> >want your machine to thrash, then."
> 
> Most people don't have over a gig of physical memory.  Setting the buffer
> sizes to such huge amounts in such cases will cause a lot of swapping,
> completely obviating the attempt to improve performance.
> 
> >
> >Ramon
> >
> >
> >On Sat, 11 May 2002, Paul DuBois wrote:
> >
> >>  At 15:44 -0400 5/11/02, <sup-mysql@stripped> wrote:
> >>  >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.
> >>
> >>  I guess you want your machine to thrash, then.
> >>
> >>  How much physical memory do you actually have?  1200M?
> >>
> >>  >
> >>  >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
> 

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