<h2>Edit File - mariadbd-safe</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/usr/bin/mariadbd-safe">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">#!/bin/sh
# Copyright Abandoned 1996 TCX DataKonsult AB &amp; Monty Program KB &amp; Detron HB
# This file is public domain and comes with NO WARRANTY of any kind
#
# Script 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 is not installed in its compile-time default
# location
#
# mysql.server works by first doing a cd to the base directory and from there
# executing mysqld_safe

# Initialize script globals
KILL_MYSQLD=1;
MYSQLD=
niceness=0
nowatch=0
mysqld_ld_preload=
mysqld_ld_library_path=
flush_caches=0
numa_interleave=0
wsrep_on=0
dry_run=0
defaults_group_suffix=

# Initial logging status: error log is not open, and not using syslog
logging=init
want_syslog=0
syslog_tag=
user=&#039;mysql&#039;
group=&#039;mysql&#039;
pid_file=
err_log=
err_log_base=
skip_err_log=0

syslog_tag_mysqld=mysqld
syslog_tag_mysqld_safe=mysqld_safe

trap &#039;&#039; 1 2 3 15			# we shouldn&#039;t let anyone kill us

# MySQL-specific environment variable. First off, it&#039;s not really a umask,
# it&#039;s the desired mode. Second, it follows umask(2), not umask(3) in that
# octal needs to be explicit. Our shell might be a proper sh without printf,
# multiple-base arithmetic, and binary arithmetic, so this will get ugly.
# We reject decimal values to keep things at least half-sane.
umask 007                               # fallback
UMASK=&quot;${UMASK-0640}&quot;
fmode=`echo &quot;$UMASK&quot; | sed -e &#039;s/[^0246]//g&#039;`
octalp=`echo &quot;$fmode&quot;|cut -c1`
fmlen=`echo &quot;$fmode&quot;|wc -c|sed -e &#039;s/ //g&#039;`
if [ &quot;x$octalp&quot; != &quot;x0&quot; -o &quot;x$UMASK&quot; != &quot;x$fmode&quot; -o &quot;x$fmlen&quot; != &quot;x5&quot; ]
then
  fmode=0640
  echo &quot;UMASK must be a 3-digit mode with an additional leading 0 to indicate octal.&quot; &gt;&amp;2
  echo &quot;The first digit will be corrected to 6, the others may be 0, 2, 4, or 6.&quot; &gt;&amp;2
fi
fmode=`echo &quot;$fmode&quot;|cut -c3-4`
fmode=&quot;6$fmode&quot;
if [ &quot;x$UMASK&quot; != &quot;x0$fmode&quot; ]
then
  echo &quot;UMASK corrected from $UMASK to 0$fmode ...&quot;
fi

defaults=
case &quot;$1&quot; in
    --no-defaults|--defaults-file=*|--defaults-extra-file=*)
      defaults=&quot;$1&quot;; shift
      ;;
esac

usage () {
        cat &lt;&lt;EOF
Usage: $0 [OPTIONS]
  --no-defaults              Don&#039;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
  --defaults-group-suffix=X  Additionally read default groups with X appended
                             as a suffix
  --ledir=DIRECTORY          Look for mysqld in the specified directory
  --open-files-limit=LIMIT   Limit the number of open files
  --crash-script=FILE        Script to call when mysqld crashes
  --core-file-size=LIMIT     Limit core files to the specified size
  --timezone=TZ              Set the system timezone
  --malloc-lib=LIB           Preload shared library LIB if available
  --mysqld=FILE              Use the specified file as mysqld
  --mysqld-version=VERSION   Use &quot;mysqld-VERSION&quot; as mysqld
  --dry-run                  Simulate the start to detect errors but don&#039;t start
  --nice=NICE                Set the scheduling priority of mysqld
  --no-auto-restart          Exit after starting mysqld
  --nowatch                  Exit after starting mysqld
  --plugin-dir=DIR           Plugins are under DIR or DIR/VERSION, if
                             VERSION is given
  --skip-kill-mysqld         Don&#039;t try to kill stray mysqld processes
  --syslog                   Log messages to syslog with &#039;logger&#039;
  --skip-syslog              Log messages to error log (default)
  --syslog-tag=TAG           Pass -t &quot;mysqld-TAG&quot; to &#039;logger&#039;
  --flush-caches             Flush and purge buffers/caches before
                             starting the server
  --numa-interleave          Run mysqld with its memory interleaved
                             on all NUMA nodes

All other options are passed to the mysqld program.

EOF
        exit 1
}

find_in_bin() {
  if test -x &quot;$MY_BASEDIR_VERSION/bin/$1&quot;
  then
    echo &quot;$MY_BASEDIR_VERSION/bin/$1&quot;
  elif test -x &quot;/usr/bin/$1&quot;
  then
    echo &quot;/usr/bin/$1&quot;
  else
    echo &quot;$1&quot;
  fi
}

