Group Meeting【2022/11/11】

Ottertune

env set log

  1. python 3.5.2 (ps:😅tf运行不了,报错信息给出需要3.7.0)
  2. 更换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

  1. OtterTune源码解析
  2. otlpbenchmark git repo
  3. ottertune git repo

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/	
    # ————————————————
    # 版权声明:本文为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
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值