vorpal-buildbot
commented
4 years ago Exceeded slow_query limit (43.1 > 30.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
)```[1595946096.3617675, 4671, 3, 'https://pennydreadfulmagic.com/competitions/3269/', '["yut0kun", 3269, "1595946096"]', 'High-Tide 2', 3269, None, None, None, None, None, None, None, 'b77e7366bb6fcb63ec13df8e7edae645992d0807'] (slow_query, 43.1, mysql)
Reported on decksite by mysql-perf
Location Hash: 2231702f245380ab6f979e6eccd8b731bb862463
Request Data
``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('__cfduid', 'd45d6c4719dd0fe245047d38c536259861595344872'), ('_ga', 'GA1.2.1050251278.1595344873'), ('_gid', 'GA1.2.106925955.1595621196'), ('hide_intro', 'True'), ('views', '8'), ('session', '.eJx1UctuwjAQ_BefUxSCMQm3UlVULY-KBBVaVZFJNg9I7NR2EAHx790gAYeqN-_O7M7s-ETCClTJBQhDhkbVYBEel7kgw4QXGqsYyryU8b3OdSRVHObYIn026LEudV1GHYdS1nPJnVHIiBeALBAPSx-B_0dyEaZ1XsRXC4VMU4hba1qKixRlg65FSpPKsNagBC_bzU1t7F0tcIPktcmcUBtuWmC8aPz36cvSjP1S_RSwih4npnJf06OZ7Js738gd4K0nwqMItL7W5Hk-qzZPkb8IFnx7jOjxsJ2-JXPmbKazwMN5OFS5Ah1yjK3b9_oes6lHOzbt9bqec8fbJBFybdsiChJsZTeRoMpM-rEXzcqsj1NnUPssiCejbKc_l2uGIphjhdd8YXL4P3nSGr_kpG-PzlaixLdFLktD07QDZARcgSJni_yJ0HCVApoWdVGcfwG48qao.XyAzfg.4rVArREgmp7VBgE4v1SCyKDMgjU')]) Endpoint: add_signup View Args: {} Person: 567361488642244638 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'yut0kun', 'name': 'High-Tide 2', 'decklist': "1 Brain Freeze\r\n1 Braingeyser\r\n2 Commit // Memory\r\n1 Dizzy Spell\r\n3 Fact or Fiction\r\n4 Frantic Inventory\r\n4 Frantic Search\r\n4 High Tide\r\n16 Island\r\n3 Logic Knot\r\n3 Mystic Sanctuary\r\n4 Opt\r\n4 Peer Through Depths\r\n1 Scholar of the Ages\r\n2 Thassa's Intervention\r\n2 Thawing Glaciers\r\n4 Turnabout\r\n1 Winds of Rebuke\r\n\r\nSideboard:\r\n3 Engulf the Shore\r\n2 Lazotep Plating\r\n3 Miscast\r\n1 Negate\r\n3 Pteramander\r\n2 Soul-Guide Lantern\r\n1 Teferi, Mage of Zhalfir"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 67.149.167.218, 172.69.23.95 Cf-Ray: 5b9f3f5e1ced7f68-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/84.0.4147.89 Safari/537.36 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/signup/ Accept-Language: en-US,en;q=0.9 Cookie: __cfduid=d45d6c4719dd0fe245047d38c536259861595344872; _ga=GA1.2.1050251278.1595344873; _gid=GA1.2.106925955.1595621196; hide_intro=True; views=8; session=.eJx1UctuwjAQ_BefUxSCMQm3UlVULY-KBBVaVZFJNg9I7NR2EAHx790gAYeqN-_O7M7s-ETCClTJBQhDhkbVYBEel7kgw4QXGqsYyryU8b3OdSRVHObYIn026LEudV1GHYdS1nPJnVHIiBeALBAPSx-B_0dyEaZ1XsRXC4VMU4hba1qKixRlg65FSpPKsNagBC_bzU1t7F0tcIPktcmcUBtuWmC8aPz36cvSjP1S_RSwih4npnJf06OZ7Js738gd4K0nwqMItL7W5Hk-qzZPkb8IFnx7jOjxsJ2-JXPmbKazwMN5OFS5Ah1yjK3b9_oes6lHOzbt9bqec8fbJBFybdsiChJsZTeRoMpM-rEXzcqsj1NnUPssiCejbKc_l2uGIphjhdd8YXL4P3nSGr_kpG-PzlaixLdFLktD07QDZARcgSJni_yJ0HCVApoWdVGcfwG48qao.XyAzfg.4rVArREgmp7VBgE4v1SCyKDMgjU Cf-Request-Id: 043765eecd00007f68fcbbe200000001 Cf-Connecting-Ip: 67.149.167.218 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 610 Connection: Keep-Alive ```Labels: decksite
[1595687058.2285256, 4903, 3, 'https://pennydreadfulmagic.com/competitions/3269/', '["infinitesunshine", 3269, "1595687058"]', 'Death Cloud', 3269, None, None, None, None, None, None, None, 'd56d8590c287edb6c54c0cac8c34fc5f48b0e61e'](slow_query, 36.1, mysql)Reported on decksite by mysql-perf
Location Hash: 2231702f245380ab6f979e6eccd8b731bb862463
Request Data
``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('__cfduid', 'd0d40cbf6b143792f4cca09f83b106ee41595685913'), ('session', '.eJx1UctuwjAQ_BefU-QAThpuhUooqFABogWqKnKTTeLWscGPhof49zpIJYeqN8_s7M7u-IySHaiKChAGDYyy4CGaVUygQU65diiDilUyazHTqVRZwhyFfEIiTHAYEYKxH5JeiFoFlynl4FQg7lZLV_i_hYmksIy3LlwWBWTNblqKq1c_wj0PVaaQidWgBK2a0UzkTDAD2gpdMgFulqTWlN1EG2oaRbiJ6pGa2jher77X9WJWz4asnp349PCh_FZv5Be4q8-Ipilo_YvRUD1tGcR4PH0Y2U25BTt5PtLjdrUkQT92_XDYMQU6oS5An0RBN_KDqN_pBr0oxEFbbzINcP8eYw8pyB1V3kwWMe-adF_tx_OQvMz8w4S92nl44qMdeTw6E5fozl3z5jJ0P8Xyhrsmpm-Pzqd0Fu8eug5NzLFpQEOgChS6eOhPloaqAtzSwnJ--QF3K6m-.XxxAcQ.hgAJqnbfDyNkXicsjvS7aQHxSJg')]) Endpoint: add_signup View Args: {} Person: 155905079550017537 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'infinitesunshine', 'name': 'Death Cloud', 'decklist': "4 Birds of Paradise\r\n4 Elvish Mystic\r\n3 Dusk Legion Zealot\r\n4 Wall of Blossoms\r\n4 Grim Haruspex\r\n4 Llanowar Visionary\r\n4 Braids, Cabal Minion\r\n4 Talisman of Resilience\r\n3 Garruk Wildspeaker\r\n4 Smokestack\r\n2 Death Cloud\r\n3 Drownyard Temple\r\n8 Forest\r\n5 Swamp\r\n4 Temple of Malady\r\n\r\n4 Dark Ritual\r\n4 Soul-Guide Lantern\r\n3 Choking Sands\r\n2 Curse of Death's Hold\r\n2 Sandwurm Convergence"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 199.48.170.66, 172.69.22.190 Cf-Ray: 5b868b317936c5f4-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,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/signup/ Upgrade-Insecure-Requests: 1 Cookie: __cfduid=d0d40cbf6b143792f4cca09f83b106ee41595685913; session=.eJx1UctuwjAQ_BefU-QAThpuhUooqFABogWqKnKTTeLWscGPhof49zpIJYeqN8_s7M7u-IySHaiKChAGDYyy4CGaVUygQU65diiDilUyazHTqVRZwhyFfEIiTHAYEYKxH5JeiFoFlynl4FQg7lZLV_i_hYmksIy3LlwWBWTNblqKq1c_wj0PVaaQidWgBK2a0UzkTDAD2gpdMgFulqTWlN1EG2oaRbiJ6pGa2jher77X9WJWz4asnp349PCh_FZv5Be4q8-Ipilo_YvRUD1tGcR4PH0Y2U25BTt5PtLjdrUkQT92_XDYMQU6oS5An0RBN_KDqN_pBr0oxEFbbzINcP8eYw8pyB1V3kwWMe-adF_tx_OQvMz8w4S92nl44qMdeTw6E5fozl3z5jJ0P8Xyhrsmpm-Pzqd0Fu8eug5NzLFpQEOgChS6eOhPloaqAtzSwnJ--QF3K6m-.XxxAcQ.hgAJqnbfDyNkXicsjvS7aQHxSJg Cf-Request-Id: 0427f552ee0000c5f4e0a34200000001 Cf-Connecting-Ip: 199.48.170.66 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 523 Connection: Keep-Alive ```