vorpal-buildbot
commented
2 years ago Exceeded slow_query limit (74.9 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s
['136854131653476352', 1449] (slow_query, 74.9, mysql)
Reported on decksite by mysql-perf
Location Hash: c7f38d838216aabc1120c0708e2118a9ad05be63
Request Data
``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('page_size', '20'), ('hide_intro', 'True'), ('deck_id', '197633'), ('session', '.eJx1UU1TgzAQ_S85owOFAu1Ne6i1UPtdO47DpLBAKEnaJGg_pv_dgKMcHG95-3b37Xu5ougAgmIGTKG-EhUYCCeUMNRPcSk1SoASypMWExlzkUREl5Blu37XsWzL7dqO59rdDmo7Sh7jEnQXsLvVQhP_jxAWZRUpW5WSZxkk9W2Ss0bLcpyegajKeFRJEAzTejXFCRcFZnoHx5XKO5FUWNXMXu7y-Wxr5dPVPMwm4Wkf0HU5eA3WVbEQbb_ie9BurwjHMUj5g1EPRtNwCeN0vniC48vxYTmZBeNzPPA27CPV83A6EAEywjo4y3Vdy_a0s3vXN72O6bd8naVrOr5pGkhAqkv5r0iAzcsz3m1FWAWbUTG0L850OdwdO0nvUwVaRCd50G7eUBOPvC84YU2S-r9IetbPbwK9G6hZGqlzPYAeAQsQ6GagPxkqLDLQR7OqLG9fWKemcQ.Y0gYaQ.X4buHppc6WZDHVTThruKQlypwis'), ('views', '908')]) Endpoint: retire_deck View Args: {} Person: 136854131653476352 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '197633'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 80.99.33.219, 172.69.22.180 Cf-Ray: 7598903ffc40c245-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Chromium";v="106", "Google Chrome";v="106", "Not;A=Brand";v="99" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com Content-Type: application/x-www-form-urlencoded User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.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.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/retire/ Accept-Language: hu-HU,hu;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: page_size=20; hide_intro=True; deck_id=197633; session=.eJx1UU1TgzAQ_S85owOFAu1Ne6i1UPtdO47DpLBAKEnaJGg_pv_dgKMcHG95-3b37Xu5ougAgmIGTKG-EhUYCCeUMNRPcSk1SoASypMWExlzkUREl5Blu37XsWzL7dqO59rdDmo7Sh7jEnQXsLvVQhP_jxAWZRUpW5WSZxkk9W2Ss0bLcpyegajKeFRJEAzTejXFCRcFZnoHx5XKO5FUWNXMXu7y-Wxr5dPVPMwm4Wkf0HU5eA3WVbEQbb_ie9BurwjHMUj5g1EPRtNwCeN0vniC48vxYTmZBeNzPPA27CPV83A6EAEywjo4y3Vdy_a0s3vXN72O6bd8naVrOr5pGkhAqkv5r0iAzcsz3m1FWAWbUTG0L850OdwdO0nvUwVaRCd50G7eUBOPvC84YU2S-r9IetbPbwK9G6hZGqlzPYAeAQsQ6GagPxkqLDLQR7OqLG9fWKemcQ.Y0gYaQ.X4buHppc6WZDHVTThruKQlypwis; views=908 Priority: u=0 Cf-Connecting-Ip: 80.99.33.219 Cf-Ipcountry: HU Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```Labels: decksite
['953625999264858133', 9365](slow_query, 151.7, mysql)Reported on decksite by mysql-perf
Location Hash: c7f38d838216aabc1120c0708e2118a9ad05be63
Request Data
``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('views', '14'), ('session', '.eJx1kclOwzAQht_F51ClTePGPZatUoRK2YRAKHKTiePWS2Q7qATx7kyKSg-Im2f7_5nPn6RowWluwAQyD66DiPBKS0PmNVceowq01LY6xdKX1lWFxBRhaUInKWNsQqdZmo2ThJw6lC25AuwCc_Z4j4X_R6QpRCdVdVxBWSGgGlbz1hysWELTiOggbNF5cIbrQbkE7jYNlwo1LO9CMyl84GEoNVStgn_pxb67Nve9gMY9t97kd15cNfmpP9gd4LWfhJcleH-Mydrs3lfL2_Par_nNXa4Ea7aZ3njdT594jfOwb6UDX3AEN6Z0Gid0lrIRo2ycZempPrCk8TSL44g4qDHV_Jrka6M7b3vdJcYv92F3UYF72PazfPEwvkQTJNniNa_kgMdj5ucx2lrUHZDix8n6g7xF5CBahI9hgCyQDDjyFZE_EAN3AnBp0yn19Q23gKku.YzBytQ.mnEM_14I1lZCK_w6_4PP-PKBHRQ'), ('cf_use_ob', '0')]) Endpoint: retire_deck View Args: {} Person: 953625999264858133 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '194266'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2603:6010:ff03:7b38:d85f:fa86:295b:74f2, 172.69.22.181 Cf-Ray: 7504c68c59ed2b14-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Microsoft Edge";v="105", " Not;A Brand";v="99", "Chromium";v="105" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36 Edg/105.0.1343.50 Origin: https://pennydreadfulmagic.com Content-Type: application/x-www-form-urlencoded Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 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; page_size=20; views=14; session=.eJx1kclOwzAQht_F51ClTePGPZatUoRK2YRAKHKTiePWS2Q7qATx7kyKSg-Im2f7_5nPn6RowWluwAQyD66DiPBKS0PmNVceowq01LY6xdKX1lWFxBRhaUInKWNsQqdZmo2ThJw6lC25AuwCc_Z4j4X_R6QpRCdVdVxBWSGgGlbz1hysWELTiOggbNF5cIbrQbkE7jYNlwo1LO9CMyl84GEoNVStgn_pxb67Nve9gMY9t97kd15cNfmpP9gd4LWfhJcleH-Mydrs3lfL2_Par_nNXa4Ea7aZ3njdT594jfOwb6UDX3AEN6Z0Gid0lrIRo2ycZempPrCk8TSL44g4qDHV_Jrka6M7b3vdJcYv92F3UYF72PazfPEwvkQTJNniNa_kgMdj5ucx2lrUHZDix8n6g7xF5CBahI9hgCyQDDjyFZE_EAN3AnBp0yn19Q23gKku.YzBytQ.mnEM_14I1lZCK_w6_4PP-PKBHRQ; cf_use_ob=0 Priority: u=0 Cf-Connecting-Ip: 2603:6010:ff03:7b38:d85f:fa86:295b:74f2 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```