Paul I have 1536MB of RAM and have turned off disk swap.
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