Paul,
I dont quite understand what you mean when you say "I guess you
want your machine to thrash, then."
Ramon
On Sat, 11 May 2002, Paul DuBois wrote:
> At 15:44 -0400 5/11/02, <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] 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
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
