vorpal-buildbot
commented
2 months ago Exceeded slow_query limit (140.5 > 60.0) in mysql: INSERT INTO `match` (`date`, `round`, elimination, mtgo_id) VALUES (%s, %s, %s, %s)
[1719965231, None, None, None] (slow_query, 140.5, mysql)
Reported on decksite by mysql-perf
Location Hash: c27ae9f588313a1941791c50d1944fa88a3e5aa5
Request Data
``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '245455'), ('session', '.eJx1kdtOwkAQht9lr6tptwcKlxiDaBCpIEFjmqUd2q3tbt1DUkJ4d6cY4MJ4t3P6559vDyRtQTVMgDBkZJQFh7C84YKMdqzWGOXQ8Ebm15jrTKo85ZgiXhgENPbDgFI_dl3fd8m1o5YZqwG7QNysXrHw_wgXaWF5nZ8t1LIoIO-taSlOq-Kh5zmkMYVMrQYlWNMro7UtqD0wZUqUkcyakqbaMNNXkyqaVg8QtxP3-95KSsvBYvY8VJtZtkTNS7-RX4AHHwjLMtD6HBOXT_Pofb-uym6eNYWed4VO1DQYUFsvVjgPXcsV6JQhO29A3TAKfTe-xVc8DP1rvccZuQGe6xAFO0yVlyVjs15Vb3HyOHm52y63vtjMnqqxLZNubts1LkGYLV7zQU6ENGZ-H7eVRN2eKv4d3-3Jp0NOoqnZ9wNkjFhAkaND_nA0TBWApoWt6-MPHLCndg.ZoSWJQ.Y3bgWqga5oYqblx2n_i5mILgJX4'), ('views', '73')]) Endpoint: add_report View Args: {} Person: 154428354223800330 Referrer: https://pennydreadfulmagic.com/report/ Request Data: {'entry': '245455', 'opponent': '245457', 'result': '2–1', 'draws': '0'} Content-Type: application/x-www-form-urlencoded Content-Length: 55 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 2601:602:d001:1af0:2c1e:8dfe:cfeb:56fe Cf-Ray: 89d2a243584775ac-SEA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Sec-Ch-Ua: "Not/A)Brand";v="8", "Chromium";v="126", "Microsoft Edge";v="126" 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/126.0.0.0 Safari/537.36 Edg/126.0.0.0 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/report/ Accept-Language: en-US,en;q=0.9 Priority: u=0, i Cookie: hide_intro=True; page_size=20; deck_id=245455; session=.eJx1kdtOwkAQht9lr6tptwcKlxiDaBCpIEFjmqUd2q3tbt1DUkJ4d6cY4MJ4t3P6559vDyRtQTVMgDBkZJQFh7C84YKMdqzWGOXQ8Ebm15jrTKo85ZgiXhgENPbDgFI_dl3fd8m1o5YZqwG7QNysXrHw_wgXaWF5nZ8t1LIoIO-taSlOq-Kh5zmkMYVMrQYlWNMro7UtqD0wZUqUkcyakqbaMNNXkyqaVg8QtxP3-95KSsvBYvY8VJtZtkTNS7-RX4AHHwjLMtD6HBOXT_Pofb-uym6eNYWed4VO1DQYUFsvVjgPXcsV6JQhO29A3TAKfTe-xVc8DP1rvccZuQGe6xAFO0yVlyVjs15Vb3HyOHm52y63vtjMnqqxLZNubts1LkGYLV7zQU6ENGZ-H7eVRN2eKv4d3-3Jp0NOoqnZ9wNkjFhAkaND_nA0TBWApoWt6-MPHLCndg.ZoSWJQ.Y3bgWqga5oYqblx2n_i5mILgJX4; views=73 Cf-Connecting-Ip: 2601:602:d001:1af0:2c1e:8dfe:cfeb:56fe Cdn-Loop: cloudflare Cf-Ipcountry: US ```Labels: decksite
[1719619707, None, None, '269962375'](slow_query, 173.9, mysql)Reported on decksite by mysql-perf
Location Hash: c27ae9f588313a1941791c50d1944fa88a3e5aa5
Request Data
``` Request Method: POST Path: /report/? Cookies: ImmutableMultiDict([]) Endpoint: add_report View Args: {} Person: logged_out Referrer: None Request Data: {'entry': '245215', 'opponent': '245253', 'result': '2–0', 'draws': '0', 'matchID': '269962375'} Content-Type: application/x-www-form-urlencoded Content-Length: 116 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 198.22.162.92 Cf-Ray: 89b1ae9e983e430e-EWR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: PennyDeadfulBot Cf-Connecting-Ip: 198.22.162.92 Cdn-Loop: cloudflare Cf-Ipcountry: US ```