Thanks you all for your nice suggestions. The thing is, for some reason, I could not stop the mysqld using 'mysqld stop'. Any insight about why this would fail?
Another question, which might not be a *pure* mysql one, is: I ran a script to load my mysql database, but it has not finished the job for almost 10 hours and now it is in *wait 4* state. Anything I can do about this? Should I wait till it is done or there is no hope and I just need to stop it and ran again? Thanks, Jack ++++++++++++++++++++++++++++++++++++++++++++++++ Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] ++++++++++++++++++++++++++++++++++++++++++++++++ On Sat, 9 Nov 2002, Gelu Gogancea wrote: > Hi, > If you really wish to kill the mysql daemon in this way : > You should try : > ps -ef |grep "mysql" > ...show all the mysqld processes and after this must enumarate all pid of > processes in a single kill command. > E.g. > kill -9 1024 1056 ...(processes which are open). > But it's more "health" if you can stop the server using : > /etc/rc.d/mysqld stop > > Regards, > > Gelu > _____________________________________________________ > G.NET SOFTWARE COMPANY > > Permanent e-mail address : [EMAIL PROTECTED] > [EMAIL PROTECTED] > ----- Original Message ----- > From: "Jack Chen" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, November 09, 2002 7:57 AM > Subject: Re: mysqld refuse to die > > > > I have just figured out: > > > > kill -9 xxx (process number) > > > > Thanks, > > > > Jack > > > > ++++++++++++++++++++++++++++++++++++++++++++++++ > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > ++++++++++++++++++++++++++++++++++++++++++++++++ > > > > On Sat, 9 Nov 2002, Jack Chen wrote: > > > > > Hi All, > > > > > > Please help me with this problem: > > > > > > For some reason, I could not bring down my mysqld by running > > > > > > mysqld stop > > > > > > An error message indicate: fail > > > > > > What's going on? > > > > > > Thanks, > > > > > > Jack > > > > > > ++++++++++++++++++++++++++++++++++++++++++++++++ > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > > Tel: 1 516 3676904; e-mail: [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 > > > > > > > > > > > > --------------------------------------------------------------------- > > 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 > > > > > > ------------------------------------------------------- > > Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV > AntiVirus. > > Xnet automatically scans all messages for viruses using RAV AntiVirus. > > > > Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate > variantele lor. Va rugam sa luati in considerare ca exista un risc de > fiecare data cand deschideti fisiere atasate si ca MobiFon nu este > responsabila pentru nici un prejudiciu cauzat de virusi. > > Disclaimer: RAV AntiVirus may not be able to detect all new viruses and > variants. Please be aware that there is a risk involved whenever opening > e-mail attachments to your computer and that MobiFon is not responsible for > any damages caused by viruses. > > > > > > --------------------------------------------------------------------- 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