26 lines
943 B
Bash
26 lines
943 B
Bash
#!/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 |