vorpal-buildbot
commented
1 month ago Exceeded slow_query limit (139.2 > 60.0) in mysql: UPDATE person SET elo = IFNULL(elo, 1500) + %s WHERE id = %s
[9, 10540] (slow_query, 139.2, mysql)
Reported on decksite by mysql-perf
Location Hash: c74d9f1388cf332e8aca11d623273d38e8be15ff
Request Data
``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '248289', 'opponent': '248379', 'result': '2–1', 'draws': '0', 'matchID': '271450493'} 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: 8b616b006a345d1a-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
[7, 359](slow_query, 142.5, mysql)Reported on decksite by mysql-perf
Location Hash: c74d9f1388cf332e8aca11d623273d38e8be15ff
Request Data
``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '248098', 'opponent': '248006', 'result': '2–0', 'draws': '0', 'matchID': '271379720'} 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: 8b4dbf55ad4aaafb-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 ```