search

tetsuzawa / isucon12-qualify-suburi-0730

0 stars 0 forks source link

mysqlをBのみに #19

Closed tetsuzawa closed 2 years ago

tetsuzawa commented 2 years ago

/etc/mysql/mysql.conf.d/mysqld.cnf

127.0.0.1 -> 0.0.0.0

RENAME USER 'root'@'localhost' TO 'root'@'%';
tetsuzawa commented 2 years ago 
13:14:03.666801 SCORE: 1561 (+1576 -15(1%))
[ADMIN] 13:14:03.666899 score.ScoreTable{
  "GET /api/admin/tenants/billing":                         0,
  "GET /api/organizer/billing":                             3,
  "GET /api/organizer/players/list":                        6,
  "GET /api/player/competition/:competition_id/ranking":    1162,
  "GET /api/player/competitions":                           112,
  "GET /api/player/player/:player_name":                    25,
  "POST /api/admin/tenants/add":                            2,
  "POST /api/organizer/competition/:competition_id/finish": 4,
  "POST /api/organizer/competition/:competition_id/score":  7,
  "POST /api/organizer/competitions/add":                   8,
  "POST /api/organizer/player/:player_name/disqualified":   1,
  "POST /api/organizer/players/add":                        3,
}
tetsuzawa commented 2 years ago 
13:33:04.057557 SCORE: 958 (+1212 -254(21%))
[ADMIN] 13:33:04.057666 score.ScoreTable{
  "GET /api/admin/tenants/billing":                         0,
  "GET /api/organizer/billing":                             4,
  "GET /api/organizer/players/list":                        6,
  "GET /api/player/competition/:competition_id/ranking":    772,
  "GET /api/player/competitions":                           74,
  "GET /api/player/player/:player_name":                    70,
  "POST /api/admin/tenants/add":                            2,
  "POST /api/organizer/competition/:competition_id/finish": 5,
  "POST /api/organizer/competition/:competition_id/score":  6,
  "POST /api/organizer/competitions/add":                   9,
  "POST /api/organizer/player/:player_name/disqualified":   0,
  "POST /api/organizer/players/add":                        3,
}