PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (123.0 > 60.0) in mysql: ```INSERT INTO `match` (`date`, `round`, elimination, mtgo_id) VALUES (%s, %s, %s, %s)``` #63616

Open vorpal-buildbot opened 2 months ago

vorpal-buildbot commented 2 months ago

[1724976492, None, None, '271737438'] (slow_query, 123.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 7ef47db0afe7e9b9421f79b3b2cc11f3818771a0

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '249084', 'opponent': '249081', 'result': '2–0', 'draws': '0', 'matchID': '271737438'} 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: 8bb08b7f6b5a5c07-SYD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 159.196.238.229 Cdn-Loop: cloudflare; loops=1 Cf-Ipcountry: AU ```
vorpal-buildbot commented 2 months ago

Exceeded slow_query limit (101.2 > 60.0) in mysql: INSERT INTO `match` (`date`, `round`, elimination, mtgo_id) VALUES (%s, %s, %s, %s)

[1725494892, None, None, '271932788'] (slow_query, 101.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 7ef47db0afe7e9b9421f79b3b2cc11f3818771a0

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

Exceeded slow_query limit (136.2 > 60.0) in mysql: INSERT INTO `match` (`date`, `round`, elimination, mtgo_id) VALUES (%s, %s, %s, %s)

[1725840466, None, None, '272057083'] (slow_query, 136.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 7ef47db0afe7e9b9421f79b3b2cc11f3818771a0

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