Hi Joseph, The situation is like this. The daemon was running but any command / requests were hanging for example any mysqladmin command would sit there forever, any mysql command would behave the same way.
OS - HP-UX 10.20 Mysql version - 3.23.33 There were lot of activities at the time server hung-up. But even after users got out it was in the hung state. Nothing in the error log files to give any clues. thanks Vivek > -----Original Message----- > From: joseph.bueno [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 19, 2002 1:18 AM > To: CHAUDHARY, Vivek > Cc: mysql > Subject: Re: FW: Mysql unresponsive .... > > > Hi, > > May be this list was unresponsive because your description of the > problem was a bit vague... > > I haven't experienced this kind of behaviour myself however some > more details on your problem may help: > - What OS are you using ? > - What version of MySQL are you using ? > - Was mysql server dead ? > (Have you tried mysqladmin with "ping", "status" or > "processlist" options ?) > - Have you checked mysql error log ? > - When the problem happened, what kind of system activity have > you seen ? Have you run top, vmstat (I assume you are on a > Unix like OS) ? > > Hope this helps > -- > Joseph Bueno > NetClub/Trader.com > > [EMAIL PROTECTED] wrote : > > > > Since I didn't get any response (like mysql server) I am sending it > > again. > > > > thanks > > > > Vivek > > > -----Original Message----- > > > From: CHAUDHARY, Vivek > > > Sent: Wednesday, April 17, 2002 3:34 PM > > > To: '[EMAIL PROTECTED]' > > > Subject: Mysql unresponsive .... > > > > > > > > > Hi all, > > > > > > Last friday we found that mysql was unresponsive (all the SQL > > > activities were on hold) but the daemon was still running. We > > > shutdown the daemon and restarted and everything was OK. > My questions: > > > > > > 1) What could cause this behavior ? > > > 2) Is there any way to monitor such a behavior ? any > > > commands, scripts that could test for inactivity etc. > > > > > > Needless to say that I am a newbie on mysql front. > > > > > > Vivek Chaudhary > > > Database Administrator > > > "IT" STMicroelectronics, Phoenix. > > > Phone:(602)485-2271 > > > Fax: (602)485-6402 > > > Cell:(602)363-1492 > > > Email: [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