php fork太多进程导致整体性能下降,mysql down掉的解决.

* */1 * * * /sh/detect_php.sh

#!/bin/bash

host_dir=`cd /sh`
proc_name="mysql"
bug_time=`date -R`
pid=0

proc_num()
{
	num=`ps -ef | grep $proc_name | grep -v grep | wc -l`
	return $num
}

proc_id()
{
	pid=`ps -ef | grep $proc_name | grep -v grep | awk '{print $2}'`
}

proc_num
number=$?
if [ $number -eq 0 ]
then
	./restart_php_mysql.sh
	proc_id
	echo " Kill the php and new mysql pid is : ${pid} :  ${bug_time} " >> php_mysql.log 2>&1
else
	proc_id
	echo " The mysql is working , ${bug_time} " >> php_mysql.log 2>&1
	echo "it's ok!"
fi

#!/bin/sh
killall -9 php
service mysql restart

#!/bin/bash
host_dir=`cd /sh`
log_dir="/var/log/php_mysql_log/"
proc_name="mysql"
bug_time=`date -R`
pid=0
now_time=`date +%F`
log_file="${log_dir}${now_time}.log"

log_detect()
{
	if [ ! -d "$log_dir" ];
	then
	mkdir "$log_dir"
	fi

	if [ ! -f "$log_file" ]
	then
	touch "$log_file"
	fi
}

proc_num()
{
	num=`ps -ef | grep $proc_name | grep -v grep | wc -l`
	return $num
}

proc_id()
{
	pid=`ps -ef | grep $proc_name | grep -v grep | awk '{print $2}'`
}

proc_num
number=$?
if [ $number -eq 0 ]
then
	./restart_php.sh
	proc_id
	log_detect
	echo " Kill the php and new mysql pid is : ${pid} :  ${bug_time} " >> ${log_dir}${now_time}.log 2>&1
else
	proc_id
	log_detect
	echo " The mysql is working ,${pid} : ${bug_time} " >> ${log_dir}${now_time}.log 2>&1
	echo "it's ok!"
fi