最初にやること

[agatan]

• [ ] Regulationを読む
• [x] authorized_keys する

  curl https://github.com/izumin5210.keys >> ~/.ssh/authorized_keys
  curl https://github.com/0gajun.keys >> ~/.ssh/authorized_keys
  curl https://github.com/agatan.keys >> ~/.ssh/authorized_keys

• [x] 素直に必要なやつだけ git add する
  • [x] echo '*' > .gitignore && git init && git add -f env.sh && git add -f private_isu/webapp/ && git commit -m 'Initial commit'
• [x] 秘密鍵をもっていく
• [ ] https://github.com/0gajun/isucon2016-qualifier/tree/master/scripts
• [x] git commit -m "initial commit" && git remote add origin git@github.com:agatan/isucon2017-qualify && git push origin master
• [ ] mysqldump
  • [ ] mysqldump --all-databases -u root -p | gzip > ~/backup.sql.gz
  • [ ] scp admin@13.115.178.102:/home/isucon/backup.sql.gz ~/backup.sql.gz
• [x] 実装切り替え
  • [x] sudo systemctl stop isu-ruby
  • [x] sudo systemctl start isu-go
  • [x] sudo systemctl disable isu-ruby
  • [x] sudo systemctl enable isu-go

↑のあとに

• [x] とりあえずベンチマーカ走らせる
• [x] 動きをみる
• [x] コードを読む

[agatan]

お便利グッズ入れてく

• [x] alp
  • wget -o alp.zip https://github.com/tkuchiki/alp/releases/download/v0.3.1/alp_linux_amd64.zip
  • unzip alp.zip
• [ ] netdata
  • [ ] bash <(curl -Ss https://my-netdata.io/kickstart.sh)
  • Nginxプラグイン
    • http://www.instrumedley.net/entry/2017/04/03/093000#web_log%E3%83%97%E3%83%A9%E3%82%B0%E3%82%A4%E3%83%B3
  • Uninstallation
    • ./netdata-uninstaller.sh
• [ ] pt-query-digest
  • https://www.percona.com/doc/percona-toolkit/LATEST/installation.html

[agatan]

最初のDB作業

SELECT table_name, engine, table_rows, avg_row_length, floor((data_length+index_length)/1024/1024) as allMB, floor((data_length)/1024/1024) as dMB, floor((index_length)/1024/1024) as iMB FROM information_schema.tables WHERE table_schema=database() ORDER BY (data_length+index_length) DESC;

[agatan]

Middleware調査

• [ ] sudo systemctl でデーモンのリスト表示

[izumin5210]

ローカル開発環境

• postgres

  docker run --rm -d -p 5432:5432 postgres:9.6.5-alpine

• mysql

  docker run --rm -d -e MYSQL_ALLOW_EMPTY_PASSWORD=1 -p 3306:3306 mysql

• redis

  docker run --rm -d -p 6379:6379 redis:alpine

• memcached

  docker run --rm -d -p 11211:11211 memcached:alpine