sqladvisor.sh

#!/bin/bash
## Centos6下一键安装美团开源SQL优化工具SQLAdvisor脚本  2018-04-10
## http://www.aqzt.com
## email: ppabc@qq.com
## robert yu
## Centos6

yum install -y http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm
yum install -y gcc-c++ make gcc httpd php mysql php-mysql php-devel php-pear libssh2 libssh2-devel unzip cmake libaio-devel libffi-devel glib2 glib2-devel Percona-Server-shared-56  bison libaio-devel ncurses-devel

echo '' | pecl install -f ssh2
ln -s /usr/lib64/libperconaserverclient_r.so.18 /usr/lib64/libperconaserverclient_r.so

unzip SQLAdvisor.zip
cd SQLAdvisor-master
if [ -f  CMakeCache.txt ];then
    rm -rf CMakeCache.txt
fi
cmake -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=debug -DCMAKE_INSTALL_PREFIX=/usr/local/sqlparser ./
make && make install

cd sqladvisor
cmake -DCMAKE_BUILD_TYPE=debug ./
make
cp sqladvisor /usr/bin/sqladvisor
sqladvisor --help