SQLAdvisor
SQLAdvisor copied to clipboard
Meituan-Dianping
输入SQL，输出索引优化建议
[root@f6-web-test opt]# sqladvisor -f sqladvisor.cnf -v 1 2017-05-24 17:01:25 15179 [Note] 第1步: 对SQL解析优化之后得到的SQL:select `*` AS `*` from (select `m`.`pk_id` AS `pk_id`,ifnull(`m`.`service_subtotal`,0) AS `mService`,ifnull(`m`.`partinfo_subtotal`,0) AS `mPart`,ifnull(`s`.`servicePrice`,0) AS `service`,ifnull(`p`.`partPrice`,0) AS `part`,ifnull(`m`.`vip_expense`,0) AS...
sql是可以查询的，但是优化过程出现了select * from * 结果报错，想请您帮忙看下，谢谢 优化sql：SELECT e.id, e.target_id, e.target_num, e.client_name, e.business_name, e.collection_name, e.client_order_num, e.region, e.pick_time, e.late_age, e.households, e.amount, e.BALANCEMONEY, ( e.amount - e.BALANCEMONEY - e.apply_money ) chargeMoney, e.agent_term, e.rateStr, (...
当索引名称不规范，包含中横线（-），在force index时会出现语法报错，可用``包括。 2017-04-28 09:25:27 98697 [Note] show table status like 'play' 2017-04-28 09:25:27 98697 [Note] select count(*) from ( select `start_time` from `play` FORCE INDEX( cinema_play-id ) order by cinema_id...
#SQLAdvisor 安装 --- ### 1. SQLAdvisor安装 >环境：Linux 86_64 GNU/Linux #### 1.1 拉取最新代码 ``` git clone https://github.com/Meituan-Dianping/SQLAdvisor.git ``` #### 1.2 安装依赖项 ``` 1. yum | apt-get install cmake libaio-devel libffi-devel glib2...
请问sqladvisor是不是写死输出到console了？为什么我重定向的时候没有日志输出。类似 sqladvisor -h xx -u xx -p xx -P 3306 -d xx -q "xx" > log。发现直接就能展示结果出来，但是log中并没有结果。
select max(num) from tbname; select distinct A from tbname; select title,count(*) from tbname group by title; 类似的没有where条件的sql，不能给出优化建议，SQL也不逆天：）
[ 93%] Building CXX object sql/CMakeFiles/sqlparser.dir/sql_list.cc.o [ 93%] Building CXX object sql/CMakeFiles/sqlparser.dir/sql_plugin.cc.o [ 94%] Building CXX object sql/CMakeFiles/sqlparser.dir/sql_show.cc.o /root/SQLAdvisor-master/sql/sql_show.cc:92: warning: ‘sys_privileges’ defined but not used [ 94%] Building CXX object...
修复的版本验证： ``` 2017-03-13 16:19:23 1180 [Note] Query 0 SELECT p.*,s.cn_name FROM cc_paysystem_withdrawal as p LEFT JOIN cc_shop as s ON p.type_id = s.id WHERE ( p.type = 'SHOP' ) ORDER...
``` ./sqladvisor -u xxx -p xxx -h xxxx -P xxx -d xxxx -q "SELECT p.*,s.cn_name FROM cc_paysystem_withdrawal as p LEFT JOIN cc_shop as s ON p.type_id = s.id WHERE (...
