Exceeded slow_query limit (72.9 > 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 (72.9 > 60.0) in mysql: ```UPDATE person SET elo = IFNULL(elo, 1500) + %s WHERE id = %s``` #63515

Open vorpal-buildbot opened 1 month ago

vorpal-buildbot commented 1 month ago

[7, 5209] (slow_query, 72.9, mysql)

Reported on decksite by mysql-perf

Location Hash: fa41ca81f5f737fa1293ed1199abead62e253632

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '245641', 'opponent': '245655', 'result': '2–0', 'draws': '0', 'matchID': '270248398'} 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: 89fbe33b2bae1a03-EWR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 198.22.162.92 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

vorpal-buildbot commented 1 month ago

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

[5, 9143] (slow_query, 81.1, mysql)

Reported on decksite by mysql-perf

Location Hash: fa41ca81f5f737fa1293ed1199abead62e253632

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '245513', 'opponent': '245656', 'result': '2–1', 'draws': '0', 'matchID': '270248454'} 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: 89fbec31aa8f19db-EWR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 198.22.162.92 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 month ago

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

[7, 11185] (slow_query, 114.7, mysql)

Reported on decksite by mysql-perf

Location Hash: fa41ca81f5f737fa1293ed1199abead62e253632

Request Data

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

Labels: decksite

vorpal-buildbot commented 1 month ago

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

[7, 9000] (slow_query, 131.6, mysql)

Reported on decksite by mysql-perf

Location Hash: fa41ca81f5f737fa1293ed1199abead62e253632

Request Data

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

Labels: decksite