List: | General Discussion | « Previous MessageNext Message » | |
From: | <sup-mysql | Date: | May 11 2002 7:44pm |
Subject: | Re: Repair with key cache | ||
View as plain text |
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 > >
Thread | ||
---|---|---|
• quick sql question | Augey Mikus | 10 May |
• Re: quick sql question | Paul DuBois | 10 May |
• Re: quick sql question | Augey Mikus | 10 May |
• Re: quick sql question | Paul DuBois | 10 May |
• Re: quick sql question | Augey Mikus | 10 May |
• Re: quick sql question | Paul DuBois | 10 May |
• Re: quick sql question | Augey Mikus | 11 May |
• Re: quick sql question | Augey Mikus | 11 May |
• Re: quick sql question | Paul DuBois | 11 May |
• Repair with key cache | sup-mysql | 11 May |
• Re: Repair with key cache | Benjamin Pflugmann | 11 May |
• Re: Repair with key cache | sup-mysql | 11 May |
• Re: Repair with key cache | Paul DuBois | 12 May |
• Re: Repair with key cache | sup-mysql | 12 May |
• Re: Repair with key cache | sup-mysql | 12 May |
• Re: Repair with key cache | Paul DuBois | 12 May |
• Re: Repair with key cache | sup-mysql | 12 May |
• Re: Repair with key cache | Jeremy Zawodny | 12 May |
• RE: Repair with key cache | Ramon Arias | 13 May |
• Re: Repair with key cache | Jeremy Zawodny | 13 May |
• Re: quick sql question | Augey Mikus | 11 May |