perl 监控mysql数据库

#!/usr/bin/perl 
use HTTP::Date qw(time2iso str2time time2iso time2isoz);
use Net::Ping;  
use Socket;
use Net::SMTP;
sub send_mail{
if (@_ != 2){print "请输入2个参数n";exit 1};
    ($m,$n) = @_; #将参数赋值给变量  
    my $to_address  = $m;
my $CurrTime = time2iso(time());
    my $to_address  = $m;
    my $mail_user   = 'zhao.yangjian@163.com';
    my $mail_pwd    = 'xxxxx';
    my $mail_server = 'smtp.163.com';

    my $from    = "From: $mail_usern";
    my $subject = "Subject: zjcap infon";
    my $info = "$CurrTime--$n";
     my $message = <<CONTENT; 
     $info
CONTENT
    my $smtp = Net::SMTP->new($mail_server);

    $smtp->auth($mail_user,$mail_pwd) || die "Auth Error! $!";
    $smtp->mail($mail_user);
    $smtp->to($to_address);

    $smtp->data();             # begin the data
    $smtp->datasend($from);    # set user
    $smtp->datasend($subject); # set subject
    $smtp->datasend("nn");
    $smtp->datasend("$messagen"); # set content
    $smtp->dataend();
    $smtp->quit();
};
use DBI;
$database='zjzc';
$user="root";
$passwd="xxxx";
$host="192.168.32.x";
$dbh = DBI->connect("dbi:mysql:database=$database;host=$host;port=3306",$user,$passwd) or (die "can't connect to database ",send_mail('zhaoyangjian@zjcap.cn',"test-database $database is lost"));

$database='zjzc';
$user="backup";
$passwd="axxxx";
$host="x.x.x.x";
$dbh = DBI->connect("dbi:mysql:database=$database;host=$host;port=3306","database $database is lost"));

$database='pay';
$user="xxxx";
$passwd="xxx";
$host="1x1.x.x3.x";
$dbh = DBI->connect("dbi:mysql:database=$database;host=$host;port=3306","database $database is lost"));