SQL优化工具
SQL优化工具
(1.)小米公司的soar,下载二进制文件
https://github.com/XiaoMi/soar/releases
(2.)使用说明:
https://www.jianshu.com/p/1594228e18c6
(3.)安装Web图形化工具,下载地址:
https://github.com/xiyangxixian/soar-web
(4.)下载源码
git clone https://github.com/xiyangxixian/soar-web.git
(5.)解决依赖:python3
Ubuntu:
sudo apt-get install python3 python3-pip (如果两个包都有安装可跳过此步骤)
CentOS:
sudo yum install python36 python36-pip (如果两个包都有安装可跳过此步骤)
(6.)进入代码目录,下载依赖
pip install -r requirement.txt
(7.)运行启动脚本:
Windows: run.bat
Linux or Mac: bash run.sh
守护进程支持:
启动服务:bash manage.sh start
关闭服务:bash manage.sh stop
重启服务:bash manage.sh restart
(8.)浏览器访问
localhost:5077
(9.) SQL优化工具 美团开源工具SQLAdvisor
https://blog.csdn.net/eagle89/article/details/80079766
https://github.com/Meituan-Dianping/SQLAdvisor/blob/master/doc/QUICK_START.md
https://github.com/zyw/sqladvisor-web
(10.)SQL审核平台
https://gitee.com/rtttte/Archery
相关链接
https://www.jianshu.com/p/1594228e18c6
https://github.com/xiyangxixian/soar-web