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
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
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
I am not really sure where it gets installed... nor that wether it is
all installed on a single location. Try searching for it..
find / -name mysql
Good Luck
Ramon
On Sat, 11 May 2002, Hoa Doan wrote:
Hello,
I'm trying to install mysql on RedHat Linux 7.0. I've downloaded the rpm.
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
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 the
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
Hello there,
Does anyone know what the MySQL delay_key_write variable do?
Ramon
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To