Re: Warning about mysqld's behaviour

[Alex Efros <powerman@sky.net.ua>]

Hi!

On Thu, Apr 14, 2005 at 08:53:06AM +0000, Gerrit Pape wrote:
> > Version of mysql is 3.23.58. I haven't looked at other versions, so don't 
> > know whether this is new or old brain-damage.
> > 
> > I have a straightforward run file:
> > 
> > #!/bin/sh
> > exec /usr/libexec/mysqld \
> >  --defaults-file=/etc/my.cnf \
> >  --basedir=/usr \
> >  --datadir=/var/lib/mysql \
> >  --user=mysql \
> >  --pid-file=/var/run/mysqld/mysqld.pid

I use this ./run with MySQL 4.0.x. It allow me control mysql using runsvctrl:
---cut---
#!/bin/bash
exec </dev/null >/dev/null 2>/dev/null
SHUTPASS="HERE_IS_ME_PASSWORD"
trap "mysqladmin -u shutdown -p$SHUTPASS shutdown" 0
trap 'exit 2' 1 2 3 15
mysqld_safe --default-character-set=koi8_ru & wait
---cut---
(I've special user "shutdown" with only permission to shutdown server
because I dislike use "root" user and put it password in this script.)

I've switched from sending TERM to mysqld to using "mysqladmin shutdown"
some time ago because on very busy server sending TERM sometimes result
in damaging database. There was number of cases when after reboot with
"init 6" I found database crashed. :(

-- 
			WBR, Alex.