content
Ottertune
env set log
- python 3.5.2 (ps:😅tf运行不了,报错信息给出需要3.7.0)
- 更换python 版本 3.7.0 (ps:😅celery安装失败)
project 🌟
archi
- ottertune = server + client
- server = mysql (store training data) + Django (UI) + Celery (ML task schedule)
- client = target dbms + controller + driver
controller control target dmbs
driver control controller
env set
-
ottertune = server set + client set
-
need oltpbench for create wkld and run wkld get result
oltpbench
- generate and run wkld --> get performance
- otlpbenchmark git repo
./oltpbenchmark -b tpcc -c config/tpcc_config.xml --create=true --load=true -s 10 -o outputfile
- result of cmd
Ref
Sum 🌟
python install
-
see available python and do something with them
-
Run
python
and see the version of it. You can also check the folder/usr/local/bin
or/usr/bin
sincepython
is always installed there.import sys print(sys.executable)
-
get pakage from website see 菜鸟教程python安装
-
choose a proper version (ps: the hardest part)
We take python3.7.0 as example -
compile and build (ps: python depends on gcc)
./configure make make install
-
build soft link (ps: for mvc)
ln -s /usr/bin/python /usr/local/bin/python3.7 # when type `python`, you actually run `python3.7` useful for mvc
-
try and test: make sure you really install the python properly
-
how to choose python version❓
It depends on the pakcage that your project need --> get info from repo or try (ps: I am confused with this part😭)
network
- do this part first❗️
- basic idea: network need dns & domestic image
- set dns set dns
- Warning: You can only have 3 dns ip❗️
vim /etc/resolv.conf # tmp vim /etc/resolvconf/resolv.conf.d/base # perm # nameserver 10.3.3.3 # nameserver 114.114.114.114 # nameserver 8.8.8.8
- domestic image
vim /etc/apt/sources.list # add the proper content from [网络设置清华源](https://mirror.tuna.tsinghua.edu.cn/help/ubuntu/)
reboot
the server
pip install
sudo apt-get install pip
python get-pip.py
(ps: recommend)
Install get-pip.py from website and runpython get-pip.py
.- install pip from pypi
website contains python’s all pakcages, which inludepip
. You can install pip like other pakages.
pakage install
pip install [pakage name]
(ps: need pip)pip install [pakage name] -i [domestic image]
you can choose domestic image from below https://pypi.tuna.tsinghua.edu.cn/simple/ # 清华大学 https://mirrors.aliyun.com/pypi/simple/ # 阿里云 https://pypi.douban.com/simple/ # 豆瓣 https://pypi.mirrors.ustc.edu.cn/simple/ # 中国科学技术大学 https://pypi.hustunique.com/ # ———————————————— # 版权声明:本文为CSDN博主「Doris404」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。 # 原文链接:https://blog.csdn.net/kullollo/article/details/109448254
- install pakage.tar.gz from pypi and run
cd [pakage] & python setup.py install
- install pakage from pakage.whl in pypi and run
pip install [pakage.whl]
Philosophy
goal first
- don’t update software frequently (ps: update pip)
- see only the important info (ps: warning is ok, useless err is ok)
easy first - passwd free login how to set passwd free login
log and checkpoint - this README.md
- env set will last long time log and checkpoint will keep you clear