SQLAdvisor
SQLAdvisor copied to clipboard
Meituan-Dianping
输入SQL，输出索引优化建议
# 完整的安装步骤： ## 安装依赖 ``` apt-get install -y gcc g++ cmake make libaio1 libaio-dev libffi-dev libglib2.0-0 libglib2.0-dev ``` ## 安装 libperconaserverclient18.1-dev ``` apt-get install -y gnupg2 && \ wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release...
2018-07-16 23:12:34 50130 [Note] 第1步: 对SQL解析优化之后得到的SQL:select `*` AS `*` from `crmdb2`.`tbl_dept` where ((1 = 1) and (`id` > 50) and (`id` < 100)) 2018-07-16 23:12:34 50130 [Note] 第2步：开始解析where中的条件:(`id` > 50)...
我安装了一个下午还没有搞定. [root@linux01 apps]# cmake -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=debug -DCMAKE_INSTALL_PREFIX=/usr/local/sqlparser ./ CMake Error: The source directory "/root/apps" does not appear to contain CMakeLists.txt. Specify --help for usage, or press the help button on...
1.拉取代码 `git clone https://github.com/Meituan-Dianping/SQLAdvisor.git` 2.安装依赖项 ``` apt-get install cmake libaio-dev libffi-dev apt-get install libglib2.0-dev apt-get install libperconaserverclient18.1-dev //g++不知道有没有起作用，中间各种出错后尝试安装了他 apt-get install g++ ``` percona的安装参考 https://www.percona.com/doc/percona-server/5.6/installation/apt_repo.html 3.编译依赖项sqlparser ``` cmake -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=debug -DCMAKE_INSTALL_PREFIX=/usr/local/sqlparser...
[root@qk-yunwei sqladvisor]# ./sqladvisor -h 192.168.1.XX -P 3306 -u XXX-p 'XXX' -d qk_auth -q "select af.* from auth_function af inner join auth_function_permission afp on af.id = afp.function_id where af.id=1;" -v 1...
```sql select * from rocket_release where end_time>start_time order by id desc ``` 日志： 2020-06-03 15:38:00 7482 [Note] 第1步: 对SQL解析优化之后得到的SQL:select `*` AS `*` from `nasa`.`rocket_release` where (`end_time` > `start_time`) order by...
