x-motemen/isucon11-qualifier

作業ログ

motemen opened this issue · 8 comments

motemen commented
作業ログ
motemen commented

.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

これでよろしく

  • 👍1
motemen commented

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

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

これ書くサーバで

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

スローログ

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 commented

こういう感じ

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 commented

pt-query-digest #4 (comment)

toricls commented

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

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