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 requ
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
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
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.
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
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 rea
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
loadi
