vorpal-buildbot
commented
4 years ago Exceeded slow_query limit (135.6 > 30.0) in mysql: UPDATE `deck` SET `retired` = 1, updated_date = UNIX_TIMESTAMP(NOW()) WHERE id = %s
[67698] (slow_query, 135.6, mysql)
Reported on decksite by mysql-perf
Location Hash: 28a5fa6818111c9f1ad071d5d71e72d033f52e5a
Request Data
``` Request Method: POST Path: /retire/? Cookies: {'_ga': 'GA1.2.1585996359.1538206921', '__cfduid': 'd3c4adfaff68768a82c7ff6cf5297c79a1569765884', '_gid': 'GA1.2.1972524718.1581722797', 'page_size': '20', 'session': '.eJx1UV1PwjAU_S99Xkz3wbrxJqgZqKCJUcCYpW5llG0ta7swRvjv3pHAYoxvveee03PvuUcU75gqqWDCoKFRNbMQTUsu0HBNCw1VykpeyrSvuU6kSmMOEPJC37OdwPYJIaHrh5ignlHIhBYMWNwA-j-fizireZFe_H_rCpllLO2m1FKcXR3ihhYqTSbjWjMlaNmRE9qtkUoFGklrs3FibajpWkvn5TUyT_4tn7tJNWNikYil_1C1h2rcRD3fyJzB4kdEk4RpfamRXcrVWzjFfFG3eV58t_fkHW_b6fxDbUkFetbsuGI6ppChPSBOiAehG9x4OPBsQvp-F6uPvQBjCym2BmhzNVlGUTRxmtFqkk91Yyabar8ns2c1vvNw-ggmEOoOtvmEJOFYfH0A7Jybvj5uthIsvix0_jQ2h06ARowqptDJQn9CNFRlDIYWdVGcfgCQw6oP.ESmDhQ.gzaQSGIOOU6MYo2UJ8v8Cpz-2Bg'} Endpoint: retire_deck View Args: {} Person: 496412816777936907 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '67698'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 93.56.72.240, 172.69.22.94 Cf-Ray: 5657a2ac4b6af93b-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 Content-Type: application/x-www-form-urlencoded User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36 Sec-Fetch-User: ?1 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 Referer: https://pennydreadfulmagic.com/retire/ Accept-Language: it-IT,it;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: _ga=GA1.2.1585996359.1538206921; __cfduid=d3c4adfaff68768a82c7ff6cf5297c79a1569765884; _gid=GA1.2.1972524718.1581722797; page_size=20; session=.eJx1UV1PwjAU_S99Xkz3wbrxJqgZqKCJUcCYpW5llG0ta7swRvjv3pHAYoxvveee03PvuUcU75gqqWDCoKFRNbMQTUsu0HBNCw1VykpeyrSvuU6kSmMOEPJC37OdwPYJIaHrh5ignlHIhBYMWNwA-j-fizireZFe_H_rCpllLO2m1FKcXR3ihhYqTSbjWjMlaNmRE9qtkUoFGklrs3FibajpWkvn5TUyT_4tn7tJNWNikYil_1C1h2rcRD3fyJzB4kdEk4RpfamRXcrVWzjFfFG3eV58t_fkHW_b6fxDbUkFetbsuGI6ppChPSBOiAehG9x4OPBsQvp-F6uPvQBjCym2BmhzNVlGUTRxmtFqkk91Yyabar8ns2c1vvNw-ggmEOoOtvmEJOFYfH0A7Jybvj5uthIsvix0_jQ2h06ARowqptDJQn9CNFRlDIYWdVGcfgCQw6oP.ESmDhQ.gzaQSGIOOU6MYo2UJ8v8Cpz-2Bg Cf-Connecting-Ip: 93.56.72.240 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 11 ```Labels: decksite
[67562](slow_query, 189.5, mysql)Reported on decksite by mysql-perf
Location Hash: 28a5fa6818111c9f1ad071d5d71e72d033f52e5a
Request Data
``` Request Method: POST Path: /retire/? Cookies: {'__cfduid': 'd9e4e52bb16b469294d23f502826bd15f1580042666', '_ga': 'GA1.2.865641068.1580042647', '_gid': 'GA1.2.1107808328.1581296927', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx1UctuwjAQ_BefU-Q8SFKOPNpSoALRFqGqitxkEwJ-RLZTQRH_3k0kyKHqzbMzu7M7PpOkAi2YBGnJwOoaHMIyUUoyyBk3iDIQpVBZh0uTKp0lJZaI14-iOLqnURgGUeS7HiWdgquUcUCV-b5bT5D4v6WUSVGXPLuuwFVRQNasZpRsrfyYBg4RtlBJbUBLJtrJQh1YAThBsdruvMRYZhviMPryR_Zn_hJW-7cHO-5zuzLblD5XiwWPOr1VB8Bbz4SlKRhzxWS9oYsiCsdyvoX9O0yPa7rlj8vpitab8Ij9cKxKDSZhGJvbj93QjX3P63luELhxRzdBhjSIKXWIhhxLu5vHRizWw3EMNBXydTx7Ok7ivf8zyfv5Usw0emCMFR7zgcHh95T5CWttTOb26O0VWnw6pB2a2FPTQIbANGhyccifBC3TBeDOsub88gt8VqRJ.ESQ9ZQ.KEwn-o6Fv5-Yf9qy6QhF-uGgmGA'} Endpoint: retire_deck View Args: {} Person: 257787907664773120 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '67562'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: SE X-Forwarded-For: 85.225.98.1, 162.158.255.30 Cf-Ray: 5636aa01fd3dd8a1-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 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/80.0.3987.87 Safari/537.36 Sec-Fetch-Dest: document 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 Referer: https://pennydreadfulmagic.com/retire/ Accept-Language: sv-SE,sv;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: __cfduid=d9e4e52bb16b469294d23f502826bd15f1580042666; _ga=GA1.2.865641068.1580042647; _gid=GA1.2.1107808328.1581296927; _gat_gtag_UA_109131120_1=1; session=.eJx1UctuwjAQ_BefU-Q8SFKOPNpSoALRFqGqitxkEwJ-RLZTQRH_3k0kyKHqzbMzu7M7PpOkAi2YBGnJwOoaHMIyUUoyyBk3iDIQpVBZh0uTKp0lJZaI14-iOLqnURgGUeS7HiWdgquUcUCV-b5bT5D4v6WUSVGXPLuuwFVRQNasZpRsrfyYBg4RtlBJbUBLJtrJQh1YAThBsdruvMRYZhviMPryR_Zn_hJW-7cHO-5zuzLblD5XiwWPOr1VB8Bbz4SlKRhzxWS9oYsiCsdyvoX9O0yPa7rlj8vpitab8Ij9cKxKDSZhGJvbj93QjX3P63luELhxRzdBhjSIKXWIhhxLu5vHRizWw3EMNBXydTx7Ok7ivf8zyfv5Usw0emCMFR7zgcHh95T5CWttTOb26O0VWnw6pB2a2FPTQIbANGhyccifBC3TBeDOsub88gt8VqRJ.ESQ9ZQ.KEwn-o6Fv5-Yf9qy6QhF-uGgmGA Cf-Connecting-Ip: 85.225.98.1 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 11 ```