Group Meeting【2022/11/11】

原创已于 2022-11-11 11:05:49 修改 · 172 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#python #django #开发语言

于 2022-11-11 10:52:48 首次发布

Log 专栏收录该内容

3 篇文章

订阅专栏

本文档详细介绍了OtterTune项目的环境配置步骤，包括Python版本的切换与安装，以及使用pip安装依赖包的过程。还提到了Oltpbench的使用来创建工作负载并获取性能结果。此外，讨论了网络设置，如DNS配置和选择国内镜像源以加速下载。最后，文章强调了软件更新与错误处理的原则。

content

Ottertune

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 since python 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 run python get-pip.py.
install pip from pypi
website contains python’s all pakcages, which inlude pip. 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/	
# ————————————————
# 版权声明：本文为优快云博主「Doris404」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
# 原文链接：https://blog.youkuaiyun.com/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