Exceeded slow_query limit (95.1 > 60.0) in mysql: ```UPDATE person SET elo = IFNULL(elo, 1500) + %s WHERE id = %s```

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (95.1 > 60.0) in mysql: ```UPDATE person SET elo = IFNULL(elo, 1500) + %s WHERE id = %s``` #63646

Open vorpal-buildbot opened 3 days ago

vorpal-buildbot commented 3 days ago

[3, 8619] (slow_query, 95.1, mysql)

Reported on decksite by mysql-perf

Location Hash: b75f026d934c5a6015f888eead771bd04756c1c4

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '250262', 'opponent': '250263', 'result': '2–1', 'draws': '0', 'matchID': '272232228'} Content-Type: application/x-www-form-urlencoded Content-Length: 116 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 198.22.162.92 Cf-Ray: 8c3472de581b7ca5-EWR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 198.22.162.92 Cdn-Loop: cloudflare; loops=1 Cf-Ipcountry: US ```

vorpal-buildbot commented 3 days ago

Exceeded slow_query limit (136.1 > 60.0) in mysql: UPDATE person SET elo = IFNULL(elo, 1500) + %s WHERE id = %s

[3, 143] (slow_query, 136.1, mysql)

Reported on decksite by mysql-perf

Location Hash: b75f026d934c5a6015f888eead771bd04756c1c4

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '250266', 'opponent': '250265', 'result': '2–0', 'draws': '0', 'matchID': '272232642'} Content-Type: application/x-www-form-urlencoded Content-Length: 116 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 198.22.162.92 Cf-Ray: 8c347f6a28a3177c-EWR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 198.22.162.92 Cdn-Loop: cloudflare; loops=1 Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 15 hours ago

Exceeded slow_query limit (68.8 > 60.0) in mysql: UPDATE person SET elo = IFNULL(elo, 1500) + %s WHERE id = %s

[4, 11147] (slow_query, 68.8, mysql)

Reported on decksite by mysql-perf

Location Hash: b75f026d934c5a6015f888eead771bd04756c1c4

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '250502', 'opponent': '250501', 'result': '2–1', 'draws': '0', 'matchID': '272320371'} Content-Type: application/x-www-form-urlencoded Content-Length: 116 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 159.196.238.229 Cf-Ray: 8c4d29542f89aadd-SYD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 159.196.238.229 Cdn-Loop: cloudflare; loops=1 Cf-Ipcountry: AU ```

Labels: decksite