vorpal-buildbot
commented
2 years ago Exceeded slow_query limit (102.9 > 60.0) in mysql: ```INSERT INTO deck (
created_date,
updated_date,
person_id,
source_id,
url,
identifier,
name,
competition_id,
archetype_id,
resource_uri,
featured_card,
score,
thumbnail_url,
small_thumbnail_url,
finish,
decklist_hash,
reviewed
) VALUES (
IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE
)```[1651244679.826901, 4353, 3, 'https://pennydreadfulmagic.com/competitions/3904/', '["beowulfs", 3904, "1651244680"]', 'Goat Hater BW Midrange', 3904, None, None, None, None, None, None, None, 'd19eb8e5530fdecc3e111dd4ee75f43afb07f0c8'] (slow_query, 102.9, mysql)
Reported on decksite by mysql-perf
Location Hash: 33f2ca9496b61bcf7f23da33a61134601e0b836f
Request Data
``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.177962426.1611933781'), ('hide_intro', 'True'), ('session', '.eJx1UV1vgjAU_S99ZoaPFohvYxpnjNNpIsuWhVQoBVdabMuGGv_7CpnjYdnjuffcc8899wKSmsgKc8I1GGvZEAvgrCo5GOeYKYMyUpWVyAZcqlTILClNCThugFwYwCD0IEI-dHwwMJhIMSOGVeu7aGMa_4-UPKFNybKbBSYoJVlnTQner4Ie8ixQaSqSRhHJcdUp74n4aliujITAjS7cRGmsu05-aO_zmbdbMreJ83hu53uqn7mcbDYifR34WnwQc-wF4DQlSt0w2Dq1QrSYirnaLc4Rjg_u2i6K1UxM1WRh5klbl5KoBJvcHB85IQxQ4IygD8MAoaHfRenbMLRtC0iSm1Lxu2SHon1LHz9bvJ5sn6oX97wURzcOVuvjg4PNEhNkba55A306anQQRs76QX2i5m9lfgLvFuhFE33qBkBEsCQSXC3wJ0ONJSXGNG8Yu34Dt02l_Q.Ymv-cQ.KU_uPPtSKdRRa4BoLg-MN9LUcv8'), ('views', '50')]) Endpoint: add_signup View Args: {} Person: 127524747834556416 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'beowulfs', 'name': 'Goat Hater BW Midrange', 'decklist': '4 Isolated Chapel\r\n1 Eiganjo Castle\r\n3 Shambling Vent\r\n4 Vindicate\r\n3 Flickerwisp\r\n4 Temple of Silence\r\n3 Cloudshift\r\n4 Thraben Inspector\r\n3 Mesmeric Fiend\r\n2 Infernal Grasp\r\n4 Tidehollow Sculler\r\n6 Plains\r\n2 Fiend Hunter\r\n3 Wasteland Strangler\r\n4 Blade Splicer\r\n2 Thalia, Heretic Cathar\r\n3 Touch the Spirit Realm\r\n5 Swamp\r\n\r\n2 Return to Dust\r\n3 Ravenous Trap\r\n2 Lone Missionary\r\n2 Kambal, Consul of Allocation\r\n2 Eerie Interlude\r\n2 Sunset Revelry\r\n1 Lantern of the Lost\r\n1 Disenchant\r\n\r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 179.179.226.176, 172.68.189.4 Cf-Ray: 7038ee6d4cb4a586-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/signup/ Accept-Language: pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: _ga=GA1.2.177962426.1611933781; hide_intro=True; session=.eJx1UV1vgjAU_S99ZoaPFohvYxpnjNNpIsuWhVQoBVdabMuGGv_7CpnjYdnjuffcc8899wKSmsgKc8I1GGvZEAvgrCo5GOeYKYMyUpWVyAZcqlTILClNCThugFwYwCD0IEI-dHwwMJhIMSOGVeu7aGMa_4-UPKFNybKbBSYoJVlnTQner4Ie8ixQaSqSRhHJcdUp74n4aliujITAjS7cRGmsu05-aO_zmbdbMreJ83hu53uqn7mcbDYifR34WnwQc-wF4DQlSt0w2Dq1QrSYirnaLc4Rjg_u2i6K1UxM1WRh5klbl5KoBJvcHB85IQxQ4IygD8MAoaHfRenbMLRtC0iSm1Lxu2SHon1LHz9bvJ5sn6oX97wURzcOVuvjg4PNEhNkba55A306anQQRs76QX2i5m9lfgLvFuhFE33qBkBEsCQSXC3wJ0ONJSXGNG8Yu34Dt02l_Q.Ymv-cQ.KU_uPPtSKdRRa4BoLg-MN9LUcv8; views=50 Cf-Connecting-Ip: 179.179.226.176 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 664 Connection: Keep-Alive ```Labels: decksite
[1649772897.1798234, 9185, 3, 'https://pennydreadfulmagic.com/competitions/3904/', '["rae953", 3904, "1649772897"]', 'rakdos idk man', 3904, None, None, None, None, None, None, None, '32f72fd1692836dee3f1dc3c7284548ebce42fc5'](slow_query, 85.0, mysql)Reported on decksite by mysql-perf
Location Hash: 33f2ca9496b61bcf7f23da33a61134601e0b836f
Request Data
``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', ''), ('views', '4485'), ('session', '.eJx1UctuwjAQ_BefU2TyTm-ltBwgRYJeoKoiK94YQ2IH22mhiH_vBgk4VL3tzj5mdvZEihZMwxQoRx6d6cAjjDdSkceK1RYzDo1sNL_n0pba8EIiRGLqp2mUBJFPw2iYZUFC7h21LlkN2AXqYTLCwv8jUhWikzW_Sqi1EMB7aVarC1U2TCOPNE7oorNgFGv6zYZBFgW4QLPObfzCOuZ6fCV21J_St02yaPfhsVmOvlUcv_N5sy7V673f6R3gqSfCyhKsveYko0r8OCpkNpNfT3yZszjb59163tmA9afAoZUGbMHQtWEcBklGoygZpD4G4b3c-xjTMKXUIwYqhDY3jsl2ZvPnNszbRTA-dJO9vxq30yS3_KU6AHKgiy0e84G-4XdkdUTs4pK9BYOtRopPj1yWFu7YD5ARMAOGnD3yx0DHjADUrLq6Pv8CLA-j4Q.YlWJVQ.PEaXiy4RrIypy34NrDo9BSEnfic')]) Endpoint: add_signup View Args: {} Person: 602885735204519937 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'rae953', 'name': 'rakdos idk man', 'decklist': "4 Forsworn Paladin\r\n4 Shambling Ghast\r\n2 Kalain, Reclusive Painter\r\n3 Stormfist Crusader\r\n1 Breya's Apprentice\r\n3 Morbid Opportunist\r\n4 Torgaar, Famine Incarnate\r\n2 Bloodchief's Thirst\r\n4 Reckoner's Bargain\r\n4 Sign in Blood\r\n4 Hidetsugu's Second Rite\r\n2 Sarkhan the Masterless\r\n4 Canyon Slough\r\n4 Dragonskull Summit\r\n5 Mountain\r\n10 Swamp\r\n\r\n4 Duress\r\n2 Lantern of the Lost\r\n3 Kari Zev's Expertise\r\n4 Crumble to Dust\r\n2 Slaughter Games"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: GB X-Forwarded-For: 82.30.132.36, 172.68.189.16 Cf-Ray: 6fac923eabb006c1-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 GX";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.65 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/signup/ Accept-Language: en-US,en;q=0.9 Cookie: hide_intro=True; page_size=20; deck_id=; views=4485; session=.eJx1UctuwjAQ_BefU2TyTm-ltBwgRYJeoKoiK94YQ2IH22mhiH_vBgk4VL3tzj5mdvZEihZMwxQoRx6d6cAjjDdSkceK1RYzDo1sNL_n0pba8EIiRGLqp2mUBJFPw2iYZUFC7h21LlkN2AXqYTLCwv8jUhWikzW_Sqi1EMB7aVarC1U2TCOPNE7oorNgFGv6zYZBFgW4QLPObfzCOuZ6fCV21J_St02yaPfhsVmOvlUcv_N5sy7V673f6R3gqSfCyhKsveYko0r8OCpkNpNfT3yZszjb59163tmA9afAoZUGbMHQtWEcBklGoygZpD4G4b3c-xjTMKXUIwYqhDY3jsl2ZvPnNszbRTA-dJO9vxq30yS3_KU6AHKgiy0e84G-4XdkdUTs4pK9BYOtRopPj1yWFu7YD5ARMAOGnD3yx0DHjADUrLq6Pv8CLA-j4Q.YlWJVQ.PEaXiy4RrIypy34NrDo9BSEnfic Cf-Connecting-Ip: 82.30.132.36 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 582 Connection: Keep-Alive ```