1. 下载 Anemometer
2. 下载 Percona Toolkit
# wget
https://www.percona.com/downloads/percona-toolkit/2.2.18/RPM/percona-toolkit-2.2.18-1.noarch.rpm
# yum install percona-toolkit-2.2.18-1.noarch.rpm
3. 安装httpd 和 php,需要 Apache webserver with PHP 5.3+ ,依赖包:bcmath,mysqli,
# yum install httpd php *bcmath* *mysqli* -y
4. 将Anemometer文件包解压,重命名为anemometer,并移动到/var/www/html 下(apache默认路径)
# unzip Anemometer-master.zip
# mv Anemometer-master /var/www/html/Anemometer
5. Anemometer 配置:存储分析数据
# /usr/local/mysql/bin/mysql -h localhost -uroot -p123456</var/www/html/Anemometer/install.sql
6. 创建用户
# mysql -h localhost -uroot -p123456 -e "grant ALL ON slow_query_log.* to 'anemometer'@'%' IDENTIFIED BY 'anemometer';"
# mysql -h localhost -uroot -p123456 -e "grant select on *.* to