log_generic () {
  [ $dry_run -eq 1 ] &amp;&amp; return
  priority=&quot;$1&quot;
  shift

  msg=&quot;`date +&#039;%y%m%d %H:%M:%S&#039;` mysqld_safe $*&quot;
  echo &quot;$msg&quot;
  case $logging in
    init) ;;  # Just echo the message, don&#039;t save it anywhere
    file)
      if [ &quot;$helper_exist&quot; -eq &quot;0&quot; ]; then
        echo &quot;$msg&quot; | &quot;$helper&quot; &quot;$user&quot; log &quot;$err_log&quot;
      fi
    ;;
    syslog) logger -t &quot;$syslog_tag_mysqld_safe&quot; -p &quot;$priority&quot; &quot;$*&quot; ;;
    *)
      echo &quot;Internal program error (non-fatal):&quot; \
           &quot; unknown logging method &#039;$logging&#039;&quot; &gt;&amp;2
      ;;
  esac
}

log_error () {
  log_generic daemon.error &quot;$@&quot; &gt;&amp;2
}

log_notice () {
  log_generic daemon.notice &quot;$@&quot;
}

eval_log_error () {
  local cmd=&quot;$1&quot;
  case $logging in
    file)
     if [ &quot;$helper_exist&quot; -eq &quot;0&quot; ]; then
        cmd=&quot;$cmd 2&gt;&amp;1 | &quot;`shell_quote_string &quot;$helper&quot;`&quot; $user log &quot;`shell_quote_string &quot;$err_log&quot;`
     fi
     ;;
    syslog)
      # mysqld often prefixes its messages with a timestamp, which is
      # redundant when logging to syslog (which adds its own timestamp)
      # However, we don&#039;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=&quot;$cmd 2&gt;&amp;1 | logger -t &#039;$syslog_tag_mysqld&#039; -p daemon.error&quot;
      ;;
    *)
      echo &quot;Internal program error (non-fatal):&quot; \
           &quot; unknown logging method &#039;$logging&#039;&quot; &gt;&amp;2
      ;;
  esac

  if test $nowatch -eq 1
  then
    # We&#039;d prefer to exec $cmd here, but SELinux needs to be fixed first
    #/usr/bin/logger &quot;Running mysqld: $cmd&quot;
    eval &quot;$cmd &amp;&quot;
    exit 0
  else
    #echo &quot;Running mysqld: [$cmd]&quot;
    eval &quot;$cmd&quot;
  fi
}

shell_quote_string() {
  # This sed command makes sure that any special chars are quoted,
  # so the arg gets passed exactly to the server.
  echo &quot;$1&quot; | sed -e &#039;s,\([^a-zA-Z0-9/_.=-]\),\\\1,g&#039;
}

