search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

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

Open vorpal-buildbot opened 3 years ago

vorpal-buildbot commented 3 years ago

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

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('views', '6'), ('session', '.eJx1kcluwjAQht_F5xSZKEvDrZUKUYlEK6CLqipykyEYvKS2UwiId-8ECXKoevM_2z_z-UjyGoxkCpQjI2ca8AgrJVdktGLCoipBcqnLXnNbaFPmHEPEH_pBlPjDJA6HkR_ENCB9hdAFE4BVoG6Wc0z838JVXjVclJcVhK4qKLvVrFZnq5BGsUekq3TeWDCKyW7ylhtmmVvjCM0at_Zz65jrMo-t3o1fs30G4x1rzWoGX-livs8ELOvnuK93egt47JGwogBrL5pMDtv3zfDHtO71iU3SKeO6ci-Lh7cyk2OB_bCvuQGbM-SGhyRRmFBKB0EQB1Ho9_kOZUSDW0o9YmCFofXVZKaSu-_0EAahnG6jcJ5K689occjMMqo6Lgiyxms-EB1-EF-1GDuDstfHYKPR4tMj56G5a7sGcg_MgCEnj_xh6JipAJdWjRCnX4JfppI.YaXv3Q.hRtZkp7h3Op3Txx0sh6XioOpqmI')]) 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: 6b6312e3aa907373-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; views=6; session=.eJx1kcluwjAQht_F5xSZKEvDrZUKUYlEK6CLqipykyEYvKS2UwiId-8ECXKoevM_2z_z-UjyGoxkCpQjI2ca8AgrJVdktGLCoipBcqnLXnNbaFPmHEPEH_pBlPjDJA6HkR_ENCB9hdAFE4BVoG6Wc0z838JVXjVclJcVhK4qKLvVrFZnq5BGsUekq3TeWDCKyW7ylhtmmVvjCM0at_Zz65jrMo-t3o1fs30G4x1rzWoGX-livs8ELOvnuK93egt47JGwogBrL5pMDtv3zfDHtO71iU3SKeO6ci-Lh7cyk2OB_bCvuQGbM-SGhyRRmFBKB0EQB1Ho9_kOZUSDW0o9YmCFofXVZKaSu-_0EAahnG6jcJ5K689occjMMqo6Lgiyxms-EB1-EF-1GDuDstfHYKPR4tMj56G5a7sGcg_MgCEnj_xh6JipAJdWjRCnX4JfppI.YaXv3Q.hRtZkp7h3Op3Txx0sh6XioOpqmI 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 (661.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['160231660045074432', 8988] (slow_query, 661.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', '169973'), ('session', '.eJx1UV1TwjAQ_C95rkzShgq8CQ4fCsoIKOo4ndheSyRNIEkHweG_ezADPDi-Ze_2bvc2PyRZgS2FBu1Jy9sKAiKyUmrSyoVyiDIoZWmyC5YuNTZLJJYIi2kYsTimlNfpNedRSC4MZVKhAFmgr2YTbPw_InVSVFJlJwvKFAVkB2vO6KNUo9loBKT0hUkqB1aL8rC5LDcsrOMCIyq_CBPnhT8qKgnzittRNXEpW7ruQK-fNoO78e1mLXsXvjdLwFN_iEhTcO6ECd_Oht165m7oaBG9TV0z7Xd8MeDz5e5FUJyH75W04BKBqbGYsyajIaW1JotoHEaX_iHImPIGpQGxkGNpcRZpZ3yYjzl7Xm3S_uNrPNn19DS_f7Cfauc7KIIxrvCadwwOv0fmW6wdY3LnR-3LoMRHQI5LE789DJA2CAuW7APyJ0EvbAFoWldK7X8BO9CkgA.YhTm9g.VSoGr4LMC6olTlp7hpBuslFGOD0'), ('views', '42')]) Endpoint: retire_deck View Args: {} Person: 160231660045074432 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '169973'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 74.109.243.81, 172.69.34.42 Cf-Ray: 6e189b2dcc965b23-LAX X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="98", "Google Chrome";v="98" 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/98.0.4758.102 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=169973; session=.eJx1UV1TwjAQ_C95rkzShgq8CQ4fCsoIKOo4ndheSyRNIEkHweG_ezADPDi-Ze_2bvc2PyRZgS2FBu1Jy9sKAiKyUmrSyoVyiDIoZWmyC5YuNTZLJJYIi2kYsTimlNfpNedRSC4MZVKhAFmgr2YTbPw_InVSVFJlJwvKFAVkB2vO6KNUo9loBKT0hUkqB1aL8rC5LDcsrOMCIyq_CBPnhT8qKgnzittRNXEpW7ruQK-fNoO78e1mLXsXvjdLwFN_iEhTcO6ECd_Oht165m7oaBG9TV0z7Xd8MeDz5e5FUJyH75W04BKBqbGYsyajIaW1JotoHEaX_iHImPIGpQGxkGNpcRZpZ3yYjzl7Xm3S_uNrPNn19DS_f7Cfauc7KIIxrvCadwwOv0fmW6wdY3LnR-3LoMRHQI5LE789DJA2CAuW7APyJ0EvbAFoWldK7X8BO9CkgA.YhTm9g.VSoGr4LMC6olTlp7hpBuslFGOD0; views=42 Cf-Connecting-Ip: 74.109.243.81 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 (189.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['569553268225605651', 3369] (slow_query, 189.8, 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', '170192'), ('views', '142'), ('session', '.eJx1UV1vgjAU_S99ZkY-SsBH3VymbjFOXcyykAIFO0vL2iKC8b_vYqI8LHvrvefce849PaOopKogggqDRkZV1EIkLZhAo4xwDVVKC1bItK-ZTqRKIwYthP0QY9fxA8fB_hD72EY9g8uEcAqs0jyMVwD8P8JElFeMpzcLXOY5TTtrWoqrlOv6oYUKk8uo0lQJUnSbcxIrRnnEYYckldk7kTbEdJBwl2STfmzr1Tw78EWxfv05Pe_M2jaT-Xjb8408ULj2jEiSUK1vNWqXc7t1GycQ9aw9Nke8fiMraddFFptdC_P0VDJFdUQgONv3PNfrPA5wGGDsOD3eZekPvWA4tJCiGbT2d5H5YTt5fH-y3cUinE3jONbTmqm996LG7SYHEUiyhGs-ITv4IZY10Lsmpe-PwbcEiS8LXZdGpukG0JgSRRW6WOhPiIaonIJpUXF--QW_h6bV.YhjWYA.xz9Abnl4mit5NitMV0bR9Q6wddg')]) Endpoint: retire_deck View Args: {} Person: 569553268225605651 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '170192'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 45.174.237.57, 172.68.133.101 Cf-Ray: 6e31338069ef798a-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="98", "Google Chrome";v="98" 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/98.0.4758.102 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; deck_id=170192; views=142; session=.eJx1UV1vgjAU_S99ZkY-SsBH3VymbjFOXcyykAIFO0vL2iKC8b_vYqI8LHvrvefce849PaOopKogggqDRkZV1EIkLZhAo4xwDVVKC1bItK-ZTqRKIwYthP0QY9fxA8fB_hD72EY9g8uEcAqs0jyMVwD8P8JElFeMpzcLXOY5TTtrWoqrlOv6oYUKk8uo0lQJUnSbcxIrRnnEYYckldk7kTbEdJBwl2STfmzr1Tw78EWxfv05Pe_M2jaT-Xjb8408ULj2jEiSUK1vNWqXc7t1GycQ9aw9Nke8fiMraddFFptdC_P0VDJFdUQgONv3PNfrPA5wGGDsOD3eZekPvWA4tJCiGbT2d5H5YTt5fH-y3cUinE3jONbTmqm996LG7SYHEUiyhGs-ITv4IZY10Lsmpe-PwbcEiS8LXZdGpukG0JgSRRW6WOhPiIaonIJpUXF--QW_h6bV.YhjWYA.xz9Abnl4mit5NitMV0bR9Q6wddg Cf-Connecting-Ip: 45.174.237.57 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.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['556253284814553088', 5211] (slow_query, 68.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', '170891'), ('session', '.eJx1UV1PgzAU_S99xgUYBbZHdMo0JpsaE2YMqXCBbkBZWyK47L97Idl4ML71nPtxzj09kbgBWbEaak2WWrZgEJZWvCbLjJUKUQoVr0Q6Ya4SIdOYI0UodW06t33HtxxK56bvk6mjFAkrAbsafRO8YOH_EV7HecvL9GKhFHkO6WBNiXqUorZlGaTSuYhbBbJm1biZ5xXrcIFgrS7sWGmmB770VpudbpOwKzZ-tIqy24f13f7e3dF-A8epX4sD4KknwpIElLpgcgydrqBP26in32ETVT8qOfQcnoMweLMVzkPXcAkqZpia5Tpz0zMdfzFzPJe63lQecnSxYpoGkZAhVVw1Vl_JK_f2Qvp59Cga9c4X237d6s7uvNpGDUyxwWM-MDf8HZ71yI0pqetjthco8WmQcWms-2GABMAkSHI2yJ8ANZM5oOe6LcvzL8NmpY8.YhzO3Q.0ypgoy7XDI_Sc7y9_7LSckJ0SHs'), ('views', '99')]) Endpoint: retire_deck View Args: {} Person: 556253284814553088 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '170891'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 2804:431:cfcc:8197:48c9:dd7d:f949:5034, 172.68.189.16 Cf-Ray: 6e4a05221d3bf760-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="98", "Google Chrome";v="98" 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/98.0.4758.102 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; deck_id=170891; session=.eJx1UV1PgzAU_S99xgUYBbZHdMo0JpsaE2YMqXCBbkBZWyK47L97Idl4ML71nPtxzj09kbgBWbEaak2WWrZgEJZWvCbLjJUKUQoVr0Q6Ya4SIdOYI0UodW06t33HtxxK56bvk6mjFAkrAbsafRO8YOH_EV7HecvL9GKhFHkO6WBNiXqUorZlGaTSuYhbBbJm1biZ5xXrcIFgrS7sWGmmB770VpudbpOwKzZ-tIqy24f13f7e3dF-A8epX4sD4KknwpIElLpgcgydrqBP26in32ETVT8qOfQcnoMweLMVzkPXcAkqZpia5Tpz0zMdfzFzPJe63lQecnSxYpoGkZAhVVw1Vl_JK_f2Qvp59Cga9c4X237d6s7uvNpGDUyxwWM-MDf8HZ71yI0pqetjthco8WmQcWms-2GABMAkSHI2yJ8ANZM5oOe6LcvzL8NmpY8.YhzO3Q.0ypgoy7XDI_Sc7y9_7LSckJ0SHs; views=99 Cf-Connecting-Ip: 2804:431:cfcc:8197:48c9:dd7d:f949:5034 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 (90.9 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['556253284814553088', 5211] (slow_query, 90.9, 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', '170891'), ('session', '.eJx1UV1PgzAU_S99xgUYBbZHdMo0JpsaE2YMqXCBbkBZWyK47L97Idl4ML71nPtxzj09kbgBWbEaak2WWrZgEJZWvCbLjJUKUQoVr0Q6Ya4SIdOYI0UodW06t33HtxxK56bvk6mjFAkrAbsafRO8YOH_EV7HecvL9GKhFHkO6WBNiXqUorZlGaTSuYhbBbJm1biZ5xXrcIFgrS7sWGmmB770VpudbpOwKzZ-tIqy24f13f7e3dF-A8epX4sD4KknwpIElLpgcgydrqBP26in32ETVT8qOfQcnoMweLMVzkPXcAkqZpia5Tpz0zMdfzFzPJe63lQecnSxYpoGkZAhVVw1Vl_JK_f2Qvp59Cga9c4X237d6s7uvNpGDUyxwWM-MDf8HZ71yI0pqetjthco8WmQcWms-2GABMAkSHI2yJ8ANZM5oOe6LcvzL8NmpY8.YhzO3Q.0ypgoy7XDI_Sc7y9_7LSckJ0SHs'), ('views', '99')]) Endpoint: retire_deck View Args: {} Person: 556253284814553088 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '170891'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 2804:431:cfcc:8197:48c9:dd7d:f949:5034, 172.68.189.16 Cf-Ray: 6e4a04937dd3f760-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="98", "Google Chrome";v="98" 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/98.0.4758.102 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; deck_id=170891; session=.eJx1UV1PgzAU_S99xgUYBbZHdMo0JpsaE2YMqXCBbkBZWyK47L97Idl4ML71nPtxzj09kbgBWbEaak2WWrZgEJZWvCbLjJUKUQoVr0Q6Ya4SIdOYI0UodW06t33HtxxK56bvk6mjFAkrAbsafRO8YOH_EV7HecvL9GKhFHkO6WBNiXqUorZlGaTSuYhbBbJm1biZ5xXrcIFgrS7sWGmmB770VpudbpOwKzZ-tIqy24f13f7e3dF-A8epX4sD4KknwpIElLpgcgydrqBP26in32ETVT8qOfQcnoMweLMVzkPXcAkqZpia5Tpz0zMdfzFzPJe63lQecnSxYpoGkZAhVVw1Vl_JK_f2Qvp59Cga9c4X237d6s7uvNpGDUyxwWM-MDf8HZ71yI0pqetjthco8WmQcWms-2GABMAkSHI2yJ8ANZM5oOe6LcvzL8NmpY8.YhzO3Q.0ypgoy7XDI_Sc7y9_7LSckJ0SHs; views=99 Cf-Connecting-Ip: 2804:431:cfcc:8197:48c9:dd7d:f949:5034 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 (125.6 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['433574100238073860', 1115] (slow_query, 125.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', '100'), ('deck_id', '171504'), ('session', '.eJx1UU1vgkAQ_S97JoZlEdSbxIqUNj3Y2mjTkBUGBIHF3cX6Ef97BxP10PS28-bNvHlvzyRqQFa8hlqTkZYtGIQnVV6TUcpLhVUCVV6J5FHnKhYyiXKEiM1Y37WpaVpsYLps4JjkwShFzEtAVsER_Z-f11HW5mVy0y9FlkHS3aVEfdWhlPYNUulMRK0CWfOqW2vbFsNxwVu9sSKlue7Q9c6L9YQx32-X7WEitzB7XTX7k0Wf0xfvwddiC-jyTHgcg1K3mqybeLby_VnAxg198nfDxWfdp0URhPN00RmBQ5NLUBHHwKhjO4xSy3V6roPeHPvR7zJ0THtgmgaRkCK0uYuE8_1KTSH-8KxlGEzf2zD4Gc4dWo0P1ukNRTDBBt18YWz4M3l6ROwakro_eoVAiW-DXJdG-tgNEA-4BEkuBvmTn-YyAzy6bsvy8gupDqE1.YiIWfg.U-JrjYEG78-yM7SRI19oQOyxvcw'), ('views', '363')]) Endpoint: retire_deck View Args: {} Person: 433574100238073860 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '171504'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: JP X-Forwarded-For: 2400:2653:86e0:ec00:9194:6cbe:f304:a33b, 172.68.132.204 Cf-Ray: 6e6b0445e82c837f-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="98", "Google Chrome";v="98" 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/98.0.4758.102 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=171504; session=.eJx1UU1vgkAQ_S97JoZlEdSbxIqUNj3Y2mjTkBUGBIHF3cX6Ef97BxP10PS28-bNvHlvzyRqQFa8hlqTkZYtGIQnVV6TUcpLhVUCVV6J5FHnKhYyiXKEiM1Y37WpaVpsYLps4JjkwShFzEtAVsER_Z-f11HW5mVy0y9FlkHS3aVEfdWhlPYNUulMRK0CWfOqW2vbFsNxwVu9sSKlue7Q9c6L9YQx32-X7WEitzB7XTX7k0Wf0xfvwddiC-jyTHgcg1K3mqybeLby_VnAxg198nfDxWfdp0URhPN00RmBQ5NLUBHHwKhjO4xSy3V6roPeHPvR7zJ0THtgmgaRkCK0uYuE8_1KTSH-8KxlGEzf2zD4Gc4dWo0P1ukNRTDBBt18YWz4M3l6ROwakro_eoVAiW-DXJdG-tgNEA-4BEkuBvmTn-YyAzy6bsvy8gupDqE1.YiIWfg.U-JrjYEG78-yM7SRI19oQOyxvcw; views=363 Cf-Connecting-Ip: 2400:2653:86e0:ec00:9194:6cbe:f304:a33b 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 (238.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['50028095083646976', 9311] (slow_query, 238.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'), ('deck_id', '171511'), ('views', '433'), ('session', '.eJx1UctOwzAQ_Jc9B-S6eXIEtbQSL1GlBSEUuck2devYxXYQoeq_symCHhAn786-ZsZ7KHZoG6FRe7jwtsUARNVIDRcroRxlFTayMdUpl640tiokQRAxxlOWRSwdxmGcJTGcGpQphUJqQn2Wz6jw74TURd1KVf0QUKauseqJOaOPh7LhYBBA42tTtA6tFk2_uOo0vQEY0fo1L5wXvoe309ul_7xj4cMW67fcGRk9ti67zZbvk7Y59XuzRdK5B1GW6NxPDjP_HmaLZDK_mXJclvEm9-J-Pss-dThetzSPHztp0RWCLBuQiphzzvj5MOLpMElP9d7FmIUpYwFYXBG0_j3izYxHuVLVYtHhdTdNRk92dDeWnbp6eE7oCJm4IzUvcLTGEfIdnG8M7e3dpC-Tqw5eAzguLXzXD8AlCosWDgH8MdALWyOR1q1Shy-pXKSD.YiS5Vg.hposswhIB_AuuEsUhKEBCVgWHWU')]) Endpoint: retire_deck View Args: {} Person: 50028095083646976 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '171511'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2603:6080:4800:7a00:f9e7:cdbc:8cc2:2332, 172.68.143.211 Cf-Ray: 6e7b7e0ecf075878-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/98.0.4758.87 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-Gpc: 1 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/retire/ Accept-Language: en-US,en;q=0.9 Cookie: hide_intro=True; page_size=20; deck_id=171511; views=433; session=.eJx1UctOwzAQ_Jc9B-S6eXIEtbQSL1GlBSEUuck2devYxXYQoeq_symCHhAn786-ZsZ7KHZoG6FRe7jwtsUARNVIDRcroRxlFTayMdUpl640tiokQRAxxlOWRSwdxmGcJTGcGpQphUJqQn2Wz6jw74TURd1KVf0QUKauseqJOaOPh7LhYBBA42tTtA6tFk2_uOo0vQEY0fo1L5wXvoe309ul_7xj4cMW67fcGRk9ti67zZbvk7Y59XuzRdK5B1GW6NxPDjP_HmaLZDK_mXJclvEm9-J-Pss-dThetzSPHztp0RWCLBuQiphzzvj5MOLpMElP9d7FmIUpYwFYXBG0_j3izYxHuVLVYtHhdTdNRk92dDeWnbp6eE7oCJm4IzUvcLTGEfIdnG8M7e3dpC-Tqw5eAzguLXzXD8AlCosWDgH8MdALWyOR1q1Shy-pXKSD.YiS5Vg.hposswhIB_AuuEsUhKEBCVgWHWU Cf-Connecting-Ip: 2603:6080:4800:7a00:f9e7:cdbc:8cc2:2332 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 (449.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['50028095083646976', 9311] (slow_query, 449.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', '171511'), ('session', '.eJx1UctOwzAQ_Jc9B-S6eXIEtbQSL1GlBSEUuck2devYxXYQoeq_symCHhAn786-ZsZ7KHZoG6FRe7jwtsUARNVIDRcroRxlFTayMdUpl640tiokQRAxxlOWRSwdxmGcJTGcGpQphUJqQn2Wz6jw74TURd1KVf0QUKauseqJOaOPh7LhYBBA42tTtA6tFk2_uOo0vQEY0fo1L5wXvoe309ul_7xj4cMW67fcGRk9ti67zZbvk7Y59XuzRdK5B1GW6NxPDjP_HmaLZDK_mXJclvEm9-J-Pss-dThetzSPHztp0RWCLBuQiphzzvj5MOLpMElP9d7FmIUpYwFYXBG0_j3izYxHuVLVYtHhdTdNRk92dDeWnbp6eE7oCJm4IzUvcLTGEfIdnG8M7e3dpC-Tqw5eAzguLXzXD8AlCosWDgH8MdALWyOR1q1Shy-pXKSD.YiS4gg.bAmwYElZsGuKoC-eyDY65UQgwxE'), ('views', '426')]) Endpoint: retire_deck View Args: {} Person: 50028095083646976 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '171511'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2603:6080:4800:7a00:f9e7:cdbc:8cc2:2332, 172.68.143.211 Cf-Ray: 6e7b78e60ab95b1c-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/98.0.4758.87 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-Gpc: 1 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/retire/ Accept-Language: en-US,en;q=0.9 Cookie: hide_intro=True; page_size=20; deck_id=171511; session=.eJx1UctOwzAQ_Jc9B-S6eXIEtbQSL1GlBSEUuck2devYxXYQoeq_symCHhAn786-ZsZ7KHZoG6FRe7jwtsUARNVIDRcroRxlFTayMdUpl640tiokQRAxxlOWRSwdxmGcJTGcGpQphUJqQn2Wz6jw74TURd1KVf0QUKauseqJOaOPh7LhYBBA42tTtA6tFk2_uOo0vQEY0fo1L5wXvoe309ul_7xj4cMW67fcGRk9ti67zZbvk7Y59XuzRdK5B1GW6NxPDjP_HmaLZDK_mXJclvEm9-J-Pss-dThetzSPHztp0RWCLBuQiphzzvj5MOLpMElP9d7FmIUpYwFYXBG0_j3izYxHuVLVYtHhdTdNRk92dDeWnbp6eE7oCJm4IzUvcLTGEfIdnG8M7e3dpC-Tqw5eAzguLXzXD8AlCosWDgH8MdALWyOR1q1Shy-pXKSD.YiS4gg.bAmwYElZsGuKoC-eyDY65UQgwxE; views=426 Cf-Connecting-Ip: 2603:6080:4800:7a00:f9e7:cdbc:8cc2:2332 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 (332.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['50028095083646976', 9311] (slow_query, 332.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', '171511'), ('views', '429'), ('session', '.eJx1UctOwzAQ_Jc9B-S6eXIEtbQSL1GlBSEUuck2devYxXYQoeq_symCHhAn786-ZsZ7KHZoG6FRe7jwtsUARNVIDRcroRxlFTayMdUpl640tiokQRAxxlOWRSwdxmGcJTGcGpQphUJqQn2Wz6jw74TURd1KVf0QUKauseqJOaOPh7LhYBBA42tTtA6tFk2_uOo0vQEY0fo1L5wXvoe309ul_7xj4cMW67fcGRk9ti67zZbvk7Y59XuzRdK5B1GW6NxPDjP_HmaLZDK_mXJclvEm9-J-Pss-dThetzSPHztp0RWCLBuQiphzzvj5MOLpMElP9d7FmIUpYwFYXBG0_j3izYxHuVLVYtHhdTdNRk92dDeWnbp6eE7oCJm4IzUvcLTGEfIdnG8M7e3dpC-Tqw5eAzguLXzXD8AlCosWDgH8MdALWyOR1q1Shy-pXKSD.YiS4-Q.MJ05USipNvf0d_Yv1hN5jvU8dIU')]) Endpoint: retire_deck View Args: {} Person: 50028095083646976 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '171511'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2603:6080:4800:7a00:f9e7:cdbc:8cc2:2332, 172.68.189.16 Cf-Ray: 6e7b7bc18e20cf18-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/98.0.4758.87 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-Gpc: 1 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/retire/ Accept-Language: en-US,en;q=0.9 Cookie: hide_intro=True; page_size=20; deck_id=171511; views=429; session=.eJx1UctOwzAQ_Jc9B-S6eXIEtbQSL1GlBSEUuck2devYxXYQoeq_symCHhAn786-ZsZ7KHZoG6FRe7jwtsUARNVIDRcroRxlFTayMdUpl640tiokQRAxxlOWRSwdxmGcJTGcGpQphUJqQn2Wz6jw74TURd1KVf0QUKauseqJOaOPh7LhYBBA42tTtA6tFk2_uOo0vQEY0fo1L5wXvoe309ul_7xj4cMW67fcGRk9ti67zZbvk7Y59XuzRdK5B1GW6NxPDjP_HmaLZDK_mXJclvEm9-J-Pss-dThetzSPHztp0RWCLBuQiphzzvj5MOLpMElP9d7FmIUpYwFYXBG0_j3izYxHuVLVYtHhdTdNRk92dDeWnbp6eE7oCJm4IzUvcLTGEfIdnG8M7e3dpC-Tqw5eAzguLXzXD8AlCosWDgH8MdALWyOR1q1Shy-pXKSD.YiS4-Q.MJ05USipNvf0d_Yv1hN5jvU8dIU Cf-Connecting-Ip: 2603:6080:4800:7a00:f9e7:cdbc:8cc2:2332 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 (310.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['600582501068439553', 3548] (slow_query, 310.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'), ('deck_id', '171653'), ('session', '.eJx1UF1TwjAQ_C_3zDApbfrBG9VRGFERpyo6TifTphBMm5qkVmD4715xpE--Zff2snt7gLTmumQVryyMrW74AFheigrGBZMGUc5LUaq8x8JkSuepQAp8Qmg4osQhfui5EaUu9AqpMiY5qoRF9n-9qNJ1I2RvoVhjN6PUWGa7dRPpzXJ3myTeDcmeLxauVNdPs3geFxMWvcJZb9UHx9wHYFnGjfnDkEzuzAPJvKuVu9gu5Xa5b03tt9HnLL9sugD8uxaam5RhBY7vBU4Q0oAOqRe4xHH7edeKT7yQkAFoXiC1OZu8BAR9po9FVZP7djVhwfxr7eQOmUatSdAEO6nxmjc43WpOjWDpotjh85cbbhVavA_g9Glqd90CxJxpruGINNNrjhmrRsrjD0VnjNg.YiS5Dg.NqipWnuOFnQ14_BHXUO_qhyXPsc'), ('views', '311')]) Endpoint: retire_deck View Args: {} Person: 600582501068439553 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '171653'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 87.16.126.120, 172.68.133.101 Cf-Ray: 6e7b7c4c2c3f839c-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="98", "Google Chrome";v="98" 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/98.0.4758.102 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: it-IT,it;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: hide_intro=True; page_size=20; deck_id=171653; session=.eJx1UF1TwjAQ_C_3zDApbfrBG9VRGFERpyo6TifTphBMm5qkVmD4715xpE--Zff2snt7gLTmumQVryyMrW74AFheigrGBZMGUc5LUaq8x8JkSuepQAp8Qmg4osQhfui5EaUu9AqpMiY5qoRF9n-9qNJ1I2RvoVhjN6PUWGa7dRPpzXJ3myTeDcmeLxauVNdPs3geFxMWvcJZb9UHx9wHYFnGjfnDkEzuzAPJvKuVu9gu5Xa5b03tt9HnLL9sugD8uxaam5RhBY7vBU4Q0oAOqRe4xHH7edeKT7yQkAFoXiC1OZu8BAR9po9FVZP7djVhwfxr7eQOmUatSdAEO6nxmjc43WpOjWDpotjh85cbbhVavA_g9Glqd90CxJxpruGINNNrjhmrRsrjD0VnjNg.YiS5Dg.NqipWnuOFnQ14_BHXUO_qhyXPsc; views=311 Cf-Connecting-Ip: 87.16.126.120 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 (92.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['257787907664773120', 3804] (slow_query, 92.5, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.309790536.1600296015'), ('hide_intro', 'True'), ('views', '9'), ('session', '.eJx1UU2PgjAU_C89s6Yo8uFNNuLGeDHqumGzIQ08EIW2tsX4Ef_7PkiUw2ZvnTczndfpnSQSVM04cEMmRjVgEZbVJSeTnFUaUQZ1WYusx6VOhcqSEkdkOPY83wuo57qO543sISW9ohIpqwBV-vy2niHxv6XkSdGUVfZc4WUFTlpUFJC1i2rBu-CRTx2L1KYQSaNBcVZ3ObU4sgLQIVhj9sNEG2Zawm34WJ5Ph2We-oErt-oSsE14usm1XMas1xtxxMDJnbA0Ba2fmCy-dnK1aKYh-5jduENFFDib8BaneRVN9-iHiywV6IRhibbrUEp923cH48APbNvv-bZXlzo-pRZRkONo_wqJ5pfpasHqreN8zaO4ueXRLpbwvjUH8ZlhCLYq8TXf2CP-Vplfcda1pl-HwUFgxI9FuksTc20NJASmQJGHRf5UaJgqAJfmTVU9fgGkZaoD.YidfHQ.6vVuyJpyu5gd6M9xflZAe2-yhIo')]) Endpoint: retire_deck View Args: {} Person: 257787907664773120 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '172081'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: SE X-Forwarded-For: 98.128.167.189, 172.68.133.101 Cf-Ray: 6e8c0a292ea21e81-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="99", "Google Chrome";v="99" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com Content-Type: application/x-www-form-urlencoded User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 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: sv-SE,sv;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: _ga=GA1.2.309790536.1600296015; hide_intro=True; views=9; session=.eJx1UU2PgjAU_C89s6Yo8uFNNuLGeDHqumGzIQ08EIW2tsX4Ef_7PkiUw2ZvnTczndfpnSQSVM04cEMmRjVgEZbVJSeTnFUaUQZ1WYusx6VOhcqSEkdkOPY83wuo57qO543sISW9ohIpqwBV-vy2niHxv6XkSdGUVfZc4WUFTlpUFJC1i2rBu-CRTx2L1KYQSaNBcVZ3ObU4sgLQIVhj9sNEG2Zawm34WJ5Ph2We-oErt-oSsE14usm1XMas1xtxxMDJnbA0Ba2fmCy-dnK1aKYh-5jduENFFDib8BaneRVN9-iHiywV6IRhibbrUEp923cH48APbNvv-bZXlzo-pRZRkONo_wqJ5pfpasHqreN8zaO4ueXRLpbwvjUH8ZlhCLYq8TXf2CP-Vplfcda1pl-HwUFgxI9FuksTc20NJASmQJGHRf5UaJgqAJfmTVU9fgGkZaoD.YidfHQ.6vVuyJpyu5gd6M9xflZAe2-yhIo Cf-Connecting-Ip: 98.128.167.189 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 (94.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['257787907664773120', 3804] (slow_query, 94.8, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.309790536.1600296015'), ('hide_intro', 'True'), ('views', '9'), ('session', '.eJx1UU2PgjAU_C89s6Yo8uFNNuLGeDHqumGzIQ08EIW2tsX4Ef_7PkiUw2ZvnTczndfpnSQSVM04cEMmRjVgEZbVJSeTnFUaUQZ1WYusx6VOhcqSEkdkOPY83wuo57qO543sISW9ohIpqwBV-vy2niHxv6XkSdGUVfZc4WUFTlpUFJC1i2rBu-CRTx2L1KYQSaNBcVZ3ObU4sgLQIVhj9sNEG2Zawm34WJ5Ph2We-oErt-oSsE14usm1XMas1xtxxMDJnbA0Ba2fmCy-dnK1aKYh-5jduENFFDib8BaneRVN9-iHiywV6IRhibbrUEp923cH48APbNvv-bZXlzo-pRZRkONo_wqJ5pfpasHqreN8zaO4ueXRLpbwvjUH8ZlhCLYq8TXf2CP-Vplfcda1pl-HwUFgxI9FuksTc20NJASmQJGHRf5UaJgqAJfmTVU9fgGkZaoD.YidfHQ.6vVuyJpyu5gd6M9xflZAe2-yhIo')]) Endpoint: retire_deck View Args: {} Person: 257787907664773120 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '172081'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: SE X-Forwarded-For: 98.128.167.189, 172.68.133.101 Cf-Ray: 6e8c0a18cd4b1e81-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="99", "Google Chrome";v="99" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com Content-Type: application/x-www-form-urlencoded User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 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: sv-SE,sv;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: _ga=GA1.2.309790536.1600296015; hide_intro=True; views=9; session=.eJx1UU2PgjAU_C89s6Yo8uFNNuLGeDHqumGzIQ08EIW2tsX4Ef_7PkiUw2ZvnTczndfpnSQSVM04cEMmRjVgEZbVJSeTnFUaUQZ1WYusx6VOhcqSEkdkOPY83wuo57qO543sISW9ohIpqwBV-vy2niHxv6XkSdGUVfZc4WUFTlpUFJC1i2rBu-CRTx2L1KYQSaNBcVZ3ObU4sgLQIVhj9sNEG2Zawm34WJ5Ph2We-oErt-oSsE14usm1XMas1xtxxMDJnbA0Ba2fmCy-dnK1aKYh-5jduENFFDib8BaneRVN9-iHiywV6IRhibbrUEp923cH48APbNvv-bZXlzo-pRZRkONo_wqJ5pfpasHqreN8zaO4ueXRLpbwvjUH8ZlhCLYq8TXf2CP-Vplfcda1pl-HwUFgxI9FuksTc20NJASmQJGHRf5UaJgqAJfmTVU9fgGkZaoD.YidfHQ.6vVuyJpyu5gd6M9xflZAe2-yhIo Cf-Connecting-Ip: 98.128.167.189 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 (219.3 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['496412816777936907', 2739] (slow_query, 219.3, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.524279029.1588427333'), ('hide_intro', 'True'), ('session', '.eJx1UctuwjAQ_BefIxRCiBOOVJSqIKGWikerKjLJEhz8CLbTAhX_3k0k4FD15pmd8azHPyStwEimQDkycKYGj7BcckUGWyYsohwklzq_Y24zbfKUI0XCJAq7QdyNKKVJL0p8Su4KoTMmAFXcIfu_nqu0qLnIr_k3HyjSoKKAvNnSatWmBrSXeES6Qqe1BaOYbMQZa56Ra4MezWq3C1LrmGtHcmWO5f6weZCLpRhROu29RX74MhGnsArueqf3GDn4ISzLwNorJlsNi9X-eVEpei4V9M1wHrwuZ7IcPpbnCv1wrLgBmzLssBuFvh_HNPE7fkTjuJ_c502tGBz7vkcMbJHa3UL0fFyN5rM1LECIA-_Gq_XXeLqZvB-fsvM3hmCpFb7mA5vEz-LbE3Jtb_Z26JQaIz490l6aulNjIENgBgy5eORPiY6ZAnBpVQtx-QW1-Kqk.YioCrg.9LbV5U16rIxYtHa1F943ZuVfBqg'), ('session', '.eJx1UctuwjAQ_BefIxRCiBOOVJSqIKGWikerKjLJEhz8CLbTAhX_3k0k4FD15pmd8azHPyStwEimQDkycKYGj7BcckUGWyYsohwklzq_Y24zbfKUI0XCJAq7QdyNKKVJL0p8Su4KoTMmAFXcIfu_nqu0qLnIr_k3HyjSoKKAvNnSatWmBrSXeES6Qqe1BaOYbMQZa56Ra4MezWq3C1LrmGtHcmWO5f6weZCLpRhROu29RX74MhGnsArueqf3GDn4ISzLwNorJlsNi9X-eVEpei4V9M1wHrwuZ7IcPpbnCv1wrLgBmzLssBuFvh_HNPE7fkTjuJ_c502tGBz7vkcMbJHa3UL0fFyN5rM1LECIA-_Gq_XXeLqZvB-fsvM3hmCpFb7mA5vEz-LbE3Jtb_Z26JQaIz490l6aulNjIENgBgy5eORPiY6ZAnBpVQtx-QW1-Kqk.YioCrg.9LbV5U16rIxYtHa1F943ZuVfBqg'), ('views', '43'), ('page_size', '20')]) Endpoint: retire_deck View Args: {} Person: 496412816777936907 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '172249'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 193.104.94.26, 172.68.143.211 Cf-Ray: 6e9c88660f359060-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:97.0) Gecko/20100101 Firefox/97.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8 Accept-Language: it-IT,it;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.524279029.1588427333; hide_intro=True; session=.eJx1UctuwjAQ_BefIxRCiBOOVJSqIKGWikerKjLJEhz8CLbTAhX_3k0k4FD15pmd8azHPyStwEimQDkycKYGj7BcckUGWyYsohwklzq_Y24zbfKUI0XCJAq7QdyNKKVJL0p8Su4KoTMmAFXcIfu_nqu0qLnIr_k3HyjSoKKAvNnSatWmBrSXeES6Qqe1BaOYbMQZa56Ra4MezWq3C1LrmGtHcmWO5f6weZCLpRhROu29RX74MhGnsArueqf3GDn4ISzLwNorJlsNi9X-eVEpei4V9M1wHrwuZ7IcPpbnCv1wrLgBmzLssBuFvh_HNPE7fkTjuJ_c502tGBz7vkcMbJHa3UL0fFyN5rM1LECIA-_Gq_XXeLqZvB-fsvM3hmCpFb7mA5vEz-LbE3Jtb_Z26JQaIz490l6aulNjIENgBgy5eORPiY6ZAnBpVQtx-QW1-Kqk.YioCrg.9LbV5U16rIxYtHa1F943ZuVfBqg; views=43; session=.eJx1UctuwjAQ_BefIxRCiBOOVJSqIKGWikerKjLJEhz8CLbTAhX_3k0k4FD15pmd8azHPyStwEimQDkycKYGj7BcckUGWyYsohwklzq_Y24zbfKUI0XCJAq7QdyNKKVJL0p8Su4KoTMmAFXcIfu_nqu0qLnIr_k3HyjSoKKAvNnSatWmBrSXeES6Qqe1BaOYbMQZa56Ra4MezWq3C1LrmGtHcmWO5f6weZCLpRhROu29RX74MhGnsArueqf3GDn4ISzLwNorJlsNi9X-eVEpei4V9M1wHrwuZ7IcPpbnCv1wrLgBmzLssBuFvh_HNPE7fkTjuJ_c502tGBz7vkcMbJHa3UL0fFyN5rM1LECIA-_Gq_XXeLqZvB-fsvM3hmCpFb7mA5vEz-LbE3Jtb_Z26JQaIz490l6aulNjIENgBgy5eORPiY6ZAnBpVQtx-QW1-Kqk.YioCrg.9LbV5U16rIxYtHa1F943ZuVfBqg; page_size=20 Cf-Connecting-Ip: 193.104.94.26 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 (133.2 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 133.2, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('session', '.eJx1UctuwjAQ_BefUxTikDjcCm2hQqUPUQSpqsgkm2DqxMF2WqDqv3eDBByq3jw7szu742-S1KBLXkFlSd_qBhzCs1JUpJ9zaRBlUIpSZRcsTKp0lggsEer7zAsopX4Qdru9HnXJRSFVyiWgCqqr0QCJ_1tElRSNkNlpBamKArJ2NaOqo5UXMOqQ0hYqaQzoipft5C9xOHCdqVwdcIrijV17ibHctuT9OB5tRnwavQ5ftvO6CO14KcPZrTcrt3R50Vv1AXjvN-FpCsacMPEeDquH6aaexB5d2c_t9Dre9rJobBhjdwvsh10tNJiEY3TdwA-jHnMp60QhC_2IXfg2zcD1mes6REOOpfXZ5DPdzRez4c3-UQ6e85S7wdMu7oK3HE1kvEETzLLGa94wPfwjke-xdszKnB-djUKLd4cchyZ23zaQAXANmvw45E-MlusCcOmqkfLnF8NnpjA.YjCdzQ.T-yNWmBvjcbtt629GjMYF_XVJbU'), ('views', '13')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '172918'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.133.247 Cf-Ray: 6ec5d1ee7eef94ef-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="99", "Google Chrome";v="99" 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/99.0.4844.51 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: session=.eJx1UctuwjAQ_BefUxTikDjcCm2hQqUPUQSpqsgkm2DqxMF2WqDqv3eDBByq3jw7szu742-S1KBLXkFlSd_qBhzCs1JUpJ9zaRBlUIpSZRcsTKp0lggsEer7zAsopX4Qdru9HnXJRSFVyiWgCqqr0QCJ_1tElRSNkNlpBamKArJ2NaOqo5UXMOqQ0hYqaQzoipft5C9xOHCdqVwdcIrijV17ibHctuT9OB5tRnwavQ5ftvO6CO14KcPZrTcrt3R50Vv1AXjvN-FpCsacMPEeDquH6aaexB5d2c_t9Dre9rJobBhjdwvsh10tNJiEY3TdwA-jHnMp60QhC_2IXfg2zcD1mes6REOOpfXZ5DPdzRez4c3-UQ6e85S7wdMu7oK3HE1kvEETzLLGa94wPfwjke-xdszKnB-djUKLd4cchyZ23zaQAXANmvw45E-MlusCcOmqkfLnF8NnpjA.YjCdzQ.T-yNWmBvjcbtt629GjMYF_XVJbU; views=13 Cf-Connecting-Ip: 89.153.131.85 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.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 69.7, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('views', '19'), ('session', '.eJx1UctuwjAQ_BefUxTikDjcCm2hQqUPUQSpqsgkm2DqxMF2WqDqv3eDBByq3jw7szu742-S1KBLXkFlSd_qBhzCs1JUpJ9zaRBlUIpSZRcsTKp0lggsEer7zAsopX4Qdru9HnXJRSFVyiWgCqqr0QCJ_1tElRSNkNlpBamKArJ2NaOqo5UXMOqQ0hYqaQzoipft5C9xOHCdqVwdcIrijV17ibHctuT9OB5tRnwavQ5ftvO6CO14KcPZrTcrt3R50Vv1AXjvN-FpCsacMPEeDquH6aaexB5d2c_t9Dre9rJobBhjdwvsh10tNJiEY3TdwA-jHnMp60QhC_2IXfg2zcD1mes6REOOpfXZ5DPdzRez4c3-UQ6e85S7wdMu7oK3HE1kvEETzLLGa94wPfwjke-xdszKnB-djUKLd4cchyZ23zaQAXANmvw45E-MlusCcOmqkfLnF8NnpjA.YjCeDQ.xy1xWn-lomQdinW11uRZPXIXVTY')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '172918'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.133.247 Cf-Ray: 6ec5d3822d5094ef-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="99", "Google Chrome";v="99" 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/99.0.4844.51 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: views=19; session=.eJx1UctuwjAQ_BefUxTikDjcCm2hQqUPUQSpqsgkm2DqxMF2WqDqv3eDBByq3jw7szu742-S1KBLXkFlSd_qBhzCs1JUpJ9zaRBlUIpSZRcsTKp0lggsEer7zAsopX4Qdru9HnXJRSFVyiWgCqqr0QCJ_1tElRSNkNlpBamKArJ2NaOqo5UXMOqQ0hYqaQzoipft5C9xOHCdqVwdcIrijV17ibHctuT9OB5tRnwavQ5ftvO6CO14KcPZrTcrt3R50Vv1AXjvN-FpCsacMPEeDquH6aaexB5d2c_t9Dre9rJobBhjdwvsh10tNJiEY3TdwA-jHnMp60QhC_2IXfg2zcD1mes6REOOpfXZ5DPdzRez4c3-UQ6e85S7wdMu7oK3HE1kvEETzLLGa94wPfwjke-xdszKnB-djUKLd4cchyZ23zaQAXANmvw45E-MlusCcOmqkfLnF8NnpjA.YjCeDQ.xy1xWn-lomQdinW11uRZPXIXVTY Cf-Connecting-Ip: 89.153.131.85 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 (113.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 113.1, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('session', '.eJx1UctuwjAQ_BefUxTikDjcCm2hQqUPUQSpqsgkm2DqxMF2WqDqv3eDBByq3jw7szu742-S1KBLXkFlSd_qBhzCs1JUpJ9zaRBlUIpSZRcsTKp0lggsEer7zAsopX4Qdru9HnXJRSFVyiWgCqqr0QCJ_1tElRSNkNlpBamKArJ2NaOqo5UXMOqQ0hYqaQzoipft5C9xOHCdqVwdcIrijV17ibHctuT9OB5tRnwavQ5ftvO6CO14KcPZrTcrt3R50Vv1AXjvN-FpCsacMPEeDquH6aaexB5d2c_t9Dre9rJobBhjdwvsh10tNJiEY3TdwA-jHnMp60QhC_2IXfg2zcD1mes6REOOpfXZ5DPdzRez4c3-UQ6e85S7wdMu7oK3HE1kvEETzLLGa94wPfwjke-xdszKnB-djUKLd4cchyZ23zaQAXANmvw45E-MlusCcOmqkfLnF8NnpjA.YjCdzQ.T-yNWmBvjcbtt629GjMYF_XVJbU'), ('views', '13')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '172918'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.133.247 Cf-Ray: 6ec5d2765eff94ef-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="99", "Google Chrome";v="99" 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/99.0.4844.51 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: session=.eJx1UctuwjAQ_BefUxTikDjcCm2hQqUPUQSpqsgkm2DqxMF2WqDqv3eDBByq3jw7szu742-S1KBLXkFlSd_qBhzCs1JUpJ9zaRBlUIpSZRcsTKp0lggsEer7zAsopX4Qdru9HnXJRSFVyiWgCqqr0QCJ_1tElRSNkNlpBamKArJ2NaOqo5UXMOqQ0hYqaQzoipft5C9xOHCdqVwdcIrijV17ibHctuT9OB5tRnwavQ5ftvO6CO14KcPZrTcrt3R50Vv1AXjvN-FpCsacMPEeDquH6aaexB5d2c_t9Dre9rJobBhjdwvsh10tNJiEY3TdwA-jHnMp60QhC_2IXfg2zcD1mes6REOOpfXZ5DPdzRez4c3-UQ6e85S7wdMu7oK3HE1kvEETzLLGa94wPfwjke-xdszKnB-djUKLd4cchyZ23zaQAXANmvw45E-MlusCcOmqkfLnF8NnpjA.YjCdzQ.T-yNWmBvjcbtt629GjMYF_XVJbU; views=13 Cf-Connecting-Ip: 89.153.131.85 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 (86.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 86.1, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('session', '.eJx1UctuwjAQ_BefUxTikDjcCm2hQqUPUQSpqsgkm2DqxMF2WqDqv3eDBByq3jw7szu742-S1KBLXkFlSd_qBhzCs1JUpJ9zaRBlUIpSZRcsTKp0lggsEer7zAsopX4Qdru9HnXJRSFVyiWgCqqr0QCJ_1tElRSNkNlpBamKArJ2NaOqo5UXMOqQ0hYqaQzoipft5C9xOHCdqVwdcIrijV17ibHctuT9OB5tRnwavQ5ftvO6CO14KcPZrTcrt3R50Vv1AXjvN-FpCsacMPEeDquH6aaexB5d2c_t9Dre9rJobBhjdwvsh10tNJiEY3TdwA-jHnMp60QhC_2IXfg2zcD1mes6REOOpfXZ5DPdzRez4c3-UQ6e85S7wdMu7oK3HE1kvEETzLLGa94wPfwjke-xdszKnB-djUKLd4cchyZ23zaQAXANmvw45E-MlusCcOmqkfLnF8NnpjA.YjCdzQ.T-yNWmBvjcbtt629GjMYF_XVJbU'), ('views', '13')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '172918'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.133.247 Cf-Ray: 6ec5d31f5e7894ef-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="99", "Google Chrome";v="99" 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/99.0.4844.51 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: session=.eJx1UctuwjAQ_BefUxTikDjcCm2hQqUPUQSpqsgkm2DqxMF2WqDqv3eDBByq3jw7szu742-S1KBLXkFlSd_qBhzCs1JUpJ9zaRBlUIpSZRcsTKp0lggsEer7zAsopX4Qdru9HnXJRSFVyiWgCqqr0QCJ_1tElRSNkNlpBamKArJ2NaOqo5UXMOqQ0hYqaQzoipft5C9xOHCdqVwdcIrijV17ibHctuT9OB5tRnwavQ5ftvO6CO14KcPZrTcrt3R50Vv1AXjvN-FpCsacMPEeDquH6aaexB5d2c_t9Dre9rJobBhjdwvsh10tNJiEY3TdwA-jHnMp60QhC_2IXfg2zcD1mes6REOOpfXZ5DPdzRez4c3-UQ6e85S7wdMu7oK3HE1kvEETzLLGa94wPfwjke-xdszKnB-djUKLd4cchyZ23zaQAXANmvw45E-MlusCcOmqkfLnF8NnpjA.YjCdzQ.T-yNWmBvjcbtt629GjMYF_XVJbU; views=13 Cf-Connecting-Ip: 89.153.131.85 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 (296.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['383612667610267648', 8432] (slow_query, 296.8, 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', '173584'), ('views', '642'), ('session', '.eJx1UdtuwjAM_Zc8VxO9rC28MTZgjMGKNsQ2TVXauCU0baokFTfx73OZGA_TXiL7-PjYPjmSuAZV0goqQ3pGNWARykpekV5GhcaMQclLya4516lULOYIETd0fdvx_cC3Ow6-XkiuDCFTKgBZDBD9n8-rOG-4YJf5QuY5sHYvLavznNBzHYuUJpdxo0FVtGxlC0EbzQtuDgIU6kjamLUTa0NNWzbJLN0li7oQWx5lS91_vq_HkV5EH7uHaXLlG1kAnnskNE1B60tOHulrGq5eoBhEs-jJ69LIPUzzVbUdLidzB_thV3MFOqbonO17QRB03eD2xgsd23O8a7010-94YadjEQUZQuvfIf3BvNxNsvcyf5uu59v9gW2CcTIKh2K0ZO2SaGWN13ySs0UakZ_gZiNRt7UVf45ne_JlkbNobPZtA7kDqtCWk0X-GGmoygGXrhohTt83b6fO.Yjh9Ng.hiWY0-XLJ9Ck3yIoyGaedSojTZ8')]) Endpoint: retire_deck View Args: {} Person: 383612667610267648 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '173584'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: DE X-Forwarded-For: 88.153.97.11, 172.68.189.4 Cf-Ray: 6ef7063bacac5b44-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="98", "Opera GX";v="84" 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/98.0.4758.109 Safari/537.36 OPR/84.0.4316.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: de-DE,de;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: page_size=20; hide_intro=True; deck_id=173584; views=642; session=.eJx1UdtuwjAM_Zc8VxO9rC28MTZgjMGKNsQ2TVXauCU0baokFTfx73OZGA_TXiL7-PjYPjmSuAZV0goqQ3pGNWARykpekV5GhcaMQclLya4516lULOYIETd0fdvx_cC3Ow6-XkiuDCFTKgBZDBD9n8-rOG-4YJf5QuY5sHYvLavznNBzHYuUJpdxo0FVtGxlC0EbzQtuDgIU6kjamLUTa0NNWzbJLN0li7oQWx5lS91_vq_HkV5EH7uHaXLlG1kAnnskNE1B60tOHulrGq5eoBhEs-jJ69LIPUzzVbUdLidzB_thV3MFOqbonO17QRB03eD2xgsd23O8a7010-94YadjEQUZQuvfIf3BvNxNsvcyf5uu59v9gW2CcTIKh2K0ZO2SaGWN13ySs0UakZ_gZiNRt7UVf45ne_JlkbNobPZtA7kDqtCWk0X-GGmoygGXrhohTt83b6fO.Yjh9Ng.hiWY0-XLJ9Ck3yIoyGaedSojTZ8 Cf-Connecting-Ip: 88.153.97.11 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 (510.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['912722447239901215', 8856] (slow_query, 510.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', '173574'), ('session', '.eJx1UdlOwzAQ_Bc_R1Xi5uwbBQQ9FCgIKgWhyE02qUtiBx9t06r_jlNUIoR4887O7OyOjyhtQNSEAVNopIQGC5G8pgyNClJJU-VQ05rnfU1lxkWeUgOhyMEBxq4b4GEU2Q52PNQzKp6RCgxrQwz6P5-ytNS0yi_-v3UVL0vIuy0lZ2fXMPR8C9Wq5KmWIBipO7IE0hG0WBkRJ1qtcSoVUV1P7_bM3cRxsvT8qEiug_FMwfjV286bO33V8xX_AHP5EZEsAykvNaLy8Tb4dJLtk40fDg2bHYJJover1Q7bSaeHfUMFyJSYEB3fDZ3Ic4fRwMfB0Jza97tcfdsNbdtCAgoDrX9M-H3cLqbTYF6_LFv2vIbtBKv5DdPeYkdjY2JSbcw1b-icljTI92Ow4WZul7D5RFq06N1C56GpajsBGgMRINDJQn9SVESUYJZmuqpOX2-_qgM.Yjh_Ig.NV4N054zsA0CG-JeF9_U1SrJWDE'), ('views', '143')]) Endpoint: retire_deck View Args: {} Person: 912722447239901215 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '173574'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: JP X-Forwarded-For: 118.243.77.18, 172.68.133.101 Cf-Ray: 6ef7124938da34e7-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="99", "Google Chrome";v="99" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com Content-Type: application/x-www-form-urlencoded User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 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=173574; session=.eJx1UdlOwzAQ_Bc_R1Xi5uwbBQQ9FCgIKgWhyE02qUtiBx9t06r_jlNUIoR4887O7OyOjyhtQNSEAVNopIQGC5G8pgyNClJJU-VQ05rnfU1lxkWeUgOhyMEBxq4b4GEU2Q52PNQzKp6RCgxrQwz6P5-ytNS0yi_-v3UVL0vIuy0lZ2fXMPR8C9Wq5KmWIBipO7IE0hG0WBkRJ1qtcSoVUV1P7_bM3cRxsvT8qEiug_FMwfjV286bO33V8xX_AHP5EZEsAykvNaLy8Tb4dJLtk40fDg2bHYJJover1Q7bSaeHfUMFyJSYEB3fDZ3Ic4fRwMfB0Jza97tcfdsNbdtCAgoDrX9M-H3cLqbTYF6_LFv2vIbtBKv5DdPeYkdjY2JSbcw1b-icljTI92Ow4WZul7D5RFq06N1C56GpajsBGgMRINDJQn9SVESUYJZmuqpOX2-_qgM.Yjh_Ig.NV4N054zsA0CG-JeF9_U1SrJWDE; views=143 Cf-Connecting-Ip: 118.243.77.18 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 (72.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['761763865058476052', 8748] (slow_query, 72.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', '173585'), ('session', '.eJx1UctuwjAQ_BefUxQCiQM3oBIFtUX0mbaqIpNsjCG2qe2Il_j3bqhoDlVvnn3MzI6PJN2AkUyBcqTvTAUeYbkUivQLVlpEOUghdd5gYTNt8lRgidCoTaNOHIV-GHdp5IcBaSZKnbEScArU1fMjNv5fESrllSjzi4VScw55bc1qdZaKaTf2iHRcp5UFo5ismblhGygFXzolFEcizSq3DFLrmKv710YmSRJko3u-lixxg_UoeKCT6Xgy44OsmXd6DXjykbAsA2svmNwh962dLbZvuzmlYli0q-BrNXsy7cl2X-A-7DbCgE0ZpteOurTT68W9sOX7US-mTbvOM_K7se97xECBpeWvBkSH0R5u1quXzvtUjg_zxdMiMe51pytrt6iBaW7wmA9yjshi5efRWmnkrWPFzxPFnnx65Eyaun29QIbADBhy8sifIB0zHNCzqsry9A0D9al-.YjiCTQ.VRnqxwuHSktoRMCqFer6UH3uGsg'), ('views', '74')]) Endpoint: retire_deck View Args: {} Person: 761763865058476052 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '173585'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2601:845:8180:5ef0:4ceb:f832:5e8f:d94e, 172.68.133.83 Cf-Ray: 6ef7260bedbfe392-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="99", "Microsoft Edge";v="99" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com Content-Type: application/x-www-form-urlencoded User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.74 Safari/537.36 Edg/99.0.1150.46 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/retire/ Accept-Language: en-US,en;q=0.9 Cookie: hide_intro=True; page_size=20; deck_id=173585; session=.eJx1UctuwjAQ_BefUxQCiQM3oBIFtUX0mbaqIpNsjCG2qe2Il_j3bqhoDlVvnn3MzI6PJN2AkUyBcqTvTAUeYbkUivQLVlpEOUghdd5gYTNt8lRgidCoTaNOHIV-GHdp5IcBaSZKnbEScArU1fMjNv5fESrllSjzi4VScw55bc1qdZaKaTf2iHRcp5UFo5ismblhGygFXzolFEcizSq3DFLrmKv710YmSRJko3u-lixxg_UoeKCT6Xgy44OsmXd6DXjykbAsA2svmNwh962dLbZvuzmlYli0q-BrNXsy7cl2X-A-7DbCgE0ZpteOurTT68W9sOX7US-mTbvOM_K7se97xECBpeWvBkSH0R5u1quXzvtUjg_zxdMiMe51pytrt6iBaW7wmA9yjshi5efRWmnkrWPFzxPFnnx65Eyaun29QIbADBhy8sifIB0zHNCzqsry9A0D9al-.YjiCTQ.VRnqxwuHSktoRMCqFer6UH3uGsg; views=74 Cf-Connecting-Ip: 2601:845:8180:5ef0:4ceb:f832:5e8f:d94e 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 (102.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['288753857910145025', 9141] (slow_query, 102.7, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UV1TwjAQ_C95rkxTWmh5k1FHBMEPwLGO04ntNQTSBJPUsTL8d6_MAA-Ob7nbvdu9zY5kWzAVU6AcGThTg0dYUQlFBiWTFqsCKlHp4lwLm2tTZAJbJIjjftSNo35CfRpGfhCRM0PqnElAFqiLxTMC_48IlfFayOJoQWrOoWitWa0OUgkNqUcqx3VWWzCKVe1mLqwzzDpcoVntVkFmHXMtEn-ODJ_TkZCTKXe5LN3TMh590aveUixfz3ynN4DH7gjLc7D2WJPZWNzP9Uf0MszLyZ26tXyyltNUVWKMlnAevrfCgM0Y5kZ7YTeIgyTpdxK_G_j0DLdJ9vww9n2PGCixtTpppOtr2qwWiZj-pLPmMVrkD-klbGbR-CZctRqY4xaPecPk8H9E2WDvkJM9PTprjRLvHjkszVzTDpAhMAOG7D3yJ0LHDAf0rGop979iKaYg.YkG4Sg.ecpBchCzEAhQgMBemsnv1KavzVU'), ('views', '39'), ('deck_id', '174356')]) Endpoint: retire_deck View Args: {} Person: 288753857910145025 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '174356'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PL X-Forwarded-For: 91.246.213.77, 172.68.189.16 Cf-Ray: 6f30b773ccc20c1d-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:98.0) Gecko/20100101 Firefox/98.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8 Accept-Language: en-GB,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: hide_intro=True; session=.eJx1UV1TwjAQ_C95rkxTWmh5k1FHBMEPwLGO04ntNQTSBJPUsTL8d6_MAA-Ob7nbvdu9zY5kWzAVU6AcGThTg0dYUQlFBiWTFqsCKlHp4lwLm2tTZAJbJIjjftSNo35CfRpGfhCRM0PqnElAFqiLxTMC_48IlfFayOJoQWrOoWitWa0OUgkNqUcqx3VWWzCKVe1mLqwzzDpcoVntVkFmHXMtEn-ODJ_TkZCTKXe5LN3TMh590aveUixfz3ynN4DH7gjLc7D2WJPZWNzP9Uf0MszLyZ26tXyyltNUVWKMlnAevrfCgM0Y5kZ7YTeIgyTpdxK_G_j0DLdJ9vww9n2PGCixtTpppOtr2qwWiZj-pLPmMVrkD-klbGbR-CZctRqY4xaPecPk8H9E2WDvkJM9PTprjRLvHjkszVzTDpAhMAOG7D3yJ0LHDAf0rGop979iKaYg.YkG4Sg.ecpBchCzEAhQgMBemsnv1KavzVU; views=39; deck_id=174356 Cf-Connecting-Ip: 91.246.213.77 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 (1122.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['751497032291713085', 7518] (slow_query, 1122.1, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('session', '.eJx1UctOwzAQ_BefQ-WkebXHgooQEAmq9IVQZOxN4taxI9sRtFX_HafQ9oC4eWZ3PbOzB1S0oBsiQVo0troDDxHWcInGJRHGIQYNbxS7Ym6o0qzgjkJJ5IejBA-DYOQn_hCnEbp2CEWJANcF8iafucL_I1wWVccFO1sQqqqA9daMkicp2QnhocZWqugMaEkaOJOKdLYOCmOJ7dWWYZa9lP5DyXa3dMmzMLvbt9UilaoK5r2N336rtuDWPCBCKRhzxshmr_UqeArK-V5s5yL9zFcLqiI6WfJ8unbz8NVyDaYgLjE_Dkc4xaEfDHCIcZxcy32GMQ5TjD2koXRUfdHIN_HjczTrPup1vCkZmfmwuq-ytZkyzqnTcAm2bpk3l5m7DC93jjslZC6PwUY5iXcPnT4t7K4fQBMgGjQ6euhPeJboCuwPOn4DOrallA.YkG93g.Z1z0VifqEMX4KGheB3BID0mTFck'), ('hide_intro', 'True'), ('views', '19')]) Endpoint: retire_deck View Args: {} Person: 751497032291713085 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '174269'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2600:1700:aa92:ad50:5477:6a57:d6d6:770b, 172.68.133.247 Cf-Ray: 6f30da555eab8728-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:98.0) Gecko/20100101 Firefox/98.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=.eJx1UctOwzAQ_BefQ-WkebXHgooQEAmq9IVQZOxN4taxI9sRtFX_HafQ9oC4eWZ3PbOzB1S0oBsiQVo0troDDxHWcInGJRHGIQYNbxS7Ym6o0qzgjkJJ5IejBA-DYOQn_hCnEbp2CEWJANcF8iafucL_I1wWVccFO1sQqqqA9daMkicp2QnhocZWqugMaEkaOJOKdLYOCmOJ7dWWYZa9lP5DyXa3dMmzMLvbt9UilaoK5r2N336rtuDWPCBCKRhzxshmr_UqeArK-V5s5yL9zFcLqiI6WfJ8unbz8NVyDaYgLjE_Dkc4xaEfDHCIcZxcy32GMQ5TjD2koXRUfdHIN_HjczTrPup1vCkZmfmwuq-ytZkyzqnTcAm2bpk3l5m7DC93jjslZC6PwUY5iXcPnT4t7K4fQBMgGjQ6euhPeJboCuwPOn4DOrallA.YkG93g.Z1z0VifqEMX4KGheB3BID0mTFck; hide_intro=True; views=19 Cf-Connecting-Ip: 2600:1700:aa92:ad50:5477:6a57:d6d6:770b 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 (118.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['688821020127133701', 9420] (slow_query, 118.5, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('session', '.eJx1UV1rg0AQ_C_3bIPfmrxVSNJgIITYtKQUOXTVS_RO7s7WEPrfu1pSH0rfbnd2dmbnbiRtQTaUA9dkoWUHBqF5wzhZFLRWWOXQsEbkU81UJmSeMmwRPwxD2zJt07IDy3EC0yLTRC0yWgNOAX9YRwj8T2E8LTtW53cLtShLyAdrSvBRau7apkEaXYq0UyA5bYbNumLnBjhuELTTlZ0qTfUAJF4SRbG3lY8b2HP2ckquF_NQnjZLh_ZqmtfigvTFjdAsA6XuNQEq9_I1kqU-BvGHc4jpZ3VaWSKLdvY6Rj70LZOgUoqxWb47d0PXmlsz3w8dJ_QmfEjSN93QRPcSCmxVvyJO3kF_bMs47u1i6z3tjufED9bLIHyWmxWKYI4tXvNGxnDU7CwYH3PE32LFFZ8_AHk3yLg01deBQCL0D5J8GeRPhJrKEtA07-r66xukmaQ3.YksCOA.CZjC75lZNjbQk5S_ZSc4AG6UKfw'), ('hide_intro', 'True'), ('views', '346'), ('page_size', '100'), ('deck_id', '174990')]) Endpoint: retire_deck View Args: {} Person: 688821020127133701 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '174990'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: NL X-Forwarded-For: 83.128.133.177, 172.68.133.181 Cf-Ray: 6f6ac58d9cb70b6f-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:98.0) Gecko/20100101 Firefox/98.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8 Accept-Language: nl,en-US;q=0.7,en;q=0.3 Content-Type: application/x-www-form-urlencoded Origin: https://pennydreadfulmagic.com Dnt: 1 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: session=.eJx1UV1rg0AQ_C_3bIPfmrxVSNJgIITYtKQUOXTVS_RO7s7WEPrfu1pSH0rfbnd2dmbnbiRtQTaUA9dkoWUHBqF5wzhZFLRWWOXQsEbkU81UJmSeMmwRPwxD2zJt07IDy3EC0yLTRC0yWgNOAX9YRwj8T2E8LTtW53cLtShLyAdrSvBRau7apkEaXYq0UyA5bYbNumLnBjhuELTTlZ0qTfUAJF4SRbG3lY8b2HP2ckquF_NQnjZLh_ZqmtfigvTFjdAsA6XuNQEq9_I1kqU-BvGHc4jpZ3VaWSKLdvY6Rj70LZOgUoqxWb47d0PXmlsz3w8dJ_QmfEjSN93QRPcSCmxVvyJO3kF_bMs47u1i6z3tjufED9bLIHyWmxWKYI4tXvNGxnDU7CwYH3PE32LFFZ8_AHk3yLg01deBQCL0D5J8GeRPhJrKEtA07-r66xukmaQ3.YksCOA.CZjC75lZNjbQk5S_ZSc4AG6UKfw; hide_intro=True; views=346; page_size=100; deck_id=174990 Cf-Connecting-Ip: 83.128.133.177 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 (95.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['493124322995732480', 8811] (slow_query, 95.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', '.eJx1UV1PwkAQ_C_33JB-0pY3UYKlGjRUJRjTnO22FK69ch8gEv67WxLpg_HtZnZ2Z3fuRNIWRE0baBQZKaHBIDSvq4aMCsokohzqquZ5jyuZcZGnFVLEDR3Ldh3bDkPPd2w3MEmvYDyjDFAlNLL_66smLXXFegvGyxLybjHJm4tREFiWQWpV8lRLEA2tu7lbQetWSwtncKrV2k6loqqrsAe2iuPkZT9r3p7zg4CFI6yNFqunuXuY9HrFt4CnngjNMpDyF5OpTpY53ET71_ku44mjjp-3iXuoTZhM_Rn2w1dbCZApxdSsoePbXhiYzsAOhqbrBX29CxKpwDQNIqBAan01eYziiH57th_FUKjh_Qac6G43Xs7dLV2M0QRjbPGad8wOv6cqjshdkpLXx2DD0eLDIJehqTp2DWQMVIAgZ4P8yVBRUQIu3WjGzj9PTqTP.YlBJUA.-02Pul8B_rpYGtKPeAPQCu_GnxM'), ('views', '25')]) Endpoint: retire_deck View Args: {} Person: 493124322995732480 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '175017'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: RU X-Forwarded-For: 109.252.130.115, 172.68.189.16 Cf-Ray: 6f8bc1f07c8c4196-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="98", "Yandex";v="22" 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/98.0.4758.119 YaBrowser/22.3.0.2430 Yowser/2.5 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,en;q=0.9 Cookie: hide_intro=True; page_size=20; session=.eJx1UV1PwkAQ_C_33JB-0pY3UYKlGjRUJRjTnO22FK69ch8gEv67WxLpg_HtZnZ2Z3fuRNIWRE0baBQZKaHBIDSvq4aMCsokohzqquZ5jyuZcZGnFVLEDR3Ldh3bDkPPd2w3MEmvYDyjDFAlNLL_66smLXXFegvGyxLybjHJm4tREFiWQWpV8lRLEA2tu7lbQetWSwtncKrV2k6loqqrsAe2iuPkZT9r3p7zg4CFI6yNFqunuXuY9HrFt4CnngjNMpDyF5OpTpY53ET71_ku44mjjp-3iXuoTZhM_Rn2w1dbCZApxdSsoePbXhiYzsAOhqbrBX29CxKpwDQNIqBAan01eYziiH57th_FUKjh_Qac6G43Xs7dLV2M0QRjbPGad8wOv6cqjshdkpLXx2DD0eLDIJehqTp2DWQMVIAgZ4P8yVBRUQIu3WjGzj9PTqTP.YlBJUA.-02Pul8B_rpYGtKPeAPQCu_GnxM; views=25 Cf-Connecting-Ip: 109.252.130.115 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 (83.6 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['493124322995732480', 8811] (slow_query, 83.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'), ('session', '.eJx1UV1PwkAQ_C_33JB-0pY3UYKlGjRUJRjTnO22FK69ch8gEv67WxLpg_HtZnZ2Z3fuRNIWRE0baBQZKaHBIDSvq4aMCsokohzqquZ5jyuZcZGnFVLEDR3Ldh3bDkPPd2w3MEmvYDyjDFAlNLL_66smLXXFegvGyxLybjHJm4tREFiWQWpV8lRLEA2tu7lbQetWSwtncKrV2k6loqqrsAe2iuPkZT9r3p7zg4CFI6yNFqunuXuY9HrFt4CnngjNMpDyF5OpTpY53ET71_ku44mjjp-3iXuoTZhM_Rn2w1dbCZApxdSsoePbXhiYzsAOhqbrBX29CxKpwDQNIqBAan01eYziiH57th_FUKjh_Qac6G43Xs7dLV2M0QRjbPGad8wOv6cqjshdkpLXx2DD0eLDIJehqTp2DWQMVIAgZ4P8yVBRUQIu3WjGzj9PTqTP.YlBJXg.h8YhrLTIEplGVtQ7Jl7LrNoX0JU'), ('views', '33')]) Endpoint: retire_deck View Args: {} Person: 493124322995732480 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '175017'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: RU X-Forwarded-For: 109.252.130.115, 172.68.189.16 Cf-Ray: 6f8bc23c0e1d4196-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="98", "Yandex";v="22" 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/98.0.4758.119 YaBrowser/22.3.0.2430 Yowser/2.5 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,en;q=0.9 Cookie: hide_intro=True; page_size=20; session=.eJx1UV1PwkAQ_C_33JB-0pY3UYKlGjRUJRjTnO22FK69ch8gEv67WxLpg_HtZnZ2Z3fuRNIWRE0baBQZKaHBIDSvq4aMCsokohzqquZ5jyuZcZGnFVLEDR3Ldh3bDkPPd2w3MEmvYDyjDFAlNLL_66smLXXFegvGyxLybjHJm4tREFiWQWpV8lRLEA2tu7lbQetWSwtncKrV2k6loqqrsAe2iuPkZT9r3p7zg4CFI6yNFqunuXuY9HrFt4CnngjNMpDyF5OpTpY53ET71_ku44mjjp-3iXuoTZhM_Rn2w1dbCZApxdSsoePbXhiYzsAOhqbrBX29CxKpwDQNIqBAan01eYziiH57th_FUKjh_Qac6G43Xs7dLV2M0QRjbPGad8wOv6cqjshdkpLXx2DD0eLDIJehqTp2DWQMVIAgZ4P8yVBRUQIu3WjGzj9PTqTP.YlBJXg.h8YhrLTIEplGVtQ7Jl7LrNoX0JU; views=33 Cf-Connecting-Ip: 109.252.130.115 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 (149.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['401340702664949770', 8939] (slow_query, 149.1, 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', '175550'), ('session', '.eJx1UctuwjAQ_BefU-Q85BBuUFokCuoDEKCqiiy8BJPYDrYjSCv-vU4qmkPV4-xjdmb2C6UlaEElSIsGVlfgIcoEl2iwp4VxiIHgQrEOc7NTmqXclVCE_TDCMQ4IiZIoiWOMuolC7WgBbgrk3WrhGv-vcJlmFS_YTUKhsgxYI80o2Z7qJ2HiIWEzlVYGtKSiYS6pZJQp6SgUrewhSI2ltum8nSE_TobCx-s8Xtj1hbyea1iSZGitnHfzVuXgzH4hutuBMTeMnp5rNVyI7baeTLen4DgPtwf5-TKan2KNN24fLiXXYFLqcvNJRKKgH8d-z_dxSPyu3SRJcNTH2EMa9q50-L2Bx5vpfoaNfx_2h-SBcpbPynzMluHKPE7dDZdj6cy8ozYc0zsq3lj9QW2g7m18X6MPD7Wkqa2bBTQCqkGjq4f-RGipzsBpllVRXL8Be3Skzg.YlBLDw.-r9mx44g5RhhGwqQPnyIilEKCSw'), ('views', '5075')]) Endpoint: retire_deck View Args: {} Person: 401340702664949770 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '175550'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2600:1700:5f42:c490:7159:c1c0:7b93:35a8, 172.68.132.210 Cf-Ray: 6f8bccc9bdf21807-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.60 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=175550; session=.eJx1UctuwjAQ_BefU-Q85BBuUFokCuoDEKCqiiy8BJPYDrYjSCv-vU4qmkPV4-xjdmb2C6UlaEElSIsGVlfgIcoEl2iwp4VxiIHgQrEOc7NTmqXclVCE_TDCMQ4IiZIoiWOMuolC7WgBbgrk3WrhGv-vcJlmFS_YTUKhsgxYI80o2Z7qJ2HiIWEzlVYGtKSiYS6pZJQp6SgUrewhSI2ltum8nSE_TobCx-s8Xtj1hbyea1iSZGitnHfzVuXgzH4hutuBMTeMnp5rNVyI7baeTLen4DgPtwf5-TKan2KNN24fLiXXYFLqcvNJRKKgH8d-z_dxSPyu3SRJcNTH2EMa9q50-L2Bx5vpfoaNfx_2h-SBcpbPynzMluHKPE7dDZdj6cy8ozYc0zsq3lj9QW2g7m18X6MPD7Wkqa2bBTQCqkGjq4f-RGipzsBpllVRXL8Be3Skzg.YlBLDw.-r9mx44g5RhhGwqQPnyIilEKCSw; views=5075 Cf-Connecting-Ip: 2600:1700:5f42:c490:7159:c1c0:7b93:35a8 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.9 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['401340702664949770', 8939] (slow_query, 64.9, 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', '175550'), ('session', '.eJx1UctuwjAQ_BefU-Q85BBuUFokCuoDEKCqiiy8BJPYDrYjSCv-vU4qmkPV4-xjdmb2C6UlaEElSIsGVlfgIcoEl2iwp4VxiIHgQrEOc7NTmqXclVCE_TDCMQ4IiZIoiWOMuolC7WgBbgrk3WrhGv-vcJlmFS_YTUKhsgxYI80o2Z7qJ2HiIWEzlVYGtKSiYS6pZJQp6SgUrewhSI2ltum8nSE_TobCx-s8Xtj1hbyea1iSZGitnHfzVuXgzH4hutuBMTeMnp5rNVyI7baeTLen4DgPtwf5-TKan2KNN24fLiXXYFLqcvNJRKKgH8d-z_dxSPyu3SRJcNTH2EMa9q50-L2Bx5vpfoaNfx_2h-SBcpbPynzMluHKPE7dDZdj6cy8ozYc0zsq3lj9QW2g7m18X6MPD7Wkqa2bBTQCqkGjq4f-RGipzsBpllVRXL8Be3Skzg.YlBLDw.-r9mx44g5RhhGwqQPnyIilEKCSw'), ('views', '5075'), ('cf_use_ob', '0')]) Endpoint: retire_deck View Args: {} Person: 401340702664949770 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '175550'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2600:1700:5f42:c490:7159:c1c0:7b93:35a8, 172.68.132.210 Cf-Ray: 6f8bced61ebe1807-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.60 Safari/537.36 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: en-US,en;q=0.9 Cookie: page_size=20; hide_intro=True; deck_id=175550; session=.eJx1UctuwjAQ_BefU-Q85BBuUFokCuoDEKCqiiy8BJPYDrYjSCv-vU4qmkPV4-xjdmb2C6UlaEElSIsGVlfgIcoEl2iwp4VxiIHgQrEOc7NTmqXclVCE_TDCMQ4IiZIoiWOMuolC7WgBbgrk3WrhGv-vcJlmFS_YTUKhsgxYI80o2Z7qJ2HiIWEzlVYGtKSiYS6pZJQp6SgUrewhSI2ltum8nSE_TobCx-s8Xtj1hbyea1iSZGitnHfzVuXgzH4hutuBMTeMnp5rNVyI7baeTLen4DgPtwf5-TKan2KNN24fLiXXYFLqcvNJRKKgH8d-z_dxSPyu3SRJcNTH2EMa9q50-L2Bx5vpfoaNfx_2h-SBcpbPynzMluHKPE7dDZdj6cy8ozYc0zsq3lj9QW2g7m18X6MPD7Wkqa2bBTQCqkGjq4f-RGipzsBpllVRXL8Be3Skzg.YlBLDw.-r9mx44g5RhhGwqQPnyIilEKCSw; views=5075; cf_use_ob=0 Cf-Connecting-Ip: 2600:1700:5f42:c490:7159:c1c0:7b93:35a8 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.6 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['941480620092174396', 9252] (slow_query, 185.6, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('views', '8'), ('session', '.eJx1UV1PwkAQ_C_3XElbSnvlTQmiCR_GKhKMaa7t0h5c75q7q0II_90tBnkwvt3uzs7szB1J2oCumQRpydDqFhzCippLMtwwYbAqoOa1Kq41N7nSRcqxReLAC6gb-q4b-14U9OOQXBFC5UwAokDevCY4-H-Fy7RsuSguJwhVllB0pxklz1KxP_AdUttSpa0BLVndMecVkwVikUKx1lZ-aiyz3WQeMT7qVw8JzZ6zcDpdcJF8raI1DNrFbnfFW7UDNHskLM_BmEtNJn64v-Usu--7jzltlnw8flos30xLGzEXuA_7hmswKcPcvDAIB2groj3P9T1K6XXeRRm6aNl1iIYNtqpfkVkhqrk7y6o4aaJ9Mlp_lsl2Mgpe8jk9rFAEg2zQzTs5p2Ow8_PobRXydoniv_HNgXw45Eya2kO3QO6AadDk5JA_GVqmS8CjZSvE6RtqMaTV.YlGbmA.5bHmxlM5P2x90QE3N1R3wfHJ4H4')]) Endpoint: retire_deck View Args: {} Person: 941480620092174396 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '175599'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 68.189.251.214, 172.68.132.204 Cf-Ray: 6f940432fc0e5806-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 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; views=8; session=.eJx1UV1PwkAQ_C_3XElbSnvlTQmiCR_GKhKMaa7t0h5c75q7q0II_90tBnkwvt3uzs7szB1J2oCumQRpydDqFhzCippLMtwwYbAqoOa1Kq41N7nSRcqxReLAC6gb-q4b-14U9OOQXBFC5UwAokDevCY4-H-Fy7RsuSguJwhVllB0pxklz1KxP_AdUttSpa0BLVndMecVkwVikUKx1lZ-aiyz3WQeMT7qVw8JzZ6zcDpdcJF8raI1DNrFbnfFW7UDNHskLM_BmEtNJn64v-Usu--7jzltlnw8flos30xLGzEXuA_7hmswKcPcvDAIB2groj3P9T1K6XXeRRm6aNl1iIYNtqpfkVkhqrk7y6o4aaJ9Mlp_lsl2Mgpe8jk9rFAEg2zQzTs5p2Ow8_PobRXydoniv_HNgXw45Eya2kO3QO6AadDk5JA_GVqmS8CjZSvE6RtqMaTV.YlGbmA.5bHmxlM5P2x90QE3N1R3wfHJ4H4 Cf-Connecting-Ip: 68.189.251.214 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 (286.7 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['941480620092174396', 9252] (slow_query, 286.7, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('views', '8'), ('session', '.eJx1UV1PwkAQ_C_3XElbSnvlTQmiCR_GKhKMaa7t0h5c75q7q0II_90tBnkwvt3uzs7szB1J2oCumQRpydDqFhzCippLMtwwYbAqoOa1Kq41N7nSRcqxReLAC6gb-q4b-14U9OOQXBFC5UwAokDevCY4-H-Fy7RsuSguJwhVllB0pxklz1KxP_AdUttSpa0BLVndMecVkwVikUKx1lZ-aiyz3WQeMT7qVw8JzZ6zcDpdcJF8raI1DNrFbnfFW7UDNHskLM_BmEtNJn64v-Usu--7jzltlnw8flos30xLGzEXuA_7hmswKcPcvDAIB2groj3P9T1K6XXeRRm6aNl1iIYNtqpfkVkhqrk7y6o4aaJ9Mlp_lsl2Mgpe8jk9rFAEg2zQzTs5p2Ow8_PobRXydoniv_HNgXw45Eya2kO3QO6AadDk5JA_GVqmS8CjZSvE6RtqMaTV.YlGbIA._Vwsi-E0xlEr9vCpgZGmXEfPVKs')]) Endpoint: retire_deck View Args: {} Person: 941480620092174396 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '175599'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 68.189.251.214, 172.68.143.211 Cf-Ray: 6f9401ba98508275-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 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; views=8; session=.eJx1UV1PwkAQ_C_3XElbSnvlTQmiCR_GKhKMaa7t0h5c75q7q0II_90tBnkwvt3uzs7szB1J2oCumQRpydDqFhzCippLMtwwYbAqoOa1Kq41N7nSRcqxReLAC6gb-q4b-14U9OOQXBFC5UwAokDevCY4-H-Fy7RsuSguJwhVllB0pxklz1KxP_AdUttSpa0BLVndMecVkwVikUKx1lZ-aiyz3WQeMT7qVw8JzZ6zcDpdcJF8raI1DNrFbnfFW7UDNHskLM_BmEtNJn64v-Usu--7jzltlnw8flos30xLGzEXuA_7hmswKcPcvDAIB2groj3P9T1K6XXeRRm6aNl1iIYNtqpfkVkhqrk7y6o4aaJ9Mlp_lsl2Mgpe8jk9rFAEg2zQzTs5p2Ow8_PobRXydoniv_HNgXw45Eya2kO3QO6AadDk5JA_GVqmS8CjZSvE6RtqMaTV.YlGbIA._Vwsi-E0xlEr9vCpgZGmXEfPVKs Cf-Connecting-Ip: 68.189.251.214 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 (305.9 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['941480620092174396', 9252] (slow_query, 305.9, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('views', '8'), ('session', '.eJx1UV1PwkAQ_C_3XElbSnvlTQmiCR_GKhKMaa7t0h5c75q7q0II_90tBnkwvt3uzs7szB1J2oCumQRpydDqFhzCippLMtwwYbAqoOa1Kq41N7nSRcqxReLAC6gb-q4b-14U9OOQXBFC5UwAokDevCY4-H-Fy7RsuSguJwhVllB0pxklz1KxP_AdUttSpa0BLVndMecVkwVikUKx1lZ-aiyz3WQeMT7qVw8JzZ6zcDpdcJF8raI1DNrFbnfFW7UDNHskLM_BmEtNJn64v-Usu--7jzltlnw8flos30xLGzEXuA_7hmswKcPcvDAIB2groj3P9T1K6XXeRRm6aNl1iIYNtqpfkVkhqrk7y6o4aaJ9Mlp_lsl2Mgpe8jk9rFAEg2zQzTs5p2Ow8_PobRXydoniv_HNgXw45Eya2kO3QO6AadDk5JA_GVqmS8CjZSvE6RtqMaTV.YlGbIA._Vwsi-E0xlEr9vCpgZGmXEfPVKs')]) Endpoint: retire_deck View Args: {} Person: 941480620092174396 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '175599'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 68.189.251.214, 172.68.143.211 Cf-Ray: 6f9401434ea58275-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 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; views=8; session=.eJx1UV1PwkAQ_C_3XElbSnvlTQmiCR_GKhKMaa7t0h5c75q7q0II_90tBnkwvt3uzs7szB1J2oCumQRpydDqFhzCippLMtwwYbAqoOa1Kq41N7nSRcqxReLAC6gb-q4b-14U9OOQXBFC5UwAokDevCY4-H-Fy7RsuSguJwhVllB0pxklz1KxP_AdUttSpa0BLVndMecVkwVikUKx1lZ-aiyz3WQeMT7qVw8JzZ6zcDpdcJF8raI1DNrFbnfFW7UDNHskLM_BmEtNJn64v-Usu--7jzltlnw8flos30xLGzEXuA_7hmswKcPcvDAIB2groj3P9T1K6XXeRRm6aNl1iIYNtqpfkVkhqrk7y6o4aaJ9Mlp_lsl2Mgpe8jk9rFAEg2zQzTs5p2Ow8_PobRXydoniv_HNgXw45Eya2kO3QO6AadDk5JA_GVqmS8CjZSvE6RtqMaTV.YlGbIA._Vwsi-E0xlEr9vCpgZGmXEfPVKs Cf-Connecting-Ip: 68.189.251.214 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 (98.1 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['713812947910262847', 9020] (slow_query, 98.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', '175593'), ('session', '.eJx1UctuwjAQ_BefU-Q4KUm4gYBCUZ-UqlVVRSZZgiGxI9uBpIh_7wYJOFS9eWd3dmbHBxKXoAsuQVrSs7oCh_C0EJL0Vjw3WKVQiEKl11qYROk0FgiRwPVCl0V-ELmUdVnoB-Q6kauE54BTIG8Wc2z8TxEyziqRp2cLucoySFtrRsmTVEQZdUhhMxVXBrTkRbt5zXWNdMUru2axsdy2aJPtazZ52Ipi_0NHw3DYeOXQq4u-umPR_Dpv1Rbw0APhSQLGnGsShaDGg9miYeOX6eNrf7cd378vw883EXnPe-RDXQoNJuaYmdv1I0Zvmcc6NMD3tduG2KV-SNG4hhVC64vEfDmZV2FFE_PxNNpuYBlO9UyarKzH0W6CEhhhibd8YWj4NWLVIHaKyFwenY1CiW-HnJbGtmkJZABcgyZHh_xJz3KdAVqWVZ4ffwHDfaNL.YlGdSQ.tz0VUUvG3pcR6rDIRE9km4Cduf0'), ('views', '931')]) Endpoint: retire_deck View Args: {} Person: 713812947910262847 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '175593'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 100.4.168.58, 172.68.143.211 Cf-Ray: 6f941169ae788c05-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="99", "Opera";v="85" 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/99.0.4844.84 Safari/537.36 OPR/85.0.4341.47 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; page_size=20; deck_id=175593; session=.eJx1UctuwjAQ_BefU-Q4KUm4gYBCUZ-UqlVVRSZZgiGxI9uBpIh_7wYJOFS9eWd3dmbHBxKXoAsuQVrSs7oCh_C0EJL0Vjw3WKVQiEKl11qYROk0FgiRwPVCl0V-ELmUdVnoB-Q6kauE54BTIG8Wc2z8TxEyziqRp2cLucoySFtrRsmTVEQZdUhhMxVXBrTkRbt5zXWNdMUru2axsdy2aJPtazZ52Ipi_0NHw3DYeOXQq4u-umPR_Dpv1Rbw0APhSQLGnGsShaDGg9miYeOX6eNrf7cd378vw883EXnPe-RDXQoNJuaYmdv1I0Zvmcc6NMD3tduG2KV-SNG4hhVC64vEfDmZV2FFE_PxNNpuYBlO9UyarKzH0W6CEhhhibd8YWj4NWLVIHaKyFwenY1CiW-HnJbGtmkJZABcgyZHh_xJz3KdAVqWVZ4ffwHDfaNL.YlGdSQ.tz0VUUvG3pcR6rDIRE9km4Cduf0; views=931 Cf-Connecting-Ip: 100.4.168.58 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 (393.5 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['713812947910262847', 9020] (slow_query, 393.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', '176411'), ('session', '.eJx1UctuwjAQ_BefU-Q4KUm4gYBCUZ-UqlVVRSZZgiGxI9uBpIh_7wYJOFS9eWd3dmbHBxKXoAsuQVrSs7oCh_C0EJL0Vjw3WKVQiEKl11qYROk0FgiRwPVCl0V-ELmUdVnoB-Q6kauE54BTIG8Wc2z8TxEyziqRp2cLucoySFtrRsmTVEQZdUhhMxVXBrTkRbt5zXWNdMUru2axsdy2aJPtazZ52Ipi_0NHw3DYeOXQq4u-umPR_Dpv1Rbw0APhSQLGnGsShaDGg9miYeOX6eNrf7cd378vw883EXnPe-RDXQoNJuaYmdv1I0Zvmcc6NMD3tduG2KV-SNG4hhVC64vEfDmZV2FFE_PxNNpuYBlO9UyarKzH0W6CEhhhibd8YWj4NWLVIHaKyFwenY1CiW-HnJbGtmkJZABcgyZHh_xJz3KdAVqWVZ4ffwHDfaNL.YlrUFw.5N76_I-KwlhlGok_0M5J-pH6n60'), ('views', '1753')]) Endpoint: retire_deck View Args: {} Person: 713812947910262847 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176411'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 100.4.168.58, 172.68.143.211 Cf-Ray: 6fcda538fccd9e04-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="99", "Opera";v="85" 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/99.0.4844.84 Safari/537.36 OPR/85.0.4341.60 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; page_size=20; deck_id=176411; session=.eJx1UctuwjAQ_BefU-Q4KUm4gYBCUZ-UqlVVRSZZgiGxI9uBpIh_7wYJOFS9eWd3dmbHBxKXoAsuQVrSs7oCh_C0EJL0Vjw3WKVQiEKl11qYROk0FgiRwPVCl0V-ELmUdVnoB-Q6kauE54BTIG8Wc2z8TxEyziqRp2cLucoySFtrRsmTVEQZdUhhMxVXBrTkRbt5zXWNdMUru2axsdy2aJPtazZ52Ipi_0NHw3DYeOXQq4u-umPR_Dpv1Rbw0APhSQLGnGsShaDGg9miYeOX6eNrf7cd378vw883EXnPe-RDXQoNJuaYmdv1I0Zvmcc6NMD3tduG2KV-SNG4hhVC64vEfDmZV2FFE_PxNNpuYBlO9UyarKzH0W6CEhhhibd8YWj4NWLVIHaKyFwenY1CiW-HnJbGtmkJZABcgyZHh_xJz3KdAVqWVZ4ffwHDfaNL.YlrUFw.5N76_I-KwlhlGok_0M5J-pH6n60; views=1753 Cf-Connecting-Ip: 100.4.168.58 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 (250.9 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['713812947910262847', 9020] (slow_query, 250.9, 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', '176411'), ('session', '.eJx1UctuwjAQ_BefU-Q4KUm4gYBCUZ-UqlVVRSZZgiGxI9uBpIh_7wYJOFS9eWd3dmbHBxKXoAsuQVrSs7oCh_C0EJL0Vjw3WKVQiEKl11qYROk0FgiRwPVCl0V-ELmUdVnoB-Q6kauE54BTIG8Wc2z8TxEyziqRp2cLucoySFtrRsmTVEQZdUhhMxVXBrTkRbt5zXWNdMUru2axsdy2aJPtazZ52Ipi_0NHw3DYeOXQq4u-umPR_Dpv1Rbw0APhSQLGnGsShaDGg9miYeOX6eNrf7cd378vw883EXnPe-RDXQoNJuaYmdv1I0Zvmcc6NMD3tduG2KV-SNG4hhVC64vEfDmZV2FFE_PxNNpuYBlO9UyarKzH0W6CEhhhibd8YWj4NWLVIHaKyFwenY1CiW-HnJbGtmkJZABcgyZHh_xJz3KdAVqWVZ4ffwHDfaNL.YlrUFw.5N76_I-KwlhlGok_0M5J-pH6n60'), ('views', '1753')]) Endpoint: retire_deck View Args: {} Person: 713812947910262847 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176411'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 100.4.168.58, 172.68.132.10 Cf-Ray: 6fcda8b3ae140ca1-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="99", "Opera";v="85" 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/99.0.4844.84 Safari/537.36 OPR/85.0.4341.60 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: en-US,en;q=0.9 Cookie: hide_intro=True; page_size=20; deck_id=176411; session=.eJx1UctuwjAQ_BefU-Q4KUm4gYBCUZ-UqlVVRSZZgiGxI9uBpIh_7wYJOFS9eWd3dmbHBxKXoAsuQVrSs7oCh_C0EJL0Vjw3WKVQiEKl11qYROk0FgiRwPVCl0V-ELmUdVnoB-Q6kauE54BTIG8Wc2z8TxEyziqRp2cLucoySFtrRsmTVEQZdUhhMxVXBrTkRbt5zXWNdMUru2axsdy2aJPtazZ52Ipi_0NHw3DYeOXQq4u-umPR_Dpv1Rbw0APhSQLGnGsShaDGg9miYeOX6eNrf7cd378vw883EXnPe-RDXQoNJuaYmdv1I0Zvmcc6NMD3tduG2KV-SNG4hhVC64vEfDmZV2FFE_PxNNpuYBlO9UyarKzH0W6CEhhhibd8YWj4NWLVIHaKyFwenY1CiW-HnJbGtmkJZABcgyZHh_xJz3KdAVqWVZ4ffwHDfaNL.YlrUFw.5N76_I-KwlhlGok_0M5J-pH6n60; views=1753 Cf-Connecting-Ip: 100.4.168.58 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 (90.2 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['179438273763082240', 8757] (slow_query, 90.2, 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', '176662'), ('session', '.eJx1UdtOwkAU_Jd9rqS0pVt4VIiCQQuC15hmaU_b7WW37sUUCf_uFoN9ML7tnMvMnNkDihoQNWHAFJooocFCJKkpQ5OUVNKgBGpa86THVMZcJBE1JTTEY88NHOxi37UDx_Fs1E9UPCYVmClgF9sH0_h_hbIo07RKzhYqnmWQdNYkZyepAI-whWqV8UhLEIzUHfOOikQSluwApKHhRKvciaQiquvaGR0vr1dBiW8_Azzb6rBtlTtdr-eULmg_r3gJ5uADInEMUp4xulu2U_XV5JtQz8L5yC5TdXMlS12WhSIfZh_ahgqQETHZDX1vjAPXd4cDBzvu2MN9v4vTt73Ati0kIDWl_Fdk85LK8GmWsfuV3DlsufCdwnv1iuc8Xj3GRsSE2Zhr3tApoe7Mn8eg4Ia3S9X8HU336N1CJ9JI7bsFdAlEgEBHC_3JURGRgTHNdFUdvwGEHKfG.Yl17vg.tj-T1fyNUvu554FoKQXtXWvxbgY'), ('views', '3738')]) Endpoint: retire_deck View Args: {} Person: 179438273763082240 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176662'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2601:c1:400:e740:68c0:af84:1d:e63d, 172.68.132.204 Cf-Ray: 6fde3d13dd3c7fae-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.75 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; page_size=20; deck_id=176662; session=.eJx1UdtOwkAU_Jd9rqS0pVt4VIiCQQuC15hmaU_b7WW37sUUCf_uFoN9ML7tnMvMnNkDihoQNWHAFJooocFCJKkpQ5OUVNKgBGpa86THVMZcJBE1JTTEY88NHOxi37UDx_Fs1E9UPCYVmClgF9sH0_h_hbIo07RKzhYqnmWQdNYkZyepAI-whWqV8UhLEIzUHfOOikQSluwApKHhRKvciaQiquvaGR0vr1dBiW8_Azzb6rBtlTtdr-eULmg_r3gJ5uADInEMUp4xulu2U_XV5JtQz8L5yC5TdXMlS12WhSIfZh_ahgqQETHZDX1vjAPXd4cDBzvu2MN9v4vTt73Ati0kIDWl_Fdk85LK8GmWsfuV3DlsufCdwnv1iuc8Xj3GRsSE2Zhr3tApoe7Mn8eg4Ia3S9X8HU336N1CJ9JI7bsFdAlEgEBHC_3JURGRgTHNdFUdvwGEHKfG.Yl17vg.tj-T1fyNUvu554FoKQXtXWvxbgY; views=3738 Cf-Connecting-Ip: 2601:c1:400:e740:68c0:af84:1d:e63d 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 (71.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['179438273763082240', 8757] (slow_query, 71.8, 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', '176662'), ('session', '.eJx1UdtOwkAU_Jd9rqS0pVt4VIiCQQuC15hmaU_b7WW37sUUCf_uFoN9ML7tnMvMnNkDihoQNWHAFJooocFCJKkpQ5OUVNKgBGpa86THVMZcJBE1JTTEY88NHOxi37UDx_Fs1E9UPCYVmClgF9sH0_h_hbIo07RKzhYqnmWQdNYkZyepAI-whWqV8UhLEIzUHfOOikQSluwApKHhRKvciaQiquvaGR0vr1dBiW8_Azzb6rBtlTtdr-eULmg_r3gJ5uADInEMUp4xulu2U_XV5JtQz8L5yC5TdXMlS12WhSIfZh_ahgqQETHZDX1vjAPXd4cDBzvu2MN9v4vTt73Ati0kIDWl_Fdk85LK8GmWsfuV3DlsufCdwnv1iuc8Xj3GRsSE2Zhr3tApoe7Mn8eg4Ia3S9X8HU336N1CJ9JI7bsFdAlEgEBHC_3JURGRgTHNdFUdvwGEHKfG.Yl17vg.tj-T1fyNUvu554FoKQXtXWvxbgY'), ('views', '3738')]) Endpoint: retire_deck View Args: {} Person: 179438273763082240 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176662'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2601:c1:400:e740:68c0:af84:1d:e63d, 172.68.132.204 Cf-Ray: 6fde3d91bed37fae-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.75 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; page_size=20; deck_id=176662; session=.eJx1UdtOwkAU_Jd9rqS0pVt4VIiCQQuC15hmaU_b7WW37sUUCf_uFoN9ML7tnMvMnNkDihoQNWHAFJooocFCJKkpQ5OUVNKgBGpa86THVMZcJBE1JTTEY88NHOxi37UDx_Fs1E9UPCYVmClgF9sH0_h_hbIo07RKzhYqnmWQdNYkZyepAI-whWqV8UhLEIzUHfOOikQSluwApKHhRKvciaQiquvaGR0vr1dBiW8_Azzb6rBtlTtdr-eULmg_r3gJ5uADInEMUp4xulu2U_XV5JtQz8L5yC5TdXMlS12WhSIfZh_ahgqQETHZDX1vjAPXd4cDBzvu2MN9v4vTt73Ati0kIDWl_Fdk85LK8GmWsfuV3DlsufCdwnv1iuc8Xj3GRsSE2Zhr3tApoe7Mn8eg4Ia3S9X8HU336N1CJ9JI7bsFdAlEgEBHC_3JURGRgTHNdFUdvwGEHKfG.Yl17vg.tj-T1fyNUvu554FoKQXtXWvxbgY; views=3738 Cf-Connecting-Ip: 2601:c1:400:e740:68c0:af84:1d:e63d 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 (174.0 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['538024786950094858', 3121] (slow_query, 174.0, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.331181298.1612570798'), ('session', '.eJx1UctuwjAQ_BefU-S8k95KUEEtLW0RKlBVkZMsiSGxE9uhIMS_10EiHKrePLuzOzvjE4prEBVhwBS6V6IFA5GsouwKMqhoxbMeUplykcVUV5BrB9hy_MALXYxDJ3ADdGOUPCUlaBawu8VcN_4foSzOW1r2IiXPc8i6wyRnFynbtEwDVSrncStBMFJ1m6tW1CQ76g2ctKqwYqmI6hpmk1rR3o_K1dZckWSx_mzFoxgn78Qczn9ufMV3oJ2eEElTkPKKUWguhVxHxc90Gs1entnx0HzU69e9tPh8QvU8HGoqQMZEh2Z6tueHvoeDge_YFvatW7_L0cNOgLGBBGx0qehFZvUuGUMzmiSCPj2E_vKtgFG9d0NBm3KlRXSOtXbzpZPTv0M3ndFLTrJ_DLZcS3wb6LI0VsduAA2BCBDobKA_ESoictBHs7Ysz7_91KWF.Yl19XQ.FuKYdZBDOxR6WSnDkGPXe1EzvK8'), ('hide_intro', 'True'), ('views', '243'), ('page_size', '20'), ('deck_id', '176560')]) Endpoint: retire_deck View Args: {} Person: 538024786950094858 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176560'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2601:184:200:8c50:e55c:e890:d68:6d61, 172.68.132.204 Cf-Ray: 6fde47983dee332c-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Priority: u=1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:99.0) Gecko/20100101 Firefox/99.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: _ga=GA1.2.331181298.1612570798; session=.eJx1UctuwjAQ_BefU-S8k95KUEEtLW0RKlBVkZMsiSGxE9uhIMS_10EiHKrePLuzOzvjE4prEBVhwBS6V6IFA5GsouwKMqhoxbMeUplykcVUV5BrB9hy_MALXYxDJ3ADdGOUPCUlaBawu8VcN_4foSzOW1r2IiXPc8i6wyRnFynbtEwDVSrncStBMFJ1m6tW1CQ76g2ctKqwYqmI6hpmk1rR3o_K1dZckWSx_mzFoxgn78Qczn9ufMV3oJ2eEElTkPKKUWguhVxHxc90Gs1entnx0HzU69e9tPh8QvU8HGoqQMZEh2Z6tueHvoeDge_YFvatW7_L0cNOgLGBBGx0qehFZvUuGUMzmiSCPj2E_vKtgFG9d0NBm3KlRXSOtXbzpZPTv0M3ndFLTrJ_DLZcS3wb6LI0VsduAA2BCBDobKA_ESoictBHs7Ysz7_91KWF.Yl19XQ.FuKYdZBDOxR6WSnDkGPXe1EzvK8; hide_intro=True; views=243; page_size=20; deck_id=176560 Cf-Connecting-Ip: 2601:184:200:8c50:e55c:e890:d68:6d61 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 (201.9 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 201.9, 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', '176838'), ('views', '64'), ('session', '.eJx1UctuwjAQ_BefU5Q3gVtpC1QI2kqIAlUVmXgTHJw42A7lIf69GyTgUPXm2Znd2R2fSFyBKmgJpSFdo2qwCGUFL0k3pUIjYlDwQrI75jqRisUcS8Tz_cgNPc_zw7bjBIFnk7tCyIQKQBWUD4MeEv-38DLOai7YdQUhswxYs5qW5cXKDSPPIoXJZFxrUCUtmsk__HikislUHnGKpLVZu7E21DRkzqp852xsNsz6pjNLX8cBX70M1CL5XNDpXW_kBvDeE6FJAlpfMXHHx9V4klejpeutzG47eVxuA9YZ6iiK-nPsh33FFeiYYnROGDh2GAa-37KDthv50Z1v0gxtP7JtiyhIsbS-meyS_Ww-fXo-vIneR5pQO3zfLx1wF4ORWOZogllWeM0Xpod_xNMD1i5Z6dujlUu0-LbIZWhsDk0D6QFVoMjZIn9iNFRlgEuXtRDnX1WMpqc.YmAbPw.Y8m5S1WPgadR2Istvwq6BH2gFfI')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176838'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.143.211 Cf-Ray: 6feea45a5f65da72-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Dnt: 1 Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36 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: en,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: hide_intro=True; page_size=20; deck_id=176838; views=64; session=.eJx1UctuwjAQ_BefU5Q3gVtpC1QI2kqIAlUVmXgTHJw42A7lIf69GyTgUPXm2Znd2R2fSFyBKmgJpSFdo2qwCGUFL0k3pUIjYlDwQrI75jqRisUcS8Tz_cgNPc_zw7bjBIFnk7tCyIQKQBWUD4MeEv-38DLOai7YdQUhswxYs5qW5cXKDSPPIoXJZFxrUCUtmsk__HikislUHnGKpLVZu7E21DRkzqp852xsNsz6pjNLX8cBX70M1CL5XNDpXW_kBvDeE6FJAlpfMXHHx9V4klejpeutzG47eVxuA9YZ6iiK-nPsh33FFeiYYnROGDh2GAa-37KDthv50Z1v0gxtP7JtiyhIsbS-meyS_Ww-fXo-vIneR5pQO3zfLx1wF4ORWOZogllWeM0Xpod_xNMD1i5Z6dujlUu0-LbIZWhsDk0D6QFVoMjZIn9iNFRlgEuXtRDnX1WMpqc.YmAbPw.Y8m5S1WPgadR2Istvwq6BH2gFfI Cf-Connecting-Ip: 89.153.131.85 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 (393.0 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 393.0, 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', '176838'), ('session', '.eJx1UctuwjAQ_BefU5Q3gVtpC1QI2kqIAlUVmXgTHJw42A7lIf69GyTgUPXm2Znd2R2fSFyBKmgJpSFdo2qwCGUFL0k3pUIjYlDwQrI75jqRisUcS8Tz_cgNPc_zw7bjBIFnk7tCyIQKQBWUD4MeEv-38DLOai7YdQUhswxYs5qW5cXKDSPPIoXJZFxrUCUtmsk__HikislUHnGKpLVZu7E21DRkzqp852xsNsz6pjNLX8cBX70M1CL5XNDpXW_kBvDeE6FJAlpfMXHHx9V4klejpeutzG47eVxuA9YZ6iiK-nPsh33FFeiYYnROGDh2GAa-37KDthv50Z1v0gxtP7JtiyhIsbS-meyS_Ww-fXo-vIneR5pQO3zfLx1wF4ORWOZogllWeM0Xpod_xNMD1i5Z6dujlUu0-LbIZWhsDk0D6QFVoMjZIn9iNFRlgEuXtRDnX1WMpqc.YmAa4A.6eXVkkaPN9_Kl9eiUDYd68551as'), ('views', '58')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176838'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.132.204 Cf-Ray: 6fee9fa118ff03de-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: hide_intro=True; page_size=20; deck_id=176838; session=.eJx1UctuwjAQ_BefU5Q3gVtpC1QI2kqIAlUVmXgTHJw42A7lIf69GyTgUPXm2Znd2R2fSFyBKmgJpSFdo2qwCGUFL0k3pUIjYlDwQrI75jqRisUcS8Tz_cgNPc_zw7bjBIFnk7tCyIQKQBWUD4MeEv-38DLOai7YdQUhswxYs5qW5cXKDSPPIoXJZFxrUCUtmsk__HikislUHnGKpLVZu7E21DRkzqp852xsNsz6pjNLX8cBX70M1CL5XNDpXW_kBvDeE6FJAlpfMXHHx9V4klejpeutzG47eVxuA9YZ6iiK-nPsh33FFeiYYnROGDh2GAa-37KDthv50Z1v0gxtP7JtiyhIsbS-meyS_Ww-fXo-vIneR5pQO3zfLx1wF4ORWOZogllWeM0Xpod_xNMD1i5Z6dujlUu0-LbIZWhsDk0D6QFVoMjZIn9iNFRlgEuXtRDnX1WMpqc.YmAa4A.6eXVkkaPN9_Kl9eiUDYd68551as; views=58 Cf-Connecting-Ip: 89.153.131.85 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 (128.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 128.8, 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', '176838'), ('cf_use_ob', '0'), ('session', '.eJx1UctuwjAQ_BefU5Q3gVtpC1QI2kqIAlUVmXgTHJw42A7lIf69GyTgUPXm2Znd2R2fSFyBKmgJpSFdo2qwCGUFL0k3pUIjYlDwQrI75jqRisUcS8Tz_cgNPc_zw7bjBIFnk7tCyIQKQBWUD4MeEv-38DLOai7YdQUhswxYs5qW5cXKDSPPIoXJZFxrUCUtmsk__HikislUHnGKpLVZu7E21DRkzqp852xsNsz6pjNLX8cBX70M1CL5XNDpXW_kBvDeE6FJAlpfMXHHx9V4klejpeutzG47eVxuA9YZ6iiK-nPsh33FFeiYYnROGDh2GAa-37KDthv50Z1v0gxtP7JtiyhIsbS-meyS_Ww-fXo-vIneR5pQO3zfLx1wF4ORWOZogllWeM0Xpod_xNMD1i5Z6dujlUu0-LbIZWhsDk0D6QFVoMjZIn9iNFRlgEuXtRDnX1WMpqc.YmAb6g.eOkoOd5YRN-D0q3Z7dHnHufJt-Y'), ('views', '71')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176838'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.143.211 Cf-Ray: 6feea6245e31da72-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: hide_intro=True; page_size=20; deck_id=176838; cf_use_ob=0; session=.eJx1UctuwjAQ_BefU5Q3gVtpC1QI2kqIAlUVmXgTHJw42A7lIf69GyTgUPXm2Znd2R2fSFyBKmgJpSFdo2qwCGUFL0k3pUIjYlDwQrI75jqRisUcS8Tz_cgNPc_zw7bjBIFnk7tCyIQKQBWUD4MeEv-38DLOai7YdQUhswxYs5qW5cXKDSPPIoXJZFxrUCUtmsk__HikislUHnGKpLVZu7E21DRkzqp852xsNsz6pjNLX8cBX70M1CL5XNDpXW_kBvDeE6FJAlpfMXHHx9V4klejpeutzG47eVxuA9YZ6iiK-nPsh33FFeiYYnROGDh2GAa-37KDthv50Z1v0gxtP7JtiyhIsbS-meyS_Ww-fXo-vIneR5pQO3zfLx1wF4ORWOZogllWeM0Xpod_xNMD1i5Z6dujlUu0-LbIZWhsDk0D6QFVoMjZIn9iNFRlgEuXtRDnX1WMpqc.YmAb6g.eOkoOd5YRN-D0q3Z7dHnHufJt-Y; views=71 Cf-Connecting-Ip: 89.153.131.85 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 (81.2 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 81.2, 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', '176838'), ('views', '77'), ('session', '.eJx1UctuwjAQ_BefU5Q3gVtpC1QI2kqIAlUVmXgTHJw42A7lIf69GyTgUPXm2Znd2R2fSFyBKmgJpSFdo2qwCGUFL0k3pUIjYlDwQrI75jqRisUcS8Tz_cgNPc_zw7bjBIFnk7tCyIQKQBWUD4MeEv-38DLOai7YdQUhswxYs5qW5cXKDSPPIoXJZFxrUCUtmsk__HikislUHnGKpLVZu7E21DRkzqp852xsNsz6pjNLX8cBX70M1CL5XNDpXW_kBvDeE6FJAlpfMXHHx9V4klejpeutzG47eVxuA9YZ6iiK-nPsh33FFeiYYnROGDh2GAa-37KDthv50Z1v0gxtP7JtiyhIsbS-meyS_Ww-fXo-vIneR5pQO3zfLx1wF4ORWOZogllWeM0Xpod_xNMD1i5Z6dujlUu0-LbIZWhsDk0D6QFVoMjZIn9iNFRlgEuXtRDnX1WMpqc.YmAcGg.oNUglFnQx0bHo8jthLqaL7Ylts8')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176838'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.143.211 Cf-Ray: 6feea74d1fe1da72-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: hide_intro=True; page_size=20; deck_id=176838; views=77; session=.eJx1UctuwjAQ_BefU5Q3gVtpC1QI2kqIAlUVmXgTHJw42A7lIf69GyTgUPXm2Znd2R2fSFyBKmgJpSFdo2qwCGUFL0k3pUIjYlDwQrI75jqRisUcS8Tz_cgNPc_zw7bjBIFnk7tCyIQKQBWUD4MeEv-38DLOai7YdQUhswxYs5qW5cXKDSPPIoXJZFxrUCUtmsk__HikislUHnGKpLVZu7E21DRkzqp852xsNsz6pjNLX8cBX70M1CL5XNDpXW_kBvDeE6FJAlpfMXHHx9V4klejpeutzG47eVxuA9YZ6iiK-nPsh33FFeiYYnROGDh2GAa-37KDthv50Z1v0gxtP7JtiyhIsbS-meyS_Ww-fXo-vIneR5pQO3zfLx1wF4ORWOZogllWeM0Xpod_xNMD1i5Z6dujlUu0-LbIZWhsDk0D6QFVoMjZIn9iNFRlgEuXtRDnX1WMpqc.YmAcGg.oNUglFnQx0bHo8jthLqaL7Ylts8 Cf-Connecting-Ip: 89.153.131.85 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 (300.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 300.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'), ('deck_id', '176838'), ('views', '64'), ('session', '.eJx1UctuwjAQ_BefU5Q3gVtpC1QI2kqIAlUVmXgTHJw42A7lIf69GyTgUPXm2Znd2R2fSFyBKmgJpSFdo2qwCGUFL0k3pUIjYlDwQrI75jqRisUcS8Tz_cgNPc_zw7bjBIFnk7tCyIQKQBWUD4MeEv-38DLOai7YdQUhswxYs5qW5cXKDSPPIoXJZFxrUCUtmsk__HikislUHnGKpLVZu7E21DRkzqp852xsNsz6pjNLX8cBX70M1CL5XNDpXW_kBvDeE6FJAlpfMXHHx9V4klejpeutzG47eVxuA9YZ6iiK-nPsh33FFeiYYnROGDh2GAa-37KDthv50Z1v0gxtP7JtiyhIsbS-meyS_Ww-fXo-vIneR5pQO3zfLx1wF4ORWOZogllWeM0Xpod_xNMD1i5Z6dujlUu0-LbIZWhsDk0D6QFVoMjZIn9iNFRlgEuXtRDnX1WMpqc.YmAbPw.Y8m5S1WPgadR2Istvwq6BH2gFfI')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176838'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.132.204 Cf-Ray: 6feea1f389f403de-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: hide_intro=True; page_size=20; deck_id=176838; views=64; session=.eJx1UctuwjAQ_BefU5Q3gVtpC1QI2kqIAlUVmXgTHJw42A7lIf69GyTgUPXm2Znd2R2fSFyBKmgJpSFdo2qwCGUFL0k3pUIjYlDwQrI75jqRisUcS8Tz_cgNPc_zw7bjBIFnk7tCyIQKQBWUD4MeEv-38DLOai7YdQUhswxYs5qW5cXKDSPPIoXJZFxrUCUtmsk__HikislUHnGKpLVZu7E21DRkzqp852xsNsz6pjNLX8cBX70M1CL5XNDpXW_kBvDeE6FJAlpfMXHHx9V4klejpeutzG47eVxuA9YZ6iiK-nPsh33FFeiYYnROGDh2GAa-37KDthv50Z1v0gxtP7JtiyhIsbS-meyS_Ww-fXo-vIneR5pQO3zfLx1wF4ORWOZogllWeM0Xpod_xNMD1i5Z6dujlUu0-LbIZWhsDk0D6QFVoMjZIn9iNFRlgEuXtRDnX1WMpqc.YmAbPw.Y8m5S1WPgadR2Istvwq6BH2gFfI Cf-Connecting-Ip: 89.153.131.85 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 (808.3 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

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

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '176917'), ('page_size', '20'), ('session', '.eJx1UctuwjAQ_BefU5QXwfQGKi1FFRJCqJSqikyyJC5-BNsBUsS_d4NKOVT1bbyzs7OzJ5JWYCRToBy5d6YGj7BcckXuN0xYRDlILnV-w9xm2uQpxy-S9IOeT6lPo67fD2MaBeTGEDpjApAF6m4xx8L_LVylRc1FfrUgdFFA3lqzWl1GURr7HpGu0GltwSgmW-U007VyyKpACNTRrHZlmFrHXFueWDotyu7udbxfjNYrbrtbuZ-9NEktH8f9G9_pLeDGJ8KyDKy9YjS-U4d56RYwiY7BcvVsvuSoPDxVdDllIfbDseIGbMowvCCJe318UdDxgzCOklu5jTPxY-rjCgY2-FX-zjDrSbJ-y6umCvduOBFusOb-rNkfgsED3sQjGGaFy7yTS0K286lRzvtBl1TxdnzTkA-PXERT17QNZAjMgCFnj_zJ0TFTAHpWtRDnb9OfqT8.YmFrdA.aWSj9IbAHuGUnNYZNKRrO_Phn9I'), ('views', '26')]) Endpoint: retire_deck View Args: {} Person: 691708808350924831 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176917'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2600:1700:1d8b:400:654d:a038:51bc:d1d8, 172.68.133.247 Cf-Ray: 6ff6d751a9229c82-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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=176917; page_size=20; session=.eJx1UctuwjAQ_BefU5QXwfQGKi1FFRJCqJSqikyyJC5-BNsBUsS_d4NKOVT1bbyzs7OzJ5JWYCRToBy5d6YGj7BcckXuN0xYRDlILnV-w9xm2uQpxy-S9IOeT6lPo67fD2MaBeTGEDpjApAF6m4xx8L_LVylRc1FfrUgdFFA3lqzWl1GURr7HpGu0GltwSgmW-U007VyyKpACNTRrHZlmFrHXFueWDotyu7udbxfjNYrbrtbuZ-9NEktH8f9G9_pLeDGJ8KyDKy9YjS-U4d56RYwiY7BcvVsvuSoPDxVdDllIfbDseIGbMowvCCJe318UdDxgzCOklu5jTPxY-rjCgY2-FX-zjDrSbJ-y6umCvduOBFusOb-rNkfgsED3sQjGGaFy7yTS0K286lRzvtBl1TxdnzTkA-PXERT17QNZAjMgCFnj_zJ0TFTAHpWtRDnb9OfqT8.YmFrdA.aWSj9IbAHuGUnNYZNKRrO_Phn9I; views=26 Cf-Connecting-Ip: 2600:1700:1d8b:400:654d:a038:51bc:d1d8 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 (743.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['691708808350924831', 8840] (slow_query, 743.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', '176917'), ('page_size', '20'), ('session', '.eJx1UctuwjAQ_BefU5QXwfQGKi1FFRJCqJSqikyyJC5-BNsBUsS_d4NKOVT1bbyzs7OzJ5JWYCRToBy5d6YGj7BcckXuN0xYRDlILnV-w9xm2uQpxy-S9IOeT6lPo67fD2MaBeTGEDpjApAF6m4xx8L_LVylRc1FfrUgdFFA3lqzWl1GURr7HpGu0GltwSgmW-U007VyyKpACNTRrHZlmFrHXFueWDotyu7udbxfjNYrbrtbuZ-9NEktH8f9G9_pLeDGJ8KyDKy9YjS-U4d56RYwiY7BcvVsvuSoPDxVdDllIfbDseIGbMowvCCJe318UdDxgzCOklu5jTPxY-rjCgY2-FX-zjDrSbJ-y6umCvduOBFusOb-rNkfgsED3sQjGGaFy7yTS0K286lRzvtBl1TxdnzTkA-PXERT17QNZAjMgCFnj_zJ0TFTAHpWtRDnb9OfqT8.YmFrdA.aWSj9IbAHuGUnNYZNKRrO_Phn9I'), ('views', '26'), ('cf_use_ob', '0')]) Endpoint: retire_deck View Args: {} Person: 691708808350924831 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '176917'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2600:1700:1d8b:400:654d:a038:51bc:d1d8, 172.68.133.247 Cf-Ray: 6ff6d8e7487f9c82-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 Safari/537.36 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: en-US,en;q=0.9 Cookie: hide_intro=True; deck_id=176917; page_size=20; session=.eJx1UctuwjAQ_BefU5QXwfQGKi1FFRJCqJSqikyyJC5-BNsBUsS_d4NKOVT1bbyzs7OzJ5JWYCRToBy5d6YGj7BcckXuN0xYRDlILnV-w9xm2uQpxy-S9IOeT6lPo67fD2MaBeTGEDpjApAF6m4xx8L_LVylRc1FfrUgdFFA3lqzWl1GURr7HpGu0GltwSgmW-U007VyyKpACNTRrHZlmFrHXFueWDotyu7udbxfjNYrbrtbuZ-9NEktH8f9G9_pLeDGJ8KyDKy9YjS-U4d56RYwiY7BcvVsvuSoPDxVdDllIfbDseIGbMowvCCJe318UdDxgzCOklu5jTPxY-rjCgY2-FX-zjDrSbJ-y6umCvduOBFusOb-rNkfgsED3sQjGGaFy7yTS0K286lRzvtBl1TxdnzTkA-PXERT17QNZAjMgCFnj_zJ0TFTAHpWtRDnb9OfqT8.YmFrdA.aWSj9IbAHuGUnNYZNKRrO_Phn9I; views=26; cf_use_ob=0 Cf-Connecting-Ip: 2600:1700:1d8b:400:654d:a038:51bc:d1d8 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.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 111.8, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('deck_id', '177579'), ('page_size', '20'), ('hide_intro', 'True'), ('views', '60'), ('session', '.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqlGQ.7vc--kS68khWcW2biEhiBtbWlE8')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '177579'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.143.233 Cf-Ray: 70307f87f8cf9506-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: deck_id=177579; page_size=20; hide_intro=True; views=60; session=.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqlGQ.7vc--kS68khWcW2biEhiBtbWlE8 Cf-Connecting-Ip: 89.153.131.85 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 (174.0 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 174.0, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('deck_id', '177579'), ('page_size', '20'), ('hide_intro', 'True'), ('views', '54'), ('session', '.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '177579'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.143.233 Cf-Ray: 70307ddfdecd9506-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: deck_id=177579; page_size=20; hide_intro=True; views=54; session=.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA Cf-Connecting-Ip: 89.153.131.85 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 (161.8 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 161.8, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('deck_id', '177579'), ('page_size', '20'), ('hide_intro', 'True'), ('views', '54'), ('session', '.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '177579'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.143.233 Cf-Ray: 70307de699269506-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: deck_id=177579; page_size=20; hide_intro=True; views=54; session=.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA Cf-Connecting-Ip: 89.153.131.85 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 (156.0 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 156.0, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('deck_id', '177579'), ('page_size', '20'), ('hide_intro', 'True'), ('views', '54'), ('session', '.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '177579'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.143.233 Cf-Ray: 70307dea0e499506-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: deck_id=177579; page_size=20; hide_intro=True; views=54; session=.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA Cf-Connecting-Ip: 89.153.131.85 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 (167.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 167.4, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('deck_id', '177579'), ('page_size', '20'), ('hide_intro', 'True'), ('views', '54'), ('session', '.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '177579'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.143.233 Cf-Ray: 70307de45dda9506-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: deck_id=177579; page_size=20; hide_intro=True; views=54; session=.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA Cf-Connecting-Ip: 89.153.131.85 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 (168.2 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 168.2, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('deck_id', '177579'), ('page_size', '20'), ('hide_intro', 'True'), ('views', '54'), ('session', '.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '177579'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.143.233 Cf-Ray: 70307de33c2d9506-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: deck_id=177579; page_size=20; hide_intro=True; views=54; session=.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA Cf-Connecting-Ip: 89.153.131.85 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 (150.4 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 150.4, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('deck_id', '177579'), ('page_size', '20'), ('hide_intro', 'True'), ('views', '54'), ('session', '.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '177579'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.143.233 Cf-Ray: 70307dedaba39506-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: deck_id=177579; page_size=20; hide_intro=True; views=54; session=.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA Cf-Connecting-Ip: 89.153.131.85 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.2 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s

['344826333467115530', 2683] (slow_query, 144.2, mysql)

Reported on decksite by mysql-perf

Location Hash: d5e1bb007714e90db07bf00fb62f572e8d73707a

Request Data ``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('deck_id', '177579'), ('page_size', '20'), ('hide_intro', 'True'), ('views', '54'), ('session', '.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA')]) Endpoint: retire_deck View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '177579'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.131.85, 172.68.143.233 Cf-Ray: 70307deebd489506-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: " Not A;Brand";v="99", "Chromium";v="100", "Google Chrome";v="100" 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/100.0.4896.127 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,en-GB;q=0.9,en-US;q=0.8,pt-PT;q=0.7,pt;q=0.6,fr-FR;q=0.5,fr;q=0.4,nl;q=0.3 Sec-Gpc: 1 Cookie: deck_id=177579; page_size=20; hide_intro=True; views=54; session=.eJx1UctOwzAQ_BefQ5WnE7hREK0oLU-hNghFbrxJHZw4tZ0-UvXfcSJKD4jj7M7Ozs4eUFKDLEkFlUZXWjZgIUJLVqGrjHBlEIWSlYKeMVOpkDRhpoQ8349c7Hmej0PHCQLPRmcGFynhYFhQXYyGpvH_CKuSvGGcnixwkedAO2tKVP0qF0eehUqdi6RRICtSdspb1rZEUpGJ1qgI0uiVmyhNdNdsJ_utI1kuosV9_upi-vASqtWuWJQqGJMzX4svMPceEElTUOqEkTttl9NZUU9i11vqzXp2Ha8DejlWURTdzc087GomQSXEROfgwAmDyAnxALshDsPw3O_SxLYf2baFJGSmtPpdskl37_O3m9v9Ix8-Zymx8dMudsBdjCY8LswSk2VtrvlAfUBqUAgjZ_2gPlTzOpbt0aeFetFE77sBNAQiQaKjhf7EqInMwZiuGs6P36gIpvg.YmqktA.X7fSKY1UJAZkkTCgJnfWaq1HQHA Cf-Connecting-Ip: 89.153.131.85 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 12 Connection: Keep-Alive ```

Labels: decksite