PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

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

Open vorpal-buildbot opened 6 months ago

vorpal-buildbot commented 6 months ago

[8, 10017] (slow_query, 91.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 069555aaea5cbda1cf137e4b05a4f47bf2974aaf

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