search

PennyDreadfulMTG / perf-reports

2 stars 7 forks source link

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

Open vorpal-buildbot opened 1 month ago

vorpal-buildbot commented 1 month ago

['941480620092174396', 9252] (slow_query, 133.2, mysql)

Reported on decksite by mysql-perf

Location Hash: ee2d18eede8dcc3b6a509a81b1196172748a7d3c

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UV1PgzAU_S99xqUwPvfmIss2F1lcjIvGkAotdEBL2jKZZv_dy8zkwfjWc--595x7-oXSlqqGCCoMmhnVUQuRvOECzRipNaCcNryR-Yi5zqTKUw4lFLm2G2LfwThy7MCdRj4aGbXMSE2BRcXN0w4a_49wkRYdr_OrhVoWBc0Ha1qKi1TkeI6FGlPItNNUCdIMm7OSiBy4sEKSzpROqg0xQwe_VM3SY_E6k58baU-NDFdBVEzfH-L9PBz5RlYUjv1CJMuo1leMMpaocKFjxdtlG_f7uA_D1ZZtg-rWZj3M077liuqUQG52YOMAu57nT2zHcYNobA9J-hguxhZSlEGp_NUwvlOxqDyuFklib3bs8eN48J7X28Tc38UuaECOLRzzii7h6EuE8FGcneD5U5scJEi8WeiyNDWnYQDNKVFUobOF_kRoiCooeBZdXZ-_AZRepCk.ZhXaVQ.Sbk6zlV29GKJu3Zdhupk_Y_ZruU'), ('views', '7')]) Endpoint: retire_deck View Args: {} Person: 941480620092174396 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '239488'} Content-Type: application/x-www-form-urlencoded Content-Length: 12 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 71.164.112.103 Cf-Ray: 871e8c4ebbcb78d3-EWR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Google Chrome";v="123", "Not:A-Brand";v="8", "Chromium";v="123" 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/123.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 Cookie: hide_intro=True; session=.eJx1UV1PgzAU_S99xqUwPvfmIss2F1lcjIvGkAotdEBL2jKZZv_dy8zkwfjWc--595x7-oXSlqqGCCoMmhnVUQuRvOECzRipNaCcNryR-Yi5zqTKUw4lFLm2G2LfwThy7MCdRj4aGbXMSE2BRcXN0w4a_49wkRYdr_OrhVoWBc0Ha1qKi1TkeI6FGlPItNNUCdIMm7OSiBy4sEKSzpROqg0xQwe_VM3SY_E6k58baU-NDFdBVEzfH-L9PBz5RlYUjv1CJMuo1leMMpaocKFjxdtlG_f7uA_D1ZZtg-rWZj3M077liuqUQG52YOMAu57nT2zHcYNobA9J-hguxhZSlEGp_NUwvlOxqDyuFklib3bs8eN48J7X28Tc38UuaECOLRzzii7h6EuE8FGcneD5U5scJEi8WeiyNDWnYQDNKVFUobOF_kRoiCooeBZdXZ-_AZRepCk.ZhXaVQ.Sbk6zlV29GKJu3Zdhupk_Y_ZruU; views=7 Priority: u=0, i Cf-Connecting-Ip: 71.164.112.103 Cdn-Loop: cloudflare Cf-Ipcountry: US ```