vorpal-buildbot
commented
8 months ago Exceeded slow_query limit (80.2 > 60.0) in mysql: UPDATE person SET discord_id = %s WHERE id = %s
['695816137044262943', 9347] (slow_query, 80.2, mysql)
Reported on decksite by mysql-perf
Location Hash: 9a1235e649ef12a0288ce741aeb4f077c6ca98a3
Request Data
``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('views', '19'), ('session', '.eJx1kdtuwjAMht8l190UaBoolxWwAzuyCdimqUpb02akTUlSDYZ497lMjItpd7F_-7f9ZUfiGkwpKqgcGTjTgEdEVsqKDJZCWYwyKGWps1MsbapNFktMER4G_Q7v-D3KWJd3Q-aTU4XSqVCAVbU7i6Yo_N8iqzhvpMqOKyid55C1q1ldHUaFPut5pHS5jhsLphJl65yDMEWjVuKrUWijReOKbmydcK06ofl21HvkdX5XRUla27W9mMD9KJgyO96c6p1eAR68IyJNwdpjTIZFIpOAlnLNJ4V7XgdBVK6jAnjzUMxfsB82tTRgY4HsOjwMKed9Rs-7PUZZn5_0FifHFKUeMbDEVPE7JItu55dqMVJXQ5E8XTN_NrvR4fiT-mbzusAhCLPGa97IgZA9_9Bo18LEL5PLLT5_BPLukYNp7LZtA4kQDhiy98gfjk6YHHDpqlFq_w1N9acW.Zaxgmw.MW1UFMoqAz1XgDumlqbkQp6cf60')]) Endpoint: retire_deck View Args: {} Person: 695816137044262943 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '233665'} Content-Type: application/x-www-form-urlencoded Content-Length: 12 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 2804:14c:5f87:97a1:55b4:7067:b455:7328 Cf-Ray: 848b5391690f42a2-BNU X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Not_A Brand";v="8", "Chromium";v="120", "Google Chrome";v="120" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Origin: https://pennydreadfulmagic.com Dnt: 1 Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/retire/ Accept-Language: en-US,en;q=0.9,pt;q=0.8,pt-BR;q=0.7 Cookie: hide_intro=True; views=19; session=.eJx1kdtuwjAMht8l190UaBoolxWwAzuyCdimqUpb02akTUlSDYZ497lMjItpd7F_-7f9ZUfiGkwpKqgcGTjTgEdEVsqKDJZCWYwyKGWps1MsbapNFktMER4G_Q7v-D3KWJd3Q-aTU4XSqVCAVbU7i6Yo_N8iqzhvpMqOKyid55C1q1ldHUaFPut5pHS5jhsLphJl65yDMEWjVuKrUWijReOKbmydcK06ofl21HvkdX5XRUla27W9mMD9KJgyO96c6p1eAR68IyJNwdpjTIZFIpOAlnLNJ4V7XgdBVK6jAnjzUMxfsB82tTRgY4HsOjwMKed9Rs-7PUZZn5_0FifHFKUeMbDEVPE7JItu55dqMVJXQ5E8XTN_NrvR4fiT-mbzusAhCLPGa97IgZA9_9Bo18LEL5PLLT5_BPLukYNp7LZtA4kQDhiy98gfjk6YHHDpqlFq_w1N9acW.Zaxgmw.MW1UFMoqAz1XgDumlqbkQp6cf60 Cf-Connecting-Ip: 2804:14c:5f87:97a1:55b4:7067:b455:7328 Cdn-Loop: cloudflare Cf-Ipcountry: BR ```Labels: decksite
['343361125699813376', 8619](slow_query, 90.5, mysql)Reported on decksite by mysql-perf
Location Hash: 9a1235e649ef12a0288ce741aeb4f077c6ca98a3
Request Data
``` Request Method: POST Path: /retire/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('views', '169'), ('session', '.eJx1UctuwjAQ_BefU5QXSdxbqaoqUikHGqlQVZGJN45LYgfbSQmIf69DBRyq3rw7szO74yPKW1ANESAMujeqAwcR2nCB7ktSa1tRaHgj6QWkXBdS0ZzbDgrCIIg8z59GGCdeEMQRujFqWZAaLAvE3fPMAv-PcJGzjtdXk1oyBnTcTEtxtkoiDzuoMUzmnQYlSDMq27okwsN4FJGkM5Wfa0PMiG1e3DR9ynDmVtUcemWSR5bVPh12wyJe3fhGbsFee0SkKEDrS42azOu4u1--Vum2n8Zs_g6wrNp2scPrt3Ee9i1XoHNig_Ni1w_jMPTjCY7dIIz8Gz5mGblh4roOUlDaVnU1SaFtD_C9eliXlGVDVW7CDCf9QW6jfrO3JjbK1l7zgc75aNv5fUy-pNUdM7Ufx8sBfTroLJqbYRxAMyAKFDo56E-KhigGdmnR1fXpB6tspqg.ZZCyQA.KUkuycg3OLPy_Y4udpsxcLPzPRQ')]) Endpoint: retire_deck View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/retire/ Request Data: {'entry': '232886'} Content-Type: application/x-www-form-urlencoded Content-Length: 12 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.111.123 Cf-Ray: 83de51b4fa1b6728-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Not_A Brand";v="8", "Chromium";v="120", "Google Chrome";v="120" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/retire/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; page_size=20; views=169; session=.eJx1UctuwjAQ_BefU5QXSdxbqaoqUikHGqlQVZGJN45LYgfbSQmIf69DBRyq3rw7szO74yPKW1ANESAMujeqAwcR2nCB7ktSa1tRaHgj6QWkXBdS0ZzbDgrCIIg8z59GGCdeEMQRujFqWZAaLAvE3fPMAv-PcJGzjtdXk1oyBnTcTEtxtkoiDzuoMUzmnQYlSDMq27okwsN4FJGkM5Wfa0PMiG1e3DR9ynDmVtUcemWSR5bVPh12wyJe3fhGbsFee0SkKEDrS42azOu4u1--Vum2n8Zs_g6wrNp2scPrt3Ee9i1XoHNig_Ni1w_jMPTjCY7dIIz8Gz5mGblh4roOUlDaVnU1SaFtD_C9eliXlGVDVW7CDCf9QW6jfrO3JjbK1l7zgc75aNv5fUy-pNUdM7Ufx8sBfTroLJqbYRxAMyAKFDo56E-KhigGdmnR1fXpB6tspqg.ZZCyQA.KUkuycg3OLPy_Y4udpsxcLPzPRQ Priority: u=0, i Cf-Connecting-Ip: 178.85.111.123 Cdn-Loop: cloudflare Cf-Ipcountry: NL ```