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 memor
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 buffer will improve
the performance of this stage?
Tha
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
assume
> >> >> increasing the key cache matter.
> >> >>
> >> >> Regards,
> >> >>
> >> >>Benjamin.
> >> >>
> >> >> On Sat, May 11, 2002 at 1
ing the key cache matter.
>> >>
>> >> Regards,
>> >>
>> >> Benjamin.
>> >>
>> >> On Sat, May 11, 2002 at 11:00:11AM -0400,
>>[EMAIL PROTECTED] wrote:
>> >> > When loading lar
>>
> >> 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. Wh
AIL 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
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 &
;
> 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
ta 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
> loadi
Hello,
I wonder whether someone has and idea of what "Repair with key
cache" means.
When loading large amounts of data into MySQL there is a period of high
server activity followed by a long period of little activity. While on the
little activity period, the process state in the pr
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
Description:
I have this little script (1) that builds a table each night.
For quite a while the output shows a normal load data infile (2).
Then, it switches to a state of 'Repair with keycache' (3).
This just started happening with mysql 3.23.32. Until I upgraded
a few days ago it was not a pr
13 matches
Mail list logo