wsrep_pick_url() {
  [ $# -eq 0 ] &amp;&amp; return 0

  log_error &quot;WSREP: &#039;wsrep_urls&#039; is DEPRECATED! Use wsrep_cluster_address to specify multiple addresses instead.&quot;

  if ! command -v nc &gt;/dev/null
  then
    log_error &quot;ERROR: nc tool not found in PATH! Make sure you have it installed.&quot;
    return 1
  fi

  local url
  # Assuming URL in the form scheme://host:port
  # If host and port are not NULL, the liveness of URL is assumed to be tested
  # If port part is absent, the url is returned literally and unconditionally
  # If every URL has port but none is reachable, nothing is returned
  for url in `echo $@ | sed s/,/\ /g` 0; do
    local host=`echo $url | cut -d \: -f 2 | sed s/^\\\/\\\///`
    local port=`echo $url | cut -d \: -f 3`
    [ -z &quot;$port&quot; ] &amp;&amp; break
    nc -z &quot;$host&quot; $port &gt;/dev/null &amp;&amp; break
  done

  if [ &quot;$url&quot; == &quot;0&quot; ]; then
    log_error &quot;ERROR: none of the URLs in &#039;$@&#039; is reachable.&quot;
    return 1
  fi

  echo $url
}

# Run mysqld with --wsrep-recover and parse recovered position from log.
# Position will be stored in wsrep_start_position_opt global.
wsrep_start_position_opt=&quot;&quot;
wsrep_recover_position() {
  local mysqld_cmd=&quot;$@&quot;
  local euid=$(id -u)
  local ret=0

  local wr_logfile=$(mktemp /tmp/wsrep_recovery.XXXXXX)

  # safety checks
  if [ -z $wr_logfile ]; then
    log_error &quot;WSREP: mktemp failed&quot;
    return 1
  fi

  if [ -f $wr_logfile ]; then
    # NOTE! Do not change ownership of the temporary file, as on newer kernel
    # versions fs.protected_regular is set to &#039;2&#039; and redirecting output with &gt;
    # as root to a file not owned by root will fail with &quot;Permission denied&quot;
    chmod 600 $wr_logfile
  else
    log_error &quot;WSREP: mktemp failed&quot;
    return 1
  fi

  local wr_pidfile=&quot;$DATADIR/&quot;`uname -n`&quot;-recover.pid&quot;

  local wr_options=&quot;--disable-log-error  --pid-file=&#039;$wr_pidfile&#039;&quot;

  log_notice &quot;WSREP: Running position recovery with $wr_options&quot;

  eval &quot;$mysqld_cmd --wsrep_recover $wr_options 2&gt; $wr_logfile&quot;

  if [ ! -s &quot;$wr_logfile&quot; ]; then
    log_error &quot;Log file $wr_logfile was empty, cannot proceed. Is system running fs.protected_regular?&quot;
    exit 1
  fi

  local rp=&quot;$(grep -a &#039;WSREP: Recovered position:&#039; $wr_logfile)&quot;
  if [ -z &quot;$rp&quot; ]; then
    local skipped=&quot;$(grep -a WSREP $wr_logfile | grep &#039;skipping position recovery&#039;)&quot;
    if [ -z &quot;$skipped&quot; ]; then
      log_error &quot;WSREP: Failed to recover position: &#039;`cat $wr_logfile`&#039;&quot;
      ret=1
    else
      log_notice &quot;WSREP: Position recovery skipped&quot;
    fi
  else
    local start_pos=&quot;$(echo $rp | sed &#039;s/.*WSREP\:\ Recovered\ position://&#039; \
        | sed &#039;s/^[ \t]*//&#039;)&quot;
    log_notice &quot;WSREP: Recovered position $start_pos&quot;
    wsrep_start_position_opt=&quot;--wsrep_start_position=$start_pos&quot;
  fi

  if [ $ret -eq 0 ] ; then
    local wr_logfile_permanent=&quot;$DATADIR/wsrep_recovery.ok&quot;
  else
    local wr_logfile_permanent=&quot;$DATADIR/wsrep_recovery.fail&quot;
  fi
  touch $wr_logfile_permanent
  [ &quot;$euid&quot; = &quot;0&quot; ] &amp;&amp; chown $user $wr_logfile_permanent
  chmod 600 $wr_logfile_permanent
  cat &quot;$wr_logfile&quot; &gt;&gt; $wr_logfile_permanent
  rm -f &quot;$wr_logfile&quot;

  return $ret
}

parse_arguments() {
  for arg do
    val=`echo &quot;$arg&quot; | sed -e &quot;s;--[^=]*=;;&quot;`
    case &quot;$arg&quot; in
      # these get passed explicitly to mysqld
      --basedir=*) MY_BASEDIR_VERSION=&quot;$val&quot; ;;
      --datadir=*|--data=*) DATADIR=&quot;$val&quot; ;;
      --pid[-_]file=*) pid_file=&quot;$val&quot; ;;
      --plugin[-_]dir=*) PLUGIN_DIR=&quot;$val&quot; ;;
      --user=*) user=&quot;$val&quot;; SET_USER=1 ;;
      --group=*) group=&quot;$val&quot;; SET_USER=1 ;;
      --log[-_]basename=*|--hostname=*|--loose[-_]log[-_]basename=*)
        pid_file=&quot;$val.pid&quot;;
	err_log_base=&quot;$val&quot;;
	;;

      # these might have been set in a [mysqld_safe] section of my.cnf
      # they are added to mysqld command line to override settings from my.cnf
      --skip[-_]log[-_]error)
        err_log=;
        skip_err_log=1;
        ;;
      --log[-_]error=*)
        err_log=&quot;$val&quot;;
        skip_err_log=0;
        ;;
      --port=*) mysql_tcp_port=&quot;$val&quot; ;;
      --socket=*) mysql_unix_port=&quot;$val&quot; ;;

      # mysqld_safe-specific options - must be set in my.cnf ([mysqld_safe])!
      --core[-_]file[-_]size=*) core_file_size=&quot;$val&quot; ;;
      --ledir=*) ledir=&quot;$val&quot; ;;
      --malloc[-_]lib=*) set_malloc_lib &quot;$val&quot; ;;
      --crash[-_]script=*) crash_script=&quot;$val&quot; ;;
      --mysqld=*) MYSQLD=&quot;$val&quot; ;;
      --mysqld[-_]version=*)
        if test -n &quot;$val&quot;
        then
          MYSQLD=&quot;mysqld-$val&quot;
          PLUGIN_VARIANT=&quot;/$val&quot;
        else
          MYSQLD=&quot;mysqld&quot;
        fi
        ;;
      --dry[-_]run) dry_run=1 ;;
      --nice=*) niceness=&quot;$val&quot; ;;
      --nowatch|--no[-_]watch|--no[-_]auto[-_]restart) nowatch=1 ;;
      --open[-_]files[-_]limit=*) open_files=&quot;$val&quot; ;;
      --skip[-_]kill[-_]mysqld*) KILL_MYSQLD=0 ;;
      --syslog) want_syslog=1 ;;
      --skip[-_]syslog) want_syslog=0 ;;
      --syslog[-_]tag=*) syslog_tag=&quot;$val&quot; ;;
      --timezone=*) TZ=&quot;$val&quot;; export TZ; ;;
      --flush[-_]caches) flush_caches=1 ;;
      --numa[-_]interleave) numa_interleave=1 ;;
      --wsrep[-_]on)
        wsrep_on=1
        append_arg_to_args &quot;$arg&quot;
        ;;
      --skip[-_]wsrep[-_]on)
        wsrep_on=0
        append_arg_to_args &quot;$arg&quot;
        ;;
      --wsrep[-_]on=*)
        if echo $val | grep -iq &#039;\(ON\|1\)&#039;; then
          wsrep_on=1
        else
          wsrep_on=0
        fi
        append_arg_to_args &quot;$arg&quot;
        ;;
      --wsrep[-_]urls=*) wsrep_urls=&quot;$val&quot;; ;;
      --wsrep[-_]provider=*)
        if test -n &quot;$val&quot; &amp;&amp; test &quot;$val&quot; != &quot;none&quot;
        then
          wsrep_restart=1
        fi
        append_arg_to_args &quot;$arg&quot;
        ;;

      --defaults-group-suffix=*) defaults_group_suffix=&quot;$arg&quot; ;;

      --help) usage ;;

      *)
        case &quot;$unrecognized_handling&quot; in
          collect) append_arg_to_args &quot;$arg&quot; ;;
          complain) log_error &quot;unknown option &#039;$arg&#039;&quot; ;;
        esac
    esac
  done
}


