mysqld_safe.sh 15.4 KB
Newer Older
unknown's avatar
unknown committed
1 2 3 4
#!/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
#
5
# Script to start the MySQL daemon and restart it if it dies unexpectedly
unknown's avatar
unknown committed
6 7
#
# This should be executed in the MySQL base directory if you are using a
8 9
# binary installation that is not installed in its compile-time default
# location
unknown's avatar
unknown committed
10 11
#
# mysql.server works by first doing a cd to the base directory and from there
unknown's avatar
unknown committed
12
# executing mysqld_safe
unknown's avatar
unknown committed
13

14
KILL_MYSQLD=1;
15
MYSQLD=
16
niceness=0
17 18 19 20
# Initial logging status: error log is not open, and not using syslog
logging=init
want_syslog=0
syslog_tag=
21 22 23
user=@MYSQLD_USER@
pid_file=
err_log=
24

25 26 27
syslog_tag_mysqld=mysqld
syslog_tag_mysqld_safe=mysqld_safe

unknown's avatar
unknown committed
28 29
trap '' 1 2 3 15			# we shouldn't let anyone kill us

30 31
umask 007

unknown's avatar
unknown committed
32 33
defaults=
case "$1" in
unknown's avatar
unknown committed
34
    --no-defaults|--defaults-file=*|--defaults-extra-file=*)
unknown's avatar
unknown committed
35 36 37 38
      defaults="$1"; shift
      ;;
esac

39 40 41 42 43 44 45 46 47 48 49 50 51 52
usage () {
        cat <<EOF
Usage: $0 [OPTIONS]
  --no-defaults              Don't read the system defaults file
  --defaults-file=FILE       Use the specified defaults file
  --defaults-extra-file=FILE Also use defaults from the specified file
  --ledir=DIRECTORY          Look for mysqld in the specified directory
  --open-files-limit=LIMIT   Limit the number of open files
  --core-file-size=LIMIT     Limit core files to the specified size
  --timezone=TZ              Set the system timezone
  --mysqld=FILE              Use the specified file as mysqld
  --mysqld-version=VERSION   Use "mysqld-VERSION" as mysqld
  --nice=NICE                Set the scheduling priority of mysqld
  --skip-kill-mysqld         Don't try to kill stray mysqld processes
53
  --syslog                   Log messages to syslog with 'logger'
54 55
  --skip-syslog              Log messages to error log (default)
  --syslog-tag=TAG           Pass -t "mysqld-TAG" to 'logger'
56 57 58 59 60 61 62

All other options are passed to the mysqld program.

EOF
        exit 1
}

63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
my_which ()
{
  save_ifs="${IFS-UNSET}"
  IFS=:
  for file
  do
    for dir in $PATH
    do
      if [ -f "$dir/$file" ]
      then
        echo "$dir/$file"
        continue 2
      fi
    done
    return 1  # Failure, didn't find file in path
  done
  if [ "$save_ifs" = UNSET ]
  then
    unset IFS
  else
    IFS="$save_ifs"
  fi
  return 0  # Success
}

88 89 90 91 92 93
log_generic () {
  priority="$1"
  shift

  msg="`date +'%y%m%d %H:%M:%S'` mysqld_safe $*"
  echo "$msg"
94 95 96 97 98 99 100 101 102
  case $logging in
    init) ;;  # Just echo the message, don't save it anywhere
    file) echo "$msg" >> "$err_log" ;;
    syslog) logger -t "$syslog_tag_mysqld_safe" -p "$priority" "$*" ;;
    *)
      echo "Internal program error (non-fatal):" \
           " unknown logging method '$logging'" >&2
      ;;
  esac
103 104 105 106 107 108 109 110 111 112 113 114
}

log_error () {
  log_generic daemon.error "$@" >&2
}

log_notice () {
  log_generic daemon.notice "$@"
}

eval_log_error () {
  cmd="$1"
115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131
  case $logging in
    file) cmd="$cmd >> "`shell_quote_string "$err_log"`" 2>&1" ;;
    syslog)
      # mysqld often prefixes its messages with a timestamp, which is
      # redundant when logging to syslog (which adds its own timestamp)
      # However, we don't strip the timestamp with sed here, because
      # sed buffers output (only GNU sed supports a -u (unbuffered) option)
      # which means that messages may not get sent to syslog until the
      # mysqld process quits.
      cmd="$cmd 2>&1 | logger -t '$syslog_tag_mysqld' -p daemon.error"
      ;;
    *)
      echo "Internal program error (non-fatal):" \
           " unknown logging method '$logging'" >&2
      ;;
  esac

