vorpal-buildbot
commented
1 week ago Exceeded slow_query limit (941.6 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s
['497856304283385859', 11304] (slow_query, 941.6, mysql)
Reported on decksite by mysql-perf
Location Hash: 44b0911dd8dff3cc602af4b0fc07b8d73de33883
Request Data
``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UV1PwkAQ_C_3XE2_e_AmEowYYipIIcY0R7stB9c7vLtGG8J_d0uifTA-7u7szOzsmeQn0A2TIC0ZW92CQ1jZcEnGFRMGqxIa3qhyqLkplC5zji0SjhIaxYEb-jQIaESjERkQQhVMAKJA3rwucfD_Cpd53XJR_lgQqq6h7K0ZJa9SnocrDmlsrfLWgJas6akbJnjBVWtKzWolkUqx1u793Fhme8AiUuljBZtVUGXV2giRRtmL8LKPNatpOuCtOgIefSasKMCYn5rM-HbXPNHlcdKa-D68S-eT3cNh2slNEK0y3IevE9dgcob5eYlPY5okfnwb-a4bxskw7yON3ZC6rkM0VNja_4rMt89V1Qk6g53_ORPLtj4ke7mAIGRqNEURDPSE17xhhPgoXnXYuwZmyLtDrjS57XoImQDToMnFIX_Ts0zXgD5lK8TlG3Bjo9I.ZwL8Cg.e1pRtVPzU-l2YwPNGCRQU3q2LVw'), ('views', '33')]) Endpoint: retire_deck View Args: {} Person: 497856304283385859 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '251663'} Content-Type: application/x-www-form-urlencoded Content-Length: 12 Cf-Ray: 8ce89f534efe7ae2-SJC X-Forwarded-For: 2601:1c2:c184:bd30:b901:49e4:fba0:aeaa Host: pennydreadfulmagic.com Cf-Connecting-Ip: 2601:1c2:c184:bd30:b901:49e4:fba0:aeaa Accept-Encoding: gzip, br Cookie: hide_intro=True; session=.eJx1UV1PwkAQ_C_3XE2_e_AmEowYYipIIcY0R7stB9c7vLtGG8J_d0uifTA-7u7szOzsmeQn0A2TIC0ZW92CQ1jZcEnGFRMGqxIa3qhyqLkplC5zji0SjhIaxYEb-jQIaESjERkQQhVMAKJA3rwucfD_Cpd53XJR_lgQqq6h7K0ZJa9SnocrDmlsrfLWgJas6akbJnjBVWtKzWolkUqx1u793Fhme8AiUuljBZtVUGXV2giRRtmL8LKPNatpOuCtOgIefSasKMCYn5rM-HbXPNHlcdKa-D68S-eT3cNh2slNEK0y3IevE9dgcob5eYlPY5okfnwb-a4bxskw7yON3ZC6rkM0VNja_4rMt89V1Qk6g53_ORPLtj4ke7mAIGRqNEURDPSE17xhhPgoXnXYuwZmyLtDrjS57XoImQDToMnFIX_Ts0zXgD5lK8TlG3Bjo9I.ZwL8Cg.e1pRtVPzU-l2YwPNGCRQU3q2LVw; views=33 X-Forwarded-Proto: https Cdn-Loop: cloudflare; loops=1 Priority: u=0, i Cf-Visitor: {"scheme":"https"} Cf-Ipcountry: US Accept-Language: en-US,en;q=0.9 Referer: https://pennydreadfulmagic.com/retire/ Sec-Fetch-Dest: document Sec-Fetch-User: ?1 Connection: Keep-Alive Sec-Fetch-Mode: navigate Cache-Control: max-age=0 Sec-Ch-Ua: "Microsoft Edge";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 Edg/129.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
['257787907664773120', 3804](slow_query, 136.2, mysql)Reported on decksite by mysql-perf
Location Hash: 44b0911dd8dff3cc602af4b0fc07b8d73de33883
Request Data
``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '251546'), ('page_size', '100'), ('session', '.eJx1UctugzAQ_BefaQSYYJJjpFbKQ6mSJlLTqkIOXsAJ2Mg25KX8ew1VyqHqzbMzO7s7vqG4AlVSAcKgsVE1OIiykgs0TmmhLWJQ8lKyHnOdSMVibkvIHxISkZFLwjAgBHu-i3pFIRNagFXp5unt2RL_t3ARZzUv2GOFQmYZsHY1LUU3Ckdu4KDSZDKuNShBy865lEeagXWQtDa5H2tDTUvMvH2TbeXpwE547WF8wnrINyuWCAJDv9cbeQR76w3RJAGtHxjR-Wo2jUaLebI8NdcNLw-b93O6SthknU73th_OFVegY2pj84gfhYR4QTQgnhe6uKfbIEM3iFzXQQpSW8p_Z7DoSrfNOn9ZVOoVdqER-MPHZDkL013u2Rk2xsoe84m6bPTgIK1dG6P9LJ5e7POHQF8O6kxjc2kb0ASoAoXuDvqToKEqA7uzqIvi_g32W6TZ.ZwGsYg.btGLWP89tvZKLQ1HnYB-1yc6hlk'), ('views', '535')]) Endpoint: retire_deck View Args: {} Person: 257787907664773120 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '251546'} Content-Type: application/x-www-form-urlencoded Content-Length: 12 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 98.128.167.210 Cf-Ray: 8ce06d0e0e6a6620-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} 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 Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/retire/ Accept-Language: sv-SE,sv;q=0.9,en-US;q=0.8,en;q=0.7 Priority: u=0, i Cookie: hide_intro=True; deck_id=251546; page_size=100; session=.eJx1UctugzAQ_BefaQSYYJJjpFbKQ6mSJlLTqkIOXsAJ2Mg25KX8ew1VyqHqzbMzO7s7vqG4AlVSAcKgsVE1OIiykgs0TmmhLWJQ8lKyHnOdSMVibkvIHxISkZFLwjAgBHu-i3pFIRNagFXp5unt2RL_t3ARZzUv2GOFQmYZsHY1LUU3Ckdu4KDSZDKuNShBy865lEeagXWQtDa5H2tDTUvMvH2TbeXpwE547WF8wnrINyuWCAJDv9cbeQR76w3RJAGtHxjR-Wo2jUaLebI8NdcNLw-b93O6SthknU73th_OFVegY2pj84gfhYR4QTQgnhe6uKfbIEM3iFzXQQpSW8p_Z7DoSrfNOn9ZVOoVdqER-MPHZDkL013u2Rk2xsoe84m6bPTgIK1dG6P9LJ5e7POHQF8O6kxjc2kb0ASoAoXuDvqToKEqA7uzqIvi_g32W6TZ.ZwGsYg.btGLWP89tvZKLQ1HnYB-1yc6hlk; views=535 Cf-Connecting-Ip: 98.128.167.210 Cdn-Loop: cloudflare; loops=1 Cf-Ipcountry: SE ```