On Tue, Sep 24, 2002 at 08:21:36PM -0700, Andrew Maltsev wrote: : Any suggestions how to approach the problem? How and what to test? It : happens randomly, can work for a day or two with no problems and then : hang three times in one hour. And obviously I can't reproduce it in my : test environment however hard I stress test it.
When it happens, what does the system look like? Is CPU pegged? Is MySQL using a lot of CPU. What does iostat tell you in terms of drive activity. Are the drives actively seeking or does the system seem relatively quiet? You'll have to do *some* troubleshooting. We had a similar problem on RedHat 7.2 (2.4.7) that we traced to poor memory/swap management in the kernel. Updating the kernel fixed it. Then we had another similar problem which we traced to our fibrechannel card. Replacing the card solved that. What does a 'show processlist' during the pause tell you? Are there any queries running extremely long? You can log those. Now, if we ever have a problem like that, it's usually I/O related (the disks are ultra busy, usually because of a backup or something; throttling the backup bandwidth usually solves that). Do some more research. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] --------------------------------------------------------------------- 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
