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

Open vorpal-buildbot opened 2 weeks ago

vorpal-buildbot commented 2 weeks ago

[7, 10861] (slow_query, 120.8, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '251396', 'opponent': '251517', 'result': '2–1', 'draws': '0', 'matchID': '272765317'} Content-Type: application/x-www-form-urlencoded Content-Length: 116 Cf-Ray: 8cdc4e651c3c0f9b-EWR Cf-Ipcountry: US Host: pennydreadfulmagic.com X-Forwarded-For: 198.22.162.92 Accept-Encoding: gzip, br X-Forwarded-Proto: https Cdn-Loop: cloudflare; loops=1 Cf-Connecting-Ip: 198.22.162.92 Cf-Visitor: {"scheme":"https"} User-Agent: PennyDeadfulBot Connection: Keep-Alive ```

vorpal-buildbot commented 2 weeks ago

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

[6, 7854] (slow_query, 91.0, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

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

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

[4, 757] (slow_query, 115.9, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

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

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

[8, 11037] (slow_query, 345.1, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

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

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

[5, 8973] (slow_query, 81.7, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

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

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

[8, 9352] (slow_query, 75.6, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '251734', 'opponent': '251905', 'result': '2–1', 'draws': '0', 'matchID': '272830204'} Content-Type: application/x-www-form-urlencoded Content-Length: 116 Cf-Ray: 8cf0f1b9bd2632e4-EWR Cf-Ipcountry: US Host: pennydreadfulmagic.com X-Forwarded-For: 198.22.162.92 Accept-Encoding: gzip, br X-Forwarded-Proto: https Cdn-Loop: cloudflare; loops=1 Cf-Connecting-Ip: 198.22.162.92 Cf-Visitor: {"scheme":"https"} User-Agent: PennyDeadfulBot Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 1 week ago

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

[4, 8411] (slow_query, 85.5, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '252335'), ('session', '.eJx1UctugzAQ_BefacTDGMitKc1DidJIoVXVqkIWLARibGIbKVGUf69BTTlUPfgwO7Ozu-MrSluQDeXANZpq2YGFaN5UHE0LypRBOTRVI_IRVyoTMk8rU0IRxoR4rmuHTog94uAAjQomMsrAqIA_vO4N8X9LxdOyq1h-X4GJsoS8X00JPowKseNYqNGlSDsFktOmd3YLIR3zXOMhaKcPbqo01T2VeLm3S2hOEhxvHnGxpLXUbo3VU7xii1GvxRHMtVdEswyUumOkl8EbiTcBn8e-d0pITU_PutlDELWzl8j0w7mtJKiUmuCcwPUDj4ShN_GjwPGIP_J9lsTGoW1bSEJhSoffIZy08bbG791yffnYwrpbkUV0XJyDVTHfxWaISbI113yiIR41qYWxs37QEKn5uKq4oC8LDaapvvQNaAZUgkQ3C_0JUVNZglmad4zdvgGO1aOE.ZwmVNw.efsdsU4YNkdUHHgF-hPmRwvBsxo'), ('views', '100')]) Endpoint: add_report View Args: {} Person: 944663220818436147 Referrer: https://pennydreadfulmagic.com/report/ Request Data: {'entry': '252335', 'opponent': '252319', 'result': '2–0', 'draws': '0'} Content-Type: application/x-www-form-urlencoded Content-Length: 55 Cf-Ray: 8d11dc5459382d47-DFW Cookie: hide_intro=True; page_size=20; deck_id=252335; session=.eJx1UctugzAQ_BefacTDGMitKc1DidJIoVXVqkIWLARibGIbKVGUf69BTTlUPfgwO7Ozu-MrSluQDeXANZpq2YGFaN5UHE0LypRBOTRVI_IRVyoTMk8rU0IRxoR4rmuHTog94uAAjQomMsrAqIA_vO4N8X9LxdOyq1h-X4GJsoS8X00JPowKseNYqNGlSDsFktOmd3YLIR3zXOMhaKcPbqo01T2VeLm3S2hOEhxvHnGxpLXUbo3VU7xii1GvxRHMtVdEswyUumOkl8EbiTcBn8e-d0pITU_PutlDELWzl8j0w7mtJKiUmuCcwPUDj4ShN_GjwPGIP_J9lsTGoW1bSEJhSoffIZy08bbG791yffnYwrpbkUV0XJyDVTHfxWaISbI113yiIR41qYWxs37QEKn5uKq4oC8LDaapvvQNaAZUgkQ3C_0JUVNZglmad4zdvgGO1aOE.ZwmVNw.efsdsU4YNkdUHHgF-hPmRwvBsxo; views=100 Host: pennydreadfulmagic.com Cf-Ipcountry: US Accept-Encoding: gzip, br X-Forwarded-For: 2600:100c:a223:4760:75b5:2f57:4118:3b0c X-Forwarded-Proto: https Priority: u=0, i Accept-Language: en-US,en;q=0.9 Cf-Visitor: {"scheme":"https"} Referer: https://pennydreadfulmagic.com/report/ Sec-Fetch-Dest: document Cf-Connecting-Ip: 2600:100c:a223:4760:75b5:2f57:4118:3b0c Cdn-Loop: cloudflare; loops=1 Sec-Fetch-User: ?1 Connection: Keep-Alive Sec-Fetch-Mode: navigate Cache-Control: max-age=0 Sec-Ch-Ua: "Google Chrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.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 ```

