search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (111.6 > 60.0) in mysql: ```UPDATE person SET discord_id = %s WHERE id = %s``` #63839

Open vorpal-buildbot opened 1 week ago

vorpal-buildbot commented 1 week ago

['117012722708774919', 10429] (slow_query, 111.6, mysql)

Reported on decksite by mysql-perf

Location Hash: e0f83a584fa2a6d8533b2d297d4a5de9bd0b968b

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('session', '.eJx1kctuwjAQRf_F67SyQ4gDu1AqKAUELbCgqiITTx4lsSPbgQLi3-sg0SyqLufOndeZC4oqUCUTIAzqG1WDgxgvc4H6CSu0jTiUeSl5G-c6lopHuZUQIRQTl7ouxQGlXo_0UOsoZMwKsC4QD6OBTfxfkosorfOC31coZJoCb1bTUtxGEey5PQeVJpVRrUEJVjatE3WuZGU7SFabzI20YabRZ5vlcO9nbD5ehaf3w-hc6EHX7Hx8CM_Za-s3cg_21gticQxa32PkrRdz8jbxhqtsPH2pn8OQcy12M7Z62pGlrYfvKlegI2axEdpxPer7neARe7hHOkGbb0j62AswdpCCxErZ7xA82a6_tq6cLKoh3Ry7xwNMp5RLb2OyuAFmOVb2mg9Lzv4nT05Wu3HS6NNBtzaROTUWNACmQKGrg_5CM0ylYPcUdVFcfwAydp-F.Zz0AEw.Q1O-HDBz0EeeioojJg4ziWEgOUo'), ('views', '76')]) Endpoint: retire_deck View Args: {} Person: 117012722708774919 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '254561'} Content-Type: application/x-www-form-urlencoded Content-Length: 12 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 85.230.72.10 Cf-Ray: 8e53381eaef09310-CPH X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Google Chrome";v="131", "Chromium";v="131", "Not_A Brand";v="24" 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/131.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/retire/ Accept-Language: en-US,en;q=0.9,sv;q=0.8,es-419;q=0.7,es;q=0.6 Priority: u=0, i Cookie: hide_intro=True; page_size=20; session=.eJx1kctuwjAQRf_F67SyQ4gDu1AqKAUELbCgqiITTx4lsSPbgQLi3-sg0SyqLufOndeZC4oqUCUTIAzqG1WDgxgvc4H6CSu0jTiUeSl5G-c6lopHuZUQIRQTl7ouxQGlXo_0UOsoZMwKsC4QD6OBTfxfkosorfOC31coZJoCb1bTUtxGEey5PQeVJpVRrUEJVjatE3WuZGU7SFabzI20YabRZ5vlcO9nbD5ehaf3w-hc6EHX7Hx8CM_Za-s3cg_21gticQxa32PkrRdz8jbxhqtsPH2pn8OQcy12M7Z62pGlrYfvKlegI2axEdpxPer7neARe7hHOkGbb0j62AswdpCCxErZ7xA82a6_tq6cLKoh3Ry7xwNMp5RLb2OyuAFmOVb2mg9Lzv4nT05Wu3HS6NNBtzaROTUWNACmQKGrg_5CM0ylYPcUdVFcfwAydp-F.Zz0AEw.Q1O-HDBz0EeeioojJg4ziWEgOUo; views=76 Cf-Connecting-Ip: 85.230.72.10 Cdn-Loop: cloudflare; loops=1 Cf-Ipcountry: SE ```