132 133 134 135
  #echo "Running mysqld: [$cmd]"
  eval "$cmd"
}

136 137 138 139 140
shell_quote_string() {
  # This sed command makes sure that any special chars are quoted,
  # so the arg gets passed exactly to the server.
  echo "$1" | sed -e 's,\([^a-zA-Z0-9/_.=-]\),\\\1,g'
}
141

unknown's avatar
unknown committed
142
parse_arguments() {
unknown's avatar
unknown committed
143 144 145 146 147 148 149 150 151 152 153
  # 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=
  if test "$1" = PICK-ARGS-FROM-ARGV
  then
    pick_args=1
    shift
  fi

  for arg do
154
    val=`echo "$arg" | sed -e "s;--[^=]*=;;"`
unknown's avatar
unknown committed
155 156
    case "$arg" in
      # these get passed explicitly to mysqld
157 158 159 160
      --basedir=*) MY_BASEDIR_VERSION="$val" ;;
      --datadir=*) DATADIR="$val" ;;
      --pid-file=*) pid_file="$val" ;;
      --user=*) user="$val"; SET_USER=1 ;;
unknown's avatar
unknown committed
161

162
      # these might have been set in a [mysqld_safe] section of my.cnf
163
      # they are added to mysqld command line to override settings from my.cnf
164 165 166
      --log-error=*) err_log="$val" ;;
      --port=*) mysql_tcp_port="$val" ;;
      --socket=*) mysql_unix_port="$val" ;;
unknown's avatar
unknown committed
167

unknown's avatar
unknown committed
168
      # mysqld_safe-specific options - must be set in my.cnf ([mysqld_safe])!
169 170 171
      --core-file-size=*) core_file_size="$val" ;;
      --ledir=*) ledir="$val" ;;
      --mysqld=*) MYSQLD="$val" ;;
unknown's avatar
unknown committed
172
      --mysqld-version=*)
173 174 175 176 177 178
        if test -n "$val"
        then
          MYSQLD="mysqld-$val"
        else
          MYSQLD="mysqld"
        fi
179
        ;;
180 181 182
      --nice=*) niceness="$val" ;;
      --open-files-limit=*) open_files="$val" ;;
      --skip-kill-mysqld*) KILL_MYSQLD=0 ;;
183 184 185
      --syslog) want_syslog=1 ;;
      --skip-syslog) want_syslog=0 ;;
      --syslog-tag=*) syslog_tag="$val" ;;
186 187 188 189
      --timezone=*) TZ="$val"; export TZ; ;;

      --help) usage ;;

unknown's avatar
unknown committed
190 191 192
      *)
        if test -n "$pick_args"
        then
193
          append_arg_to_args "$arg"
unknown's avatar
unknown committed
194 195
        fi
        ;;
unknown's avatar
unknown committed
196 197 198 199
    esac
  done
}

200

201 202 203 204
#
# First, try to find BASEDIR and ledir (where mysqld is)
# 

unknown's avatar
unknown committed
205
MY_PWD=`pwd`
206 207
# Check for the directories we would expect from a binary release install
if test -f ./share/mysql/english/errmsg.sys -a -x ./bin/mysqld
unknown's avatar
unknown committed
208 209 210
then
  MY_BASEDIR_VERSION=$MY_PWD		# Where bin, share and data are
  ledir=$MY_BASEDIR_VERSION/bin		# Where mysqld is
211
# Check for the directories we would expect from a source install
212
elif test -f ./share/mysql/english/errmsg.sys -a -x ./libexec/mysqld
unknown's avatar
unknown committed
213 214 215
then
  MY_BASEDIR_VERSION=$MY_PWD		# Where libexec, share and var are
  ledir=$MY_BASEDIR_VERSION/libexec	# Where mysqld is
216
# Since we didn't find anything, used the compiled-in defaults
unknown's avatar
unknown committed
217 218 219 220 221
else
  MY_BASEDIR_VERSION=@prefix@
  ledir=@libexecdir@
fi

222 223 224 225 226 227 228
#
# Second, try to find the data directory
#

# Try where the binary installs put it
if test -d $MY_BASEDIR_VERSION/data/mysql
then
unknown's avatar
unknown committed
229
  DATADIR=$MY_BASEDIR_VERSION/data
unknown's avatar
unknown committed
230
  if test -z "$defaults" -a -r "$DATADIR/my.cnf"
unknown's avatar
unknown committed
231
  then
232
    defaults="--defaults-extra-file=$DATADIR/my.cnf"
unknown's avatar
unknown committed
233
  fi
234 235
# Next try where the source installs put it
elif test -d $MY_BASEDIR_VERSION/var/mysql
unknown's avatar
unknown committed
236 237
then
  DATADIR=$MY_BASEDIR_VERSION/var