Labels: decksite

vorpal-buildbot commented 1 week ago

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

[6, 2566] (slow_query, 117.1, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '252285', 'opponent': '252334', 'result': '2–1', 'draws': '0', 'matchID': '272930132'} Content-Type: application/x-www-form-urlencoded Content-Length: 116 Cf-Ray: 8d11db8f0e26429b-EWR X-Forwarded-For: 198.22.162.92 Host: pennydreadfulmagic.com Accept-Encoding: gzip, br X-Forwarded-Proto: https User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 198.22.162.92 Cf-Visitor: {"scheme":"https"} Cf-Ipcountry: US Connection: Keep-Alive Cdn-Loop: cloudflare; loops=1 ```

Labels: decksite

vorpal-buildbot commented 1 week ago

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

[5, 10994] (slow_query, 71.8, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '252326', 'opponent': '252405', 'result': '2–0', 'draws': '0', 'matchID': '272941143'} Content-Type: application/x-www-form-urlencoded Content-Length: 116 Cf-Ray: 8d15fc0279c05e66-EWR X-Forwarded-For: 198.22.162.92 Host: pennydreadfulmagic.com Accept-Encoding: gzip, br X-Forwarded-Proto: https User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 198.22.162.92 Cf-Visitor: {"scheme":"https"} Cf-Ipcountry: US Connection: Keep-Alive Cdn-Loop: cloudflare; loops=1 ```

Labels: decksite

vorpal-buildbot commented 1 week ago

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

