timeline

[sorah]

No description provided.

[rosylilly]

https://gist.github.com/kazeburo/bccc2d2b2b9dc307b5640ae855f3e0bf

[rosylilly]

https://gist.github.com/kazeburo/70b352e6d51969b214f919bcf0794ba6

[sorah]

DNS水責めがあるの、完全に kazeburo さんの恨み入ってそう

[sorah]

Host isu1
  HostName 52.69.112.84
Host isu2
  HostName 18.178.255.184
Host isu3
  HostName 57.180.97.87
Host isu1 isu2 isu3
  Port 22
  User isucon

[sorah]

JobId	56
57.180.97.87
3,444

[rosylilly]

これで3番の DNS 使いつつ他も使ってサービスアクセスできる

[mirakui]

Ruby
4,081

[sorah]

3,809

[sorah]

mysql> select User,Host from mysql.user;
+------------------+-----------+
| User             | Host      |
+------------------+-----------+
| debian-sys-maint | localhost |
| isucon           | localhost |
| isudns           | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
7 rows in set (0.00 sec)

mysql> update mysql.user set Host = '%' where User like 'isu%';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> ^DBye

[mirakui]

重クエリランキング発表
https://docs.google.com/spreadsheets/d/1OXH1GfMmxG8OtPZngS8tYgBoPUEbd3otYjaFifHtRoo/edit#gid=1969898504

[sorah]

なんもしてないのにスコア上がった 8996

[sorah]

score/11768

[sorah]

score/14447

[sorah]

icon オフロード 20160

[sorah]

50089

• さよならpdns
• さよなら theme
• stats counter cache
• moderation sqlクエリマシ

[sorah]

2023-11-25 04:43:09 - Mysql2::Error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1:
        /home/isucon/vendor/bundle/ruby/3.3.0+0/gems/mysql2-0.5.5/lib/mysql2/client.rb:151:in `_query'
        /home/isucon/vendor/bundle/ruby/3.3.0+0/gems/mysql2-0.5.5/lib/mysql2/client.rb:151:in `block in query'
        /home/isucon/vendor/bundle/ruby/3.3.0+0/gems/mysql2-0.5.5/lib/mysql2/client.rb:150:in `handle_interrupt'
        /home/isucon/vendor/bundle/ruby/3.3.0+0/gems/mysql2-0.5.5/lib/mysql2/client.rb:150:in `query'
        /home/isucon/vendor/bundle/ruby/3.3.0+0/gems/mysql2-cs-bind-0.1.1/lib/mysql2-cs-bind.rb:11:in `xquery'
        /home/isucon/git/webapp/ruby/app.rb:656:in `block (2 levels) in <class:App>'
        /home/isucon/git/webapp/ruby/app.rb:75:in `db_transaction'
        /home/isucon/git/webapp/ruby/app.rb:642:in `block in <class:App>'

syntax error出しちゃったねえ＾＾

[mirakui]

88,874

[sorah]

15:26 に 92110 は出てる

[sorah]

15:57 109,465

[sorah]

反省: エンドポイントが負荷レベルに寄与してるか怪しいと思ったら sleep を入れてみよう

[sorah]

反省2: ローカルTLS終端できる便利設定くらいは事前に手配しよう

でもフロントエンド壊れてたんだよな

[sorah]

反省: 304をappに寄せたけどそのpumaへの影響をちゃんと確認しておくべきだった

[mirakui]

ベンチマーカーが送ってくるリクエストをキャプチャしといて手元で再現する何かを用意したい