1. 从git上拉取最新代码

[BEGIN]2018/8/614:13:04(venv4archer)[root@mysql-serverdata1]#mkdirSQLAdvisor(venv4archer)[root@mysql-serverdata1]#cdSQLAdvisor(venv4archer)[root@mysql-serverSQLAdvisor]#gitclonehttps://github.com/Meituan-Dianping/SQLAdvisor.git正克隆到'SQLAdvisor'...remote:Countingobjects:1460,done.remote:Total1460(delta0),reused0(delta0),pack-reused1460接收对象中:100%(1460/1460),19.92MiB|473.00KiB/s,done.处理delta中:100%(367/367),done.(venv4archer)[root@mysql-serverSQLAdvisor]#lsSQLAdvisor

2. 安装依赖包

(venv4archer)[root@mysql-serverSQLAdvisor]#yuminstallcmakelibaio-devellibffi-develglib2glib2-devel-y(venv4archer)[root@mysql-serverSQLAdvisor]#yuminstallhttp://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm(venv4archer)[root@mysql-serveryum.repos.d]#yummakecache(venv4archer)[root@mysql-serveryum.repos.d]#yuminstallPercona-Server-shared-56

3. 编译依赖项sqlparser

(venv4archer)[root@mysql-serverSQLAdvisor]#cdSQLAdvisor/(venv4archer)[root@mysql-serverSQLAdvisor]#cmake-DBUILD_CONFIG=mysql_release-DCMAKE_BUILD_TYPE=debug-DCMAKE_INSTALL_PREFIX=/usr/local/sqlparser./--Runningcmakeversion2.8.12.2--FoundGit:/usr/bin/git(foundversion"1.8.3.1")--TheCcompileridentificationisGNU4.4.7--TheCXXcompileridentificationisGNU4.4.7--CheckforworkingCcompiler:/usr/bin/cc--CheckforworkingCcompiler:/usr/bin/cc--works--DetectingCcompilerABIinfo--DetectingCcompilerABIinfo-done--CheckforworkingCXXcompiler:/usr/bin/c++--CheckforworkingCXXcompiler:/usr/bin/c++--works--DetectingCXXcompilerABIinfo--DetectingCXXcompilerABIinfo-done--Lookingforincludefilelibaio.h--Lookingforincludefilelibaio.h-found--Lookingforio_queue_initinaio--Lookingforio_queue_initinaio-found(venv4archer)[root@mysql-serverSQLAdvisor]#makeScanningdependenciesoftargetINFO_BIN[0%]BuilttargetINFO_BINScanningdependenciesoftargetINFO_SRC[0%]BuilttargetINFO_SRCScanningdependenciesoftargetabi_check[0%]Builttargetabi_checkScanningdependenciesoftargetzlib[0%]BuildingCobjectzlib/CMakeFiles/zlib.dir/adler32.c.o[1%]BuildingCobjectzlib/CMakeFiles/zlib.dir/compress.c.o[1%]BuildingCobjectzlib/CMakeFiles/zlib.dir/crc32.c.o[1%]BuildingCobjectzlib/CMakeFiles/zlib.dir/deflate.c.o[2%]BuildingCobjectzlib/CMakeFiles/zlib.dir/gzio.c.o[2%]BuildingCobjectzlib/CMakeFiles/zlib.dir/infback.c.o(venv4archer)[root@mysql-serverSQLAdvisor]#makeinstall[0%]BuilttargetINFO_BIN[0%]BuilttargetINFO_SRC[0%]Builttargetabi_check[5%]Builttargetzlib

建立 percona 包的软连接

(venv4archer)[root@mysql-serversqladvisor]#cd/usr/lib64/(venv4archer)[root@mysql-serverlib64]#ln-slibperconaserverclient_r.so.18libperconaserverclient_r.so

4.安装SQLAdvisor源码

(venv4archer)[root@mysql-serverSQLAdvisor]#cdsqladvisor/(venv4archer)[root@mysql-serversqladvisor]#cmake-DCMAKE_BUILD_TYPE=debug./--TheCcompileridentificationisGNU4.4.7--TheCXXcompileridentificationisGNU4.4.7--CheckforworkingCcompiler:/usr/bin/cc--CheckforworkingCcompiler:/usr/bin/cc--works--DetectingCcompilerABIinfo--DetectingCcompilerABIinfo-done--CheckforworkingCXXcompiler:/usr/bin/c++--CheckforworkingCXXcompiler:/usr/bin/c++--works--DetectingCXXcompilerABIinfo--DetectingCXXcompilerABIinfo-done--Configuringdone--Generatingdone--Buildfileshavebeenwrittento:/data1/SQLAdvisor/SQLAdvisor/sqladvisor(venv4archer)[root@mysql-serversqladvisor]#makeLinkingCXXexecutablesqladvisor[100%]Builttargetsqladvisor(venv4archer)[root@mysql-serversqladvisor]#ls-l总用量580-rw-r--r--1rootroot120968月614:43CMakeCache.txtdrwxr-xr-x5rootroot40968月614:44CMakeFiles-rw-r--r--1rootroot16328月614:43cmake_install.cmake-rw-r--r--1rootroot6948月614:15CMakeLists.txt-rw-r--r--1rootroot531958月614:15main.cc-rw-r--r--1rootroot47948月614:43Makefile-rw-r--r--1rootroot2578月614:15README-rwxr-xr-x1rootroot5025418月614:44sqladvisor

5. 测试

(venv4archer)[root@mysql-serversqladvisor]#./sqladvisor-h172.31.0.68-P23305-uinception-p'inception'-dtest-q"select*fromtest"-v12018-08-0614:49:0413887[Note]第1步:对SQL解析优化之后得到的SQL:select`*`AS`*`from`test`.`test`2018-08-0614:49:0413887[Note]第2步：表test的SQL太逆天,没有优化建议2018-08-0614:49:0413887[Note]第3步:SQLAdvisor结束!