238
# Or just give up and use our compiled-in default
unknown's avatar
unknown committed
239 240 241
else
  DATADIR=@localstatedir@
fi
unknown's avatar
unknown committed
242

243 244
if test -z "$MYSQL_HOME"
then 
unknown's avatar
unknown committed
245 246
  if test -r "$MY_BASEDIR_VERSION/my.cnf" && test -r "$DATADIR/my.cnf"
  then
247 248 249 250 251
    log_error "WARNING: Found two instances of my.cnf -
$MY_BASEDIR_VERSION/my.cnf and
$DATADIR/my.cnf
IGNORING $DATADIR/my.cnf"

unknown's avatar
unknown committed
252 253 254
    MYSQL_HOME=$MY_BASEDIR_VERSION
  elif test -r "$DATADIR/my.cnf"
  then
255 256 257
    log_error "WARNING: Found $DATADIR/my.cnf
The data directory is a deprecated location for my.cnf, please move it to
$MY_BASEDIR_VERSION/my.cnf"
unknown's avatar
unknown committed
258 259 260 261
    MYSQL_HOME=$DATADIR
  else
    MYSQL_HOME=$MY_BASEDIR_VERSION
  fi
262 263
fi
export MYSQL_HOME
unknown's avatar
unknown committed
264

unknown's avatar
unknown committed
265

unknown's avatar
unknown committed
266
# Get first arguments from the my.cnf file, groups [mysqld] and [mysqld_safe]
unknown's avatar
unknown committed
267
# and then merge with the command line arguments
unknown's avatar
unknown committed
268 269
if test -x ./bin/my_print_defaults
then
unknown's avatar
unknown committed
270
  print_defaults="./bin/my_print_defaults"
unknown's avatar
unknown committed
271 272
elif test -x @bindir@/my_print_defaults
then
unknown's avatar
unknown committed
273
  print_defaults="@bindir@/my_print_defaults"
unknown's avatar
unknown committed
274 275
elif test -x @bindir@/mysql_print_defaults
then
unknown's avatar
unknown committed
276 277 278 279
  print_defaults="@bindir@/mysql_print_defaults"
else
  print_defaults="my_print_defaults"
fi
unknown's avatar
unknown committed
280

281 282 283 284
append_arg_to_args () {
  args="$args "`shell_quote_string "$1"`
}

unknown's avatar
unknown committed
285
args=
286

287
SET_USER=2
unknown's avatar
unknown committed
288
parse_arguments `$print_defaults $defaults --loose-verbose mysqld server`
289 290 291 292
if test $SET_USER -eq 2
then
  SET_USER=0
fi
293

unknown's avatar
unknown committed
294
parse_arguments `$print_defaults $defaults --loose-verbose mysqld_safe safe_mysqld`
unknown's avatar
unknown committed
295
parse_arguments PICK-ARGS-FROM-ARGV "$@"
unknown's avatar
unknown committed
296

297
# Determine what logging facility to use
298 299 300 301 302 303 304

# Ensure that 'logger' exists, if it's requested
if [ $want_syslog -eq 1 ]
then
  my_which logger > /dev/null 2>&1
  if [ $? -ne 0 ]
  then
unknown's avatar
unknown committed
305 306
    log_error "--syslog requested, but no 'logger' program found.  Please ensure that 'logger' is in your PATH, or do not specify the --syslog option to mysqld_safe."
    exit 1
307 308 309 310
  fi
fi

if [ -n "$err_log" -o $want_syslog -eq 0 ]
311 312 313
then
  if [ -n "$err_log" ]
  then
unknown's avatar
unknown committed
314
    # mysqld adds ".err" if there is no extension on the --log-error
