SQLAdvisor
SQLAdvisor copied to clipboard
安装最后失败
[root@devcenter-8-36 sqladvisor]# sudo cmake -DCMAKE_BUILD_TYPE=debug ./
-- The C compiler identification is GNU 4.8.5
-- The CXX compiler identification is GNU 4.8.5
-- Check for working C compiler: /bin/cc
-- Check for working C compiler: /bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /bin/c++
-- Check for working CXX compiler: /bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Configuring done
-- Generating done
-- Build files have been written to: /opt/software/SQLAdvisor/sqladvisor
[root@devcenter-8-36 sqladvisor]# make
Scanning dependencies of target sqladvisor
[100%] Building CXX object CMakeFiles/sqladvisor.dir/main.cc.o
In file included from /usr/local/sqlparser/include/sql/item.h:2470:0,
from /usr/local/sqlparser/include/sql/sql_class.h:39,
from /opt/software/SQLAdvisor/sqladvisor/main.cc:6:
/usr/local/sqlparser/include/sql/item_timefunc.h: In member function ‘virtual longlong Item_time_func::val_int()’:
/usr/local/sqlparser/include/sql/item_timefunc.h:533:12: warning: converting to non-pointer type ‘longlong {aka long long int}’ from NULL [-Wconversion-null]
return NULL;
^
Linking CXX executable sqladvisor
/usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../lib64/libperconaserverclient_r.so: undefined reference to [email protected]' /usr/lib/gcc/x86_64-redhat-linux/4.8.5/../../../../lib64/libperconaserverclient_r.so: undefined reference to [email protected]'
collect2: error: ld returned 1 exit status
make[2]: *** [sqladvisor] Error 1
make[1]: *** [CMakeFiles/sqladvisor.dir/all] Error 2
make: *** [all] Error 2
同样的问题,不知道是什么鬼
我遇到同样问题,执行 yum install openssl-devel 解决。
美团SQLAdvisor工具docker镜像 https://aqzt.com/5390.html docker run -d --name=sqladvisor ppabc/sqladvisor