PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

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

Open vorpal-buildbot opened 3 weeks ago

vorpal-buildbot commented 3 weeks ago

[6, 11227] (slow_query, 97.6, mysql)

Reported on decksite by mysql-perf

Location Hash: f596fea0098890d2ac0808b5dc144b602c5eb3fb

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

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

[7, 11253] (slow_query, 132.7, mysql)

Reported on decksite by mysql-perf

Location Hash: f596fea0098890d2ac0808b5dc144b602c5eb3fb

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

vorpal-buildbot commented 2 weeks ago

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

[6, 4437] (slow_query, 91.5, mysql)

Reported on decksite by mysql-perf

Location Hash: f596fea0098890d2ac0808b5dc144b602c5eb3fb

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

vorpal-buildbot commented 2 weeks ago

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

[6, 1890] (slow_query, 128.1, mysql)

Reported on decksite by mysql-perf

Location Hash: f596fea0098890d2ac0808b5dc144b602c5eb3fb

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

vorpal-buildbot commented 1 week ago

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

[7, 7750] (slow_query, 90.9, mysql)

Reported on decksite by mysql-perf

Location Hash: f596fea0098890d2ac0808b5dc144b602c5eb3fb

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

vorpal-buildbot commented 1 week ago

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

[8, 3117] (slow_query, 64.8, mysql)

Reported on decksite by mysql-perf

Location Hash: f596fea0098890d2ac0808b5dc144b602c5eb3fb

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