Hi all,
I seem to be running into a stability problem with our current mySQL
server. I'm at a loss as to where to begin looking. We first noticed a
problem with large files being created in the /tmp directory. That
hasn't happened since, but yesterday the server bogged down twice.
There were about 100 or so connections to the server, mostly sleeping,
and the server was acting extremely sluggish. It took about 60 seconds
to get a processlist via mysqladmin...
Can anyone give me any pointers as to where to look first? Are there
any settings I can tweak that may help this? The machine is a dual 1.3
Ghz machine with 512 Meg RAM .... It used to be running on a dual 733
Mhz machine and we never experienced anything like this ...
--
---------------------------
Jason 'XenoPhage' Frisvold
Senior ATM Engineer
Penteledata Engineering
[EMAIL PROTECTED]
RedHat Certified - RHCE # 807302349405893
---------------------------
"Something mysterious is formed, born in the silent void. Waiting alone
and unmoving, it is at once still and yet in constant motion. It is the
source of all programs. I do not know its name, so I will call it the
Tao of Programming."
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