315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336
    # argument; must match that here, or mysqld_safe will write to a
    # different log file than mysqld

    # mysqld does not add ".err" to "--log-error=foo."; it considers a
    # trailing "." as an extension
    if expr "$err_log" : '.*\.[^/]*$' > /dev/null
    then
        :
    else
      err_log="$err_log".err
    fi

    case "$err_log" in
      /* ) ;;
      * ) err_log="$DATADIR/$err_log" ;;
    esac
  else
    err_log=$DATADIR/`@HOSTNAME@`.err
  fi

  append_arg_to_args "--log-error=$err_log"

337
  if [ $want_syslog -eq 1 ]
338 339
  then
    # User explicitly asked for syslog, so warn that it isn't used
340
    log_error "Can't log to error log and syslog at the same time.  Remove all --log-error configuration options for --syslog to take effect."
341 342
  fi

343 344 345 346 347 348 349 350 351 352 353 354 355
  # Log to err_log file
  log_notice "Logging to '$err_log'."
  logging=file
else
  if [ -n "$syslog_tag" ]
  then
    # Sanitize the syslog tag
    syslog_tag=`echo "$syslog_tag" | sed -e 's/[^a-zA-Z0-9_-]/_/g'`
    syslog_tag_mysqld_safe="${syslog_tag_mysqld_safe}-$syslog_tag"
    syslog_tag_mysqld="${syslog_tag_mysqld}-$syslog_tag"
  fi
  log_notice "Logging to syslog."
  logging=syslog
356 357
fi

358 359 360 361 362 363 364 365
USER_OPTION=""
if test -w / -o "$USER" = "root"
then
  if test "$user" != "root" -o $SET_USER = 1
  then
    USER_OPTION="--user=$user"
  fi
  # Change the err log to the right user, if it is in use
366
  if [ $want_syslog -eq 0 ]; then
367 368 369 370 371 372 373 374 375 376
    touch $err_log
    chown $user $err_log
  fi
  if test -n "$open_files"
  then
    ulimit -n $open_files
    append_arg_to_args "--open-files-limit=$open_files"
  fi
fi

377
safe_mysql_unix_port=${mysql_unix_port:-${MYSQL_UNIX_PORT:-@MYSQL_UNIX_ADDR@}}
378 379 380 381 382 383
# Make sure that directory for $safe_mysql_unix_port exists
mysql_unix_port_dir=`dirname $safe_mysql_unix_port`
if [ ! -d $mysql_unix_port_dir ]
then
  mkdir $mysql_unix_port_dir
  chown $user $mysql_unix_port_dir
384
  chmod 755 $mysql_unix_port_dir
385 386
fi

unknown's avatar
unknown committed
387
# If the user doesn't specify a binary, we assume name "mysqld"
388 389
if test -z "$MYSQLD"
then
unknown's avatar
unknown committed
390
  MYSQLD=mysqld
391
fi
392

unknown's avatar
unknown committed
393
if test ! -x $ledir/$MYSQLD
unknown's avatar
unknown committed
394
then
395 396 397 398
  log_error "The file $ledir/$MYSQLD
does not exist or is not executable. Please cd to the mysql installation
directory and restart this script from there as follows:
./bin/mysqld_safe&
399
See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information"
unknown's avatar
unknown committed
400
  exit 1
unknown's avatar
unknown committed
401 402
fi

403 404 405 406 407 408 409 410 411
if test -z "$pid_file"
then
  pid_file=$DATADIR/`@HOSTNAME@`.pid
else
  case "$pid_file" in
    /* ) ;;
    * )  pid_file="$DATADIR/$pid_file" ;;
  esac
fi
412 413
append_arg_to_args "--pid-file=$pid_file"

414 415
if test -n "$mysql_unix_port"
then
416
  append_arg_to_args "--socket=$mysql_unix_port"
417 418 419
fi
if test -n "$mysql_tcp_port"
then
420
  append_arg_to_args "--port=$mysql_tcp_port"
421
fi
unknown's avatar
unknown committed
422

423 424 425 426 427 428
if test $niceness -eq 0
then
  NOHUP_NICENESS="nohup"
else
  NOHUP_NICENESS="nohup nice -$niceness"
fi
429 430 431 432 433 434 435

# Using nice with no args to get the niceness level is GNU-specific.
# This check could be extended for other operating systems (e.g.,
# BSD could use "nohup sh -c 'ps -o nice -p $$' | tail -1").
# But, it also seems that GNU nohup is the only one which messes
# with the priority, so this is okay.
if nohup nice > /dev/null 2>&1
unknown's avatar
unknown committed
436
then
437
    normal_niceness=`nice`
438
    nohup_niceness=`nohup nice 2>/dev/null`
439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458

    numeric_nice_values=1
    for val in $normal_niceness $nohup_niceness
    do
        case "$val" in
            -[0-9] | -[0-9][0-9] | -[0-9][0-9][0-9] | \
             [0-9] |  [0-9][0-9] |  [0-9][0-9][0-9] )
                ;;
            * )
                numeric_nice_values=0 ;;
        esac
    done

    if test $numeric_nice_values -eq 1
    then
        nice_value_diff=`expr $nohup_niceness - $normal_niceness`
        if test $? -eq 0 && test $nice_value_diff -gt 0 && \
            nice --$nice_value_diff echo testing > /dev/null 2>&1
        then
            # nohup increases the priority (bad), and we are permitted
459 460 461 462
            # to lower the priority with respect to the value the user
            # might have been given
            niceness=`expr $niceness - $nice_value_diff`
            NOHUP_NICENESS="nice -$niceness nohup"
463 464 465 466 467 468 469 470 471 472
        fi
    fi
else
    if nohup echo testing > /dev/null 2>&1
    then
        :
    else
        # nohup doesn't work on this system
        NOHUP_NICENESS=""
    fi
unknown's avatar
unknown committed
473 474
fi

unknown's avatar
unknown committed
475 476 477 478 479
# Try to set the core file size (even if we aren't root) because many systems
# don't specify a hard limit on core file size.
if test -n "$core_file_size"
then
  ulimit -c $core_file_size
unknown's avatar
unknown committed
480
fi
unknown's avatar
unknown committed
481 482 483 484 485 486 487 488 489 490 491

#
# 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 @CHECK_PID@
  then
    if @FIND_PROC@
    then    # The pid contains a mysqld process
492
      log_error "A mysqld process already exists"
unknown's avatar
unknown committed
493
      exit 1
unknown's avatar
unknown committed
494 495 496 497 498
    fi
  fi
  rm -f $pid_file
  if test -f $pid_file
  then
499 500 501 502
    log_error "Fatal error: Can't remove the pid file:
$pid_file
Please remove it manually and start $0 again;
mysqld daemon not started"
unknown's avatar
unknown committed
503
    exit 1
unknown's avatar
unknown committed
504 505 506 507
  fi
fi

#
508 509 510 511 512 513
# Uncomment the following lines if you want all tables to be automatically
# checked and repaired during startup. You should add sensible key_buffer
# and sort_buffer values to my.cnf to improve check performance or require
# less disk space.
# Alternatively, you can start mysqld with the "myisam-recover" option. See
# the manual for details.
unknown's avatar
unknown committed
514 515
#
# echo "Checking tables in $DATADIR"
516 517
# $MY_BASEDIR_VERSION/bin/myisamchk --silent --force --fast --medium-check $DATADIR/*/*.MYI
# $MY_BASEDIR_VERSION/bin/isamchk --silent --force $DATADIR/*/*.ISM
unknown's avatar
unknown committed
518 519 520 521 522 523 524

