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, <[EMAIL PROTECTED]> 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, <[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
