safe_mysqld
上传用户:dzyhzl
上传日期:2019-04-29
资源大小:56270k
文件大小:9k
- #!/bin/sh
- # Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
- # This file is public domain and comes with NO WARRANTY of any kind
- #
- # scripts to start the MySQL daemon and restart it if it dies unexpectedly
- #
- # This should be executed in the MySQL base directory if you are using a
- # binary installation that has other paths than you are using.
- #
- # mysql.server works by first doing a cd to the base directory and from there
- # executing safe_mysqld
- trap '' 1 2 3 15 # we shouldn't let anyone kill us
- umask 007
- defaults=
- case "$1" in
- --no-defaults|--defaults-file=*|--defaults-extra-file=*)
- defaults="$1"; shift
- ;;
- esac
- parse_arguments() {
- # We only need to pass arguments through to the server if we don't
- # handle them here. So, we collect unrecognized options (passed on
- # the command line) into the args variable.
- pick_args=$1; shift
- for arg do
- case "$arg" in
- # these get passed explicitly to mysqld
- --basedir=*) MY_BASEDIR_VERSION=`echo "$arg" | sed -e "s;--[^=]*=;;"` ;;
- --datadir=*) DATADIR=`echo "$arg" | sed -e "s;--[^=]*=;;"` ;;
- --pid-file=*) pid_file=`echo "$arg" | sed -e "s;--[^=]*=;;"` ;;
- --user=*) user=`echo "$arg" | sed -e "s;--[^=]*=;;"` ; SET_USER=1 ;;
- # these two might have been set in a [safe_mysqld] section of my.cnf
- # they get passed via environment variables to safe_mysqld
- --socket=*) MYSQL_UNIX_PORT=`echo "$arg" | sed -e "s;--[^=]*=;;"` ;;
- --port=*) MYSQL_TCP_PORT=`echo "$arg" | sed -e "s;--[^=]*=;;"` ;;
- # safe_mysqld-specific options
- --ledir=*) ledir=`echo "$arg" | sed -e "s;--[^=]*=;;"` ;;
- --err-log=*) err_log=`echo "$arg" | sed -e "s;--[^=]*=;;"` ;;
- # QQ The --open-files should be removed
- --open-files=*) open_files=`echo "$arg" | sed -e "s;--[^=]*=;;"` ;;
- --open-files-limit=*) open_files=`echo "$arg" | sed -e "s;--[^=]*=;;"` ;;
- --core-file-size=*) core_file_size=`echo "$arg" | sed -e "s;--[^=]*=;;"` ;;
- --timezone=*) TZ=`echo "$arg" | sed -e "s;--[^=]*=;;"` ; export TZ; ;;
- --mysqld=*) MYSQLD=`echo "$arg" | sed -e "s;--[^=]*=;;"` ;;
- --mysqld-version=*)
- tmp=`echo "$arg" | sed -e "s;--[^=]*=;;"`
- if test -n "$tmp"
- then
- MYSQLD="mysqld-$tmp"
- else
- MYSQLD="mysqld"
- fi
- ;;
- *)
- if test $pick_args -eq 1
- then
- # This sed command makes sure that any special chars are quoted,
- # so the arg gets passed exactly to the server.
- args="$args "`echo "$arg" | sed -e 's,([^a-zA-Z0-9_.-]),\\1,g'`
- fi
- ;;
- esac
- done
- }
- MY_PWD=`pwd`
- # Check if we are starting this relative (for the binary release)
- if test -d $MY_PWD/data/mysql -a -f ./share/mysql/english/errmsg.sys -a
- -x ./bin/mysqld
- then
- MY_BASEDIR_VERSION=$MY_PWD # Where bin, share and data are
- ledir=$MY_BASEDIR_VERSION/bin # Where mysqld is
- DATADIR=$MY_BASEDIR_VERSION/data
- if test -z "$defaults"
- then
- defaults="--defaults-extra-file=$MY_BASEDIR_VERSION/data/my.cnf"
- fi
- # Check if this is a 'moved install directory'
- elif test -f ./var/mysql/db.frm -a -f ./share/mysql/english/errmsg.sys -a
- -x ./libexec/mysqld
- then
- MY_BASEDIR_VERSION=$MY_PWD # Where libexec, share and var are
- ledir=$MY_BASEDIR_VERSION/libexec # Where mysqld is
- DATADIR=$MY_BASEDIR_VERSION/var
- else
- MY_BASEDIR_VERSION=/usr/local/mysql
- DATADIR=/usr/local/mysql/var
- ledir=/usr/local/mysql/libexec
- fi
- MYSQL_UNIX_PORT=${MYSQL_UNIX_PORT:-/tmp/mysql.sock}
- MYSQL_TCP_PORT=${MYSQL_TCP_PORT:-3306}
- user=mysql
- # Use the mysqld-max binary by default if the user doesn't specify a binary
- if test -x $ledir/mysqld-max
- then
- MYSQLD=mysqld-max
- else
- MYSQLD=mysqld
- fi
- # these rely on $DATADIR by default, so we'll set them later on
- pid_file=
- err_log=
- SET_USER=0
- # Get first arguments from the my.cnf file, groups [mysqld] and [safe_mysqld]
- # and then merge with the command line arguments
- if test -x ./bin/my_print_defaults
- then
- print_defaults="./bin/my_print_defaults"
- elif test -x /usr/local/mysql/bin/my_print_defaults
- then
- print_defaults="/usr/local/mysql/bin/my_print_defaults"
- elif test -x /usr/local/mysql/bin/mysql_print_defaults
- then
- print_defaults="/usr/local/mysql/bin/mysql_print_defaults"
- else
- print_defaults="my_print_defaults"
- fi
- args=
- parse_arguments 0 `$print_defaults $defaults mysqld server safe_mysqld`
- parse_arguments 1 "$@"
- if test ! -x $ledir/$MYSQLD
- then
- echo "The file $ledir/$MYSQLD doesn't exist or is not executable"
- echo "Please do a cd to the mysql installation directory and restart"
- echo "this script from there as follows:"
- echo "./bin/safe_mysqld".
- exit 1
- fi
- if test -z "$pid_file"
- then
- pid_file=$DATADIR/`/bin/hostname`.pid
- else
- case "$pid_file" in
- /* ) ;;
- * ) pid_file="$DATADIR/$pid_file" ;;
- esac
- fi
- test -z "$err_log" && err_log=$DATADIR/`/bin/hostname`.err
- export MYSQL_UNIX_PORT
- export MYSQL_TCP_PORT
- NOHUP_NICENESS="nohup"
- if test -w /
- then
- NOHUP_NICENESS=`nohup nice 2>&1`
- if test $? -eq 0 && test x"$NOHUP_NICENESS" != x0 && nice --1 echo foo > /dev/null 2>&1
- then
- if test $NOHUP_NICENESS -gt 0
- then
- NOHUP_NICENESS="nice --$NOHUP_NICENESS nohup"
- else
- NOHUP_NICENESS="nice -$NOHUP_NICENESS nohup"
- fi
- else
- NOHUP_NICENESS="nohup"
- fi
- fi
- USER_OPTION=""
- if test -w /
- then
- if test "$user" != "root" -o $SET_USER = 1
- then
- USER_OPTION="--user=$user"
- fi
- # If we are root, change the err log to the right user.
- touch $err_log; chown $user $err_log
- if test -n "$open_files"
- then
- ulimit -n $open_files
- fi
- if test -n "$core_file_size"
- then
- ulimit -c $core_file_size
- fi
- fi
- #
- # If there exists an old pid file, check if the daemon is already running
- # Note: The switches to 'ps' may depend on your operating system
- if test -f $pid_file
- then
- PID=`cat $pid_file`
- if /bin/kill -0 $PID > /dev/null 2> /dev/null
- then
- if /bin/ps p $PID | grep mysqld > /dev/null
- then # The pid contains a mysqld process
- echo "A mysqld process already exists"
- echo "A mysqld process already exists at " `date` >> $err_log
- exit 1
- fi
- fi
- rm -f $pid_file
- if test -f $pid_file
- then
- echo "Fatal error: Can't remove the pid file: $pid_file"
- echo "Fatal error: Can't remove the pid file: $pid_file at " `date` >> $err_log
- echo "Please remove it manually and start $0 again"
- echo "mysqld daemon not started"
- exit 1
- fi
- fi
- #
- # Uncomment the following lines if you want all tables to be automaticly
- # checked and repaired at start
- #
- # echo "Checking tables in $DATADIR"
- # $MY_BASEDIR_VERSION/bin/myisamchk --silent --force --fast --medium-check -O key_buffer=64M -O sort_buffer=64M $DATADIR/*/*.MYI
- # $MY_BASEDIR_VERSION/bin/isamchk --silent --force -O sort_buffer=64M $DATADIR/*/*.ISM
- echo "Starting $MYSQLD daemon with databases from $DATADIR"
- # Does this work on all systems?
- #if type ulimit | grep "shell builtin" > /dev/null
- #then
- # ulimit -n 256 > /dev/null 2>&1 # Fix for BSD and FreeBSD systems
- #fi
- echo "`date +'%y%m%d %H:%M:%S mysqld started'`" >> $err_log
- while true
- do
- rm -f $MYSQL_UNIX_PORT $pid_file # Some extra safety
- if test -z "$args"
- then
- $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >> $err_log 2>&1
- else
- eval "$NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $args >> $err_log 2>&1"
- fi
- if test ! -f $pid_file # This is removed if normal shutdown
- then
- break
- fi
- if true
- then
- # Test if one process was hanging.
- # This is only a fix for Linux (running as base 3 mysqld processes)
- # but should work for the rest of the servers.
- # The only thing is ps x => redhat 5 gives warnings when using ps -x.
- # kill -9 is used or the process won't react on the kill.
- numofproces=`ps xa | grep -v "grep" | grep -c $ledir/$MYSQLD`
- echo -e "nNumber of processes running now: $numofproces" | tee -a $err_log
- I=1
- while test "$I" -le "$numofproces"
- do
- PROC=`ps xa | grep $ledir/$MYSQLD | grep -v "grep" | sed -n '$p'`
- for T in $PROC
- do
- break
- done
- # echo "TEST $I - $T **"
- if kill -9 $T
- then
- echo "$MYSQLD process hanging, pid $T - killed" | tee -a $err_log
- else
- break
- fi
- I=`expr $I + 1`
- done
- fi
- echo "`date +'%y%m%d %H:%M:%S'` mysqld restarted" | tee -a $err_log
- done
- echo "`date +'%y%m%d %H:%M:%S'` mysqld ended" | tee -a $err_log
- echo "" | tee -a $err_log