From mboxrd@z Thu Jan 1 00:00:00 1970 X-Msuck: nntp://news.gmane.io/gmane.comp.sysutils.supervision.general/765 Path: news.gmane.org!not-for-mail From: Alex Efros Newsgroups: gmane.comp.sysutils.supervision.general Subject: Re: Warning about mysqld's behaviour Date: Thu, 14 Apr 2005 15:07:50 +0300 Organization: asdfGroup Inc., http://www.asdfGroup.com/ Message-ID: <20050414120750.GB21873@home.power> References: <20050414085007.3830.qmail@b6398251b71d42.315fe32.mid.smarden.org> NNTP-Posting-Host: main.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: sea.gmane.org 1113480351 27360 80.91.229.2 (14 Apr 2005 12:05:51 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Thu, 14 Apr 2005 12:05:51 +0000 (UTC) Original-X-From: supervision-return-1001-gcsg-supervision=m.gmane.org@list.skarnet.org Thu Apr 14 14:05:49 2005 Return-path: Original-Received: from antah.skarnet.org ([212.85.147.14]) by ciao.gmane.org with smtp (Exim 4.43) id 1DM35C-0005r1-Ct for gcsg-supervision@gmane.org; Thu, 14 Apr 2005 14:04:31 +0200 Original-Received: (qmail 8993 invoked by uid 76); 14 Apr 2005 12:08:14 -0000 Mailing-List: contact supervision-help@list.skarnet.org; run by ezmlm List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Archive: Original-Received: (qmail 8987 invoked from network); 14 Apr 2005 12:08:14 -0000 Original-To: supervision@list.skarnet.org Mail-Followup-To: supervision@list.skarnet.org Content-Disposition: inline In-Reply-To: <20050414085007.3830.qmail@b6398251b71d42.315fe32.mid.smarden.org> User-Agent: Mutt/1.5.8i Xref: news.gmane.org gmane.comp.sysutils.supervision.general:765 X-Report-Spam: http://spam.gmane.org/gmane.comp.sysutils.supervision.general:765 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 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.