List:General Discussion« Previous MessageNext Message »
From:Erik Price Date:November 14 2001 4:46pm
Subject:Re: mysqld shutdown
View as plain text  
--- Bill Adams <badams@stripped> wrote:
> >  One option is to use
> >
> > /usr/local/mysql/bin:mysql$ mysqladmin -u root -p shutdown
> >
> > But this one doesn't work for me, even though I am using the proper
> > password and am the proper user.  Executing this command just
> leaves me
> > hanging at the prompt (and the only way to get out of the hang is
> to
> > either suspend the job, which also has no effect).
> 
> Do you have a query still running? E.g. does mysqladmin -uroot -p
> processlist show any locks?  If so, can you kill the thread with
> mysqladmin
> kill?

Bill,

First of all, thanks for responding -- I'm a bit worried about this
problem (since I can't come across a logical solution yet).  Being new
to MySQL, I hadn't checked for running processes, but I just tried your
command:

mysql:localhost~:$ ../bin/mysqladmin -u root -p processlist
Enter password: 
+----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host      | db | Command | Time | State | Info           
 |
+----+------+-----------+----+---------+------+-------+------------------+
| 4  | root | localhost |    | Query   | 0    |       | show
processlist |
+----+------+-----------+----+---------+------+-------+------------------+
mysql:localhost~:$ 

I'm assuming that this says that the only query is the actual
"processlist" command itself, so it doesn't need to be killed.  Any
other ideas?

Erik

PS:  If I run the mysqladmin shutdown command, then check "top" in
another console, both the daemon and the mysqladmin command continue to
run indefinitely -- and I have waited an hour to see if it's just slow.
 That doesn't seem to be the case.

__________________________________________________
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
Thread
mysqld shutdownErik Price14 Nov
  • Re: mysqld shutdownBill Adams14 Nov
    • Re: mysqld shutdownErik Price14 Nov
      • Re: mysqld shutdownBill Adams14 Nov
        • Re: mysqld shutdownErik Price14 Nov
        • Re: mysqld shutdownSergei Golubchik14 Nov
          • Re: mysqld shutdownErik Price14 Nov
            • Re: mysqld shutdownGerald Clark14 Nov
            • Re: mysqld shutdownDan Nelson15 Nov
              • Re: mysqld shutdownErik Price15 Nov
    • Re: mysqld shutdownMike(mickalo)Blezien14 Nov
Re: mysqld shutdownErik Price14 Nov