Extract MySQL error level logs and automatically report police content on mail

Prerequisite installation Postfix

#!/bin/shell

Log=/home/dbdata/db2.err

#原来error记录数

Numa= ' Cat/tmp/mysqlerrornb.log '

#当前error数

Numb= ' cat $log |grep "ERROR" |wc-l '

#增加的error条目

numc=$ (($numB-$numA))

#从日志中过滤出error日志

Errtotal=/tmp/mysqlerrtotal.log

#对新增的error日志提取, and report the police

Errincrease=/tmp/errincrease.log

if [[$numC > 0]]

Then

' Cat $log |grep ' ERROR ' > $errTotal '

Tail-n $numC $errTotal > $errIncrease

Mail-s "mysql10.0.0.111 error alert!" to [email protected] < $errIncrease #上报告警功能

Echo $numB >/tmp/mysqlerrornb.log

Exit 1

Else

echo "It's OK" >/dev/null 2>&1

Exit 1

Fi

Extract MySQL error level logs and automatically report police content on mail