SQLAdvisor
SQLAdvisor copied to clipboard
Meituan-Dianping
输入SQL，输出索引优化建议
[Note] explain select * from IN_ORDER as t where (`t`.`acc_date` = '2017-06-24') 段错误 (core dumped) 单独执行后边的select语句是可以的
root@ubuntu:~/SQLAdvisor/sqladvisor# make&&make install Scanning dependencies of target sqladvisor [100%] Building CXX object CMakeFiles/sqladvisor.dir/main.cc.o /root/SQLAdvisor/sqladvisor/main.cc:6:24: fatal error: sql/mysqld.h: No such file or directory #include "sql/mysqld.h" ^ compilation terminated. make[2]: *** [CMakeFiles/sqladvisor.dir/main.cc.o]...
数据库安装时指定了另外的sock文件路径，在sqladvisor的时候无法指定新的sock文件，会默认去找/var/lib/mysql/mysql.sock文件。
问题是：在执行完命令./sqladvisor -f sql.cnf -v 1后，错误日志什么都没有。 以下是输出日志： 2017-03-31 15:50:01 15432 [Note] 第1步: 对SQL解析优化之后得到的SQL:select count(1) AS `count(1)` from `im_server`.`message` where (`msgsender` = '10006') 2017-03-31 15:50:01 15432 [Note] 第2步：开始解析where中的条件:(`msgsender` = '10006') 2017-03-31 15:50:01...
[root@sss sqladvisor]# ./sqladvisor -h x.x.x.x -u sun -p mysql -P 3000 -v 1 -q 'select * from T where id=1' [root@sss sqladvisor]#
笔者安装多次失败，通过这篇文章的介绍成功安装！ [文章链接](https://dev-tang.com/post/2018/02/meituan-sqladvisor.html) 如果有用请点赞！
安装最后失败
[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 --...
20:47 $ uname -a Linux ip-172-31-11-168 4.4.0-101-generic #124~14.04.1-Ubuntu SMP Fri Nov 10 19:05:36 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux ✔ ~/SQLAdvisor/sqladvisor [master|✚ 3…60] 20:47 $ sudo cmake -DCMAKE_BUILD_TYPE=debug ./ --...
root@XXXX:/usr/local/SQLAdvisor/SQLAdvisor-master/sqladvisor# make Scanning dependencies of target sqladvisor [100%] Building CXX object CMakeFiles/sqladvisor.dir/main.cc.o /usr/local/SQLAdvisor/SQLAdvisor-master/sqladvisor/main.cc:6:24: fatal error: sql/mysqld.h: No such file or directory #include "sql/mysqld.h" ^ compilation terminated. make[2]: *** [CMakeFiles/sqladvisor.dir/main.cc.o] Error...
