--- 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