# Add a single shared library to the list of libraries which will be added to
# LD_PRELOAD for mysqld
#
# Since LD_PRELOAD is a space-separated value (for historical reasons), if a
# shared lib&#039;s path contains spaces, that path will be prepended to
# LD_LIBRARY_PATH and stripped from the lib value.
add_mysqld_ld_preload() {
  lib_to_add=&quot;$1&quot;
  log_notice &quot;Adding &#039;$lib_to_add&#039; to LD_PRELOAD for mysqld&quot;

  case &quot;$lib_to_add&quot; in
    *&#039; &#039;*)
      # Must strip path from lib, and add it to LD_LIBRARY_PATH
      lib_file=`basename &quot;$lib_to_add&quot;`
      case &quot;$lib_file&quot; in
        *&#039; &#039;*)
          # The lib file itself has a space in its name, and can&#039;t
          # be used in LD_PRELOAD
          log_error &quot;library name &#039;$lib_to_add&#039; contains spaces and can not be used with LD_PRELOAD&quot;
          exit 1
          ;;
      esac
      lib_path=`dirname &quot;$lib_to_add&quot;`
      lib_to_add=&quot;$lib_file&quot;
      [ -n &quot;$mysqld_ld_library_path&quot; ] &amp;&amp; mysqld_ld_library_path=&quot;$mysqld_ld_library_path:&quot;
      mysqld_ld_library_path=&quot;$mysqld_ld_library_path$lib_path&quot;
      ;;
  esac

  # LD_PRELOAD is a space-separated
  [ -n &quot;$mysqld_ld_preload&quot; ] &amp;&amp; mysqld_ld_preload=&quot;$mysqld_ld_preload &quot;
  mysqld_ld_preload=&quot;${mysqld_ld_preload}$lib_to_add&quot;
}


# Returns LD_PRELOAD (and LD_LIBRARY_PATH, if needed) text, quoted to be
# suitable for use in the eval that calls mysqld.
#
# All values in mysqld_ld_preload are prepended to LD_PRELOAD.
mysqld_ld_preload_text() {
  text=

  if [ -n &quot;$mysqld_ld_preload&quot; ]; then
    new_text=&quot;$mysqld_ld_preload&quot;
    [ -n &quot;$LD_PRELOAD&quot; ] &amp;&amp; new_text=&quot;$new_text $LD_PRELOAD&quot;
    text=&quot;${text}LD_PRELOAD=&quot;`shell_quote_string &quot;$new_text&quot;`&#039; &#039;
  fi

  if [ -n &quot;$mysqld_ld_library_path&quot; ]; then
    new_text=&quot;$mysqld_ld_library_path&quot;
    [ -n &quot;$LD_LIBRARY_PATH&quot; ] &amp;&amp; new_text=&quot;$new_text:$LD_LIBRARY_PATH&quot;
    text=&quot;${text}LD_LIBRARY_PATH=&quot;`shell_quote_string &quot;$new_text&quot;`&#039; &#039;
  fi

  echo &quot;$text&quot;
}

