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