[3, 9650] (slow_query, 72.5, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '252532', 'opponent': '252534', 'result': '2–1', 'draws': '0', 'matchID': '272965185'} Content-Type: application/x-www-form-urlencoded Content-Length: 116 Cf-Ray: 8d1e3aa5cff6c434-EWR X-Forwarded-For: 198.22.162.92 Host: pennydreadfulmagic.com Accept-Encoding: gzip, br X-Forwarded-Proto: https User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 198.22.162.92 Cf-Visitor: {"scheme":"https"} Cf-Ipcountry: US Connection: Keep-Alive Cdn-Loop: cloudflare; loops=1 ```

Labels: decksite

vorpal-buildbot commented 1 week ago

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

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

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '252821'), ('session', '.eJx1UdtOwkAQ_Zd9rqZ3Km9cFEOEQFAhGNOs7bRd2Uvd3Qpo-HenJNgH4-OZOTNzzplvktagBZUgLelb3YBDaC6YJP2CcoMoB8GEyjvMTKZ0njIsEa-X9Pwo8PxeELuu74YJ6RhcZZQDskBePa2w8f8Ik2nZMJ5fJHBVlpC30oyS51NhEkYOEbZUaWNASyrazRUVAoGkjOMWRRtb-amx1LbN2WQxXi72RQ2zTS2mh8pUb4dwHRdxtp_bjm_VDtDvN6FZBsZcMJl7Yiq_avn44dYBv5fep_IHw1G28KfryRbn4VAzDSalGJ3X85P4Br1F15EbxkEUdP02zRiNuq5DNBRYqn6P3M03g7g43u6WZv082j2Mj8NRzac22KnV9h2PYJY1unnB9PBHrDhi7ZyVIa8OOa9J7bGlkCFQDZqcHPInOEt1CShTNpyffgDbgaKD.ZxDVMw.GOMIYepKJbLLq-3KmIWYnWvAGzw'), ('views', '2776')]) Endpoint: add_report View Args: {} Person: 178725312736002048 Referrer: https://pennydreadfulmagic.com/report/ Request Data: {'entry': '252821', 'opponent': '252854', 'result': '1–2', 'draws': '0'} Content-Type: application/x-www-form-urlencoded Content-Length: 55 Cf-Ray: 8d3f2c60dc88b3bb-MIA Cookie: hide_intro=True; page_size=20; deck_id=252821; session=.eJx1UdtOwkAQ_Zd9rqZ3Km9cFEOEQFAhGNOs7bRd2Uvd3Qpo-HenJNgH4-OZOTNzzplvktagBZUgLelb3YBDaC6YJP2CcoMoB8GEyjvMTKZ0njIsEa-X9Pwo8PxeELuu74YJ6RhcZZQDskBePa2w8f8Ik2nZMJ5fJHBVlpC30oyS51NhEkYOEbZUaWNASyrazRUVAoGkjOMWRRtb-amx1LbN2WQxXi72RQ2zTS2mh8pUb4dwHRdxtp_bjm_VDtDvN6FZBsZcMJl7Yiq_avn44dYBv5fep_IHw1G28KfryRbn4VAzDSalGJ3X85P4Br1F15EbxkEUdP02zRiNuq5DNBRYqn6P3M03g7g43u6WZv082j2Mj8NRzac22KnV9h2PYJY1unnB9PBHrDhi7ZyVIa8OOa9J7bGlkCFQDZqcHPInOEt1CShTNpyffgDbgaKD.ZxDVMw.GOMIYepKJbLLq-3KmIWYnWvAGzw; views=2776 Host: pennydreadfulmagic.com Cf-Ipcountry: US Accept-Encoding: gzip, br X-Forwarded-For: 75.201.66.148 X-Forwarded-Proto: https Priority: u=0, i Accept-Language: en-US,en;q=0.9 Cf-Visitor: {"scheme":"https"} Referer: https://pennydreadfulmagic.com/report/ Sec-Fetch-Dest: document Cf-Connecting-Ip: 75.201.66.148 Cdn-Loop: cloudflare; loops=1 Sec-Fetch-User: ?1 Connection: Keep-Alive Sec-Fetch-Mode: navigate Cache-Control: max-age=0 Sec-Ch-Ua: "Not)A;Brand";v="99", "Opera GX";v="113", "Chromium";v="127" 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/127.0.0.0 Safari/537.36 OPR/113.0.0.0 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 ```

Labels: decksite

vorpal-buildbot commented 5 days ago

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

[5, 4065] (slow_query, 107.0, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '251622', 'opponent': '252897', 'result': '2–0', 'draws': '0', 'matchID': '273122422'} Content-Type: application/x-www-form-urlencoded Content-Length: 116 Cf-Ray: 8d53c6687e5142ac-EWR X-Forwarded-For: 198.22.162.92 Host: pennydreadfulmagic.com Accept-Encoding: gzip, br X-Forwarded-Proto: https User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 198.22.162.92 Cf-Visitor: {"scheme":"https"} Cf-Ipcountry: US Connection: Keep-Alive Cdn-Loop: cloudflare; loops=1 ```

Labels: decksite

vorpal-buildbot commented 5 hours ago

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

[2, 8280] (slow_query, 77.2, mysql)

Reported on decksite by mysql-perf

Location Hash: a023f7a207234f099f486454bcd2db187f993961

Request Data

``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '253332', 'opponent': '253254', 'result': '2–0', 'draws': '0', 'matchID': '273242497'} Content-Type: application/x-www-form-urlencoded Content-Length: 116 Cf-Ray: 8d7d08059e0a43f9-EWR X-Forwarded-For: 198.22.162.92 Host: pennydreadfulmagic.com Accept-Encoding: gzip, br X-Forwarded-Proto: https User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 198.22.162.92 Cf-Visitor: {"scheme":"https"} Cf-Ipcountry: US Connection: Keep-Alive Cdn-Loop: cloudflare; loops=1 ```

Labels: decksite