search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

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

Open vorpal-buildbot opened 1 year ago

vorpal-buildbot commented 1 year ago

[6, 7318] (slow_query, 93.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 7c444269b75c6da6f4d556ac4b2147d21d9d1b48

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '219533'), ('views', '94')]) Endpoint: add_report View Args: {} Person: logged_out Referrer: https://pennydreadfulmagic.com/report/ Request Data: {'entry': '219533', 'opponent': '219567', 'result': '2–0', 'draws': '0'} Content-Type: application/x-www-form-urlencoded Content-Length: 55 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 184.163.106.36 Cf-Ray: 7df2334ddaecca53-YUL X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Not.A/Brand";v="8", "Chromium";v="114", "Google Chrome";v="114" 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/114.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,fr;q=0.8 Cookie: hide_intro=True; deck_id=219533; views=94 Priority: u=0, i Cdn-Loop: cloudflare Cf-Connecting-Ip: 184.163.106.36 Cf-Ipcountry: CA ```
vorpal-buildbot commented 1 year ago

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

[3, 742] (slow_query, 67.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 7c444269b75c6da6f4d556ac4b2147d21d9d1b48

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

Labels: decksite

vorpal-buildbot commented 1 year ago

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

[6, 3114] (slow_query, 71.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 7c444269b75c6da6f4d556ac4b2147d21d9d1b48

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

Labels: decksite

vorpal-buildbot commented 1 year ago

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

[5, 4662] (slow_query, 75.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 7c444269b75c6da6f4d556ac4b2147d21d9d1b48

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

Labels: decksite

vorpal-buildbot commented 1 year ago

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

[7, 1196] (slow_query, 98.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 7c444269b75c6da6f4d556ac4b2147d21d9d1b48

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

Labels: decksite

vorpal-buildbot commented 1 year ago

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

[5, 10219] (slow_query, 95.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 7c444269b75c6da6f4d556ac4b2147d21d9d1b48

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

Labels: decksite

vorpal-buildbot commented 1 year ago

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

[3, 8411] (slow_query, 82.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 7c444269b75c6da6f4d556ac4b2147d21d9d1b48

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([('page_size', '20'), ('hide_intro', 'True'), ('deck_id', '222012'), ('session', '.eJx1UctOwzAQ_BefQ-Ukbppyo0UCtUKteKcIRSbepAE_EtupGhD_zqZS6QFx8GF2Zmd3x18kb8AqrkF7cu5tBwHhQtWanJdcOkQCVK2MOOHaFcaKvMYSmTKWJHEU0TRMWZyEbEJOCmkKLgFVoM8e7pD4v6XWedXVUhxXkKaqQAyrOaMPo1IWhgFRvjJ558BqrgbnqDQ2xBehh-Gd30a589wP1Kf8qFbjbL55KjMxz5Tc9vcbev32Tvd0sz_pvfkAvPaL8KIA546YzJr1TXYrMs7aZcq6oqStvuTrcnkR69UO-2Hf1BZczjG4MJmG8XgSR9PRJGE0TdmJH7JMKEspDYiFEkvb3yFrNQt7xvkzXSnYLXY3ol2otn2Q7PFqXuEQTLLBa14wO_yhuuyxdkjKjd4NOh8ReQ3IwTT3_dBAZsAtWPIdkD8hem4rwKV1J-X3D7QTpfs.ZMmegQ.F4cLZeAyxuYNZa496g4IoPdNjSY'), ('views', '159')]) Endpoint: add_report View Args: {} Person: 944663220818436147 Referrer: https://pennydreadfulmagic.com/report/ Request Data: {'entry': '222012', 'opponent': '222010', 'result': '2–1', 'draws': '0'} Content-Type: application/x-www-form-urlencoded Content-Length: 55 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 2600:1700:24d3:70:2c2b:4af:5417:2078 Cf-Ray: 7f02167c7cda45e7-DFW X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Not/A)Brand";v="99", "Microsoft Edge";v="115", "Chromium";v="115" 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/115.0.0.0 Safari/537.36 Edg/115.0.1901.188 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,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 Cookie: page_size=20; hide_intro=True; deck_id=222012; session=.eJx1UctOwzAQ_BefQ-Ukbppyo0UCtUKteKcIRSbepAE_EtupGhD_zqZS6QFx8GF2Zmd3x18kb8AqrkF7cu5tBwHhQtWanJdcOkQCVK2MOOHaFcaKvMYSmTKWJHEU0TRMWZyEbEJOCmkKLgFVoM8e7pD4v6XWedXVUhxXkKaqQAyrOaMPo1IWhgFRvjJ558BqrgbnqDQ2xBehh-Gd30a589wP1Kf8qFbjbL55KjMxz5Tc9vcbev32Tvd0sz_pvfkAvPaL8KIA546YzJr1TXYrMs7aZcq6oqStvuTrcnkR69UO-2Hf1BZczjG4MJmG8XgSR9PRJGE0TdmJH7JMKEspDYiFEkvb3yFrNQt7xvkzXSnYLXY3ol2otn2Q7PFqXuEQTLLBa14wO_yhuuyxdkjKjd4NOh8ReQ3IwTT3_dBAZsAtWPIdkD8hem4rwKV1J-X3D7QTpfs.ZMmegQ.F4cLZeAyxuYNZa496g4IoPdNjSY; views=159 Priority: u=0, i Cdn-Loop: cloudflare Cf-Connecting-Ip: 2600:1700:24d3:70:2c2b:4af:5417:2078 Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 year ago

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

[3, 8411] (slow_query, 69.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 7c444269b75c6da6f4d556ac4b2147d21d9d1b48

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

Labels: decksite

vorpal-buildbot commented 1 year ago

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

[8, 10732] (slow_query, 76.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 7c444269b75c6da6f4d556ac4b2147d21d9d1b48

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([('views', '301'), ('page_size', '20'), ('hide_intro', 'True'), ('session', '.eJx1UdtOwjAYfpdeT9KtbIB3QmRCNAQuFDBmadZuK3YttJ3jEN7dfzO4C-Ndv__0HXpByZ6bkiquHLp3puIeoqwUCt1nVFpAjJei1KzDwqbasERACZF-iIk_HJBRiEM_DLCPugmpUyo5TO3d3XgFjf9XhErySkh2kyB1nnPWSLNatVRhEGEPlS7XSWW5UbRsLsuK1SLPjHAarmhauSJIrKOuaR5iMdgwf_owpUW5dDjAGdvFu_N2bgSNu3mnPzn4vSCaptzaG0Zbv6ZOxCTarteb2EwWT3aQLuRMndSZcNjnx70w3CYUovMj8BNFgxHp4T7xiR91_SbNCPeHGBwYnkGp-CX5yogosvHbfLV5fI7q12B2WE7zoD5OMvFSAQlkuQc376gNyLYxwmeJ7ATPn1pvp4Hiw0Pt0cSdmgU05tRwg64e-hOjoybnIFpVUl6_AXkWpwA.ZQD-zQ.sAVsV5s6Ua2vkYz_lceuFKrTVuM'), ('session', '.eJx1UdtOwjAYfpdeT9KtbIB3QmRCNAQuFDBmadZuK3YttJ3jEN7dfzO4C-Ndv__0HXpByZ6bkiquHLp3puIeoqwUCt1nVFpAjJei1KzDwqbasERACZF-iIk_HJBRiEM_DLCPugmpUyo5TO3d3XgFjf9XhErySkh2kyB1nnPWSLNatVRhEGEPlS7XSWW5UbRsLsuK1SLPjHAarmhauSJIrKOuaR5iMdgwf_owpUW5dDjAGdvFu_N2bgSNu3mnPzn4vSCaptzaG0Zbv6ZOxCTarteb2EwWT3aQLuRMndSZcNjnx70w3CYUovMj8BNFgxHp4T7xiR91_SbNCPeHGBwYnkGp-CX5yogosvHbfLV5fI7q12B2WE7zoD5OMvFSAQlkuQc376gNyLYxwmeJ7ATPn1pvp4Hiw0Pt0cSdmgU05tRwg64e-hOjoybnIFpVUl6_AXkWpwA.ZQDttw.ktPkoJvW_qnj0qtKWY2H0sv8d9o'), ('deck_id', '224501')]) Endpoint: add_report View Args: {} Person: 345031873950515201 Referrer: https://pennydreadfulmagic.com/report/ Request Data: {'entry': '224501', 'opponent': '224504', 'result': '1–2', 'draws': '0'} Content-Type: application/x-www-form-urlencoded Content-Length: 55 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 2804:14c:115:9369:51b4:f25a:c596:a79c Cf-Ray: 805c304e1fa00c9e-EWR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/117.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8 Accept-Language: pt-BR,pt;q=0.8,en-US;q=0.5,en;q=0.3 Origin: https://pennydreadfulmagic.com Dnt: 1 Referer: https://pennydreadfulmagic.com/report/ Upgrade-Insecure-Requests: 1 Sec-Fetch-Dest: document Sec-Fetch-Mode: navigate Sec-Fetch-Site: same-origin Sec-Fetch-User: ?1 Cookie: views=301; page_size=20; hide_intro=True; session=.eJx1UdtOwjAYfpdeT9KtbIB3QmRCNAQuFDBmadZuK3YttJ3jEN7dfzO4C-Ndv__0HXpByZ6bkiquHLp3puIeoqwUCt1nVFpAjJei1KzDwqbasERACZF-iIk_HJBRiEM_DLCPugmpUyo5TO3d3XgFjf9XhErySkh2kyB1nnPWSLNatVRhEGEPlS7XSWW5UbRsLsuK1SLPjHAarmhauSJIrKOuaR5iMdgwf_owpUW5dDjAGdvFu_N2bgSNu3mnPzn4vSCaptzaG0Zbv6ZOxCTarteb2EwWT3aQLuRMndSZcNjnx70w3CYUovMj8BNFgxHp4T7xiR91_SbNCPeHGBwYnkGp-CX5yogosvHbfLV5fI7q12B2WE7zoD5OMvFSAQlkuQc376gNyLYxwmeJ7ATPn1pvp4Hiw0Pt0cSdmgU05tRwg64e-hOjoybnIFpVUl6_AXkWpwA.ZQD-zQ.sAVsV5s6Ua2vkYz_lceuFKrTVuM; session=.eJx1UdtOwjAYfpdeT9KtbIB3QmRCNAQuFDBmadZuK3YttJ3jEN7dfzO4C-Ndv__0HXpByZ6bkiquHLp3puIeoqwUCt1nVFpAjJei1KzDwqbasERACZF-iIk_HJBRiEM_DLCPugmpUyo5TO3d3XgFjf9XhErySkh2kyB1nnPWSLNatVRhEGEPlS7XSWW5UbRsLsuK1SLPjHAarmhauSJIrKOuaR5iMdgwf_owpUW5dDjAGdvFu_N2bgSNu3mnPzn4vSCaptzaG0Zbv6ZOxCTarteb2EwWT3aQLuRMndSZcNjnx70w3CYUovMj8BNFgxHp4T7xiR91_SbNCPeHGBwYnkGp-CX5yogosvHbfLV5fI7q12B2WE7zoD5OMvFSAQlkuQc376gNyLYxwmeJ7ATPn1pvp4Hiw0Pt0cSdmgU05tRwg64e-hOjoybnIFpVUl6_AXkWpwA.ZQDttw.ktPkoJvW_qnj0qtKWY2H0sv8d9o; deck_id=224501 Cdn-Loop: cloudflare Cf-Connecting-Ip: 2804:14c:115:9369:51b4:f25a:c596:a79c Cf-Ipcountry: BR ```

Labels: decksite

vorpal-buildbot commented 1 year ago

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

[7, 10726] (slow_query, 100.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 7c444269b75c6da6f4d556ac4b2147d21d9d1b48

Request Data ``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('session', '.eJx1UctuwjAQ_Bef08oh5AE36EsCQQm0kFJVkZtsQoRjg-2kBcS_d4NEc6h63J3ZnZ3ZE4l3oEomQBjSN6oCi7C0LATpZ4xrrFIoi1KmbV3oRKo0LrBF_K7veK5DXc_2aRC4fpe0DC4TxgFZIG6ehgj8P1KIOK8Knl5P4DLPIW1O01JcpGzqdzyLlCaXcaVBCVY2q7VhTHA44A7JKrPpxNgxDZJMwwd-N3XDowoGC3cQmsPnS7LZ0rHawqTlG7kFdHsiLElA62tNRvXKVvv58vk426_uZ3U0rrOajeZZpGzRzMP3rlCgY4bB2V7P6QW-Y3u3foDOOi3cROnRbkCpRRRk2Nr8akxZSMd6vXgzydcjmzmTQSTUOqwP4TIqX1EDg9yhmXeMDh9UZI3PS1CafFjksiY2h4ZChsAUKHK2yN_UDFM54Jmi4vz8A1lToes.ZQUwDw.mOz7f9KeTPgZtMBr3fRMMxEGBuY'), ('session', '.eJx1UctuwjAQ_Bef08oh5AE36EsCQQm0kFJVkZtsQoRjg-2kBcS_d4NEc6h63J3ZnZ3ZE4l3oEomQBjSN6oCi7C0LATpZ4xrrFIoi1KmbV3oRKo0LrBF_K7veK5DXc_2aRC4fpe0DC4TxgFZIG6ehgj8P1KIOK8Knl5P4DLPIW1O01JcpGzqdzyLlCaXcaVBCVY2q7VhTHA44A7JKrPpxNgxDZJMwwd-N3XDowoGC3cQmsPnS7LZ0rHawqTlG7kFdHsiLElA62tNRvXKVvv58vk426_uZ3U0rrOajeZZpGzRzMP3rlCgY4bB2V7P6QW-Y3u3foDOOi3cROnRbkCpRRRk2Nr8akxZSMd6vXgzydcjmzmTQSTUOqwP4TIqX1EDg9yhmXeMDh9UZI3PS1CafFjksiY2h4ZChsAUKHK2yN_UDFM54Jmi4vz8A1lToes.ZQZEsA.5XsbEn_U7rf4ktZqkD-QjHUPxyw'), ('deck_id', '224888'), ('views', '198')]) Endpoint: add_report View Args: {} Person: 747365305617088574 Referrer: https://pennydreadfulmagic.com/report/ Request Data: {'entry': '224888', 'opponent': '224891', 'result': '2–0', 'draws': '0'} Content-Type: application/x-www-form-urlencoded Content-Length: 55 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 2403:4800:9430:9e77:9c5e:7933:ec37:3b3c Cf-Ray: 807d252dcb9d1f67-MEL X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Chromium";v="116", "Not)A;Brand";v="24", "Google Chrome";v="116" 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/116.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-GB,en-US;q=0.9,en;q=0.8 Cookie: hide_intro=True; page_size=20; session=.eJx1UctuwjAQ_Bef08oh5AE36EsCQQm0kFJVkZtsQoRjg-2kBcS_d4NEc6h63J3ZnZ3ZE4l3oEomQBjSN6oCi7C0LATpZ4xrrFIoi1KmbV3oRKo0LrBF_K7veK5DXc_2aRC4fpe0DC4TxgFZIG6ehgj8P1KIOK8Knl5P4DLPIW1O01JcpGzqdzyLlCaXcaVBCVY2q7VhTHA44A7JKrPpxNgxDZJMwwd-N3XDowoGC3cQmsPnS7LZ0rHawqTlG7kFdHsiLElA62tNRvXKVvv58vk426_uZ3U0rrOajeZZpGzRzMP3rlCgY4bB2V7P6QW-Y3u3foDOOi3cROnRbkCpRRRk2Nr8akxZSMd6vXgzydcjmzmTQSTUOqwP4TIqX1EDg9yhmXeMDh9UZI3PS1CafFjksiY2h4ZChsAUKHK2yN_UDFM54Jmi4vz8A1lToes.ZQUwDw.mOz7f9KeTPgZtMBr3fRMMxEGBuY; deck_id=224888; views=198; session=.eJx1UctuwjAQ_Bef08oh5AE36EsCQQm0kFJVkZtsQoRjg-2kBcS_d4NEc6h63J3ZnZ3ZE4l3oEomQBjSN6oCi7C0LATpZ4xrrFIoi1KmbV3oRKo0LrBF_K7veK5DXc_2aRC4fpe0DC4TxgFZIG6ehgj8P1KIOK8Knl5P4DLPIW1O01JcpGzqdzyLlCaXcaVBCVY2q7VhTHA44A7JKrPpxNgxDZJMwwd-N3XDowoGC3cQmsPnS7LZ0rHawqTlG7kFdHsiLElA62tNRvXKVvv58vk426_uZ3U0rrOajeZZpGzRzMP3rlCgY4bB2V7P6QW-Y3u3foDOOi3cROnRbkCpRRRk2Nr8akxZSMd6vXgzydcjmzmTQSTUOqwP4TIqX1EDg9yhmXeMDh9UZI3PS1CafFjksiY2h4ZChsAUKHK2yN_UDFM54Jmi4vz8A1lToes.ZQZEsA.5XsbEn_U7rf4ktZqkD-QjHUPxyw Priority: u=0, i Cdn-Loop: cloudflare Cf-Connecting-Ip: 2403:4800:9430:9e77:9c5e:7933:ec37:3b3c Cf-Ipcountry: AU ```

Labels: decksite

vorpal-buildbot commented 1 year ago

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

[6, 9359] (slow_query, 63.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 7c444269b75c6da6f4d556ac4b2147d21d9d1b48

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

Labels: decksite