search

PennyDreadfulMTG / perf-reports

2 stars 7 forks source link

Exceeded slow_query limit (582.7 > 500.0) in mysql: ```UPDATE person SET discord_id = %s WHERE id = %s``` #57917

Open vorpal-buildbot opened 2 years ago

vorpal-buildbot commented 2 years ago

['212469219751624704', 5067] (slow_query, 582.7, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1kcluwjAQht_F5xSZKEvDrZUKUYlEK6CLqipykyEYvKS2UwiId-8ECXKoevM_2z_z-UjyGoxkCpQjI2ca8AgrJVdktGLCoipBcqnLXnNbaFPmHEPEH_pBlPjDJA6HkR_ENCB9hdAFE4BVoG6Wc0z838JVXjVclJcVhK4qKLvVrFZnq5BGsUekq3TeWDCKyW7ylhtmmVvjCM0at_Zz65jrMo-t3o1fs30G4x1rzWoGX-livs8ELOvnuK93egt47JGwogBrL5pMDtv3zfDHtO71iU3SKeO6ci-Lh7cyk2OB_bCvuQGbM-SGhyRRmFBKB0EQB1Ho9_kOZUSDW0o9YmCFofXVZKaSu-_0EAahnG6jcJ5K689occjMMqo6Lgiyxms-EB1-EF-1GDuDstfHYKPR4tMj56G5a7sGcg_MgCEnj_xh6JipAJdWjRCnX4JfppI.YaXwEg.hRRoMP0icPvW54turgVdwURwO2k'), ('views', '10')]) Endpoint: retire_deck View Args: {} Person: 212469219751624704 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '161193'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: SE X-Forwarded-For: 85.230.198.183, 172.68.133.81 Cf-Ray: 6b631586dc517373-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="96", "Microsoft Edge";v="96" 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/96.0.4664.55 Safari/537.36 Edg/96.0.1054.34 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; session=.eJx1kcluwjAQht_F5xSZKEvDrZUKUYlEK6CLqipykyEYvKS2UwiId-8ECXKoevM_2z_z-UjyGoxkCpQjI2ca8AgrJVdktGLCoipBcqnLXnNbaFPmHEPEH_pBlPjDJA6HkR_ENCB9hdAFE4BVoG6Wc0z838JVXjVclJcVhK4qKLvVrFZnq5BGsUekq3TeWDCKyW7ylhtmmVvjCM0at_Zz65jrMo-t3o1fs30G4x1rzWoGX-livs8ELOvnuK93egt47JGwogBrL5pMDtv3zfDHtO71iU3SKeO6ci-Lh7cyk2OB_bCvuQGbM-SGhyRRmFBKB0EQB1Ho9_kOZUSDW0o9YmCFofXVZKaSu-_0EAahnG6jcJ5K689occjMMqo6Lgiyxms-EB1-EF-1GDuDstfHYKPR4tMj56G5a7sGcg_MgCEnj_xh6JipAJdWjRCnX4JfppI.YaXwEg.hRRoMP0icPvW54turgVdwURwO2k; views=10 Cf-Connecting-Ip: 85.230.198.183 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```
vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (1605.4 > 500.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['569553268225605651', 3369] (slow_query, 1605.4, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('session', '.eJx1UctuwjAQ_BefUxTyMAlHyqNSkWgpopSqitx4kxicOPJDBSH-vRsk4FD15tmZ3dkdn0jWgq5ZA40lQ6sdeITxWjRkWDBpEHGoRa34HQuTK80zgSUS0zSOw4AmQRBTP6Zxn9wVUuVMAqpa-zBaIvF_i2iy0gnJrytIVZbAu9WMai5WYUhTj9S2VJkzoBtWd5NL9q0FyEziDMWcrYLMWGY76uNntRi11aTQbL16j3xTHdwbnwzmPHk29K63ag947YmwPAdjrphsjrngel9s2814EUeHySZspjDd7vLF43KO_XBohQaTMQyuT8MgiQKa9ntxkiZpdKe7KKkfJb7vEQ0Flqqbx_p18FLN1_AkxtvZlB73VvWF226k27lZix4YZIvHfGJ0-EGiOGLtEpS5PXo7hRZfHrkMzeyxayAjYBo0OXvkT4aW6RJw58ZJef4F1YemkA.Yad4cA.ZkdbYtWfSk2EIybkmz7V-ix6q5w'), ('views', '36')]) Endpoint: retire_deck View Args: {} Person: 569553268225605651 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '161410'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 45.174.237.48, 162.158.255.231 Cf-Ray: 6b6ca8b17d2309d6-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="96", "Google Chrome";v="96" 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/96.0.4664.45 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: pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: hide_intro=True; page_size=20; session=.eJx1UctuwjAQ_BefUxTyMAlHyqNSkWgpopSqitx4kxicOPJDBSH-vRsk4FD15tmZ3dkdn0jWgq5ZA40lQ6sdeITxWjRkWDBpEHGoRa34HQuTK80zgSUS0zSOw4AmQRBTP6Zxn9wVUuVMAqpa-zBaIvF_i2iy0gnJrytIVZbAu9WMai5WYUhTj9S2VJkzoBtWd5NL9q0FyEziDMWcrYLMWGY76uNntRi11aTQbL16j3xTHdwbnwzmPHk29K63ag947YmwPAdjrphsjrngel9s2814EUeHySZspjDd7vLF43KO_XBohQaTMQyuT8MgiQKa9ntxkiZpdKe7KKkfJb7vEQ0Flqqbx_p18FLN1_AkxtvZlB73VvWF226k27lZix4YZIvHfGJ0-EGiOGLtEpS5PXo7hRZfHrkMzeyxayAjYBo0OXvkT4aW6RJw58ZJef4F1YemkA.Yad4cA.ZkdbYtWfSk2EIybkmz7V-ix6q5w; views=36 Cf-Connecting-Ip: 45.174.237.48 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (1617.7 > 500.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['569553268225605651', 3369] (slow_query, 1617.7, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('session', '.eJx1UctuwjAQ_BefUxTyMAlHyqNSkWgpopSqitx4kxicOPJDBSH-vRsk4FD15tmZ3dkdn0jWgq5ZA40lQ6sdeITxWjRkWDBpEHGoRa34HQuTK80zgSUS0zSOw4AmQRBTP6Zxn9wVUuVMAqpa-zBaIvF_i2iy0gnJrytIVZbAu9WMai5WYUhTj9S2VJkzoBtWd5NL9q0FyEziDMWcrYLMWGY76uNntRi11aTQbL16j3xTHdwbnwzmPHk29K63ag947YmwPAdjrphsjrngel9s2814EUeHySZspjDd7vLF43KO_XBohQaTMQyuT8MgiQKa9ntxkiZpdKe7KKkfJb7vEQ0Flqqbx_p18FLN1_AkxtvZlB73VvWF226k27lZix4YZIvHfGJ0-EGiOGLtEpS5PXo7hRZfHrkMzeyxayAjYBo0OXvkT4aW6RJw58ZJef4F1YemkA.Yad4cA.ZkdbYtWfSk2EIybkmz7V-ix6q5w'), ('views', '36')]) Endpoint: retire_deck View Args: {} Person: 569553268225605651 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '161410'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 45.174.237.48, 162.158.255.231 Cf-Ray: 6b6ca86589d609d6-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="96", "Google Chrome";v="96" 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/96.0.4664.45 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: pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: hide_intro=True; page_size=20; session=.eJx1UctuwjAQ_BefUxTyMAlHyqNSkWgpopSqitx4kxicOPJDBSH-vRsk4FD15tmZ3dkdn0jWgq5ZA40lQ6sdeITxWjRkWDBpEHGoRa34HQuTK80zgSUS0zSOw4AmQRBTP6Zxn9wVUuVMAqpa-zBaIvF_i2iy0gnJrytIVZbAu9WMai5WYUhTj9S2VJkzoBtWd5NL9q0FyEziDMWcrYLMWGY76uNntRi11aTQbL16j3xTHdwbnwzmPHk29K63ag947YmwPAdjrphsjrngel9s2814EUeHySZspjDd7vLF43KO_XBohQaTMQyuT8MgiQKa9ntxkiZpdKe7KKkfJb7vEQ0Flqqbx_p18FLN1_AkxtvZlB73VvWF226k27lZix4YZIvHfGJ0-EGiOGLtEpS5PXo7hRZfHrkMzeyxayAjYBo0OXvkT4aW6RJw58ZJef4F1YemkA.Yad4cA.ZkdbYtWfSk2EIybkmz7V-ix6q5w; views=36 Cf-Connecting-Ip: 45.174.237.48 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (304.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['361173198676688896', 8311] (slow_query, 304.8, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UctuwjAQ_BefI5TExAkcaZEQjyJApRVVFbmOE5w6sWs7PIr4926QSg5Vb57Z2Z3d8QWlmpuK1rx2aOhMwz1Es0rUaJhTaQFlvBKVyjosLFMmSwVQCJMgiHEwSEhMSJIkA4I6hVSMSg4q4YD9Xy_qtGiE7CykKgqetYtZVd-MEhwEHqpcodLGclPTqp2bYaagX9HG7cPUOupaNtzi1bosN3rCZKLybTne7V9e5-fj9-OCLTu9U58czrwgyhi39hcjtf7S0Vivgkgtff2xpctYz0bT0yiMntgY-vlJC8NtSiGxgOBBFPejOOqFfhTGuCu3GRK_n_i-hwzPgdrfPQ7HeBMvWDl_cKdssimfySaf7aZidSixCMADEtRwzBvEBj8j8jNwt5Ds_dErFVi8e-g2NHXntgGNODXcoKuH_sTnqCk47Fw3Ul5_AILMowA.YbCx4A.tkP6EA1B1HX-5AQdBxmapy9-vhQ'), ('views', '24')]) Endpoint: retire_deck View Args: {} Person: 361173198676688896 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '161713'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 2001:b07:a99:c36:d451:908e:fc77:a175, 162.158.255.165 Cf-Ray: 6ba65036ee0983ba-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="96", "Microsoft Edge";v="96" 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/96.0.4664.55 Safari/537.36 Edg/96.0.1054.43 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: it,it-IT;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6 Cookie: hide_intro=True; session=.eJx1UctuwjAQ_BefI5TExAkcaZEQjyJApRVVFbmOE5w6sWs7PIr4926QSg5Vb57Z2Z3d8QWlmpuK1rx2aOhMwz1Es0rUaJhTaQFlvBKVyjosLFMmSwVQCJMgiHEwSEhMSJIkA4I6hVSMSg4q4YD9Xy_qtGiE7CykKgqetYtZVd-MEhwEHqpcodLGclPTqp2bYaagX9HG7cPUOupaNtzi1bosN3rCZKLybTne7V9e5-fj9-OCLTu9U58czrwgyhi39hcjtf7S0Vivgkgtff2xpctYz0bT0yiMntgY-vlJC8NtSiGxgOBBFPejOOqFfhTGuCu3GRK_n_i-hwzPgdrfPQ7HeBMvWDl_cKdssimfySaf7aZidSixCMADEtRwzBvEBj8j8jNwt5Ds_dErFVi8e-g2NHXntgGNODXcoKuH_sTnqCk47Fw3Ul5_AILMowA.YbCx4A.tkP6EA1B1HX-5AQdBxmapy9-vhQ; views=24 Cf-Connecting-Ip: 2001:b07:a99:c36:d451:908e:fc77:a175 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (277.2 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['361173198676688896', 8311] (slow_query, 277.2, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('views', '36'), ('session', '.eJx1UctuwjAQ_BefI5TExAkcaZEQjyJApRVVFbmOE5w6sWs7PIr4926QSg5Vb57Z2Z3d8QWlmpuK1rx2aOhMwz1Es0rUaJhTaQFlvBKVyjosLFMmSwVQCJMgiHEwSEhMSJIkA4I6hVSMSg4q4YD9Xy_qtGiE7CykKgqetYtZVd-MEhwEHqpcodLGclPTqp2bYaagX9HG7cPUOupaNtzi1bosN3rCZKLybTne7V9e5-fj9-OCLTu9U58czrwgyhi39hcjtf7S0Vivgkgtff2xpctYz0bT0yiMntgY-vlJC8NtSiGxgOBBFPejOOqFfhTGuCu3GRK_n_i-hwzPgdrfPQ7HeBMvWDl_cKdssimfySaf7aZidSixCMADEtRwzBvEBj8j8jNwt5Ds_dErFVi8e-g2NHXntgGNODXcoKuH_sTnqCk47Fw3Ul5_AILMowA.YbCyHg.ZJjts5VFDwN6Gm-odrLFEQE2mkM')]) Endpoint: retire_deck View Args: {} Person: 361173198676688896 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '161713'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 2001:b07:a99:c36:d451:908e:fc77:a175, 162.158.255.165 Cf-Ray: 6ba650e3ae9e83ba-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="96", "Microsoft Edge";v="96" 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/96.0.4664.55 Safari/537.36 Edg/96.0.1054.43 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: it,it-IT;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6 Cookie: hide_intro=True; views=36; session=.eJx1UctuwjAQ_BefI5TExAkcaZEQjyJApRVVFbmOE5w6sWs7PIr4926QSg5Vb57Z2Z3d8QWlmpuK1rx2aOhMwz1Es0rUaJhTaQFlvBKVyjosLFMmSwVQCJMgiHEwSEhMSJIkA4I6hVSMSg4q4YD9Xy_qtGiE7CykKgqetYtZVd-MEhwEHqpcodLGclPTqp2bYaagX9HG7cPUOupaNtzi1bosN3rCZKLybTne7V9e5-fj9-OCLTu9U58czrwgyhi39hcjtf7S0Vivgkgtff2xpctYz0bT0yiMntgY-vlJC8NtSiGxgOBBFPejOOqFfhTGuCu3GRK_n_i-hwzPgdrfPQ7HeBMvWDl_cKdssimfySaf7aZidSixCMADEtRwzBvEBj8j8jNwt5Ds_dErFVi8e-g2NHXntgGNODXcoKuH_sTnqCk47Fw3Ul5_AILMowA.YbCyHg.ZJjts5VFDwN6Gm-odrLFEQE2mkM Cf-Connecting-Ip: 2001:b07:a99:c36:d451:908e:fc77:a175 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (247.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['361173198676688896', 8311] (slow_query, 247.8, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('views', '36'), ('session', '.eJx1UctuwjAQ_BefI5TExAkcaZEQjyJApRVVFbmOE5w6sWs7PIr4926QSg5Vb57Z2Z3d8QWlmpuK1rx2aOhMwz1Es0rUaJhTaQFlvBKVyjosLFMmSwVQCJMgiHEwSEhMSJIkA4I6hVSMSg4q4YD9Xy_qtGiE7CykKgqetYtZVd-MEhwEHqpcodLGclPTqp2bYaagX9HG7cPUOupaNtzi1bosN3rCZKLybTne7V9e5-fj9-OCLTu9U58czrwgyhi39hcjtf7S0Vivgkgtff2xpctYz0bT0yiMntgY-vlJC8NtSiGxgOBBFPejOOqFfhTGuCu3GRK_n_i-hwzPgdrfPQ7HeBMvWDl_cKdssimfySaf7aZidSixCMADEtRwzBvEBj8j8jNwt5Ds_dErFVi8e-g2NHXntgGNODXcoKuH_sTnqCk47Fw3Ul5_AILMowA.YbCyHg.ZJjts5VFDwN6Gm-odrLFEQE2mkM')]) Endpoint: retire_deck View Args: {} Person: 361173198676688896 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '161713'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 2001:b07:a99:c36:d451:908e:fc77:a175, 162.158.255.165 Cf-Ray: 6ba651232adb83ba-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="96", "Microsoft Edge";v="96" 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/96.0.4664.55 Safari/537.36 Edg/96.0.1054.43 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: it,it-IT;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6 Cookie: hide_intro=True; views=36; session=.eJx1UctuwjAQ_BefI5TExAkcaZEQjyJApRVVFbmOE5w6sWs7PIr4926QSg5Vb57Z2Z3d8QWlmpuK1rx2aOhMwz1Es0rUaJhTaQFlvBKVyjosLFMmSwVQCJMgiHEwSEhMSJIkA4I6hVSMSg4q4YD9Xy_qtGiE7CykKgqetYtZVd-MEhwEHqpcodLGclPTqp2bYaagX9HG7cPUOupaNtzi1bosN3rCZKLybTne7V9e5-fj9-OCLTu9U58czrwgyhi39hcjtf7S0Vivgkgtff2xpctYz0bT0yiMntgY-vlJC8NtSiGxgOBBFPejOOqFfhTGuCu3GRK_n_i-hwzPgdrfPQ7HeBMvWDl_cKdssimfySaf7aZidSixCMADEtRwzBvEBj8j8jNwt5Ds_dErFVi8e-g2NHXntgGNODXcoKuH_sTnqCk47Fw3Ul5_AILMowA.YbCyHg.ZJjts5VFDwN6Gm-odrLFEQE2mkM Cf-Connecting-Ip: 2001:b07:a99:c36:d451:908e:fc77:a175 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (230.2 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['361173198676688896', 8311] (slow_query, 230.2, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UctuwjAQ_BefI5TExAkcaZEQjyJApRVVFbmOE5w6sWs7PIr4926QSg5Vb57Z2Z3d8QWlmpuK1rx2aOhMwz1Es0rUaJhTaQFlvBKVyjosLFMmSwVQCJMgiHEwSEhMSJIkA4I6hVSMSg4q4YD9Xy_qtGiE7CykKgqetYtZVd-MEhwEHqpcodLGclPTqp2bYaagX9HG7cPUOupaNtzi1bosN3rCZKLybTne7V9e5-fj9-OCLTu9U58czrwgyhi39hcjtf7S0Vivgkgtff2xpctYz0bT0yiMntgY-vlJC8NtSiGxgOBBFPejOOqFfhTGuCu3GRK_n_i-hwzPgdrfPQ7HeBMvWDl_cKdssimfySaf7aZidSixCMADEtRwzBvEBj8j8jNwt5Ds_dErFVi8e-g2NHXntgGNODXcoKuH_sTnqCk47Fw3Ul5_AILMowA.YbCyTA.s8Eb5AQiUiQ0mJumoQxHuaGqCc8'), ('views', '42')]) Endpoint: retire_deck View Args: {} Person: 361173198676688896 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '161713'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 2001:b07:a99:c36:d451:908e:fc77:a175, 162.158.255.165 Cf-Ray: 6ba65209afe783ba-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="96", "Microsoft Edge";v="96" 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/96.0.4664.55 Safari/537.36 Edg/96.0.1054.43 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: it,it-IT;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6 Cookie: hide_intro=True; session=.eJx1UctuwjAQ_BefI5TExAkcaZEQjyJApRVVFbmOE5w6sWs7PIr4926QSg5Vb57Z2Z3d8QWlmpuK1rx2aOhMwz1Es0rUaJhTaQFlvBKVyjosLFMmSwVQCJMgiHEwSEhMSJIkA4I6hVSMSg4q4YD9Xy_qtGiE7CykKgqetYtZVd-MEhwEHqpcodLGclPTqp2bYaagX9HG7cPUOupaNtzi1bosN3rCZKLybTne7V9e5-fj9-OCLTu9U58czrwgyhi39hcjtf7S0Vivgkgtff2xpctYz0bT0yiMntgY-vlJC8NtSiGxgOBBFPejOOqFfhTGuCu3GRK_n_i-hwzPgdrfPQ7HeBMvWDl_cKdssimfySaf7aZidSixCMADEtRwzBvEBj8j8jNwt5Ds_dErFVi8e-g2NHXntgGNODXcoKuH_sTnqCk47Fw3Ul5_AILMowA.YbCyTA.s8Eb5AQiUiQ0mJumoQxHuaGqCc8; views=42 Cf-Connecting-Ip: 2001:b07:a99:c36:d451:908e:fc77:a175 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (74.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['361173198676688896', 8311] (slow_query, 74.5, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UV1PwjAU_S99XszKWLvxiJIgKIiAJhqzlK0bnd1a244PCf_dOxLZg_Gt59xz77n39IQSzU3Fal47NHCm4R5iWSVqNMiZtIAyXolKZR0WNlUmSwRQKCAY0wDHEaGERFEUE9QppEqZ5KASDtj_9aJOikbIzkKqouBZu5hV9cUoCjD2UOUKlTSWm5pV7dwsSBX0K9a4bS-xjrmWvc9Hs_E3XWm5XU3W-9e4WG_uZk1OFmQfPHV6pz45nHlCLE25tb8YqecvHY70Aodq7uvNC5tTPR1ODsNeOEtH0M8PWhhuEwaJYRLEIe1T6t_EfYJ7uCu3GRK_H_m-hwzPgdpePXZ7uqSPaflw6w7ZeFmuyTKfvk3EYlcGAoMHJKjhmHeIDX5G5EfgLiHZ6-OmVGDx4aHL0MQd2wY05Mxwg84e-hOfY6bgsHPdSHn-AQbVoog.YbCy6A.fM5xqTKdySDTWz57jXwPlqO-aFM'), ('views', '66')]) Endpoint: retire_deck View Args: {} Person: 361173198676688896 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '161713'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 2001:b07:a99:c36:d451:908e:fc77:a175, 162.158.255.165 Cf-Ray: 6ba655d6cd7383ba-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="96", "Microsoft Edge";v="96" 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/96.0.4664.55 Safari/537.36 Edg/96.0.1054.43 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: it,it-IT;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6 Cookie: hide_intro=True; session=.eJx1UV1PwjAU_S99XszKWLvxiJIgKIiAJhqzlK0bnd1a244PCf_dOxLZg_Gt59xz77n39IQSzU3Fal47NHCm4R5iWSVqNMiZtIAyXolKZR0WNlUmSwRQKCAY0wDHEaGERFEUE9QppEqZ5KASDtj_9aJOikbIzkKqouBZu5hV9cUoCjD2UOUKlTSWm5pV7dwsSBX0K9a4bS-xjrmWvc9Hs_E3XWm5XU3W-9e4WG_uZk1OFmQfPHV6pz45nHlCLE25tb8YqecvHY70Aodq7uvNC5tTPR1ODsNeOEtH0M8PWhhuEwaJYRLEIe1T6t_EfYJ7uCu3GRK_H_m-hwzPgdpePXZ7uqSPaflw6w7ZeFmuyTKfvk3EYlcGAoMHJKjhmHeIDX5G5EfgLiHZ6-OmVGDx4aHL0MQd2wY05Mxwg84e-hOfY6bgsHPdSHn-AQbVoog.YbCy6A.fM5xqTKdySDTWz57jXwPlqO-aFM; views=66 Cf-Connecting-Ip: 2001:b07:a99:c36:d451:908e:fc77:a175 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (104.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['278806026264772618', 4533] (slow_query, 104.4, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.780021484.1597680212'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '178872'), ('views', '483'), ('session', '.eJx1kdtuwjAMht8l1x3qIaQdl4itYyBgHDakaaqyNm0DbVKSVIUh3n1uJeBi2l3s3_ZvfzmjqGKqpIIJgwZG1cxCNCm5QIOUFhqihJW8lMlVTLiOpUoiDhnk-kFgE9slLsG-7xInQPeKQsa0YFDFxMNmBcL_LVxEWc2Lm0khs4wl7WZais4K9z3PQqXJZFRrpgQtu8lUGdheO64HUyStTe5G2lDTihKPtfM42e2f9MvPbLY8TuRTsV3Wi8asQ3GvN3LP4NwzonHMtL7GaJ0fYiPx-n1eTRtnLp-rw3KTj6earV75CfrZseKK6YgCOYdg2_f6LsY9jLFDguCutzCJjQPbtpBiKaTymwle7aejtyYMDsNwXJ3Kb-5uR_ttU4eL9IOACbCs4JpPoAdfxNPWuGOlb4_eToLFl4W6oZE5tQ1oCHCYQhcL_cFoqMoYLC3qorj8Ai1zpxI.YnrhXQ.dlXdDk6we8Vp-B-MfPPn63MO58s')]) Endpoint: retire_deck View Args: {} Person: 278806026264772618 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '178872'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2601:646:c600:b:95f1:ab9f:ecd8:f95d, 172.68.189.42 Cf-Ray: 7095f8792b4f9818-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" 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/101.0.4951.54 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: en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7 Cookie: _ga=GA1.2.780021484.1597680212; hide_intro=True; page_size=20; deck_id=178872; views=483; session=.eJx1kdtuwjAMht8l1x3qIaQdl4itYyBgHDakaaqyNm0DbVKSVIUh3n1uJeBi2l3s3_ZvfzmjqGKqpIIJgwZG1cxCNCm5QIOUFhqihJW8lMlVTLiOpUoiDhnk-kFgE9slLsG-7xInQPeKQsa0YFDFxMNmBcL_LVxEWc2Lm0khs4wl7WZais4K9z3PQqXJZFRrpgQtu8lUGdheO64HUyStTe5G2lDTihKPtfM42e2f9MvPbLY8TuRTsV3Wi8asQ3GvN3LP4NwzonHMtL7GaJ0fYiPx-n1eTRtnLp-rw3KTj6earV75CfrZseKK6YgCOYdg2_f6LsY9jLFDguCutzCJjQPbtpBiKaTymwle7aejtyYMDsNwXJ3Kb-5uR_ttU4eL9IOACbCs4JpPoAdfxNPWuGOlb4_eToLFl4W6oZE5tQ1oCHCYQhcL_cFoqMoYLC3qorj8Ai1zpxI.YnrhXQ.dlXdDk6we8Vp-B-MfPPn63MO58s Cf-Connecting-Ip: 2601:646:c600:b:95f1:ab9f:ecd8:f95d Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (68.6 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['278806026264772618', 4533] (slow_query, 68.6, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.780021484.1597680212'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '178872'), ('views', '487'), ('session', '.eJx1kdtuwjAMht8l1x3qIaQdl4itYyBgHDakaaqyNm0DbVKSVIUh3n1uJeBi2l3s3_ZvfzmjqGKqpIIJgwZG1cxCNCm5QIOUFhqihJW8lMlVTLiOpUoiDhnk-kFgE9slLsG-7xInQPeKQsa0YFDFxMNmBcL_LVxEWc2Lm0khs4wl7WZais4K9z3PQqXJZFRrpgQtu8lUGdheO64HUyStTe5G2lDTihKPtfM42e2f9MvPbLY8TuRTsV3Wi8asQ3GvN3LP4NwzonHMtL7GaJ0fYiPx-n1eTRtnLp-rw3KTj6earV75CfrZseKK6YgCOYdg2_f6LsY9jLFDguCutzCJjQPbtpBiKaTymwle7aejtyYMDsNwXJ3Kb-5uR_ttU4eL9IOACbCs4JpPoAdfxNPWuGOlb4_eToLFl4W6oZE5tQ1oCHCYQhcL_cFoqMoYLC3qorj8Ai1zpxI.YnrhjQ.QuQXaqu39LVI0SwcvCYw_-hnzwQ')]) Endpoint: retire_deck View Args: {} Person: 278806026264772618 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '178872'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2601:646:c600:b:95f1:ab9f:ecd8:f95d, 172.68.189.42 Cf-Ray: 7095f95a3df79818-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" 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/101.0.4951.54 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: en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7 Cookie: _ga=GA1.2.780021484.1597680212; hide_intro=True; page_size=20; deck_id=178872; views=487; session=.eJx1kdtuwjAMht8l1x3qIaQdl4itYyBgHDakaaqyNm0DbVKSVIUh3n1uJeBi2l3s3_ZvfzmjqGKqpIIJgwZG1cxCNCm5QIOUFhqihJW8lMlVTLiOpUoiDhnk-kFgE9slLsG-7xInQPeKQsa0YFDFxMNmBcL_LVxEWc2Lm0khs4wl7WZais4K9z3PQqXJZFRrpgQtu8lUGdheO64HUyStTe5G2lDTihKPtfM42e2f9MvPbLY8TuRTsV3Wi8asQ3GvN3LP4NwzonHMtL7GaJ0fYiPx-n1eTRtnLp-rw3KTj6earV75CfrZseKK6YgCOYdg2_f6LsY9jLFDguCutzCJjQPbtpBiKaTymwle7aejtyYMDsNwXJ3Kb-5uR_ttU4eL9IOACbCs4JpPoAdfxNPWuGOlb4_eToLFl4W6oZE5tQ1oCHCYQhcL_cFoqMoYLC3qorj8Ai1zpxI.YnrhjQ.QuQXaqu39LVI0SwcvCYw_-hnzwQ Cf-Connecting-Ip: 2601:646:c600:b:95f1:ab9f:ecd8:f95d Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (111.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['278806026264772618', 4533] (slow_query, 111.5, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.780021484.1597680212'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '178872'), ('views', '483'), ('session', '.eJx1kdtuwjAMht8l1x3qIaQdl4itYyBgHDakaaqyNm0DbVKSVIUh3n1uJeBi2l3s3_ZvfzmjqGKqpIIJgwZG1cxCNCm5QIOUFhqihJW8lMlVTLiOpUoiDhnk-kFgE9slLsG-7xInQPeKQsa0YFDFxMNmBcL_LVxEWc2Lm0khs4wl7WZais4K9z3PQqXJZFRrpgQtu8lUGdheO64HUyStTe5G2lDTihKPtfM42e2f9MvPbLY8TuRTsV3Wi8asQ3GvN3LP4NwzonHMtL7GaJ0fYiPx-n1eTRtnLp-rw3KTj6earV75CfrZseKK6YgCOYdg2_f6LsY9jLFDguCutzCJjQPbtpBiKaTymwle7aejtyYMDsNwXJ3Kb-5uR_ttU4eL9IOACbCs4JpPoAdfxNPWuGOlb4_eToLFl4W6oZE5tQ1oCHCYQhcL_cFoqMoYLC3qorj8Ai1zpxI.YnrhXQ.dlXdDk6we8Vp-B-MfPPn63MO58s')]) Endpoint: retire_deck View Args: {} Person: 278806026264772618 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '178872'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2601:646:c600:b:95f1:ab9f:ecd8:f95d, 172.68.189.42 Cf-Ray: 7095f84dda449818-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" 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/101.0.4951.54 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: en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7 Cookie: _ga=GA1.2.780021484.1597680212; hide_intro=True; page_size=20; deck_id=178872; views=483; session=.eJx1kdtuwjAMht8l1x3qIaQdl4itYyBgHDakaaqyNm0DbVKSVIUh3n1uJeBi2l3s3_ZvfzmjqGKqpIIJgwZG1cxCNCm5QIOUFhqihJW8lMlVTLiOpUoiDhnk-kFgE9slLsG-7xInQPeKQsa0YFDFxMNmBcL_LVxEWc2Lm0khs4wl7WZais4K9z3PQqXJZFRrpgQtu8lUGdheO64HUyStTe5G2lDTihKPtfM42e2f9MvPbLY8TuRTsV3Wi8asQ3GvN3LP4NwzonHMtL7GaJ0fYiPx-n1eTRtnLp-rw3KTj6earV75CfrZseKK6YgCOYdg2_f6LsY9jLFDguCutzCJjQPbtpBiKaTymwle7aejtyYMDsNwXJ3Kb-5uR_ttU4eL9IOACbCs4JpPoAdfxNPWuGOlb4_eToLFl4W6oZE5tQ1oCHCYQhcL_cFoqMoYLC3qorj8Ai1zpxI.YnrhXQ.dlXdDk6we8Vp-B-MfPPn63MO58s Cf-Connecting-Ip: 2601:646:c600:b:95f1:ab9f:ecd8:f95d Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (115.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['278806026264772618', 4533] (slow_query, 115.5, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.780021484.1597680212'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '178872'), ('views', '483'), ('session', '.eJx1kdtuwjAMht8l1x3qIaQdl4itYyBgHDakaaqyNm0DbVKSVIUh3n1uJeBi2l3s3_ZvfzmjqGKqpIIJgwZG1cxCNCm5QIOUFhqihJW8lMlVTLiOpUoiDhnk-kFgE9slLsG-7xInQPeKQsa0YFDFxMNmBcL_LVxEWc2Lm0khs4wl7WZais4K9z3PQqXJZFRrpgQtu8lUGdheO64HUyStTe5G2lDTihKPtfM42e2f9MvPbLY8TuRTsV3Wi8asQ3GvN3LP4NwzonHMtL7GaJ0fYiPx-n1eTRtnLp-rw3KTj6earV75CfrZseKK6YgCOYdg2_f6LsY9jLFDguCutzCJjQPbtpBiKaTymwle7aejtyYMDsNwXJ3Kb-5uR_ttU4eL9IOACbCs4JpPoAdfxNPWuGOlb4_eToLFl4W6oZE5tQ1oCHCYQhcL_cFoqMoYLC3qorj8Ai1zpxI.YnrhXQ.dlXdDk6we8Vp-B-MfPPn63MO58s')]) Endpoint: retire_deck View Args: {} Person: 278806026264772618 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '178872'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2601:646:c600:b:95f1:ab9f:ecd8:f95d, 172.68.189.42 Cf-Ray: 7095f833fdde9818-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" 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/101.0.4951.54 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: en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7 Cookie: _ga=GA1.2.780021484.1597680212; hide_intro=True; page_size=20; deck_id=178872; views=483; session=.eJx1kdtuwjAMht8l1x3qIaQdl4itYyBgHDakaaqyNm0DbVKSVIUh3n1uJeBi2l3s3_ZvfzmjqGKqpIIJgwZG1cxCNCm5QIOUFhqihJW8lMlVTLiOpUoiDhnk-kFgE9slLsG-7xInQPeKQsa0YFDFxMNmBcL_LVxEWc2Lm0khs4wl7WZais4K9z3PQqXJZFRrpgQtu8lUGdheO64HUyStTe5G2lDTihKPtfM42e2f9MvPbLY8TuRTsV3Wi8asQ3GvN3LP4NwzonHMtL7GaJ0fYiPx-n1eTRtnLp-rw3KTj6earV75CfrZseKK6YgCOYdg2_f6LsY9jLFDguCutzCJjQPbtpBiKaTymwle7aejtyYMDsNwXJ3Kb-5uR_ttU4eL9IOACbCs4JpPoAdfxNPWuGOlb4_eToLFl4W6oZE5tQ1oCHCYQhcL_cFoqMoYLC3qorj8Ai1zpxI.YnrhXQ.dlXdDk6we8Vp-B-MfPPn63MO58s Cf-Connecting-Ip: 2601:646:c600:b:95f1:ab9f:ecd8:f95d Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (126.0 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['83948327397265408', 9531] (slow_query, 126.0, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UdluwjAQ_Bc_p1VISOL0rYjQC9QD0VNVZJIlGHyktlNAiH_vhqrNQ9U37-zMzu54T_IajGQKlCNnzjTgEVZKrsjZggmLVQmSS112NbeFNmXOESI0TPs0DJIwTYI46vuUdAShCyYASaBOZlNs_KvgKq8aLjoPoasKynYzq9XRKY3Cnkekq3TeWDCKyXbymjvIcYBmjVsGuXXMtfD1NPqItJ3b4eo2M-pCPsnJ8x1_CT_uNhPo-E6vAQ_dE1YUYO1PTWjq6kGmloVYRFSn44dYz86rQTHU2UwuUQ_bmhuwOcPMenGE1wRxQk_9lIZJ2LXbFGO_T33fIwYWCC1_PT634n4zrlM6vXzkwc0qyJJRb-hGV6_ZaG7RA0Os8Zg3cozGHvPDT-KLHT6_sdOVRot3jxyH5m7XCsgAmAFDDh75k59jpgLcWTVCHL4AWfKj6g.YnrjyQ.ApH05l_Ox8UyGmDP95QNZaNunRk'), ('views', '19'), ('page_size', '20')]) Endpoint: retire_deck View Args: {} Person: 83948327397265408 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '178931'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 96.253.49.23, 172.68.189.42 Cf-Ray: 70960771290d19df-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:100.0) Gecko/20100101 Firefox/100.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 Content-Type: application/x-www-form-urlencoded 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 Sec-Gpc: 1 Cookie: hide_intro=True; session=.eJx1UdluwjAQ_Bc_p1VISOL0rYjQC9QD0VNVZJIlGHyktlNAiH_vhqrNQ9U37-zMzu54T_IajGQKlCNnzjTgEVZKrsjZggmLVQmSS112NbeFNmXOESI0TPs0DJIwTYI46vuUdAShCyYASaBOZlNs_KvgKq8aLjoPoasKynYzq9XRKY3Cnkekq3TeWDCKyXbymjvIcYBmjVsGuXXMtfD1NPqItJ3b4eo2M-pCPsnJ8x1_CT_uNhPo-E6vAQ_dE1YUYO1PTWjq6kGmloVYRFSn44dYz86rQTHU2UwuUQ_bmhuwOcPMenGE1wRxQk_9lIZJ2LXbFGO_T33fIwYWCC1_PT634n4zrlM6vXzkwc0qyJJRb-hGV6_ZaG7RA0Os8Zg3cozGHvPDT-KLHT6_sdOVRot3jxyH5m7XCsgAmAFDDh75k59jpgLcWTVCHL4AWfKj6g.YnrjyQ.ApH05l_Ox8UyGmDP95QNZaNunRk; views=19; page_size=20 Cf-Connecting-Ip: 96.253.49.23 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (69.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['646838092384305154', 7809] (slow_query, 69.8, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1905565202.1613757035'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '179308'), ('session', '.eJx1UV1PhDAQ_C99xgtcSw998-6MH9Hz9BSNxpAGFugJLbYlgub-u8sZ5cH41t3ZmdmdfpKkAVMLBcqRI2da8IjIaqnIUS4qi1UGtax1NtbSptpkicQW4YxHNPIPpzRi1A-DkJFxotKpqACnQB3cbxD4nyJVUrSyGl0qXRSQDbtZrfZeM-R4pHaFTloLRol6kN5qMCzwp6ihRevKaWKdcAOyXCyvQlp2i-XyeL1azxuW3tW3D5cp5fP3YJx3-hXw2k8i0hSs_amJfhPxR0k_rh87rtVmLWLWx13_1J2Zm6cT5EPXSAM2ERhcwFnIZyFlwYRTOg392YgPWXKfRb7vEQM5tspfE1kGfMGFzk_BtPUsaoO-OYw3F2x1fpNyNMEkG7zmmezjsdj5fky2GnWHSPHjZN6TF4_sRRPXDwQyB2HAkJ1H_mTohCkAl1ZtVe2-ACgepHc.Yn5qog.W9a-2iclzT7eDwLe_2SF-bmCNQI'), ('views', '91')]) Endpoint: retire_deck View Args: {} Person: 646838092384305154 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '179308'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2603:7081:3240:d2::1009, 172.68.143.233 Cf-Ray: 70ac127a18b32a99-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" 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/101.0.4951.54 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: en-US,en;q=0.9 Cookie: _ga=GA1.2.1905565202.1613757035; hide_intro=True; page_size=20; deck_id=179308; session=.eJx1UV1PhDAQ_C99xgtcSw998-6MH9Hz9BSNxpAGFugJLbYlgub-u8sZ5cH41t3ZmdmdfpKkAVMLBcqRI2da8IjIaqnIUS4qi1UGtax1NtbSptpkicQW4YxHNPIPpzRi1A-DkJFxotKpqACnQB3cbxD4nyJVUrSyGl0qXRSQDbtZrfZeM-R4pHaFTloLRol6kN5qMCzwp6ihRevKaWKdcAOyXCyvQlp2i-XyeL1azxuW3tW3D5cp5fP3YJx3-hXw2k8i0hSs_amJfhPxR0k_rh87rtVmLWLWx13_1J2Zm6cT5EPXSAM2ERhcwFnIZyFlwYRTOg392YgPWXKfRb7vEQM5tspfE1kGfMGFzk_BtPUsaoO-OYw3F2x1fpNyNMEkG7zmmezjsdj5fky2GnWHSPHjZN6TF4_sRRPXDwQyB2HAkJ1H_mTohCkAl1ZtVe2-ACgepHc.Yn5qog.W9a-2iclzT7eDwLe_2SF-bmCNQI; views=91 Cf-Connecting-Ip: 2603:7081:3240:d2::1009 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (82.3 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['646838092384305154', 7809] (slow_query, 82.3, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1905565202.1613757035'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '179308'), ('session', '.eJx1UV1PhDAQ_C99xgtcSw998-6MH9Hz9BSNxpAGFugJLbYlgub-u8sZ5cH41t3ZmdmdfpKkAVMLBcqRI2da8IjIaqnIUS4qi1UGtax1NtbSptpkicQW4YxHNPIPpzRi1A-DkJFxotKpqACnQB3cbxD4nyJVUrSyGl0qXRSQDbtZrfZeM-R4pHaFTloLRol6kN5qMCzwp6ihRevKaWKdcAOyXCyvQlp2i-XyeL1azxuW3tW3D5cp5fP3YJx3-hXw2k8i0hSs_amJfhPxR0k_rh87rtVmLWLWx13_1J2Zm6cT5EPXSAM2ERhcwFnIZyFlwYRTOg392YgPWXKfRb7vEQM5tspfE1kGfMGFzk_BtPUsaoO-OYw3F2x1fpNyNMEkG7zmmezjsdj5fky2GnWHSPHjZN6TF4_sRRPXDwQyB2HAkJ1H_mTohCkAl1ZtVe2-ACgepHc.Yn5qog.W9a-2iclzT7eDwLe_2SF-bmCNQI'), ('views', '91')]) Endpoint: retire_deck View Args: {} Person: 646838092384305154 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '179308'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2603:7081:3240:d2::1009, 172.68.143.233 Cf-Ray: 70ac122c3eaa2a99-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" 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/101.0.4951.54 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: en-US,en;q=0.9 Cookie: _ga=GA1.2.1905565202.1613757035; hide_intro=True; page_size=20; deck_id=179308; session=.eJx1UV1PhDAQ_C99xgtcSw998-6MH9Hz9BSNxpAGFugJLbYlgub-u8sZ5cH41t3ZmdmdfpKkAVMLBcqRI2da8IjIaqnIUS4qi1UGtax1NtbSptpkicQW4YxHNPIPpzRi1A-DkJFxotKpqACnQB3cbxD4nyJVUrSyGl0qXRSQDbtZrfZeM-R4pHaFTloLRol6kN5qMCzwp6ihRevKaWKdcAOyXCyvQlp2i-XyeL1azxuW3tW3D5cp5fP3YJx3-hXw2k8i0hSs_amJfhPxR0k_rh87rtVmLWLWx13_1J2Zm6cT5EPXSAM2ERhcwFnIZyFlwYRTOg392YgPWXKfRb7vEQM5tspfE1kGfMGFzk_BtPUsaoO-OYw3F2x1fpNyNMEkG7zmmezjsdj5fky2GnWHSPHjZN6TF4_sRRPXDwQyB2HAkJ1H_mTohCkAl1ZtVe2-ACgepHc.Yn5qog.W9a-2iclzT7eDwLe_2SF-bmCNQI; views=91 Cf-Connecting-Ip: 2603:7081:3240:d2::1009 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (79.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['646838092384305154', 7809] (slow_query, 79.1, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1905565202.1613757035'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '179308'), ('session', '.eJx1UV1PhDAQ_C99xgtcSw998-6MH9Hz9BSNxpAGFugJLbYlgub-u8sZ5cH41t3ZmdmdfpKkAVMLBcqRI2da8IjIaqnIUS4qi1UGtax1NtbSptpkicQW4YxHNPIPpzRi1A-DkJFxotKpqACnQB3cbxD4nyJVUrSyGl0qXRSQDbtZrfZeM-R4pHaFTloLRol6kN5qMCzwp6ihRevKaWKdcAOyXCyvQlp2i-XyeL1azxuW3tW3D5cp5fP3YJx3-hXw2k8i0hSs_amJfhPxR0k_rh87rtVmLWLWx13_1J2Zm6cT5EPXSAM2ERhcwFnIZyFlwYRTOg392YgPWXKfRb7vEQM5tspfE1kGfMGFzk_BtPUsaoO-OYw3F2x1fpNyNMEkG7zmmezjsdj5fky2GnWHSPHjZN6TF4_sRRPXDwQyB2HAkJ1H_mTohCkAl1ZtVe2-ACgepHc.Yn5qog.W9a-2iclzT7eDwLe_2SF-bmCNQI'), ('views', '91')]) Endpoint: retire_deck View Args: {} Person: 646838092384305154 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '179308'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2603:7081:3240:d2::1009, 172.68.143.233 Cf-Ray: 70ac1240ee402a99-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" 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/101.0.4951.54 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: en-US,en;q=0.9 Cookie: _ga=GA1.2.1905565202.1613757035; hide_intro=True; page_size=20; deck_id=179308; session=.eJx1UV1PhDAQ_C99xgtcSw998-6MH9Hz9BSNxpAGFugJLbYlgub-u8sZ5cH41t3ZmdmdfpKkAVMLBcqRI2da8IjIaqnIUS4qi1UGtax1NtbSptpkicQW4YxHNPIPpzRi1A-DkJFxotKpqACnQB3cbxD4nyJVUrSyGl0qXRSQDbtZrfZeM-R4pHaFTloLRol6kN5qMCzwp6ihRevKaWKdcAOyXCyvQlp2i-XyeL1azxuW3tW3D5cp5fP3YJx3-hXw2k8i0hSs_amJfhPxR0k_rh87rtVmLWLWx13_1J2Zm6cT5EPXSAM2ERhcwFnIZyFlwYRTOg392YgPWXKfRb7vEQM5tspfE1kGfMGFzk_BtPUsaoO-OYw3F2x1fpNyNMEkG7zmmezjsdj5fky2GnWHSPHjZN6TF4_sRRPXDwQyB2HAkJ1H_mTohCkAl1ZtVe2-ACgepHc.Yn5qog.W9a-2iclzT7eDwLe_2SF-bmCNQI; views=91 Cf-Connecting-Ip: 2603:7081:3240:d2::1009 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (60.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['646838092384305154', 7809] (slow_query, 60.7, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1905565202.1613757035'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '179308'), ('session', '.eJx1UV1PhDAQ_C99xgtcSw998-6MH9Hz9BSNxpAGFugJLbYlgub-u8sZ5cH41t3ZmdmdfpKkAVMLBcqRI2da8IjIaqnIUS4qi1UGtax1NtbSptpkicQW4YxHNPIPpzRi1A-DkJFxotKpqACnQB3cbxD4nyJVUrSyGl0qXRSQDbtZrfZeM-R4pHaFTloLRol6kN5qMCzwp6ihRevKaWKdcAOyXCyvQlp2i-XyeL1azxuW3tW3D5cp5fP3YJx3-hXw2k8i0hSs_amJfhPxR0k_rh87rtVmLWLWx13_1J2Zm6cT5EPXSAM2ERhcwFnIZyFlwYRTOg392YgPWXKfRb7vEQM5tspfE1kGfMGFzk_BtPUsaoO-OYw3F2x1fpNyNMEkG7zmmezjsdj5fky2GnWHSPHjZN6TF4_sRRPXDwQyB2HAkJ1H_mTohCkAl1ZtVe2-ACgepHc.Yn5quQ.ySiWXvgndSo-VK6Y8gx352JqQ5g'), ('views', '94')]) Endpoint: retire_deck View Args: {} Person: 646838092384305154 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '179308'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2603:7081:3240:d2::1009, 172.68.143.233 Cf-Ray: 70ac12b3bfa82a99-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" 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/101.0.4951.54 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: en-US,en;q=0.9 Cookie: _ga=GA1.2.1905565202.1613757035; hide_intro=True; page_size=20; deck_id=179308; session=.eJx1UV1PhDAQ_C99xgtcSw998-6MH9Hz9BSNxpAGFugJLbYlgub-u8sZ5cH41t3ZmdmdfpKkAVMLBcqRI2da8IjIaqnIUS4qi1UGtax1NtbSptpkicQW4YxHNPIPpzRi1A-DkJFxotKpqACnQB3cbxD4nyJVUrSyGl0qXRSQDbtZrfZeM-R4pHaFTloLRol6kN5qMCzwp6ihRevKaWKdcAOyXCyvQlp2i-XyeL1azxuW3tW3D5cp5fP3YJx3-hXw2k8i0hSs_amJfhPxR0k_rh87rtVmLWLWx13_1J2Zm6cT5EPXSAM2ERhcwFnIZyFlwYRTOg392YgPWXKfRb7vEQM5tspfE1kGfMGFzk_BtPUsaoO-OYw3F2x1fpNyNMEkG7zmmezjsdj5fky2GnWHSPHjZN6TF4_sRRPXDwQyB2HAkJ1H_mTohCkAl1ZtVe2-ACgepHc.Yn5quQ.ySiWXvgndSo-VK6Y8gx352JqQ5g; views=94 Cf-Connecting-Ip: 2603:7081:3240:d2::1009 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (73.6 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['646838092384305154', 7809] (slow_query, 73.6, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1905565202.1613757035'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '179308'), ('session', '.eJx1UV1PhDAQ_C99xgtcSw998-6MH9Hz9BSNxpAGFugJLbYlgub-u8sZ5cH41t3ZmdmdfpKkAVMLBcqRI2da8IjIaqnIUS4qi1UGtax1NtbSptpkicQW4YxHNPIPpzRi1A-DkJFxotKpqACnQB3cbxD4nyJVUrSyGl0qXRSQDbtZrfZeM-R4pHaFTloLRol6kN5qMCzwp6ihRevKaWKdcAOyXCyvQlp2i-XyeL1azxuW3tW3D5cp5fP3YJx3-hXw2k8i0hSs_amJfhPxR0k_rh87rtVmLWLWx13_1J2Zm6cT5EPXSAM2ERhcwFnIZyFlwYRTOg392YgPWXKfRb7vEQM5tspfE1kGfMGFzk_BtPUsaoO-OYw3F2x1fpNyNMEkG7zmmezjsdj5fky2GnWHSPHjZN6TF4_sRRPXDwQyB2HAkJ1H_mTohCkAl1ZtVe2-ACgepHc.Yn5qog.W9a-2iclzT7eDwLe_2SF-bmCNQI'), ('views', '91')]) Endpoint: retire_deck View Args: {} Person: 646838092384305154 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '179308'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2603:7081:3240:d2::1009, 172.68.143.233 Cf-Ray: 70ac1262fe022a99-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" 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/101.0.4951.54 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: en-US,en;q=0.9 Cookie: _ga=GA1.2.1905565202.1613757035; hide_intro=True; page_size=20; deck_id=179308; session=.eJx1UV1PhDAQ_C99xgtcSw998-6MH9Hz9BSNxpAGFugJLbYlgub-u8sZ5cH41t3ZmdmdfpKkAVMLBcqRI2da8IjIaqnIUS4qi1UGtax1NtbSptpkicQW4YxHNPIPpzRi1A-DkJFxotKpqACnQB3cbxD4nyJVUrSyGl0qXRSQDbtZrfZeM-R4pHaFTloLRol6kN5qMCzwp6ihRevKaWKdcAOyXCyvQlp2i-XyeL1azxuW3tW3D5cp5fP3YJx3-hXw2k8i0hSs_amJfhPxR0k_rh87rtVmLWLWx13_1J2Zm6cT5EPXSAM2ERhcwFnIZyFlwYRTOg392YgPWXKfRb7vEQM5tspfE1kGfMGFzk_BtPUsaoO-OYw3F2x1fpNyNMEkG7zmmezjsdj5fky2GnWHSPHjZN6TF4_sRRPXDwQyB2HAkJ1H_mTohCkAl1ZtVe2-ACgepHc.Yn5qog.W9a-2iclzT7eDwLe_2SF-bmCNQI; views=91 Cf-Connecting-Ip: 2603:7081:3240:d2::1009 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (64.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['208240085580120064', 10] (slow_query, 64.5, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '179403'), ('session', '.eJx1UVtPgzAY_S99xqVlgGVvm9myocTNeVliDOloYR3QYlt0l-y_W4hKYuLjOd853-V8Z5DUTFVEMGHAyKiGOYDQigswykipLaKs4pWkPeY6lYom3FLAhdj1IMS-jyFyIQw80CtKmZKSWRUTV09rW_jfwkWSN7zsp5Qyzxltd9NSdLMQdEBlcpk0milBqrbxJ6nrkli_JI3ZuYk2xLT8tKi39zGNRR5FJl6E5ERmRbx5pOFpudr3eiMLZi89A5KmTOsfDJA_WS_GzSaYP8zM6fn9ZX5XjcfFUt2E9Dq0fnaouWI6ITY0FPhDBDHCwcBFOPSx19fbHAPoYWiXVyyz1O53yJBMdRNlS4mOizlEt4cTDFcf2yLaSh20R9kUa3vNK-ii0YO9tO2cb9TFaZ_GsyN4c0DXNDHH1gAmjCimwMUBf_IzROXMriyasrx8AXwlo5o.Yn-9_g.IaWyb5BtoJuxFHh5D3eenfBzNX4'), ('views', '793')]) Endpoint: retire_deck View Args: {} Person: 208240085580120064 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '179403'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2600:8803:c0e:900:b4f2:5cab:5102:6920, 172.68.143.233 Cf-Ray: 70b45b21ca416275-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 Dnt: 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/101.0.4951.67 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: en-US,en;q=0.9,de;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=179403; session=.eJx1UVtPgzAY_S99xqVlgGVvm9myocTNeVliDOloYR3QYlt0l-y_W4hKYuLjOd853-V8Z5DUTFVEMGHAyKiGOYDQigswykipLaKs4pWkPeY6lYom3FLAhdj1IMS-jyFyIQw80CtKmZKSWRUTV09rW_jfwkWSN7zsp5Qyzxltd9NSdLMQdEBlcpk0milBqrbxJ6nrkli_JI3ZuYk2xLT8tKi39zGNRR5FJl6E5ERmRbx5pOFpudr3eiMLZi89A5KmTOsfDJA_WS_GzSaYP8zM6fn9ZX5XjcfFUt2E9Dq0fnaouWI6ITY0FPhDBDHCwcBFOPSx19fbHAPoYWiXVyyz1O53yJBMdRNlS4mOizlEt4cTDFcf2yLaSh20R9kUa3vNK-ii0YO9tO2cb9TFaZ_GsyN4c0DXNDHH1gAmjCimwMUBf_IzROXMriyasrx8AXwlo5o.Yn-9_g.IaWyb5BtoJuxFHh5D3eenfBzNX4; views=793 Cf-Connecting-Ip: 2600:8803:c0e:900:b4f2:5cab:5102:6920 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (130.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['215611877538004992', 4070] (slow_query, 130.1, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1091926388.1613587486'), ('hide_intro', 'True'), ('session', '.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopH1w.tyJxHDlurNYJqexvYoLCdE50bE4'), ('views', '28'), ('deck_id', '180435'), ('page_size', '20')]) Endpoint: retire_deck View Args: {} Person: 215611877538004992 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '180435'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49, 172.68.133.167 Cf-Ray: 70f638a73ef52640-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:100.0) Gecko/20100101 Firefox/100.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8 Accept-Language: pt-BR,pt;q=0.8,en-US;q=0.5,en;q=0.3 Content-Type: application/x-www-form-urlencoded 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 Cookie: _ga=GA1.2.1091926388.1613587486; hide_intro=True; session=.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopH1w.tyJxHDlurNYJqexvYoLCdE50bE4; views=28; deck_id=180435; page_size=20 Cf-Connecting-Ip: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (144.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['215611877538004992', 4070] (slow_query, 144.5, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1091926388.1613587486'), ('hide_intro', 'True'), ('session', '.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopHyA.txsNYpVC28bdm3WqO3asv_Q30X4'), ('views', '21'), ('deck_id', '180435')]) Endpoint: retire_deck View Args: {} Person: 215611877538004992 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '180435'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49, 172.68.133.167 Cf-Ray: 70f6384cecfd2640-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:100.0) Gecko/20100101 Firefox/100.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8 Accept-Language: pt-BR,pt;q=0.8,en-US;q=0.5,en;q=0.3 Content-Type: application/x-www-form-urlencoded 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 Cookie: _ga=GA1.2.1091926388.1613587486; hide_intro=True; session=.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopHyA.txsNYpVC28bdm3WqO3asv_Q30X4; views=21; deck_id=180435 Cf-Connecting-Ip: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (119.6 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['215611877538004992', 4070] (slow_query, 119.6, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1091926388.1613587486'), ('hide_intro', 'True'), ('session', '.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopLgg.SUvG3LUK6CSdiJw_cOr01cVxfB8'), ('views', '67'), ('deck_id', '180443'), ('page_size', '20')]) Endpoint: retire_deck View Args: {} Person: 215611877538004992 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '180443'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49, 172.68.189.4 Cf-Ray: 70f64fb178a1277e-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:100.0) Gecko/20100101 Firefox/100.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8 Accept-Language: pt-BR,pt;q=0.8,en-US;q=0.5,en;q=0.3 Referer: https://pennydreadfulmagic.com/retire/ Content-Type: application/x-www-form-urlencoded Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 Sec-Fetch-Dest: document Sec-Fetch-Mode: navigate Sec-Fetch-Site: same-origin Sec-Fetch-User: ?1 Cookie: _ga=GA1.2.1091926388.1613587486; hide_intro=True; session=.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopLgg.SUvG3LUK6CSdiJw_cOr01cVxfB8; views=67; deck_id=180443; page_size=20 Cf-Connecting-Ip: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (217.3 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['215611877538004992', 4070] (slow_query, 217.3, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1091926388.1613587486'), ('hide_intro', 'True'), ('session', '.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopLIQ.ojkprfioX-hvqzj5VnUx5a8gWEM'), ('views', '60'), ('deck_id', '180443'), ('page_size', '20')]) Endpoint: retire_deck View Args: {} Person: 215611877538004992 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '180443'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49, 172.68.189.4 Cf-Ray: 70f64d4e6937277e-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:100.0) Gecko/20100101 Firefox/100.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8 Accept-Language: pt-BR,pt;q=0.8,en-US;q=0.5,en;q=0.3 Referer: https://pennydreadfulmagic.com/retire/ Content-Type: application/x-www-form-urlencoded Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 Sec-Fetch-Dest: document Sec-Fetch-Mode: navigate Sec-Fetch-Site: same-origin Sec-Fetch-User: ?1 Cookie: _ga=GA1.2.1091926388.1613587486; hide_intro=True; session=.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopLIQ.ojkprfioX-hvqzj5VnUx5a8gWEM; views=60; deck_id=180443; page_size=20 Cf-Connecting-Ip: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (185.2 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['215611877538004992', 4070] (slow_query, 185.2, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1091926388.1613587486'), ('hide_intro', 'True'), ('session', '.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopLRQ.OqNpIEVy3JVoNxHeksi-aDMx2Xg'), ('views', '66'), ('deck_id', '180443'), ('page_size', '20')]) Endpoint: retire_deck View Args: {} Person: 215611877538004992 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '180443'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49, 172.68.189.4 Cf-Ray: 70f64e1749e9277e-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:100.0) Gecko/20100101 Firefox/100.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8 Accept-Language: pt-BR,pt;q=0.8,en-US;q=0.5,en;q=0.3 Content-Type: application/x-www-form-urlencoded 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 Cookie: _ga=GA1.2.1091926388.1613587486; hide_intro=True; session=.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopLRQ.OqNpIEVy3JVoNxHeksi-aDMx2Xg; views=66; deck_id=180443; page_size=20 Cf-Connecting-Ip: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (282.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['215611877538004992', 4070] (slow_query, 282.1, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1091926388.1613587486'), ('hide_intro', 'True'), ('session', '.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopK5A.3akhfo0ACVWPuo3F3Q591upchy0'), ('views', '59'), ('deck_id', '180443'), ('page_size', '20')]) Endpoint: retire_deck View Args: {} Person: 215611877538004992 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '180443'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49, 172.68.189.4 Cf-Ray: 70f64bb9a825277e-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:100.0) Gecko/20100101 Firefox/100.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8 Accept-Language: pt-BR,pt;q=0.8,en-US;q=0.5,en;q=0.3 Content-Type: application/x-www-form-urlencoded 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 Cookie: _ga=GA1.2.1091926388.1613587486; hide_intro=True; session=.eJx1UdluwkAM_Jd9TlHIHd44ChShFgoqLVUVmcQ5SrKb7oE4xL93g0p5qPo49szYHp9IVCOvgCKVpCO5QoNAUhWUdFIohUYJVkXFkhsuRMx4EhW6RKy267Xbge-7dmCaThha5MYoWQwlalYt73rPuvG_pKBRpooyua5QsizDpFlNMHoZ5Zi-aZBKZixSAjmFqnFOYYtRDCiBMm3DQMncioQE2XQ5hMN0PM_3thistxS6E1vN1oOpvR5Vy_zGl2yL-uATgThGIa6YLL4Wu0m8Ul3vweyp1ehpPBhaq1FYzYLN61TrcV8XHEUEOru259qebwae2XJdK7AD79Zv4vRMR99rEI6pLuW_Q7awGdFl_dj358fc9VN13M2D-17feXkbH0EP0WHW-pp3cklItD6ZtjN-0CVV_bsiPZAPg1xMI3loBKSHwJGTs0H-5CiBZ6iXpqosz99LAKY2.YopK5A.3akhfo0ACVWPuo3F3Q591upchy0; views=59; deck_id=180443; page_size=20 Cf-Connecting-Ip: 2804:14d:7684:96fe:2ce8:e29f:5fa9:1f49 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (198.6 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['497813586492522498', 2752] (slow_query, 198.6, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('page_size', '20'), ('hide_intro', 'True'), ('deck_id', '180920'), ('session', '.eJx1UctuwjAQ_Bef0yoEOw9u9IkolEIAVa2qyCQbY5rYwXYEEeLf64Aoh6o3z87s7O74gJIKVEkFCIN6RtXgIJqVXKBeTgttUQYlL2V2xVynUmUJtyWEoyDsdEno48gjnoejEF0VhUxpAVYF4mYRW-L_Fi4SVvMiu6xQSMYga1fTUpxGeQHxHFQaJpNagxK0PDtnoHacMS6CwPpIWpu1l2hDTUtz-hZHpprcj_PH7WxD9q_M7c-DmsglGwyveiO_wV58QDRNQesLRvM9PAxWO5Ku_C15LjFbPYkRe59MwyZcdm0_7CuuQCfUhtfxCXajCPveresGAQ68K9_m6bs4dF0HKchtaf07pPbjfNkMc_0x2-RpfzpU8STGY9LAyyIe2SE2zcpe84lOEenbjbR2bZr2z3je2OeZQF8OOpkmpmkb0B1QBQodHfQnSEMVA7u0qIvi-ANxEqcW.Yo-UPg.Zjksq6oGS1bTqurNxdnXamjw_uE'), ('views', '1031')]) Endpoint: retire_deck View Args: {} Person: 497813586492522498 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '180920'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 67.87.81.229, 172.68.189.42 Cf-Ray: 71175630ba2857c0-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Google Chrome";v="101" 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/101.0.4951.67 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: en-US,en;q=0.9 Cookie: page_size=20; hide_intro=True; deck_id=180920; session=.eJx1UctuwjAQ_Bef0yoEOw9u9IkolEIAVa2qyCQbY5rYwXYEEeLf64Aoh6o3z87s7O74gJIKVEkFCIN6RtXgIJqVXKBeTgttUQYlL2V2xVynUmUJtyWEoyDsdEno48gjnoejEF0VhUxpAVYF4mYRW-L_Fi4SVvMiu6xQSMYga1fTUpxGeQHxHFQaJpNagxK0PDtnoHacMS6CwPpIWpu1l2hDTUtz-hZHpprcj_PH7WxD9q_M7c-DmsglGwyveiO_wV58QDRNQesLRvM9PAxWO5Ku_C15LjFbPYkRe59MwyZcdm0_7CuuQCfUhtfxCXajCPveresGAQ68K9_m6bs4dF0HKchtaf07pPbjfNkMc_0x2-RpfzpU8STGY9LAyyIe2SE2zcpe84lOEenbjbR2bZr2z3je2OeZQF8OOpkmpmkb0B1QBQodHfQnSEMVA7u0qIvi-ANxEqcW.Yo-UPg.Zjksq6oGS1bTqurNxdnXamjw_uE; views=1031 Cf-Connecting-Ip: 67.87.81.229 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (99.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['159471492835311616', 4562] (slow_query, 99.7, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('page_size', '20'), ('hide_intro', 'True'), ('deck_id', '181662'), ('session', '.eJx1UctuwjAQ_BefU4QTkwRugBrK64JoVbWqIjfZBJPETv2ooIh_74aKcqh68-zOzs6OTyRtQTdcgrRkZLUDj_C8EZKMCl4bRDk0olH5DQuTKZ2nAkuEDoYsomzox8EgoDSkIbkxapXxGpDV2rvJBhv_jwiZlk7U-dVCrcoS8s6aUfKyig1C3yONLVXqDGjJm07ZWCi4LBXoClBGcWd3fmost13X-ehcr--XyUImyWIa7MbxdBzaTJTzfX7jW1UBHnwiPMvAmCsmtdt8AGdfC5HMZ5-N77Yvx2rJVvMqOWzfcR4OrdBgUo7Z0XDAojiIaNgLhgHtR_6t38UZ9lnc73tEQ4Gl3e-SJ1qun_djJYpslbPKsWj2uDQwkw8WhMUlGGaL17ySS0IGKz-P3l6hbpcq_p0ojuTNIxfR1B67ATIBrkGTs0f-5Gi5LgFNS1fX529nbKe4.YpjJxw.EFw3iX5ZJtpHDQnrlO_mfPP71gQ'), ('views', '47')]) Endpoint: retire_deck View Args: {} Person: 159471492835311616 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '181662'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 2804:14c:f287:aadf:a1f4:2906:4e10:cbcf, 172.68.133.167 Cf-Ray: 7150e4c18de99510-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 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/102.0.5005.61 Safari/537.36 Accept-Language: pt-BR;q=0.5 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-Gpc: 1 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/retire/ Cookie: page_size=20; hide_intro=True; deck_id=181662; session=.eJx1UctuwjAQ_BefU4QTkwRugBrK64JoVbWqIjfZBJPETv2ooIh_74aKcqh68-zOzs6OTyRtQTdcgrRkZLUDj_C8EZKMCl4bRDk0olH5DQuTKZ2nAkuEDoYsomzox8EgoDSkIbkxapXxGpDV2rvJBhv_jwiZlk7U-dVCrcoS8s6aUfKyig1C3yONLVXqDGjJm07ZWCi4LBXoClBGcWd3fmost13X-ehcr--XyUImyWIa7MbxdBzaTJTzfX7jW1UBHnwiPMvAmCsmtdt8AGdfC5HMZ5-N77Yvx2rJVvMqOWzfcR4OrdBgUo7Z0XDAojiIaNgLhgHtR_6t38UZ9lnc73tEQ4Gl3e-SJ1qun_djJYpslbPKsWj2uDQwkw8WhMUlGGaL17ySS0IGKz-P3l6hbpcq_p0ojuTNIxfR1B67ATIBrkGTs0f-5Gi5LgFNS1fX529nbKe4.YpjJxw.EFw3iX5ZJtpHDQnrlO_mfPP71gQ; views=47 Cf-Connecting-Ip: 2804:14c:f287:aadf:a1f4:2906:4e10:cbcf Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (76.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['294052814722957313', 849] (slow_query, 76.1, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '100'), ('deck_id', '182098'), ('views', '90'), ('session', '.eJx1Ue9rwjAQ_V_yuUgaG5v6sf5WHCLDDcYo0V5rbJt0STon4v--WOYKg318d-_eu3t3RUkNuuISpEVDqxvwEE8rIdEw46VxKIVKVCrtsDAHpdNEuBIiUYApYX4QEhLRsO_3Ucco1YGX4Fgn7qr_84VM8kaU6cO_VHkO6X0vo2Trw4LIQ5XNVdIY0JJXrSrIQkg66GOnoXhjjyQxltt773nSYO6_zBeMmLOwDGo8MmlAdrvlanru-FYV4E69In44gDEPjDabbWxPcbjP9FSPCc5sES62s2qHN6_r0M3DVy00mIS71PwBJWEUUIp7lBFKCOn69yAHOGAYe0hD5krHXxM2SedP9HNyyU4fbDaW4Wq02MfsslrqYj1yJi7G2l3zhtp4TO-knJz3g9pI3ddEdkHvHmpFE3u5D6AYuAaNbh76G6LlOge3s2zK8vYNfUSiuw.Yp4Qhw.XiszuxnUaQJXgSFSJCEgxN-qGFc')]) Endpoint: retire_deck View Args: {} Person: 294052814722957313 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '182098'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: JP X-Forwarded-For: 217.178.116.145, 172.68.143.233 Cf-Ray: 7171def01afa0aaa-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="102", "Google Chrome";v="102" 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/102.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: ja,en-US;q=0.9,en;q=0.8 Cookie: hide_intro=True; page_size=100; deck_id=182098; views=90; session=.eJx1Ue9rwjAQ_V_yuUgaG5v6sf5WHCLDDcYo0V5rbJt0STon4v--WOYKg318d-_eu3t3RUkNuuISpEVDqxvwEE8rIdEw46VxKIVKVCrtsDAHpdNEuBIiUYApYX4QEhLRsO_3Ucco1YGX4Fgn7qr_84VM8kaU6cO_VHkO6X0vo2Trw4LIQ5XNVdIY0JJXrSrIQkg66GOnoXhjjyQxltt773nSYO6_zBeMmLOwDGo8MmlAdrvlanru-FYV4E69In44gDEPjDabbWxPcbjP9FSPCc5sES62s2qHN6_r0M3DVy00mIS71PwBJWEUUIp7lBFKCOn69yAHOGAYe0hD5krHXxM2SedP9HNyyU4fbDaW4Wq02MfsslrqYj1yJi7G2l3zhtp4TO-knJz3g9pI3ddEdkHvHmpFE3u5D6AYuAaNbh76G6LlOge3s2zK8vYNfUSiuw.Yp4Qhw.XiszuxnUaQJXgSFSJCEgxN-qGFc Cf-Connecting-Ip: 217.178.116.145 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (76.3 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['150279830494117888', 9636] (slow_query, 76.3, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('session', '.eJx1UctugzAQ_BefacQb01uiCLVqFCVpoqStKuTgBZwajGxTgaL8ew1qy6HqcXZnZ3ZnryhtQFakhlqjey1bsBChFavRfU64MohCxSpBJ8xUJiRNmSkhJ7DdKMae7ce-40QYYzQxuMgIB8OC-u7wbBr_j7A6LVrGJxcuigLosJsS9egVh15ooUoXIm0VyJpUg3QJhOuSC6WMiiCtLt1UaaKHntjT8Nztg-N6d3pqlXsp-88kosuX8yV5xRNfiw8w914RyTJQ6gejU0QPun98IJtsWwax3-xwrhuxzOaus5qbeegaJkGlxETnhEHgui6Og1kcBnHoe1N_SDO0fWzbFpKQm1L5a0JLr-1U0hSrfu3P953f9IttddzgZMOCgzExWTbmmjc0BqRmF2HkrG80hmpex_IevVtoFE11PwygBRAJEt0s9CdFTWQBZum65fz2BXXOpss.YqSmgQ.1-TqsBkY4UjU6Z8sVTtJg03uCFU'), ('hide_intro', 'True'), ('views', '7')]) Endpoint: retire_deck View Args: {} Person: 150279830494117888 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '182506'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: GB X-Forwarded-For: 79.71.93.41, 172.68.133.167 Cf-Ray: 719b08503d9e768c-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.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 Content-Type: application/x-www-form-urlencoded 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 Cookie: session=.eJx1UctugzAQ_BefacQb01uiCLVqFCVpoqStKuTgBZwajGxTgaL8ew1qy6HqcXZnZ3ZnryhtQFakhlqjey1bsBChFavRfU64MohCxSpBJ8xUJiRNmSkhJ7DdKMae7ce-40QYYzQxuMgIB8OC-u7wbBr_j7A6LVrGJxcuigLosJsS9egVh15ooUoXIm0VyJpUg3QJhOuSC6WMiiCtLt1UaaKHntjT8Nztg-N6d3pqlXsp-88kosuX8yV5xRNfiw8w914RyTJQ6gejU0QPun98IJtsWwax3-xwrhuxzOaus5qbeegaJkGlxETnhEHgui6Og1kcBnHoe1N_SDO0fWzbFpKQm1L5a0JLr-1U0hSrfu3P953f9IttddzgZMOCgzExWTbmmjc0BqRmF2HkrG80hmpex_IevVtoFE11PwygBRAJEt0s9CdFTWQBZum65fz2BXXOpss.YqSmgQ.1-TqsBkY4UjU6Z8sVTtJg03uCFU; hide_intro=True; views=7 Cf-Connecting-Ip: 79.71.93.41 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (627.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['543843377712594964', 8426] (slow_query, 627.8, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('session', '.eJx1UV1PwjAU_S99nmRs3Qe8STQIKohEoxizNOvdVlnb0XaoEP67dyTIg_Gt99xz7zn3dE-yBoxkCpQjQ2da8AjjUigyLFhtseIghdT8XAuba8MzgRCJaJjSMEySpB9EAzqIKTkzap2zGpAF6uJpiY3_R4TKylbU_GSh1mUJvLNmtTpKpTSIPSJdqbPWglFMdptzWZuNwgWata4KMuuY6_Aq_ygn_khN5evoiRp-J5qKzR7X04avNuWZ7_Qa8NQ9YXkO1p5qUmyf-4PdYn2_adbzxXJlxuVrOl8m-Qzur1Och69GGLAZw9T6cRQldOCHUS8MwuRo9NTvgox9mvq-RwwUCFW_IvPABDcvYrx9_ry9nUzk6IEGl6vdJkzz-IqjCMbY4DVvGBx-jyi-ETvGZH8fvQ-NEu8eOS7N3Hc3QEbADBhy8MifBB0zJaBp1db14QcyMaS3.Yq3iHg.By0r3PTNIxPyknYUCzkGu8jYzi8'), ('hide_intro', 'True'), ('views', '160'), ('page_size', '20'), ('deck_id', '183317')]) Endpoint: retire_deck View Args: {} Person: 543843377712594964 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '183317'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2a01:4b00:844b:f500:8c4b:7961:66f5:8b46, 172.68.189.42 Cf-Ray: 71d4bce789657427-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.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 Content-Type: application/x-www-form-urlencoded 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 Cookie: session=.eJx1UV1PwjAU_S99nmRs3Qe8STQIKohEoxizNOvdVlnb0XaoEP67dyTIg_Gt99xz7zn3dE-yBoxkCpQjQ2da8AjjUigyLFhtseIghdT8XAuba8MzgRCJaJjSMEySpB9EAzqIKTkzap2zGpAF6uJpiY3_R4TKylbU_GSh1mUJvLNmtTpKpTSIPSJdqbPWglFMdptzWZuNwgWata4KMuuY6_Aq_ygn_khN5evoiRp-J5qKzR7X04avNuWZ7_Qa8NQ9YXkO1p5qUmyf-4PdYn2_adbzxXJlxuVrOl8m-Qzur1Och69GGLAZw9T6cRQldOCHUS8MwuRo9NTvgox9mvq-RwwUCFW_IvPABDcvYrx9_ry9nUzk6IEGl6vdJkzz-IqjCMbY4DVvGBx-jyi-ETvGZH8fvQ-NEu8eOS7N3Hc3QEbADBhy8MifBB0zJaBp1db14QcyMaS3.Yq3iHg.By0r3PTNIxPyknYUCzkGu8jYzi8; hide_intro=True; views=160; page_size=20; deck_id=183317 Cf-Connecting-Ip: 2a01:4b00:844b:f500:8c4b:7961:66f5:8b46 Cf-Ipcountry: GB Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (549.6 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['543843377712594964', 8426] (slow_query, 549.6, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('session', '.eJx1UV1PwjAU_S99nmRs3Qe8STQIKohEoxizNOvdVlnb0XaoEP67dyTIg_Gt99xz7zn3dE-yBoxkCpQjQ2da8AjjUigyLFhtseIghdT8XAuba8MzgRCJaJjSMEySpB9EAzqIKTkzap2zGpAF6uJpiY3_R4TKylbU_GSh1mUJvLNmtTpKpTSIPSJdqbPWglFMdptzWZuNwgWata4KMuuY6_Aq_ygn_khN5evoiRp-J5qKzR7X04avNuWZ7_Qa8NQ9YXkO1p5qUmyf-4PdYn2_adbzxXJlxuVrOl8m-Qzur1Och69GGLAZw9T6cRQldOCHUS8MwuRo9NTvgox9mvq-RwwUCFW_IvPABDcvYrx9_ry9nUzk6IEGl6vdJkzz-IqjCMbY4DVvGBx-jyi-ETvGZH8fvQ-NEu8eOS7N3Hc3QEbADBhy8MifBB0zJaBp1db14QcyMaS3.Yq3ibQ.PdlYehQKTusjtFBIbQpmSUC4Xnk'), ('hide_intro', 'True'), ('views', '174'), ('page_size', '20'), ('deck_id', '183317')]) Endpoint: retire_deck View Args: {} Person: 543843377712594964 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '183317'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2a01:4b00:844b:f500:8c4b:7961:66f5:8b46, 172.68.143.233 Cf-Ray: 71d4becfc9077521-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:101.0) Gecko/20100101 Firefox/101.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 Content-Type: application/x-www-form-urlencoded 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 Cookie: session=.eJx1UV1PwjAU_S99nmRs3Qe8STQIKohEoxizNOvdVlnb0XaoEP67dyTIg_Gt99xz7zn3dE-yBoxkCpQjQ2da8AjjUigyLFhtseIghdT8XAuba8MzgRCJaJjSMEySpB9EAzqIKTkzap2zGpAF6uJpiY3_R4TKylbU_GSh1mUJvLNmtTpKpTSIPSJdqbPWglFMdptzWZuNwgWata4KMuuY6_Aq_ygn_khN5evoiRp-J5qKzR7X04avNuWZ7_Qa8NQ9YXkO1p5qUmyf-4PdYn2_adbzxXJlxuVrOl8m-Qzur1Och69GGLAZw9T6cRQldOCHUS8MwuRo9NTvgox9mvq-RwwUCFW_IvPABDcvYrx9_ry9nUzk6IEGl6vdJkzz-IqjCMbY4DVvGBx-jyi-ETvGZH8fvQ-NEu8eOS7N3Hc3QEbADBhy8MifBB0zJaBp1db14QcyMaS3.Yq3ibQ.PdlYehQKTusjtFBIbQpmSUC4Xnk; hide_intro=True; views=174; page_size=20; deck_id=183317 Cf-Connecting-Ip: 2a01:4b00:844b:f500:8c4b:7961:66f5:8b46 Cf-Ipcountry: GB Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (1285.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['294052814722957313', 849] (slow_query, 1285.7, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '183952'), ('session', '.eJx1Ue9rwjAQ_V_yuUgaG5v6sf5WHCLDDcYo0V5rbJt0STon4v--WOYKg318d-_eu3t3RUkNuuISpEVDqxvwEE8rIdEw46VxKIVKVCrtsDAHpdNEuBIiUYApYX4QEhLRsO_3Ucco1YGX4Fgn7qr_84VM8kaU6cO_VHkO6X0vo2Trw4LIQ5XNVdIY0JJXrSrIQkg66GOnoXhjjyQxltt773nSYO6_zBeMmLOwDGo8MmlAdrvlanru-FYV4E69In44gDEPjDabbWxPcbjP9FSPCc5sES62s2qHN6_r0M3DVy00mIS71PwBJWEUUIp7lBFKCOn69yAHOGAYe0hD5krHXxM2SedP9HNyyU4fbDaW4Wq02MfsslrqYj1yJi7G2l3zhtp4TO-knJz3g9pI3ddEdkHvHmpFE3u5D6AYuAaNbh76G6LlOge3s2zK8vYNfUSiuw.YrSFag.c7GUlyuq5fHAPfz2CHg3QbX9DiM'), ('views', '122')]) Endpoint: retire_deck View Args: {} Person: 294052814722957313 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '183952'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 217.178.116.145, 172.68.189.4 Cf-Ray: 71fe397e3f04837f-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: ja,en-US;q=0.9,en;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=183952; session=.eJx1Ue9rwjAQ_V_yuUgaG5v6sf5WHCLDDcYo0V5rbJt0STon4v--WOYKg318d-_eu3t3RUkNuuISpEVDqxvwEE8rIdEw46VxKIVKVCrtsDAHpdNEuBIiUYApYX4QEhLRsO_3Ucco1YGX4Fgn7qr_84VM8kaU6cO_VHkO6X0vo2Trw4LIQ5XNVdIY0JJXrSrIQkg66GOnoXhjjyQxltt773nSYO6_zBeMmLOwDGo8MmlAdrvlanru-FYV4E69In44gDEPjDabbWxPcbjP9FSPCc5sES62s2qHN6_r0M3DVy00mIS71PwBJWEUUIp7lBFKCOn69yAHOGAYe0hD5krHXxM2SedP9HNyyU4fbDaW4Wq02MfsslrqYj1yJi7G2l3zhtp4TO-knJz3g9pI3ddEdkHvHmpFE3u5D6AYuAaNbh76G6LlOge3s2zK8vYNfUSiuw.YrSFag.c7GUlyuq5fHAPfz2CHg3QbX9DiM; views=122 Cf-Connecting-Ip: 217.178.116.145 Cf-Ipcountry: JP Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (170.3 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['385612405918531586', 8696] (slow_query, 170.3, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '184093'), ('session', '.eJx1kdtuwjAMht8l1x1q04Na7kYL08QqMVQE0jRVWRtKWJqUHAYV4t3nMjEupt3F_m3_9pczKjuqWiKoMGhslKUOInXLBBpvCdcQ1bRlrazvMdOVVHXJIIX8OIw8HLhh4sWh74VxhO4VXFaEU6jqzMNkCcL_LUyUjWW8vq3AZdPQelhNS3G1iqMkclBrGllaTZUg7TB5y7udFYYqmCGJNTtcakPMIGUtDlfZrliw9bzXL_lRpTZ4TvHSJnri3-uN_KRw7RmRqqJa32LEsqndVF-JP-tO3caPWlPwIuDHfrWYnmrop6eOKapLAuC8KAwxxkmCR16E4Tr_rg8sIzeIXddBim4htfs1EXmezWf8kaXe41L0WdGvn3J3372mH_vDAUyAZAfXvKErHn2FCF_Ftj08f3KjvQSLdwddh5amHxrQhBIFWC4O-gPRENVQWFpYzi_fDISmNw.YrXJcA.2RSexrHSFDd15dK-6ZHU8ZosC4w'), ('views', '7544')]) Endpoint: retire_deck View Args: {} Person: 385612405918531586 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '184093'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 189.126.36.181, 172.68.143.233 Cf-Ray: 7206243eef8302ae-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Opera GX";v="87" 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/101.0.4951.67 Safari/537.36 OPR/87.0.4390.58 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: pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: hide_intro=True; page_size=20; deck_id=184093; session=.eJx1kdtuwjAMht8l1x1q04Na7kYL08QqMVQE0jRVWRtKWJqUHAYV4t3nMjEupt3F_m3_9pczKjuqWiKoMGhslKUOInXLBBpvCdcQ1bRlrazvMdOVVHXJIIX8OIw8HLhh4sWh74VxhO4VXFaEU6jqzMNkCcL_LUyUjWW8vq3AZdPQelhNS3G1iqMkclBrGllaTZUg7TB5y7udFYYqmCGJNTtcakPMIGUtDlfZrliw9bzXL_lRpTZ4TvHSJnri3-uN_KRw7RmRqqJa32LEsqndVF-JP-tO3caPWlPwIuDHfrWYnmrop6eOKapLAuC8KAwxxkmCR16E4Tr_rg8sIzeIXddBim4htfs1EXmezWf8kaXe41L0WdGvn3J3372mH_vDAUyAZAfXvKErHn2FCF_Ftj08f3KjvQSLdwddh5amHxrQhBIFWC4O-gPRENVQWFpYzi_fDISmNw.YrXJcA.2RSexrHSFDd15dK-6ZHU8ZosC4w; views=7544 Cf-Connecting-Ip: 189.126.36.181 Cf-Ipcountry: BR Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (75.2 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['691708808350924831', 8840] (slow_query, 75.2, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '185067'), ('page_size', '20'), ('session', '.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM'), ('views', '63')]) Endpoint: retire_deck View Args: {} Person: 691708808350924831 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185067'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2600:1700:1d8b:400:780a:4986:a2a:fd64, 172.68.133.167 Cf-Ray: 724815b70cd8ad86-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; deck_id=185067; page_size=20; session=.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM; views=63 Cf-Connecting-Ip: 2600:1700:1d8b:400:780a:4986:a2a:fd64 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (70.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['691708808350924831', 8840] (slow_query, 70.4, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '185067'), ('page_size', '20'), ('session', '.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM'), ('views', '63')]) Endpoint: retire_deck View Args: {} Person: 691708808350924831 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185067'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2600:1700:1d8b:400:780a:4986:a2a:fd64, 172.68.133.167 Cf-Ray: 724815ba2859ad86-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; deck_id=185067; page_size=20; session=.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM; views=63 Cf-Connecting-Ip: 2600:1700:1d8b:400:780a:4986:a2a:fd64 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (75.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['691708808350924831', 8840] (slow_query, 75.4, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '185067'), ('page_size', '20'), ('session', '.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM'), ('views', '63')]) Endpoint: retire_deck View Args: {} Person: 691708808350924831 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185067'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2600:1700:1d8b:400:780a:4986:a2a:fd64, 172.68.133.167 Cf-Ray: 724815b54b1bad86-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; deck_id=185067; page_size=20; session=.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM; views=63 Cf-Connecting-Ip: 2600:1700:1d8b:400:780a:4986:a2a:fd64 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (106.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['691708808350924831', 8840] (slow_query, 106.5, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '185067'), ('page_size', '20'), ('views', '60'), ('session', '.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWnQ.qGyX4Ug2gkOljlQz8GC2dWzJq_s')]) Endpoint: retire_deck View Args: {} Person: 691708808350924831 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185067'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2600:1700:1d8b:400:780a:4986:a2a:fd64, 172.68.133.167 Cf-Ray: 724814f6d805ad86-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; deck_id=185067; page_size=20; views=60; session=.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWnQ.qGyX4Ug2gkOljlQz8GC2dWzJq_s Cf-Connecting-Ip: 2600:1700:1d8b:400:780a:4986:a2a:fd64 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (74.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['691708808350924831', 8840] (slow_query, 74.4, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '185067'), ('page_size', '20'), ('session', '.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM'), ('views', '63')]) Endpoint: retire_deck View Args: {} Person: 691708808350924831 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185067'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2600:1700:1d8b:400:780a:4986:a2a:fd64, 172.68.133.167 Cf-Ray: 724815b90f0ead86-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; deck_id=185067; page_size=20; session=.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM; views=63 Cf-Connecting-Ip: 2600:1700:1d8b:400:780a:4986:a2a:fd64 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (516.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['385612405918531586', 8696] (slow_query, 516.1, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '185069'), ('session', '.eJx1kdtuwjAMht8l1x1q04Na7kYL08QqMVQE0jRVWRtKWJqUHAYV4t3nMjEupt3F_m3_9pczKjuqWiKoMGhslKUOInXLBBpvCdcQ1bRlrazvMdOVVHXJIIX8OIw8HLhh4sWh74VxhO4VXFaEU6jqzMNkCcL_LUyUjWW8vq3AZdPQelhNS3G1iqMkclBrGllaTZUg7TB5y7udFYYqmCGJNTtcakPMIGUtDlfZrliw9bzXL_lRpTZ4TvHSJnri3-uN_KRw7RmRqqJa32LEsqndVF-JP-tO3caPWlPwIuDHfrWYnmrop6eOKapLAuC8KAwxxkmCR16E4Tr_rg8sIzeIXddBim4htfs1EXmezWf8kaXe41L0WdGvn3J3372mH_vDAUyAZAfXvKErHn2FCF_Ftj08f3KjvQSLdwddh5amHxrQhBIFWC4O-gPRENVQWFpYzi_fDISmNw.YsBVAA.LwHACjQuIRJzAg4TID-Z_x48Arg'), ('views', '11238')]) Endpoint: retire_deck View Args: {} Person: 385612405918531586 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185069'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 189.126.36.181, 172.68.133.167 Cf-Ray: 72480aed5c27228a-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Opera GX";v="87" 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/101.0.4951.67 Safari/537.36 OPR/87.0.4390.58 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: pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: hide_intro=True; page_size=20; deck_id=185069; session=.eJx1kdtuwjAMht8l1x1q04Na7kYL08QqMVQE0jRVWRtKWJqUHAYV4t3nMjEupt3F_m3_9pczKjuqWiKoMGhslKUOInXLBBpvCdcQ1bRlrazvMdOVVHXJIIX8OIw8HLhh4sWh74VxhO4VXFaEU6jqzMNkCcL_LUyUjWW8vq3AZdPQelhNS3G1iqMkclBrGllaTZUg7TB5y7udFYYqmCGJNTtcakPMIGUtDlfZrliw9bzXL_lRpTZ4TvHSJnri3-uN_KRw7RmRqqJa32LEsqndVF-JP-tO3caPWlPwIuDHfrWYnmrop6eOKapLAuC8KAwxxkmCR16E4Tr_rg8sIzeIXddBim4htfs1EXmezWf8kaXe41L0WdGvn3J3372mH_vDAUyAZAfXvKErHn2FCF_Ftj08f3KjvQSLdwddh5amHxrQhBIFWC4O-gPRENVQWFpYzi_fDISmNw.YsBVAA.LwHACjQuIRJzAg4TID-Z_x48Arg; views=11238 Cf-Connecting-Ip: 189.126.36.181 Cf-Ipcountry: BR Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (75.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['691708808350924831', 8840] (slow_query, 75.4, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '185067'), ('page_size', '20'), ('session', '.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM'), ('views', '63')]) Endpoint: retire_deck View Args: {} Person: 691708808350924831 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185067'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2600:1700:1d8b:400:780a:4986:a2a:fd64, 172.68.133.167 Cf-Ray: 724815b61be7ad86-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; deck_id=185067; page_size=20; session=.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM; views=63 Cf-Connecting-Ip: 2600:1700:1d8b:400:780a:4986:a2a:fd64 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (85.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['691708808350924831', 8840] (slow_query, 85.7, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '185067'), ('page_size', '20'), ('session', '.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM'), ('views', '63')]) Endpoint: retire_deck View Args: {} Person: 691708808350924831 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185067'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2600:1700:1d8b:400:780a:4986:a2a:fd64, 172.68.133.167 Cf-Ray: 724815760c1bad86-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; deck_id=185067; page_size=20; session=.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM; views=63 Cf-Connecting-Ip: 2600:1700:1d8b:400:780a:4986:a2a:fd64 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (75.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['691708808350924831', 8840] (slow_query, 75.1, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '185067'), ('page_size', '20'), ('session', '.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM'), ('views', '63')]) Endpoint: retire_deck View Args: {} Person: 691708808350924831 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185067'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2600:1700:1d8b:400:780a:4986:a2a:fd64, 172.68.133.167 Cf-Ray: 724815b82e12ad86-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; deck_id=185067; page_size=20; session=.eJx1UctOwzAQ_BefQ5U0aeL0RiERCIFABfpAKDLJ5tH6EdkOtKr672yCSg-Im2d3dmd2fCBZC1owCdKSqdUdOIQVopFkWjJuEBUgGqGKM25MrnSRNVgiYexFLqUu9SduPA6o75Ezg6uccUAWyIuXOTb-H2lkVnUNL04WuKoqKHprRslBitLAdYiwlco6A1oy0W_OctVJi6wWOMc9inW2HmfGMtu36YqJtL7eFlUyHuv7dJ5c0YfNUw7CXd7UZ75VW8CLD4TlORhzwuQ1Zc9ptDZmc7dhZlfmUnzOwrZOFu5XfYvzsGsbDSZjGJ4XTiIviEPfH00in4beud3HGboBdfEEDSWW6l-NZR5H66ClgVk8GhMnq8sPH5b7cBYwIWaogWG2eMwbGRIyQ474W025x-dPbbRRKPHukGFpZvf9AJkB06DJ0SF_crRMV4CeZcf58RtsRqdI.YsBWrw.uiNHcQHol9Ho6wGT7tH0vlsffaM; views=63 Cf-Connecting-Ip: 2600:1700:1d8b:400:780a:4986:a2a:fd64 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (412.6 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['385612405918531586', 8696] (slow_query, 412.6, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '185069'), ('session', '.eJx1kdtuwjAMht8l1x1q04Na7kYL08QqMVQE0jRVWRtKWJqUHAYV4t3nMjEupt3F_m3_9pczKjuqWiKoMGhslKUOInXLBBpvCdcQ1bRlrazvMdOVVHXJIIX8OIw8HLhh4sWh74VxhO4VXFaEU6jqzMNkCcL_LUyUjWW8vq3AZdPQelhNS3G1iqMkclBrGllaTZUg7TB5y7udFYYqmCGJNTtcakPMIGUtDlfZrliw9bzXL_lRpTZ4TvHSJnri3-uN_KRw7RmRqqJa32LEsqndVF-JP-tO3caPWlPwIuDHfrWYnmrop6eOKapLAuC8KAwxxkmCR16E4Tr_rg8sIzeIXddBim4htfs1EXmezWf8kaXe41L0WdGvn3J3372mH_vDAUyAZAfXvKErHn2FCF_Ftj08f3KjvQSLdwddh5amHxrQhBIFWC4O-gPRENVQWFpYzi_fDISmNw.YsBVAA.LwHACjQuIRJzAg4TID-Z_x48Arg'), ('views', '11238')]) Endpoint: retire_deck View Args: {} Person: 385612405918531586 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185069'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 189.126.36.181, 172.68.133.167 Cf-Ray: 72480d7e3d7a228a-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="101", "Opera GX";v="87" 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/101.0.4951.67 Safari/537.36 OPR/87.0.4390.58 Origin: https://pennydreadfulmagic.com Content-Type: application/x-www-form-urlencoded 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: pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: hide_intro=True; page_size=20; deck_id=185069; session=.eJx1kdtuwjAMht8l1x1q04Na7kYL08QqMVQE0jRVWRtKWJqUHAYV4t3nMjEupt3F_m3_9pczKjuqWiKoMGhslKUOInXLBBpvCdcQ1bRlrazvMdOVVHXJIIX8OIw8HLhh4sWh74VxhO4VXFaEU6jqzMNkCcL_LUyUjWW8vq3AZdPQelhNS3G1iqMkclBrGllaTZUg7TB5y7udFYYqmCGJNTtcakPMIGUtDlfZrliw9bzXL_lRpTZ4TvHSJnri3-uN_KRw7RmRqqJa32LEsqndVF-JP-tO3caPWlPwIuDHfrWYnmrop6eOKapLAuC8KAwxxkmCR16E4Tr_rg8sIzeIXddBim4htfs1EXmezWf8kaXe41L0WdGvn3J3372mH_vDAUyAZAfXvKErHn2FCF_Ftj08f3KjvQSLdwddh5amHxrQhBIFWC4O-gPRENVQWFpYzi_fDISmNw.YsBVAA.LwHACjQuIRJzAg4TID-Z_x48Arg; views=11238 Cf-Connecting-Ip: 189.126.36.181 Cf-Ipcountry: BR Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (108.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['301722406089654273', 1795] (slow_query, 108.1, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '185361'), ('views', '90'), ('session', '.eJx1UV1vgjAU_S99JqaggPqmkzGWxWSbX9uykEJrQSllbXEa43_fhUV5WPbWc3puzz2nZxRXTAlSstKgsVE1sxChIi_ReEsKDYgykQtJO5zrVCoa50ChPrZ9xxlgDw9Hnjtw_D7qFIVMScFApWpg_9fnZczrvKBX_9scK1GDOGe02VLLsnW1_ZFrIWG4jGvNVElEI04KKSjoJalN5sTaENPQ7v5pfVovg_mrbYTnRDwJ6vB7qaZz9zHAnd7IPdiNz4ikKdP6itF7hHn0tZkIs3KS9eSlyhb4-XCPjwu9CyTMs2OVK6ZjAv3ZkMlrkjk9zx16vu91902lHh4MMbaQYlugspuJTsJDuJJSRXcqoCHPHmb2JpxUszqhszcwgUIrSPOB2qJ0Wyf8WL49wfGX6-0kWHxaqH00NqdmAE0ZUUyhi4X-FGiI4gyWLuuiuPwAQ2ynew.YsL4IQ.GAXvyupC878PzMBT13vjAAnife0')]) Endpoint: retire_deck View Args: {} Person: 301722406089654273 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185361'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 95.174.99.26, 172.68.143.233 Cf-Ray: 72588683ebc62486-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: ru-RU,ru;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: hide_intro=True; page_size=20; deck_id=185361; views=90; session=.eJx1UV1vgjAU_S99JqaggPqmkzGWxWSbX9uykEJrQSllbXEa43_fhUV5WPbWc3puzz2nZxRXTAlSstKgsVE1sxChIi_ReEsKDYgykQtJO5zrVCoa50ChPrZ9xxlgDw9Hnjtw_D7qFIVMScFApWpg_9fnZczrvKBX_9scK1GDOGe02VLLsnW1_ZFrIWG4jGvNVElEI04KKSjoJalN5sTaENPQ7v5pfVovg_mrbYTnRDwJ6vB7qaZz9zHAnd7IPdiNz4ikKdP6itF7hHn0tZkIs3KS9eSlyhb4-XCPjwu9CyTMs2OVK6ZjAv3ZkMlrkjk9zx16vu91902lHh4MMbaQYlugspuJTsJDuJJSRXcqoCHPHmb2JpxUszqhszcwgUIrSPOB2qJ0Wyf8WL49wfGX6-0kWHxaqH00NqdmAE0ZUUyhi4X-FGiI4gyWLuuiuPwAQ2ynew.YsL4IQ.GAXvyupC878PzMBT13vjAAnife0 Cf-Connecting-Ip: 95.174.99.26 Cf-Ipcountry: RU Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (716.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['722077392994172948', 9730] (slow_query, 716.8, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjXg.vKnfH5nHlhatHOXeDGCwqb1pZAI'), ('views', '10')]) Endpoint: retire_deck View Args: {} Person: 722077392994172948 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185497'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2605:b100:e01a:5961:162:d6c6:d80f:3188, 172.68.132.168 Cf-Ray: 7269351dbf530388-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; session=.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjXg.vKnfH5nHlhatHOXeDGCwqb1pZAI; views=10 Cf-Connecting-Ip: 2605:b100:e01a:5961:162:d6c6:d80f:3188 Cf-Ipcountry: CA Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (706.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['722077392994172948', 9730] (slow_query, 706.7, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjXg.vKnfH5nHlhatHOXeDGCwqb1pZAI'), ('views', '10')]) Endpoint: retire_deck View Args: {} Person: 722077392994172948 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185497'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2605:b100:e01a:5961:162:d6c6:d80f:3188, 172.68.132.168 Cf-Ray: 726935219b7e0388-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; session=.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjXg.vKnfH5nHlhatHOXeDGCwqb1pZAI; views=10 Cf-Connecting-Ip: 2605:b100:e01a:5961:162:d6c6:d80f:3188 Cf-Ipcountry: CA Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (701.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['722077392994172948', 9730] (slow_query, 701.5, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjXg.vKnfH5nHlhatHOXeDGCwqb1pZAI'), ('views', '10')]) Endpoint: retire_deck View Args: {} Person: 722077392994172948 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185497'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2605:b100:e01a:5961:162:d6c6:d80f:3188, 172.68.132.168 Cf-Ray: 726935245e830388-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; session=.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjXg.vKnfH5nHlhatHOXeDGCwqb1pZAI; views=10 Cf-Connecting-Ip: 2605:b100:e01a:5961:162:d6c6:d80f:3188 Cf-Ipcountry: CA Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (557.9 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['722077392994172948', 9730] (slow_query, 557.9, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWkDg.MbaUCxXIkecVo7av1PRjju8_QkU'), ('views', '27')]) Endpoint: retire_deck View Args: {} Person: 722077392994172948 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185497'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2605:b100:e01a:5961:162:d6c6:d80f:3188, 172.68.132.168 Cf-Ray: 726939051f030388-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; session=.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWkDg.MbaUCxXIkecVo7av1PRjju8_QkU; views=27 Cf-Connecting-Ip: 2605:b100:e01a:5961:162:d6c6:d80f:3188 Cf-Ipcountry: CA Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (672.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['722077392994172948', 9730] (slow_query, 672.4, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjnA.QpGqaX6E3uGnkZ1AVnmzNWU03Ps'), ('views', '21')]) Endpoint: retire_deck View Args: {} Person: 722077392994172948 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185497'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2605:b100:e01a:5961:162:d6c6:d80f:3188, 172.68.132.168 Cf-Ray: 7269363969500388-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; session=.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjnA.QpGqaX6E3uGnkZ1AVnmzNWU03Ps; views=21 Cf-Connecting-Ip: 2605:b100:e01a:5961:162:d6c6:d80f:3188 Cf-Ipcountry: CA Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (718.0 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['722077392994172948', 9730] (slow_query, 718.0, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjXg.vKnfH5nHlhatHOXeDGCwqb1pZAI'), ('views', '10')]) Endpoint: retire_deck View Args: {} Person: 722077392994172948 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185497'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2605:b100:e01a:5961:162:d6c6:d80f:3188, 172.68.132.168 Cf-Ray: 7269351c2d970388-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; session=.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjXg.vKnfH5nHlhatHOXeDGCwqb1pZAI; views=10 Cf-Connecting-Ip: 2605:b100:e01a:5961:162:d6c6:d80f:3188 Cf-Ipcountry: CA Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (733.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['722077392994172948', 9730] (slow_query, 733.8, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjXg.vKnfH5nHlhatHOXeDGCwqb1pZAI'), ('views', '10')]) Endpoint: retire_deck View Args: {} Person: 722077392994172948 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '185497'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2605:b100:e01a:5961:162:d6c6:d80f:3188, 172.68.132.168 Cf-Ray: 726934b99a9e0388-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" 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/103.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: en-US,en;q=0.9 Cookie: hide_intro=True; session=.eJx1UctuwjAQ_BefUxTyxByRSovUhqoR6qGqIjfZBINjB9uBAOLfu0nV5lD15t2Z3ZkdX0nWgK6ZBGnJ3OoWHMKKmksyL5kwWBVQ81oVY81NrnSRcWyR2PPcOPapR2kwjT0azMjIECpnApAF8m6TIvD_CJdZ1XIxqghVVVD03oySgxaNfdchta1U1hrQktX96k_dWii1qnCJYq3depmxzPZQkExVusnXgsH2PlofnlP_TOHpFBzTJA1HvlV7wHOvhOU5GPNTkzxZvtK8WrkXKVtmReOJNk27x-SNl8zHeegarsFkDJObRmEcRh4Ng8ksjGnkRSPehxm5wcxF_xrNgtn-imwu3Uu3OlHf7k90dzlODw-LYGnwdu0fOhTBKBu85p0M-ZghRfwrXp7x-d2b7BRKfDhkWJrZcz9AFsA0aHJzyJ8QLdMVoGnZCnH7Ak4ep48.YsWjXg.vKnfH5nHlhatHOXeDGCwqb1pZAI; views=10 Cf-Connecting-Ip: 2605:b100:e01a:5961:162:d6c6:d80f:3188 Cf-Ipcountry: CA Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite