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

Open vorpal-buildbot opened 1 month ago

vorpal-buildbot commented 1 month ago

[6, 9995] (slow_query, 193.5, mysql)

Reported on decksite by mysql-perf

Location Hash: eae2440fb248a01a4d98bf42c9960689614267b7

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '250547', 'opponent': '250544', 'result': '2–0', 'draws': '0', 'matchID': '272341144'} 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: 8c5566b7ba707277-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 1 month ago

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

[6, 11293] (slow_query, 154.8, mysql)

Reported on decksite by mysql-perf

Location Hash: eae2440fb248a01a4d98bf42c9960689614267b7

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '250549', 'opponent': '250545', 'result': '2–0', 'draws': '0', 'matchID': '272341459'} 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: 8c5579295a4e17b1-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 1 month ago

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

[8, 7595] (slow_query, 66.3, mysql)

Reported on decksite by mysql-perf

Location Hash: eae2440fb248a01a4d98bf42c9960689614267b7

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '250609', 'opponent': '250612', 'result': '2–1', 'draws': '0', 'matchID': '272365457'} 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: 8c5db19e3d1a434a-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 1 month ago

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

[4, 10135] (slow_query, 143.5, mysql)

Reported on decksite by mysql-perf

Location Hash: eae2440fb248a01a4d98bf42c9960689614267b7

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '250679', 'opponent': '250678', 'result': '2–0', 'draws': '0', 'matchID': '272387799'} 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: 8c65dda29f3103d5-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