$ mysql -uroot -p -h127.0.0.1 -P33006 < install.sql
创建mysql用户
mysql> grant select on *.* to 'anemometer'@'%' identified by Abcd123#;
mysql配置
mysql> set global long_query_time=1; mysql> set global slow_query_log=on; mysql> set global log_slow_admin_statements=1; mysql> set global slow_query_log_file='/service/mysql/data/mysqlslow.log'
#config anemometer server, the purpose is to push slow query to the remote anemometer server and store it. anemometer_host="127.0.0.1" anemometer_user="root" anemometer_password="Abcd123#" anemometer_port=33006 anemometer_db="slow_query_log"
#config mysql server, the purpose is to get the path of the slow query log. mysql_client="/usr/local/mysql/bin/mysql" mysql_user="root" mysql_password="Abcd123#" mysql_port=33006
#config slowqury dir to cd, and then delete the expired slow query file. slowquery_dir="/service/data/mysqlslow.log"
#get the path of the slow query log. slowquery_file=`$mysql_client -u$mysql_user -p$mysql_password -S $mysql_socket -e "show variables like 'slow_query_log_file'"|grep log|awk '{print $2}'` pt_query_digest="/usr/local/toolkit/bin/pt-query-digest"
#collect mysql slowquery log into lepus database. $pt_query_digest --user=$anemometer_user --password=$anemometer_password --port=$anemometer_port --review h=$anemometer_host,D=$anemometer_db,t=global_query_review --history h=$anemometer_host,D=$anemometer_db,t=global_query_review_history --no-report --limit=0% --filter=" \$event->{Bytes} = length(\$event->{arg}) and \$event->{hostname}=\"$HOSTNAME:$mysql_port\"" $slowquery_file
#generate a new slow query log, the below is generate a new slow file per hour. tmp_log=`$mysql_client -u$mysql_user -p$mysql_password -e "select concat('$slowquery_dir','slowquery_',date_format(now(),'%Y%m%d%H'),'.log');"|grep log|sed -n -e '2p'`
#use new slow file to config mysql slowquery $mysql_client -u$mysql_user -p$mysql_password -S $mysql_socket -e "set global slow_query_log = 0;set global slow_query_log_file = '$tmp_log';" $mysql_client -u$mysql_user -p$mysql_password -S $mysql_socket -e "set global slow_query_log = 1; "