本文为【带你轻松接触一个检测MySQL状态的脚本】的汉字拼音对照版显示拼音
下xia面mian的de这zhe个ge脚jiao本ben用yong到dao了lenamp扫sao描miao工gong具ju,所suo以yi,系xi统tong中zhong如ru果guo没mei安an装zhuangnmap扫sao描miao工gong具ju的de,需xu要yao先xian安an装zhuang该gai工gong具ju。
脚jiao本ben的de功gong能neng:
首shou先xian,检jian测cemysql端duan口kou是shi否fou正zheng常chang存cun在zai,端duan口kou不bu存cun在zai就jiu执zhi行xing启qi动dongmysql服fu务wu,当dang然ran,启qi动dong的de脚jiao本ben的de位wei置zhi根gen据ju你ni的de安an装zhuang路lu径jing会hui有you不bu同tong,然ran后hou如ru果guo端duan口kou存cun在zai,则ze有youmysql服fu务wu在zai运yun行xing,那na么me检jian测cemysql状zhuang态tai,能neng不bu能neng正zheng常chang连lian接jie,如ru能neng正zheng常chang连lian接jie说shuo明mingmysql正zheng常chang,不bu做zuo任ren何he处chu理li,如ru果guo不bu能neng正zheng常chang连lian接jie,则ze杀sha掉diao所suo有youmysql进jin程cheng,然ran后hou启qi动dongmysql服fu务wu,为wei什shen么me要yao杀sha掉diao进jin程cheng而er不bu进jin行xing正zheng常chang的de重chong起qi呢ne,是shi因yin为wei有you时shi候houmysql是shi不bu能neng正zheng常chang关guan闭bi的de,所suo以yi不bu能neng正zheng常chang重chong起qi,所suo以yi保bao险xian的de做zuo法fa是shi杀sha掉diao进jin程cheng,然ran后hou启qi动dong服fu务wu。(
#!/bin/bash
/usr/bin/nmap localhost |grep 3306
if [ $? -eq 0 ]
then
/usr/local/mysql/bin/mysql -uxxxxx -pxxxxxx --connect_timeout=5 -e "show databases;"
if [ $? -ne 0 ]
then
/bin/ps aux |grep mysql |grep -v grep | awk '{print $2}' | xargs kill -9
/usr/local/mysql/bin/mysqld_safe --user=mysql & > /dev/null
fi
else
/usr/local/mysql/bin/mysqld_safe --user=mysql & > /dev/null
fi
【原文】