# 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

525 526 527 528 529 530 531 532 533 534 535 536
cmd="$NOHUP_NICENESS"

for i in  "$ledir/$MYSQLD" "$defaults" "--basedir=$MY_BASEDIR_VERSION" \
  "--datadir=$DATADIR" "$USER_OPTION"
do
  cmd="$cmd "`shell_quote_string "$i"`
done
cmd="$cmd $args"
# Avoid 'nohup: ignoring input' warning
test -n "$NOHUP_NICENESS" && cmd="$cmd < /dev/null"

log_notice "Starting $MYSQLD daemon with databases from $DATADIR"
unknown's avatar
unknown committed
537 538
while true
do
539
  rm -f $safe_mysql_unix_port $pid_file	# Some extra safety
540

541
  eval_log_error "$cmd"
542

unknown's avatar
unknown committed
543 544
  if test ! -f $pid_file		# This is removed if normal shutdown
  then
unknown's avatar
unknown committed
545
    break
unknown's avatar
unknown committed
546
  fi
unknown's avatar
unknown committed
547

548
  if @TARGET_LINUX@ && test $KILL_MYSQLD -eq 1
unknown's avatar
unknown committed
549 550 551 552 553 554
  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.
555
    numofproces=`ps xaww | grep -v "grep" | grep "$ledir/$MYSQLD\>" | grep -c "pid-file=$pid_file"`
unknown's avatar
unknown committed
556

557
    log_notice "Number of processes running now: $numofproces"
unknown's avatar
unknown committed
558 559 560
    I=1
    while test "$I" -le "$numofproces"
    do 
561
      PROC=`ps xaww | grep "$ledir/$MYSQLD\>" | grep -v "grep" | grep "pid-file=$pid_file" | sed -n '$p'` 
unknown's avatar
unknown committed
562 563 564 565 566 567 568

      for T in $PROC
      do
        break
      done
      #    echo "TEST $I - $T **"
      if kill -9 $T
unknown's avatar
unknown committed
569
      then
570 571
        log_error "$MYSQLD process hanging, pid $T - killed"
      else
unknown's avatar
unknown committed
572
        break
unknown's avatar
unknown committed
573
      fi
unknown's avatar
unknown committed
574
      I=`expr $I + 1`
unknown's avatar
unknown committed
575 576
    done
  fi
577
  log_notice "mysqld restarted"
unknown's avatar
unknown committed
578 579
done

580
log_notice "mysqld from pid file $pid_file ended"
unknown's avatar
unknown committed
581