arted.
2018-12-20 14:04:55 [WARNING] check redis: not found any servers
2018-12-20 14:04:55 [INFO] check redis controller finished.
2018-12-20 14:05:02 [INFO] check os controller started.
2018-12-20 14:05:02 [WARNING] check os: not found any servers
2018-12-20 14:05:02 [INFO] check os controller finished.
2018-12-20 14:05:20 [INFO] check mysql controller started.
2018-12-20 14:05:30 [INFO] check mysql controller finished.
2018-12-20 14:05:35 [INFO] alarm controller started.
2018-12-20 14:05:35 [INFO] alarm controller finished.
慢查询日志分析
[root@wallet01 ~]# yum install -y perl-DBI perl-DBD-MySQL \
perl-Time-HiRes perl-IO-Socket-SSL perl-TermReadKey
[root@wallet01 ~]# tar zxvf percona-toolkit-3.0.12_x86_64.tar.gz
[root@wallet01 ~]# cd percona-toolkit-3.0.12
[root@wallet01 percona-toolkit-3.0.12]# perl Makefile.PL
[root@wallet01 percona-toolkit-3.0.12]# make
[root@wallet01 percona-toolkit-3.0.12]# make install
[root@wallet01 ~]# pt-heartbeat --version
pt-heartbeat 3.0.12
[root@wallet01 ~]# cd /usr/local/sbin
[root@wallet01 sbin]# vi lepus_slowquery.sh
#!/bin/bash
#****************************************************************#
# ScriptName:/usr/local/sbin/lepus_slowquery.sh
# Create Date:2014-03-25 10:01
# Modify Date:2014-03-25 10:01
#***************************************************************#
#config lepus database
lepus_db_host="192.168.1.204"
lepus_db_port=3306
lepus_db_user="lepus"
lepus_db_password="lepus"
lepus_db_database="lepus"
#config mysql server
mysql_client=`which mysql`
mysql_host="192.168.1.201"
mysql_port=3306
mysql_user="root"
mysql_password="abcd.1234"
#config slowqury
slowquery_dir="/var/lib/mysql/"
slowquery_long_time=0.01
slowquery_file=`$mysql_client -h$mysql_host -P$mysql_port -u$mysql_user -p$mysql_password -e "show
variables like'slow_query_log_file'"|grep log|awk '{print $2}'`
pt_query_digest=`which pt-query-digest`
#config server_id
lepus_server_id=204
#collect slowquery log into lepus database
$pt_query_digest --user=$lepus_db_user --password=$lepus_db_password --port=$lepus_db_port --charset=utf8
--review h=$lepus_db_host,D=$lepus_db_database,t=mysql_slow_query_review --history h=$lepu