[linux-users:103138] Re: [linux-users:103127] Re: [linux-users:103124] Re: $B%9%/%j%W%HCf$G%3%^%s(B$B%I$,5"$C$F$3$J$$;~$N=hM}(B$BJ}K!$K$D$$$F(B

[sub@xxxxxxxxxxxxxxxx]

$BF#ED$G$9!#(B
(B
$B$"$j$,$H$&$4$6$$$^$7$?!#(B
(B
$B$=$N8e!"%H%i%C%W$r;H$C$?J}K!$G(B
$BF0$/$h$&$K$J$j$^$7$?$N$G$=$NJs9p$G$9!#(B
(B
$B0J2<$=$N%9%/%j%W%H$K$J$j$^$9!#(B
$B$4;29M$^$G$K!#(B
(B
(B--- 
(B#!/usr/bin/sh
(B
(B#+++++++++++++++++++++++++++++
(B#  $B%a!<%k$NHt$P$7@h(B
(B#+++++++++++++++++++++++++++++
(BtoMailAddress=[$B%a!<%k%"%I%l%9(B]
(B
(B#+++++++++++++++++++++++++++++++++++++++++++++++++
(B++++++++++++
(B# $B%H%i%C%W(B
(B#+++++++++++++++++++++++++++++++++++++++++++++++++
(B++++++++++++
(B
(B # $B%9%/%j%W%H$N%?%$%`%*!<%P!l9g(Bkill$B$7$F%a!<%k$9$k(B($B4X?t(B)
(B#+++++++++++++++++++++++++++++++++++++++++++++++++
(B+++
(B
(B check_and_exit() {
(B   [ -n "$pid_sleep" ] && kill $pid_sleep
(B   [ -n "$pid_ping" ] && kill $pid_ping
(B   [ -n "$pid_select" ] && kill $pid_select
(B   [ -n "$pid_threads" ] && kill $pid_threads
(B   echo "time over $TIME_OVER_VAL" | mail -s "not return 
(Bcommand" $toMailAddress
(B   exit 1
(B }
(B
(B#+++++++++++++++++++++++++++++
(B#  $BF0:n%A%'%C%/(B $B4X?t(B
(B#+++++++++++++++++++++++++++++
(B
(B # MySQL$B%5!<%P!<$,F0$$$F$$$k$+(B? ( $BF0$$$F$$$l$P(B mysql is 
(Balive $B$,5"$C$F$/$k(B )
(B check_mysql_ping() {
(B   CmdCk=`/usr/local/mysql/bin/mysqladmin -ptmxra910 -u 
(Bratras ping | grep "mysqld is alive" | wc -l`
(B   if [ $CmdCk != 1 ]; then
(B     echo $CmdCk | mail $toMailAddress -s "mysqld not alive "
(B     exit 1
(B   fi
(B }
(B
(B # SQL$B$,H/9T$G$-$k$+(B? ( select 1; $B$rEj$2$F$_$F(B 1$B$,5"$C$F$/$l(B
$B$P(B OK )
(B check_mysql_select() {
(B   Select1=`/usr/local/mysql/bin/mysql -ptmxra910 -u 
(Bratras -B -N -e "select 1"`
(B   if [ $Select1 != 1 ]; then
(B     echo $Select1 | mail $toMailAddress -s "mysqld sql 
(Berror "
(B     exit 1
(B   fi
(B }
(B
(B#+++++++++++++++++++++++++++++
(B#  $BIi2Y%A%'%C%/(B $B4X?t(B
(B#+++++++++++++++++++++++++++++
(B
(B # MySQL$B$K$?$^$C$F$$$k%9%l%C%I$N?t$r%A%'%C%/(B
(B check_mysql_threads() {
(B   # $B%7%-%$CM(B
(B   VAL=20
(B   Threads=`/usr/local/mysql/bin/mysqladmin -ptmxra910 -u 
(Bratras status | awk '{print $4}'`
(B   if [ $Threads -ge $VAL ]; then
(B     echo "Threads=$Threads" | mail $toMailAddress -
(Bs "mysqld threds over "
(B     exit 1
(B   fi
(B }
(B
(B#+++++++++++++++++++++++++++++
(B# $B%a%$%s=hM}(B
(B#+++++++++++++++++++++++++++++
(B
(B (check_mysql_ping)&
(B pid_ping=$!
(B wait $pid_ping
(B pid_ping=
(B
(B (check_mysql_select)&
(B pid_select=$!
(B wait $pid_select
(B pid_select=
(B
(B (check_mysql_threads)&
(B pid_threads=$!
(B wait $pid_threads
(B pid_threads=
(B
(B exit 0
(B
(B##################################################
(B###############################
(B
(B
(B>
(B>$BF#ED$G$9!#(B
(B>
(B>$BIp0f$5$s!"$R$m$;$5$sJV?.$"$j$,$H$&$4$6$$$^$9!#(B
(B>
(B>$BIp0f$5$s$NJ}K!$GpJs6&M-![(B
(B>$B$3$N7o$rD4$Y$F$$$kCf$GM-1W$@$H;W$($?>pJs$G$9!#(B
(B>(1)http://www.futomi.com/lecture/signal/alrm.html
(B>(2)$B=q@R!V(BUNIX$B%W%m%0%i%_%s%04D6-!W%"%9%-!<=PHG6I(B(ISBN4-
(B>87148-351-7)
(B>   341$B%Z!<%8(B $B%"%i!<%`$N9`L\!#(B
(B>  
(B>http://www.amazon.co.jp/exec/obidos/ASIN/4871483517/qi
(Bd
(B>=1089347343/ref=sr_8_xs_ap_i3_xgl14/249-3678484-
(B7438730
(B>
(B>
(B>