Workaround: Shutdown on OS X

[Steve Fox]

For anyone having trouble with shutting down mysqld on OS X
(especially if it times out waiting on the PID file):

I had been having trouble getting mysql (3.23.26) to shutdown on OS X
(10.1.1).
I had been using sudo to start safe_mysqld with user mysql

Now I su as user mysql to run safe_mysqld
To stop I su mysql and run mysqladmin.

I start and stop it frequently since its running on a laptop and
I haven't had a shutdown problem since I started doing it this way.

Steve Fox
UT CMHC



-
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

OS X Flush Tables before shutdown

[Steve Fox]

For folks that are having trouble with clean shutdown on OS X, try using 
mysqladmin -u root -ppw flush-tables
before shutting down mysql.

I hadn't had a shutdown problem in a week then this evening I got the 
dreaded pid file hang at shutdown and had to use kill -9.
The only thing I did differently was I *DID NOT* flush the tables first.

Its all circumstantial, but its all I've got :)

Steve Fox
UT CMHC

-
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

OS X Waiting on pid file

[Steve Fox]

Hello,
I'm using the 3.23.46 mysql binary kindly supplied by Marc Liyanage 
(www.entropy.ch/software/macosx/) on OS X 10.1.1.

Maybe 1 out of 5 tries mysqladmin shutdown fails, timed-out waiting for 
the pid file it says.
mysqladmin doesn't return and I have to either use ^C or open a new 
window and kill mysqladmin to get terminate it and get the error.

After that the mysql sock file is gone (so I may no longer connect) but 
the pid file remains and I have to kill -9 safe_mysqld and mysqld then 
run isamchk.

Here's what I'm doing:

-- Development on a laptop; no one else connecting to the DB
-- I make certain nothing is working against the DB before trying to 
shutdown
-- Most db queries coming through PHP4.0.6 all else through mysql cli
-- start from /usr/local/mysql using sudo bin/safe_mysqld --user=mysql 
-- stop with mysqladmin -u root -pppassword shutdown
-- Being on  a laptop, mysql sometimes sees the host as localhost and 
sometimes as dhcp-* host.
-- I've noticed I get different .pid and .err files depending on host
-- Hosts are switching mid-stream (I always shutdown myslq before going 
on/off a network)

I've been through books and website, but I haven't been able to resolve 
what I'm doing wrong. . .
mysql has been really great to have on the laptop and I'm hoping someone 
could help through this one problem.

Thanks in advance,

Steve Fox
UT CMHC




-
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