search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

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

Open vorpal-buildbot opened 6 months ago

vorpal-buildbot commented 6 months ago

[6, 7595] (slow_query, 202.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 450d9192dc3e9f2ba3ce5a8a230bec0dc43631a2

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '242773', 'opponent': '242797', 'result': '2–1', 'draws': '0', 'matchID': '268794130'} 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: 885fe4150bb63e5d-ADL 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 6 months ago

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

[4, 7867] (slow_query, 139.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 450d9192dc3e9f2ba3ce5a8a230bec0dc43631a2

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '242883', 'opponent': '242811', 'result': '2–1', 'draws': '0', 'matchID': '268824241'} 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: 88681bcb593f3771-MEL 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 5 months ago

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

[5, 11099] (slow_query, 19.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 450d9192dc3e9f2ba3ce5a8a230bec0dc43631a2

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '243014', 'opponent': '243022', 'result': '2–1', 'draws': '0', 'matchID': '268884733'} 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: 8878a5b41dcf2b38-MEL 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 5 months ago

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

[3, 11113] (slow_query, 61.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 450d9192dc3e9f2ba3ce5a8a230bec0dc43631a2

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '243530', 'opponent': '243568', 'result': '2–0', 'draws': '0', 'matchID': '269097890'} 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: 88ba8400ebbe2e94-MEL 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 5 months ago

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

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

Reported on decksite by mysql-perf

Location Hash: 450d9192dc3e9f2ba3ce5a8a230bec0dc43631a2

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

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

[6, 3528] (slow_query, 65.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 450d9192dc3e9f2ba3ce5a8a230bec0dc43631a2

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '244739'), ('session', '.eJx1UctuwjAQ_BefU5SH84Ab6UMFKqCFolZVFVnJJjF17MR2BAHx73WoKIeqN8_O7M7u-IiSGmRFOHCNRlq2YCGSVZSjUU6YMiiDilYiu2KqUiGzhJoSwq7nYdcOHCcYDj3s4RBdFUykhIFRAb95XRni_xbKk6KlLLuswERRQNavpgQ_W3m-G1mo0oVIWgWSk6qfvBVccbFzHWyGCNLq0k2UJrrnGrxu9k-35XY2XcUVmy9eHkVoL8h-c5h00VWvxReYc4-IpCkodcEoJfu4w_N41q3GzVzVYTfZHfzyLsDN8_LN9MO-phJUQkxyTuiEfuBHjjvAoY_94ZXuswxsHNm2hSTkplT-ejxEeVnlm_WkbnjLm_swXs7ZeAprunqvfeNhkqzNMR_oHI86h2i-iuadef7UBlthLD4tdB6a6K5vQDEQCRKdLPQnRE1kAWZn3jJ2-gbReaY0.Zm9_WQ.Gok9DgWD-E1Ti6B6J7ls87KgvPA'), ('views', '45')]) Endpoint: add_report View Args: {} Person: 423342061169934347 Referrer: https://pennydreadfulmagic.com/report/ Request Data: {'entry': '244739', 'opponent': '244740', 'result': '2–1', 'draws': '0'} Content-Type: application/x-www-form-urlencoded Content-Length: 55 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 2601:602:782:71c0:d804:ed85:8f64:e03d Cf-Ray: 894ed3b5bad7c58e-SEA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Google Chrome";v="125", "Chromium";v="125", "Not.A/Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/report/ Accept-Language: en-US,en;q=0.9 Priority: u=0, i Cookie: hide_intro=True; deck_id=244739; session=.eJx1UctuwjAQ_BefU5SH84Ab6UMFKqCFolZVFVnJJjF17MR2BAHx73WoKIeqN8_O7M7u-IiSGmRFOHCNRlq2YCGSVZSjUU6YMiiDilYiu2KqUiGzhJoSwq7nYdcOHCcYDj3s4RBdFUykhIFRAb95XRni_xbKk6KlLLuswERRQNavpgQ_W3m-G1mo0oVIWgWSk6qfvBVccbFzHWyGCNLq0k2UJrrnGrxu9k-35XY2XcUVmy9eHkVoL8h-c5h00VWvxReYc4-IpCkodcEoJfu4w_N41q3GzVzVYTfZHfzyLsDN8_LN9MO-phJUQkxyTuiEfuBHjjvAoY_94ZXuswxsHNm2hSTkplT-ejxEeVnlm_WkbnjLm_swXs7ZeAprunqvfeNhkqzNMR_oHI86h2i-iuadef7UBlthLD4tdB6a6K5vQDEQCRKdLPQnRE1kAWZn3jJ2-gbReaY0.Zm9_WQ.Gok9DgWD-E1Ti6B6J7ls87KgvPA; views=45 Cf-Connecting-Ip: 2601:602:782:71c0:d804:ed85:8f64:e03d Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 5 months ago

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

[5, 11113] (slow_query, 82.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 450d9192dc3e9f2ba3ce5a8a230bec0dc43631a2

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