SQLAdvisor
SQLAdvisor copied to clipboard
Meituan-Dianping
输入SQL，输出索引优化建议
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 /usr/local/src/SQLAdvisor/sqladvisor/main.cc:7: /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...
Linking CXX executable sqladvisor /usr/bin/ld: cannot find -lperconaserverclient_r collect2: error: ld returned 1 exit status make[2]: *** [sqladvisor] Error 1 make[1]: *** [CMakeFiles/sqladvisor.dir/all] Error 2 make: *** [all] Error 2...
`root@ubuntu:/opt/sqlAdvisor/SQLAdvisor/sqladvisor# make Scanning dependencies of target sqladvisor [ 50%] 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/sqlAdvisor/SQLAdvisor/sqladvisor/main.cc:7: /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:...
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...
`[Note] 第1步: 对SQL解析优化之后得到的SQL:select product_orgz.product_id AS product_id,products.code AS product_code,products.name AS product_name,products.product_base_code AS product_base_code,products.min_spec_unit AS sales_unit,min_spec.name AS unit_name,products.order_spec_unit AS order_spec_unit,products.order_spec_num AS spec_num,order_spec.name AS spec_unit,products.weight_type AS weight_type,products.c_code AS c_code from (((test.product_orgz join test.products...
我的socket位置不是标准的，就报错了，难道一定要位于/var/lib/mysql/下？ 2017-06-12 18:27:06 19007 [Note] 第3步：SQLAdvisor结束！错误日志:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
2017-07-28 13:56:41 58531 [Note] 第1步: 对SQL解析优化之后得到的SQL:select `*` AS `*` from `qk_auth`.`auth_function` where (`id` = 100) 2017-07-28 13:56:41 58531 [Note] 第2步：开始解析where中的条件:(`id` = 100) 2017-07-28 13:56:41 58531 [Note] 第3步：SQLAdvisor结束！错误日志:Invalid parameter number
