On Mon, May 13, 2002 at 09:23:36AM -0400, Ramon Arias wrote:
> Jereymy,
>
> Thanks a lot for your explanation on "Repair with key cache",
> I was reading the online help, but could not get a clear picture of
> what was going on. So I gess allocating as much memory as posible to
> the key bu
nks
Ramon
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 12, 2002 12:19 PM
To: [EMAIL PROTECTED]
Cc: Paul DuBois; Benjamin Pflugmann; [EMAIL PROTECTED]
Subject: Re: Repair with key cache
On Sat, May 11, 2002 at 08:39:55PM -0400, [EMAIL PROTECTED] wrote:
&g
On Sat, May 11, 2002 at 08:39:55PM -0400, [EMAIL PROTECTED] wrote:
>
> Paul, do you have any idea what this "Repair with keycache" state,
> is all about.
It means that MySQL is building up the indexes on the imported data.
It is doing so using the keycache (or key_buffer) just as it does
during
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
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 lo
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
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 the
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 imp
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 10
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 the
10 matches
Mail list logo
