vorpal-buildbot
commented
4 years ago Exceeded slow_query limit (39.8 > 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,
reviewed
) VALUES (
IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE
)```[1578143884.5958457, 3738, 3, 'https://pennydreadfulmagic.com/competitions/3094/', '["yuu200180128", 3094, "1578143885"]', 'treefolk', 3094, None, None, None, None, None, None, None] (slow_query, 39.8, mysql)
Reported on decksite by mysql-perf
Location Hash: cfb012a0cc19414e7e4993b0dc1202e759643582
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'page_size': '20', 'deck_id': '65725', 'session': '.eJx1UV1PwkAQ_C_33JjrJ1cfkQhCDJgoUYxpznbbHvZ69T4QMPx3tyTaGOPb7ezMze7sJ8k60JK30FpyabUDj_BCipZclrwxWBUghVTFUAuTK11kAiESsyiM4yRhNA4in4ZJSgZGo3LeALK2HNH_-aLNKieaweK3sFFVBUU_plHt2TYchcwj0lYqcwZ0y2VPPjgXUOoz6gcMZYo7WweZsdz23a6e0pUMFrv7XS6ujsFc8vVm4R7Y7HG53wx8q94Al_8kPM_BmO-azKba1GLDTDoZ30x3jZL19Ttcd_V6P59HqId9JzSYjGOOfpykLPZZwC5CPx2FNB76fbQJjRilHtFQIlT_mNC2hOXe2btJHU1Wr-pJPVa3wsT2GPofYzTBYDvc5hnTxIOJ8oDYOTvz87jYKrR48cj508weegEZA9egyckjf3K0XFeAQ7euaU5fFuOqDw.EPIh_Q.Yu6bztXJOSCPIv2wJzfPVtlU9H8', '_gid': 'GA1.2.162042214.1577788627', '_ga': 'GA1.2.1711824271.1568953326', '__cfduid': 'd84bc5c1e2ce666fd529f467bd0cf6bf91568953359'} Endpoint: add_signup View Args: {} Person: 584355668052410369 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'yuu200180128', 'name': 'treefolk', 'decklist': "24 Forest\r\n4 Treefolk Harbinger\r\n4 Bosk Banneret\r\n4 Dungrove Elder\r\n1 Rootgrapple\r\n4 Timber Protector\r\n3 Sapling of Colfenor\r\n2 Overrun\r\n2 Reach of Branches\r\n3 Nissa's Pilgrimage\r\n4 Nature's Lore\r\n3 Tangle Golem\r\n2 Nylea's Emissary\r\n\r\n4 Broken Bond\r\n3 Crook of Condemnation\r\n4 Autumn's Veil\r\n2 Great Sable Stag\r\n2 Raking Canopy\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: JP X-Forwarded-For: 126.120.244.176, 172.68.141.216 Cf-Ray: 54fd7f0e2e6bef75-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Referer: https://pennydreadfulmagic.com/signup/ Cache-Control: max-age=0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: ja-JP Content-Type: application/x-www-form-urlencoded Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 Edge/18.18362 Cookie: page_size=20; deck_id=65725; session=.eJx1UV1PwkAQ_C_33JjrJ1cfkQhCDJgoUYxpznbbHvZ69T4QMPx3tyTaGOPb7ezMze7sJ8k60JK30FpyabUDj_BCipZclrwxWBUghVTFUAuTK11kAiESsyiM4yRhNA4in4ZJSgZGo3LeALK2HNH_-aLNKieaweK3sFFVBUU_plHt2TYchcwj0lYqcwZ0y2VPPjgXUOoz6gcMZYo7WweZsdz23a6e0pUMFrv7XS6ujsFc8vVm4R7Y7HG53wx8q94Al_8kPM_BmO-azKba1GLDTDoZ30x3jZL19Ttcd_V6P59HqId9JzSYjGOOfpykLPZZwC5CPx2FNB76fbQJjRilHtFQIlT_mNC2hOXe2btJHU1Wr-pJPVa3wsT2GPofYzTBYDvc5hnTxIOJ8oDYOTvz87jYKrR48cj508weegEZA9egyckjf3K0XFeAQ7euaU5fFuOqDw.EPIh_Q.Yu6bztXJOSCPIv2wJzfPVtlU9H8; _gid=GA1.2.162042214.1577788627; _ga=GA1.2.1711824271.1568953326; __cfduid=d84bc5c1e2ce666fd529f467bd0cf6bf91568953359 Cf-Connecting-Ip: 126.120.244.176 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 463 ```Labels: decksite
[1577021362.7210732, 3918, 3, 'https://pennydreadfulmagic.com/competitions/3071/', '["jaapjrc", 3071, "1577021363"]', 'Rofellos Ramp', 3071, None, None, None, None, None, None, None](slow_query, 274.4, mysql)Reported on decksite by mysql-perf
Location Hash: cfb012a0cc19414e7e4993b0dc1202e759643582
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'df5a1e5144061f17e0f29cebeb58fd8d01576883012', 'hide_intro': 'True', 'session': 'eyJsb2NhbGUiOiJlbiJ9.EOD19A.ZZ_him0kXvDS8tlx5-vBGglFytU', 'page_size': '20'} Endpoint: add_signup View Args: {} Person: logged_out Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'jaapjrc', 'name': 'Rofellos Ramp', 'decklist': "2 Artisan of Kozilek\r\n4 Bane of Bala Ged\r\n4 Channel\r\n20 Forest\r\n2 Garruk Wildspeaker\r\n4 God-Pharaoh's Statue\r\n2 Havenwood Battleground\r\n4 Hedron Archive\r\n4 Joraga Treespeaker\r\n4 Leatherback Baloth\r\n2 Mouth/Feed\r\n4 Rofellos, Llanowar Emissary\r\n4 Soul Conduit\r\n\r\n4 Barkhide Troll\r\n2 Distended Mindbender\r\n4 Great Sable Stag\r\n4 Return to Nature\r\n1 Thrashing Brontodon\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: ES X-Forwarded-For: 149.34.60.115, 172.69.22.250 Cf-Ray: 549271bbdae16149-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:71.0) Gecko/20100101 Firefox/71.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: es-ES,es;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/signup/ Upgrade-Insecure-Requests: 1 Cookie: __cfduid=df5a1e5144061f17e0f29cebeb58fd8d01576883012; hide_intro=True; session=eyJsb2NhbGUiOiJlbiJ9.EOD19A.ZZ_him0kXvDS8tlx5-vBGglFytU; page_size=20 Cf-Connecting-Ip: 149.34.60.115 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 498 ```