vorpal-buildbot
commented
2 months ago Exceeded slow_query limit (95.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s
['690113928922923041', 3079] (slow_query, 95.1, mysql)
Reported on decksite by mysql-perf
Location Hash: 6498d95e18dc70656f93627c193e9609268c5535
Request Data
``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('session', '.eJx1UV1PwjAU_S99nqT7kG68SUKCjiC6DCPGLHW9bIW1nW2nLIb_bodBHoxvPfeee-65p1-oaEELKkFaNLG6Aw9RJrhEky1tjEMMBBeKXTA3pdKs4K6Exgn2_TAJ4iQIkiDEkY8ujEaVtAHHAnmVZ67x_wiXRdXxhp0tNKqqgA3WjJKnVSEmiYeErVTRGdCSikG50lxWqnUKina2DgpjqR0aKtvMHpaPJozZLk6WYg-ip2l-u2Z-fldd-Fbtwd36hWhZgjFnjKJ6nJarIEtnpLmZ54uPlK3bFH9mb-LpfXAMh5ZrMAV1sfnEvyYBCRMyipIwIphc-kOSYxzFGHtIw9aV6t8lEs_JXE9tsDRZFM_s83280Xy16OvFYa3cEpdj6655QadwjKv8PEY75XSHQN238W2PXj10Ei1sPwygKVANGh099CdCS3UFzrTsmub4Dc_2pIE.ZpsDFQ.LJzXaBLUdj9YMfXSELFrY4EySxk'), ('views', '68')]) Endpoint: retire_deck View Args: {} Person: 690113928922923041 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '246094'} Content-Type: application/x-www-form-urlencoded Content-Length: 12 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 86.141.94.177 Cf-Ray: 8a5ecb090d56bebc-LHR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Not/A)Brand";v="8", "Chromium";v="126", "Google Chrome";v="126" 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/126.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 Priority: u=0, i Cookie: hide_intro=True; page_size=20; session=.eJx1UV1PwjAU_S99nqT7kG68SUKCjiC6DCPGLHW9bIW1nW2nLIb_bodBHoxvPfeee-65p1-oaEELKkFaNLG6Aw9RJrhEky1tjEMMBBeKXTA3pdKs4K6Exgn2_TAJ4iQIkiDEkY8ujEaVtAHHAnmVZ67x_wiXRdXxhp0tNKqqgA3WjJKnVSEmiYeErVTRGdCSikG50lxWqnUKina2DgpjqR0aKtvMHpaPJozZLk6WYg-ip2l-u2Z-fldd-Fbtwd36hWhZgjFnjKJ6nJarIEtnpLmZ54uPlK3bFH9mb-LpfXAMh5ZrMAV1sfnEvyYBCRMyipIwIphc-kOSYxzFGHtIw9aV6t8lEs_JXE9tsDRZFM_s83280Xy16OvFYa3cEpdj6655QadwjKv8PEY75XSHQN238W2PXj10Ei1sPwygKVANGh099CdCS3UFzrTsmub4Dc_2pIE.ZpsDFQ.LJzXaBLUdj9YMfXSELFrY4EySxk; views=68 Cf-Connecting-Ip: 86.141.94.177 Cdn-Loop: cloudflare Cf-Ipcountry: GB ```Labels: decksite
['366360565360361472', 9479](slow_query, 126.5, mysql)Reported on decksite by mysql-perf
Location Hash: 6498d95e18dc70656f93627c193e9609268c5535
Request Data
``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UV1vgjAU_S99ZgYoFPVNMVGTbbrpPuKykAYuWIWWtEVwxv--wuJ4WPbS5Nx77j3nnl5QVIIsKAeu0VjLCixEk4JxNE5prgxKoGCFSHrMVCxkEjFTQpgQTGyf-ObFxPECF_WMXMQ0B8MCfveyMY3_RxiPsorlyc1CLrIMktaaEryTGnnByEKFzkRUKZCcFu3m0pMFVh43KwSt9N6NlKa66yyDxYqmdU1wc1psJw_PwWxG6GlUxqFMe74WRzDHXhCNY1DqhhHlylnxY_W-muxECI_r--Fmo4Jd6DD2NTPz0JRMgoqoyc0JXNuxAxf7gwD7xHX6dpsksb2hbVtIQmpK-1-NuXzLy-Xr1i-mNXbCp1rV2alp1gQfmsXcaJgcS3PMB-rCUYODYO2pP6gL1HwbS8_o00Ld0kif2wE0BSpBoquF_kSoqczAeOZVnl-_Ae41pQo.Zn9QqA.2ZBwEb-tEdOJzQ_YAChvlwEQJME'), ('views', '87'), ('page_size', '20'), ('deck_id', '245253')]) Endpoint: retire_deck View Args: {} Person: 366360565360361472 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '245253'} Content-Type: application/x-www-form-urlencoded Content-Length: 12 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 71.76.241.156 Cf-Ray: 89b1afc58d205b17-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:127.0) Gecko/20100101 Firefox/127.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8 Accept-Language: en-US,en;q=0.5 Origin: https://pennydreadfulmagic.com Referer: https://pennydreadfulmagic.com/retire/ Upgrade-Insecure-Requests: 1 Sec-Fetch-Dest: document Sec-Fetch-Mode: navigate Sec-Fetch-Site: same-origin Sec-Fetch-User: ?1 Priority: u=1 Cookie: hide_intro=True; session=.eJx1UV1vgjAU_S99ZgYoFPVNMVGTbbrpPuKykAYuWIWWtEVwxv--wuJ4WPbS5Nx77j3nnl5QVIIsKAeu0VjLCixEk4JxNE5prgxKoGCFSHrMVCxkEjFTQpgQTGyf-ObFxPECF_WMXMQ0B8MCfveyMY3_RxiPsorlyc1CLrIMktaaEryTGnnByEKFzkRUKZCcFu3m0pMFVh43KwSt9N6NlKa66yyDxYqmdU1wc1psJw_PwWxG6GlUxqFMe74WRzDHXhCNY1DqhhHlylnxY_W-muxECI_r--Fmo4Jd6DD2NTPz0JRMgoqoyc0JXNuxAxf7gwD7xHX6dpsksb2hbVtIQmpK-1-NuXzLy-Xr1i-mNXbCp1rV2alp1gQfmsXcaJgcS3PMB-rCUYODYO2pP6gL1HwbS8_o00Ld0kif2wE0BSpBoquF_kSoqczAeOZVnl-_Ae41pQo.Zn9QqA.2ZBwEb-tEdOJzQ_YAChvlwEQJME; views=87; page_size=20; deck_id=245253 Cf-Connecting-Ip: 71.76.241.156 Cdn-Loop: cloudflare Cf-Ipcountry: US ```