Taskfile.yaml

version: '3'

tasks:
  apply-config:
    desc: "apply mysql / nginx config from git"
    cmds:
      - sudo cp s1/etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/mysql.conf.d/mysqld.cnf
      - sudo cp s1/etc/nginx/nginx.conf /etc/nginx/nginx.conf
      - sudo cp s1/etc/nginx/sites-available/isucari.conf /etc/nginx/sites-available/isucari.conf
      - sudo nginx -t
      - sudo systemctl reload nginx
      - sudo systemctl restart mysql

  before-bench:
    desc: "rotate log / build / restart services"
    cmds:
      # rotate log
      - sudo rm -f /var/log/mysql/mysql-slow.log
      - sudo rm -f /var/log/nginx/access.log
      # restart mysql / nginx
      - sudo systemctl restart mysql
      - sudo nginx -t
      - sudo systemctl reload nginx
      # build app
      - cd ~/isucari && git pull
      - cd ~/isucari/webapp/go && make isucari
      - sudo systemctl restart isucari.golang.service

  analyze:
    desc: "analyze mysql / nginx log"
    cmds:
      - sudo pt-query-digest --filter 'length($event->{arg}) <= 4000' /var/log/mysql/mysql-slow.log > ~/isucari/log/$(date +mysql-slow.log-%m-%d-%H-%M -d "+9 hours")
      - sudo cat /var/log/nginx/access.log | alp ltsv -m "/users/\d+.json","/items/\d+.json","/new_items/\d+.json","/upload/.+.jpg","/transactions/\d+.png" --sort sum -r > ~/isucari/log/$(date +access.log-%m-%d-%H-%M -d "+9 hours")

  view-slow:
    desc: "view latest mysql slow log"
    cmds:
      - less $(ls ~/isucari/log/mysql-slow* | tail -n 1)

  view-log:
    desc: "view latest alp analyzed nginx log"
    cmds:
      - less $(ls ~/isucari/log/access.log* | tail -n 1)

  profile-pprof:
    # desc: "run pprof 30s"
    cmds:
      - go tool pprof http://localhost:6060/debug/pprof/profile?seconds=30

  profile-fgprof:
    # desc: "run fgprof 30s"
    cmds:
      - go tool pprof http://localhost:6060/debug/fgprof/profile?seconds=30

  profile:
    desc: "run pprof / fgprof for 30s"
    deps:
      - profile-pprof
      - profile-fgprof

  view-pprof:
    # desc: "view pprof profile localhost:6070"
    cmds:
      - go tool pprof -http=localhost:6070 $(ls ~/pprof/pprof.isucari.samples.cpu.* | tail -n 1)

  view-fgprof:
    # desc: "view fgprof profile localhost:6070"
    cmds:
      - go tool pprof -http=localhost:6071 $(ls ~/pprof/pprof.samples.time.* | tail -n 1)

  view-profile:
    desc: "view pprof / fgprof at 6070, 6071"
    deps:
      - view-pprof
      - view-fgprof