深度解析MySQL启动时报“The server quit without updating PID file”错误的原因

深度解析深度解析MySQL启动时报启动时报“The server quit without updating

PID file”错误的原因错误的原因

主要介绍了MySQL启动时报“The server quit without updating PID file”错误的原因,需要的朋友可以参考下

很多童鞋在启动mysql的时候，碰到过这个错误，

首先，澄清一点，出现这个错误的前提是：通过服务脚本来启动mysql。通过mysqld_safe或mysqld启动mysql实例并不会报

这个错误。

那么，出现这个错误的原因具体是什么呢？

哈哈，对分析过程不care的童鞋可直接跳到文末的总结部分~

# MySQL daemon start/stop script.

# Usually this is put in /etc/init.d (at least on machines SYSV R4 based

# systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql.

# When this is done the mysql server will be started when the machine is

# started and shut down when the systems goes down.

# Comments to support chkconfig on RedHat Linux

# chkconfig: 2345 64 36

# description: A very fast and reliable SQL database engine.

# Comments to support LSB init script conventions

### BEGIN INIT INFO

# Short-Description: start and stop MySQL

# Description: MySQL is a very fast and reliable SQL database engine.

### END INIT INFO

# If you install MySQL on some other places than /usr/local/mysql, then you

# have to do one of the following things for this script to work:

#

# - Run this script from within the MySQL installation directory

# - Create a /etc/my.cnf file with the following information:

# [mysqld]

# basedir=<path-to-mysql-installation-directory>

# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.

# If you change base dir, you must also change datadir. These may get

# overwritten by settings in the MySQL configuration files.

basedir=

datadir=

# Default value, in seconds, afterwhich the script should timeout waiting

# for server start.

# Value here is overriden by value in my.cnf.

# 0 means don't wait at all

# Negative numbers mean to wait indefinitely

mysqld_pid_file_path=

if test -z "$basedir"

then

basedir=/usr/local/mysql

bindir=/usr/local/mysql/bin

if test -z "$datadir"

then

datadir=/usr/local/mysql/data

fi

sbindir=/usr/local/mysql/bin

fi

sbindir="$basedir/sbin"

libexecdir="$basedir/libexec"

fi

# datadir_set is used to determine if datadir was set (and so should be

# *not* set inside of the --basedir= handler.)

datadir_set=

#

# Use LSB init script functions for printing messages, if possible

#

echo " SUCCESS! $@"

}

log_failure_msg()

{

echo " ERROR! $@"

}

fi

PATH="/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin"

export PATH

mode=$1 # start or stop

*c*,-n*) echo_n= echo_c= ;;

*c*,*) echo_n=-n echo_c= ;;

*) echo_n= echo_c='\c' ;;

esac

parse_server_arguments() {

for arg do

case "$arg" in

--basedir=*) basedir=`echo "$arg" | sed -e 's/^[^=]*=//'`

bindir="$basedir/bin"

if test -z "$datadir_set"; then

datadir_set=1

;;

--pid-file=*) mysqld_pid_file_path=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;

--service-startup-timeout=*) service_startup_timeout=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;

esac

done

}

wait_for_pid () {

verb="$1" # created | removed

pid="$2" # process ID of the program operating on the pid-file

# wait for a PID-file to pop into existence.

test -s "$pid_file_path" && i='' && break

;;

'removed')

# wait for this PID-file to disappear

test ! -s "$pid_file_path" && i='' && break

;;

*)

echo "wait_for_pid () usage: wait_for_pid created|removed pid pid_file_path"

exit 1