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?
Thanks
Ramon
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 buffer
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 a
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
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 process list
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
--
[EMAIL
: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
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
, [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
,
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
, 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
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
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
13 matches
Mail list logo