作業ログ

[motemen]

作業ログ

[motemen]

.ssh/config

Host isu01
  User isucon
  Hostname 35.76.23.211

Host isu02
  User isucon
  Hostname 35.73.159.202

Host isu03
  User isucon
  Hostname 35.74.221.161

これでよろしく

[motemen]

Mariadb 外部接続できるようにする

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'isucon'@'%' IDENTIFIED BY 'isucon' WITH GRANT OPTION;

これ書くサーバで

[motemen]

• isu01 nginx, app
• isu02 app
• isu03 db, あと app の /initialize のみ
  という担当で

[motemen]

スローログ

isu03

MariaDB [(none)]> SET GLOBAL slow_query_log_file = '/tmp/mysql-slow.log'
    -> ;
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> SET GLOBAL long_query_time = 0;
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> SET GLOBAL slow_query_log = ON;
Query OK, 0 rows affected (0.002 sec)

[motemen]

https://gist.github.com/motemen/5c848cd4f695fbeb415a9102ed28dcd8

[motemen]

こういう感じ

alp ltsv --file /var/log/nginx/access_log.ltsv -m '/api/condition/.*,/api/isu/[^/]*/icon,/api/isu/[^/]*/graph,/api/isu/[^/]*$,/isu/[^/]*/condition,/isu/[^/]*/graph,/isu/[^/]*$,/assets/.*' --sort sum --reverse

[motemen]

pt-query-digest #4 (comment)

[toricls]

dropProbaility まわりをコメントアウトしてまわしたジョブ

https://portal.isucon.net/contestant/benchmark_jobs/5526