vorpal-buildbot
commented
2 months ago Exceeded slow_query limit (76.3 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s
['259789239594516484', 286] (slow_query, 76.3, mysql)
Reported on decksite by mysql-perf
Location Hash: 020347ececc0f12bd0edf37bcbbd847c35b20af6
Request Data
``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UV1vgkAQ_C_3TA1wgOCjTf1Io0X7obRpyAVWPD04vDtarfG_dzFRkyZ9u52d3ZmdO5K0BlWyCipDekY1YBGWl7wivRUTGqscSl7K_FZznUmVpxwh4vpRN4xcGvmR5zuBF3rkxhAyYwKQBdXd6zM2_h_hVVo0XOQXC0IWBeStNS2rs5QbBhYpTSHTRoOqWNkudiiwLXJwg2SNWbupNsy0nfFwP9m9iNCZj6mki6_BQ9xkhklePr3Nuje-kVvAW4-EZRlofalJTKdiOVglbDCNB3132O_b82xRLEfxekZ3OA_7mivQKcPYnC6e4_hB1-74XmgHlN76bZKBjahtEQUrhNZXkaCZFG4ibXuUsPufb2-7MVHtvKvksTkEUxTBHGu85gOTw__hqwNi55z09dHZSJT4tMh5aWoO7QDpA1OgyMkifyM0TBWAnqtGiNMv_j-j-w.ZuIxHg.LA47JB0lKg0uWfGpiqVJ-QzXe-I'), ('views', '17')]) Endpoint: retire_deck View Args: {} Person: 259789239594516484 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '249567'} Content-Type: application/x-www-form-urlencoded Content-Length: 12 Cf-Ray: 8c1baac2dda55341 X-Forwarded-For: 73.127.164.58 Host: pennydreadfulmagic.com Cf-Connecting-Ip: 73.127.164.58 Accept-Encoding: gzip, br Cookie: hide_intro=True; session=.eJx1UV1vgkAQ_C_3TA1wgOCjTf1Io0X7obRpyAVWPD04vDtarfG_dzFRkyZ9u52d3ZmdO5K0BlWyCipDekY1YBGWl7wivRUTGqscSl7K_FZznUmVpxwh4vpRN4xcGvmR5zuBF3rkxhAyYwKQBdXd6zM2_h_hVVo0XOQXC0IWBeStNS2rs5QbBhYpTSHTRoOqWNkudiiwLXJwg2SNWbupNsy0nfFwP9m9iNCZj6mki6_BQ9xkhklePr3Nuje-kVvAW4-EZRlofalJTKdiOVglbDCNB3132O_b82xRLEfxekZ3OA_7mivQKcPYnC6e4_hB1-74XmgHlN76bZKBjahtEQUrhNZXkaCZFG4ibXuUsPufb2-7MVHtvKvksTkEUxTBHGu85gOTw__hqwNi55z09dHZSJT4tMh5aWoO7QDpA1OgyMkifyM0TBWAnqtGiNMv_j-j-w.ZuIxHg.LA47JB0lKg0uWfGpiqVJ-QzXe-I; views=17 X-Forwarded-Proto: https Cdn-Loop: cloudflare; loops=1 Priority: u=0, i Cf-Visitor: {"scheme":"https"} Cf-Ipcountry: US Referer: https://pennydreadfulmagic.com/retire/ Sec-Fetch-Dest: document Sec-Fetch-User: ?1 Sec-Fetch-Mode: navigate Connection: Keep-Alive Sec-Fetch-Site: same-origin Cache-Control: max-age=0 Sec-Ch-Ua: "Chromium";v="128", "Not;A=Brand";v="24", "Brave";v="128" 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/128.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 Sec-Gpc: 1 Accept-Language: en-US,en;q=0.6 ```Labels: decksite
['667539418529398795', 9999](slow_query, 101.5, mysql)Reported on decksite by mysql-perf
Location Hash: 020347ececc0f12bd0edf37bcbbd847c35b20af6
Request Data
``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('views', '181'), ('page_size', '20'), ('hide_intro', 'True'), ('deck_id', '249975'), ('session', '.eJx1UctuwjAQ_BefU5QHCQlHQBW0tKi0PKsqMsli3MQ2sh1aQPx7N0g0h6q-zc7uzO74TNI9aEElSEu6VlfgEJoLLkl3S0uDKAfBhcobzE2mdJ5yLJEo6oRB0vbi0E-CJO4kIWk6SpXRErAL5N3sFYn_R7hMWcXLxqVUjEFe72aUvHol-BwiLFNpZUBLKmpps-cFpCaj-ogyilZ256fGUluTio0XL5JlzyLjUz7nk-Ihbo8PIups3w6npt-qAvDgM6FZBsbcMDn2R4uhHm3urSvWs7C_fnJ3Pis2fHmYFwOch-8912BSitl5HT-KvDiO_VYQe27kBQ1fxxm57dh1HaJhi6XdrwnbTL18GK3WZW_8ODpN2GC-gq_8EC5nQdJDEwxzj9e8Y3z4SXxbH3oNy7Q-FSrfEPlwyFU0tcd6gPSAatDk4pA_MVqqGeDSsirLyw_4oaeo.ZuDiog.PUYihc28mssqZrGvgCoDM1fZ_x8')]) Endpoint: retire_deck View Args: {} Person: 667539418529398795 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '249975'} Content-Type: application/x-www-form-urlencoded Content-Length: 12 Cf-Ray: 8c13803e7f9f01e4 X-Forwarded-For: 172.219.32.135 Host: pennydreadfulmagic.com Cf-Connecting-Ip: 172.219.32.135 Accept-Encoding: gzip, br Cookie: views=181; page_size=20; hide_intro=True; deck_id=249975; session=.eJx1UctuwjAQ_BefU5QHCQlHQBW0tKi0PKsqMsli3MQ2sh1aQPx7N0g0h6q-zc7uzO74TNI9aEElSEu6VlfgEJoLLkl3S0uDKAfBhcobzE2mdJ5yLJEo6oRB0vbi0E-CJO4kIWk6SpXRErAL5N3sFYn_R7hMWcXLxqVUjEFe72aUvHol-BwiLFNpZUBLKmpps-cFpCaj-ogyilZ256fGUluTio0XL5JlzyLjUz7nk-Ihbo8PIups3w6npt-qAvDgM6FZBsbcMDn2R4uhHm3urSvWs7C_fnJ3Pis2fHmYFwOch-8912BSitl5HT-KvDiO_VYQe27kBQ1fxxm57dh1HaJhi6XdrwnbTL18GK3WZW_8ODpN2GC-gq_8EC5nQdJDEwxzj9e8Y3z4SXxbH3oNy7Q-FSrfEPlwyFU0tcd6gPSAatDk4pA_MVqqGeDSsirLyw_4oaeo.ZuDiog.PUYihc28mssqZrGvgCoDM1fZ_x8 X-Forwarded-Proto: https Cdn-Loop: cloudflare; loops=1 Priority: u=0, i Cf-Visitor: {"scheme":"https"} Cf-Ipcountry: CA Sec-Fetch-User: ?1 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-Dest: document Connection: Keep-Alive Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:130.0) Gecko/20100101 Firefox/130.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/png,image/svg+xml,*/*;q=0.8 Accept-Language: en-CA,en-US;q=0.7,en;q=0.3 Origin: https://pennydreadfulmagic.com Referer: https://pennydreadfulmagic.com/retire/ ```