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

Reply via email to