# set_malloc_lib LIB
# - If LIB is empty, do nothing and return
# - If LIB starts with &#039;tcmalloc&#039; or &#039;jemalloc&#039;, look for the shared library
#   using `ldconfig`.
#   tcmalloc is part of the Google perftools project.
# - If LIB is an absolute path, assume it is a malloc shared library
#
# Put LIB in mysqld_ld_preload, which will be added to LD_PRELOAD when
# running mysqld.  See ld.so for details.
set_malloc_lib() {
  malloc_lib=&quot;$1&quot;
  if expr &quot;$malloc_lib&quot; : &quot;\(tcmalloc\|jemalloc\)&quot; &gt; /dev/null ; then
    export PATH=$PATH:/sbin
    if ! command -v ldconfig &gt; /dev/null 2&gt;&amp;1
    then
      log_error &quot;ldconfig command not found, required for ldconfig -p&quot;
      exit 1
    fi
    # format from ldconfig:
    # &quot;libjemalloc.so.1 (libc6,x86-64) =&gt; /usr/lib/x86_64-linux-gnu/libjemalloc.so.1&quot;
    libmalloc_path=&quot;$(ldconfig -p | sed -n &quot;/lib${malloc_lib}/p&quot; | cut -d &#039;&gt;&#039; -f2)&quot;

    if [ -z &quot;$libmalloc_path&quot; ]; then
      log_error &quot;no shared library for lib$malloc_lib.so.[0-9] found.&quot;
      exit 1
    fi

    for f in $libmalloc_path; do
      if [ -f &quot;$f&quot; ]; then
        malloc_lib=$f # get the first path if many
        break
      fi
    done
  fi
  # Allow --malloc-lib=&#039;&#039; to override other settings
  [ -z  &quot;$malloc_lib&quot; ] &amp;&amp; return

  case &quot;$malloc_lib&quot; in
    /*)
      if [ ! -r &quot;$malloc_lib&quot; ]; then
        log_error &quot;--malloc-lib &#039;$malloc_lib&#039; can not be read and will not be used&quot;
        exit 1
      fi
      ;;
    *)
      log_error &quot;--malloc-lib must be an absolute path, &#039;tcmalloc&#039; or &quot; \
      &quot;&#039;jemalloc&#039;; ignoring value &#039;$malloc_lib&#039;&quot;
      exit 1
      ;;
  esac
  add_mysqld_ld_preload &quot;$malloc_lib&quot;
}


#
# First, try to find BASEDIR and ledir (where mysqld is)
#

MY_PWD=`dirname $0`
MY_PWD=`cd &quot;$MY_PWD&quot;/.. &amp;&amp; pwd`
# Check for the directories we would expect from a binary release install
if test -n &quot;$MY_BASEDIR_VERSION&quot; -a -d &quot;$MY_BASEDIR_VERSION&quot;
then
  # BASEDIR is already overridden on command line.  Do not re-set.

  # Use BASEDIR to discover le.
  if test -x &quot;$MY_BASEDIR_VERSION/libexec/mariadbd&quot;
  then
    ledir=&quot;$MY_BASEDIR_VERSION/libexec&quot;
  elif test -x &quot;$MY_BASEDIR_VERSION/sbin/mariadbd&quot;
  then
    ledir=&quot;$MY_BASEDIR_VERSION/sbin&quot;
  else
    ledir=&quot;$MY_BASEDIR_VERSION/bin&quot;
  fi
elif test -x &quot;$MY_PWD/bin/mariadbd&quot;
then
  MY_BASEDIR_VERSION=&quot;$MY_PWD&quot;		# Where bin, share and data are
  ledir=&quot;$MY_PWD/bin&quot;			# Where mysqld is
# Check for the directories we would expect from a source install
elif test -x &quot;$MY_PWD/libexec/mariadbd&quot;
then
  MY_BASEDIR_VERSION=&quot;$MY_PWD&quot;		# Where libexec, share and var are
  ledir=&quot;$MY_PWD/libexec&quot;		# Where mysqld is
elif test -x &quot;$MY_PWD/sbin/mariadbd&quot;
then
  MY_BASEDIR_VERSION=&quot;$MY_PWD&quot;		# Where sbin, share and var are
  ledir=&quot;$MY_PWD/sbin&quot;			# Where mysqld is
# Since we didn&#039;t find anything, used the compiled-in defaults
else
  MY_BASEDIR_VERSION=&#039;/usr&#039;
  ledir=&#039;/usr/sbin&#039;
fi

helper=`find_in_bin mariadbd-safe-helper`

print_defaults=`find_in_bin my_print_defaults`
# Check if helper exists
command -v $helper --help &gt;/dev/null 2&gt;&amp;1
helper_exist=$?
#
# Second, try to find the data directory
#

# Try where the binary installs put it
if test -d $MY_BASEDIR_VERSION/data/mysql
then
  DATADIR=$MY_BASEDIR_VERSION/data
# Next try where the source installs put it
elif test -d $MY_BASEDIR_VERSION/var/mysql
then
  DATADIR=$MY_BASEDIR_VERSION/var
# Or just give up and use our compiled-in default
else
  DATADIR=/var/lib/mysql
fi

if test -z &quot;$MYSQL_HOME&quot;
then
  if test -r &quot;$DATADIR/my.cnf&quot;
  then
    log_error &quot;WARNING: Found $DATADIR/my.cnf
The data directory is not a valid location for my.cnf, please move it to
$MY_BASEDIR_VERSION/my.cnf&quot;
  fi
  MYSQL_HOME=$MY_BASEDIR_VERSION
fi
export MYSQL_HOME

append_arg_to_args () {
  args=&quot;$args &quot;`shell_quote_string &quot;$1&quot;`
}

args=

# Get first arguments from the my.cnf file, groups [mysqld] and [server]
# (and related) and then merge with the command line arguments

SET_USER=2
parse_arguments `$print_defaults $defaults --loose-verbose --mysqld`
if test $SET_USER -eq 2
then
  SET_USER=0
fi

# If arguments come from [mysqld_safe] section of my.cnf
# we complain about unrecognized options
unrecognized_handling=complain
parse_arguments `$print_defaults $defaults --loose-verbose mysqld_safe safe_mysqld mariadb_safe mariadbd-safe`

# We only need to pass arguments through to the server if we don&#039;t
# handle them here.  So, we collect unrecognized options (passed on
# the command line) into the args variable.
unrecognized_handling=collect
parse_arguments &quot;$@&quot;


#
# Try to find the plugin directory
#

# Use user-supplied argument
if [ -n &quot;${PLUGIN_DIR}&quot; ]; then
  plugin_dir=&quot;${PLUGIN_DIR}&quot;
else
  # Try to find plugin dir relative to basedir
  for dir in lib64/mysql/plugin lib64/plugin lib/mysql/plugin lib/plugin
  do
    if [ -d &quot;${MY_BASEDIR_VERSION}/${dir}&quot; ]; then
      plugin_dir=&quot;${MY_BASEDIR_VERSION}/${dir}&quot;
      break
    fi
  done
  # Give up and use compiled-in default
  if [ -z &quot;${plugin_dir}&quot; ]; then
    plugin_dir=&#039;/usr/lib64/mysql/plugin&#039;
  fi
fi
plugin_dir=&quot;${plugin_dir}${PLUGIN_VARIANT}&quot;

# Determine what logging facility to use

# Ensure that &#039;logger&#039; exists, if it&#039;s requested
if [ $want_syslog -eq 1 ]
then
  if ! command -v logger &gt; /dev/null
  then
    log_error &quot;--syslog requested, but no &#039;logger&#039; program found.  Please ensure that &#039;logger&#039; is in your PATH, or do not specify the --syslog option to mysqld_safe.&quot;
    exit 1
  fi
fi

if [ $skip_err_log -eq 1 ]
then
  append_arg_to_args &quot;--skip-log-error&quot;
fi

if [ -n &quot;$err_log&quot; -o $want_syslog -eq 0 ]
then
  if [ -n &quot;$err_log&quot; ]
  then
    # mysqld adds &quot;.err&quot; if there is no extension on the --log-error
    # argument; must match that here, or mysqld_safe will write to a
    # different log file than mysqld

    # mysqld does not add &quot;.err&quot; to &quot;--log-error=foo.&quot;; it considers a
    # trailing &quot;.&quot; as an extension

    if expr &quot;$err_log&quot; : &#039;.*\.[^/]*$&#039; &gt; /dev/null
    then
        :
    else
      err_log=&quot;$err_log&quot;.err
    fi

    case &quot;$err_log&quot; in
      /* ) ;;
      * ) err_log=&quot;$DATADIR/$err_log&quot; ;;
    esac
  else
    if [ -n &quot;$err_log_base&quot; ]
    then
      err_log=$err_log_base.err
      case &quot;$err_log&quot; in
        /* ) ;;
        * ) err_log=&quot;$DATADIR/$err_log&quot; ;;
      esac
    else
      err_log=$DATADIR/`uname -n`.err
    fi
  fi

  append_arg_to_args &quot;--log-error=$err_log&quot;

  if [ $want_syslog -eq 1 ]
  then
    # User explicitly asked for syslog, so warn that it isn&#039;t used
    log_error &quot;Can&#039;t log to error log and syslog at the same time.  Remove all --log-error configuration options for --syslog to take effect.&quot;
    want_syslog=0
  fi

  # Log to err_log file
  log_notice &quot;Logging to &#039;$err_log&#039;.&quot;
  logging=file

else
  if [ -n &quot;$syslog_tag&quot; ]
  then
    # Sanitize the syslog tag
    syslog_tag=`echo &quot;$syslog_tag&quot; | sed -e &#039;s/[^a-zA-Z0-9_-]/_/g&#039;`
    syslog_tag_mysqld_safe=&quot;${syslog_tag_mysqld_safe}-$syslog_tag&quot;
    syslog_tag_mysqld=&quot;${syslog_tag_mysqld}-$syslog_tag&quot;
  fi
  log_notice &quot;Logging to syslog.&quot;
  logging=syslog
fi

USER_OPTION=&quot;&quot;
if test -w / -o &quot;$USER&quot; = &quot;root&quot;
then
  if test &quot;$user&quot; != &quot;root&quot; -o $SET_USER = 1
  then
    USER_OPTION=&quot;--user=$user&quot;
    # To be used if/when we enable --system-group as an option to mysqld
    GROUP_OPTION=&quot;--group=$group&quot;
  fi
  if test -n &quot;$open_files&quot;
  then
    ulimit -n $open_files
  fi
fi

if test -n &quot;$open_files&quot;
then
  append_arg_to_args &quot;--open-files-limit=$open_files&quot;
fi

safe_mysql_unix_port=${mysql_unix_port:-${MYSQL_UNIX_PORT:-/var/lib/mysql/mysql.sock}}
# 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 -a $dry_run -eq 0 ]
then
  if ! mkdir -p $mysql_unix_port_dir
  then
    log_error &quot;Fatal error Can&#039;t create database directory &#039;$mysql_unix_port&#039;&quot;
    exit 1
  fi
  if [ &quot;$user&quot; -a &quot;$group&quot; ]; then
    chown $user:$group $mysql_unix_port_dir
  else
    [ &quot;$user&quot; ] &amp;&amp; chown $user $mysql_unix_port_dir
    [ &quot;$group&quot; ] &amp;&amp; chgrp $group $mysql_unix_port_dir
  fi
  chmod 755 $mysql_unix_port_dir
fi

# If the user doesn&#039;t specify a binary, we assume name &quot;mariadbd&quot;
if test -z &quot;$MYSQLD&quot;
then
  MYSQLD=mariadbd
fi

if test ! -x &quot;$ledir/$MYSQLD&quot;
then
  log_error &quot;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&amp;
See https://mariadb.com/kb/en/mysqld_safe for more information&quot;
  exit 1
fi

if test -z &quot;$pid_file&quot;
then
  pid_file=&quot;`uname -n`.pid&quot;
fi
# MariaDB wants pid file without datadir
append_arg_to_args &quot;--pid-file=$pid_file&quot;
case &quot;$pid_file&quot; in
  /* ) ;;
  * )  pid_file=&quot;$DATADIR/$pid_file&quot; ;;
esac

if test -n &quot;$mysql_unix_port&quot;
then
  append_arg_to_args &quot;--socket=$mysql_unix_port&quot;
fi
if test -n &quot;$mysql_tcp_port&quot;
then
  append_arg_to_args &quot;--port=$mysql_tcp_port&quot;
fi

if test $niceness -eq 0
then
  NOHUP_NICENESS=&quot;nohup&quot;
else
  NOHUP_NICENESS=&quot;nohup nice -$niceness&quot;
fi

# 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 &quot;nohup sh -c &#039;ps -o nice -p $$&#039; | tail -1&quot;).
# But, it also seems that GNU nohup is the only one which messes
# with the priority, so this is okay.
if nohup nice &gt; /dev/null 2&gt;&amp;1
then
    normal_niceness=`nice`
    nohup_niceness=`nohup nice 2&gt;/dev/null`

    numeric_nice_values=1
    for val in $normal_niceness $nohup_niceness
    do
        case &quot;$val&quot; 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 &amp;&amp; test $nice_value_diff -gt 0 &amp;&amp; \
            nice --$nice_value_diff echo testing &gt; /dev/null 2&gt;&amp;1
        then
            # nohup increases the priority (bad), and we are permitted
            # to lower the priority with respect to the value the user
            # might have been given
            niceness=`expr $niceness - $nice_value_diff`
            NOHUP_NICENESS=&quot;nice -$niceness nohup&quot;
        fi
    fi
else
    if nohup echo testing &gt; /dev/null 2&gt;&amp;1
    then
        :
    else
        # nohup doesn&#039;t work on this system
        NOHUP_NICENESS=&quot;&quot;
    fi
fi

# Try to set the core file size (even if we aren&#039;t root) because many systems
# don&#039;t specify a hard limit on core file size.
if test -n &quot;$core_file_size&quot;
then
  ulimit -c $core_file_size
fi

#
# If there exists an old pid file, check if the daemon is already running
# Note: The switches to &#039;ps&#039; may depend on your operating system
if test -f &quot;$pid_file&quot; &amp;&amp; [ $dry_run -eq 0 ]
then
  PID=`cat &quot;$pid_file&quot;`
  if kill -0 $PID &gt; /dev/null 2&gt; /dev/null
  then
    if ps wwwp $PID | grep -v mariadbd-safe | grep -v mysqld_safe | grep -- $MYSQLD &gt; /dev/null
    then    # The pid contains a mysqld process
      log_error &quot;A mysqld process already exists&quot;
      exit 1
    fi
  fi
  rm -f &quot;$pid_file&quot;
  if test -f &quot;$pid_file&quot;
  then
    log_error &quot;Fatal error: Can&#039;t remove the pid file:
$pid_file
Please remove it manually and start $0 again;
mysqld daemon not started&quot;
    exit 1
  fi
fi

#
# Flush and purge buffers/caches.
#

if true &amp;&amp; test $flush_caches -eq 1
then
  # Locate sync, ensure it exists.
  if ! command -v sync &gt; /dev/null
  then
    log_error &quot;sync command not found, required for --flush-caches&quot;
    exit 1
  # Flush file system buffers.
  elif ! sync
  then
    # Huh, the sync() function is always successful...
    log_error &quot;sync failed, check if sync is properly installed&quot;
  fi

  # Locate sysctl, ensure it exists.
  if ! command -v sysctl &gt; /dev/null
  then
    log_error &quot;sysctl command not found, required for --flush-caches&quot;
    exit 1
  # Purge page cache, dentries and inodes.
  elif ! sysctl -q -w vm.drop_caches=3
  then
    log_error &quot;sysctl failed, check the error message for details&quot;
    exit 1
  fi
elif test $flush_caches -eq 1
then
  log_error &quot;--flush-caches is not supported on this platform&quot;
  exit 1
fi

#
# 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 &quot;myisam-recover&quot; option. See
# the manual for details.
#
# echo &quot;Checking tables in $DATADIR&quot;
# $MY_BASEDIR_VERSION/bin/myisamchk --silent --force --fast --medium-check $DATADIR/*/*.MYI
# $MY_BASEDIR_VERSION/bin/isamchk --silent --force $DATADIR/*/*.ISM

# Does this work on all systems?
#if type ulimit | grep &quot;shell builtin&quot; &gt; /dev/null
#then
#  ulimit -n 256 &gt; /dev/null 2&gt;&amp;1		# Fix for BSD and FreeBSD systems
#fi

cmd=&quot;`mysqld_ld_preload_text`$NOHUP_NICENESS&quot;
[ $dry_run -eq 1 ] &amp;&amp; cmd=&#039;&#039;

#
# Set mysqld&#039;s memory interleave policy.
#

if true &amp;&amp; test $numa_interleave -eq 1
then
  # Locate numactl, ensure it exists.
  if ! command -v numactl &gt; /dev/null
  then
    log_error &quot;numactl command not found, required for --numa-interleave&quot;
    exit 1
  # Attempt to run a command, ensure it works.
  elif ! numactl --interleave=all true
  then
    log_error &quot;numactl failed, check if numactl is properly installed&quot;
  fi

  # Launch mysqld with numactl.
  [ $dry_run -eq 0 ] &amp;&amp; cmd=&quot;$cmd numactl --interleave=all&quot;
elif test $numa_interleave -eq 1
then
  log_error &quot;--numa-interleave is not supported on this platform&quot;
  exit 1
fi

for i in  &quot;$ledir/$MYSQLD&quot; &quot;$defaults_group_suffix&quot; &quot;$defaults&quot; &quot;--basedir=$MY_BASEDIR_VERSION&quot; \
  &quot;--datadir=$DATADIR&quot; &quot;--plugin-dir=$plugin_dir&quot; &quot;$USER_OPTION&quot;
do
  cmd=&quot;$cmd &quot;`shell_quote_string &quot;$i&quot;`
done
cmd=&quot;$cmd $args&quot;

if [ $dry_run -eq 1 ]
then
  # RETURN or EXIT depending if the script is being sourced or not.
  (return 2&gt; /dev/null) &amp;&amp; return || exit
fi


# Avoid &#039;nohup: ignoring input&#039; warning
test -n &quot;$NOHUP_NICENESS&quot; &amp;&amp; cmd=&quot;$cmd &lt; /dev/null&quot;
log_notice &quot;Starting $MYSQLD daemon with databases from $DATADIR&quot;

# variable to track the current number of &quot;fast&quot; (a.k.a. subsecond) restarts
fast_restart=0
# maximum number of restarts before trottling kicks in
max_fast_restarts=5
# flag whether a usable sleep command exists
have_sleep=1

# close stdout and stderr, everything goes to $logging now
if expr &quot;${-}&quot; : &#039;.*x&#039; &gt; /dev/null
then
  :
else
  exec 1&gt;/dev/null
  exec 2&gt;/dev/null
fi

# maximum number of wsrep restarts
max_wsrep_restarts=0

while true
do
  rm -f &quot;$pid_file&quot;	# Some extra safety

  start_time=`date +%M%S`

  # Perform wsrep position recovery if wsrep_on=1, skip otherwise.
  if test $wsrep_on -eq 1
  then
    # this sets wsrep_start_position_opt
    wsrep_recover_position &quot;$cmd&quot;

    [ $? -ne 0 ] &amp;&amp; exit 1 #

    [ -n &quot;$wsrep_urls&quot; ] &amp;&amp; url=`wsrep_pick_url $wsrep_urls` # check connect address

    if [ -z &quot;$url&quot; ]
    then
      eval_log_error &quot;$cmd $wsrep_start_position_opt&quot;
    else
      eval_log_error &quot;$cmd $wsrep_start_position_opt --wsrep_cluster_address=$url&quot;
    fi
  else
    eval_log_error &quot;$cmd&quot;
  fi
  end_time=`date +%M%S`

  if test ! -f &quot;$pid_file&quot;		# This is removed if normal shutdown
  then
    break
  fi


  # sanity check if time reading is sane and there&#039;s sleep
  if test $end_time -gt 0 -a $have_sleep -gt 0
  then
    # throttle down the fast restarts
    if test $end_time -eq $start_time
    then
      fast_restart=`expr $fast_restart + 1`
      if test $fast_restart -ge $max_fast_restarts
      then
        log_notice &quot;The server is respawning too fast. Sleeping for 1 second.&quot;
        sleep 1
        sleep_state=$?
        if test $sleep_state -gt 0
        then
          log_notice &quot;The server is respawning too fast and no working sleep command. Turning off trottling.&quot;
          have_sleep=0
        fi

        fast_restart=0
      fi
    else
      fast_restart=0
    fi
  fi

  if true &amp;&amp; test $KILL_MYSQLD -eq 1
  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 =&gt; redhat 5 gives warnings when using ps -x.
    # kill -9 is used or the process won&#039;t react on the kill.
    numofproces=`ps xaww | grep -v &quot;grep&quot; | grep &quot;$ledir/$MYSQLD\&gt;&quot; | grep -c &quot;pid-file=$pid_file&quot;`

    log_notice &quot;Number of processes running now: $numofproces&quot;
    I=1
    while test &quot;$I&quot; -le &quot;$numofproces&quot;
    do
      PROC=`ps xaww | grep &quot;$ledir/$MYSQLD\&gt;&quot; | grep -v &quot;grep&quot; | grep &quot;pid-file=$pid_file&quot; | sed -n &#039;$p&#039;`

      for T in $PROC
      do
        break
      done
      #    echo &quot;TEST $I - $T **&quot;
      if kill -9 $T
      then
        log_error &quot;$MYSQLD process hanging, pid $T - killed&quot;
      else
        break
      fi
      I=`expr $I + 1`
    done
  fi

  if [ -n &quot;$wsrep_restart&quot; ]
  then
    if [ $wsrep_restart -le $max_wsrep_restarts ]
    then
      wsrep_restart=`expr $wsrep_restart + 1`
      log_notice &quot;WSREP: sleeping 15 seconds before restart&quot;
      sleep 15
    else
      log_notice &quot;WSREP: not restarting wsrep node automatically&quot;
      break
    fi
  fi

  log_notice &quot;mysqld restarted&quot;
  if test -n &quot;$crash_script&quot;
  then
    crash_script_output=`$crash_script 2&gt;&amp;1`
    log_error &quot;$crash_script_output&quot;
  fi
done

log_notice &quot;mysqld from pid file $pid_file ended&quot;
</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/blog/images/1781637752_1754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>