打赏

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

posted @ 2020-07-02 08:47  苍山落暮  阅读(498)  评论(0编辑  收藏  举报