PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

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

Open vorpal-buildbot opened 3 months ago

vorpal-buildbot commented 3 months ago

[3, 7506] (slow_query, 75.7, mysql)

Reported on decksite by mysql-perf

Location Hash: ddb06c0a7c4b4bacd34603689f7b7874432430fe

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '247036', 'opponent': '247033', 'result': '2–0', 'draws': '0', 'matchID': '271163251'} 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: 8b0bd6a8bee7a95b-SYD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 159.196.238.229 Cdn-Loop: cloudflare Cf-Ipcountry: AU ```
vorpal-buildbot commented 3 months ago

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

[3, 3121] (slow_query, 88.3, mysql)

Reported on decksite by mysql-perf

Location Hash: ddb06c0a7c4b4bacd34603689f7b7874432430fe

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '247395', 'opponent': '247396', 'result': '2–0', 'draws': '0', 'matchID': '271219683'} 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: 8b1c45e2bccd5d18-SYD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 159.196.238.229 Cdn-Loop: cloudflare Cf-Ipcountry: AU ```

Labels: decksite