vorpal-buildbot
commented
5 years ago Exceeded slow_query limit (279.9 > 100.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
)```[1553693382.8195477, 2739, 3, 'https://pennydreadfulmagic.com/competitions/1528/', '["carmandor", 1528, "1553693383"]', 'Grozoth', 1528, None, None, None, None, None, None, None] (slow_query, 279.9, mysql)
Reported on decksite by mysql-perf
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd83e7ab2c17db1acfa58acbd66c6fb29b1553068417', '_ga': 'GA1.2.1687706292.1553068422', 'session': '.eJx9UdFqwjAU_Zf7XEbaNI31cZtUi4IwcRtjlKxJ22xtokmKU_HflxacD4M9nnNvzjn35AzFTpiOKaEcTJ3pRQCMd1LBtGKt9YiLTnaa37C0pTa8kJ6COE3iMJqECaU0xUmKKATwz0QVdS9bfnVqdV0LPiSwWo2KEcVpAJ2rddFbYRTrhBcr2RCRa-M1NOtdExXWMTeO5nua461JV0sbnha9Uy-L1FbPh_3n-nV323f6S_ijzsDKUlh7xcDzQ5OzFmf3lqaZQskHXj8hKTdkc0pC_15876QRtmC-n5AQnFAcTdAdIRHBBN_mQ2UJiicIBWBE5anm18Qs3eqhySMyy6NqOZt38dpu0TGj2ZxHj97EV7rz17z57vxHyOroubEpC-8BjDKFOw4rcC-YEQYuAfypzTFTCx9T9W17-QHaLpeG.D30MPg.df_vXGCU1HrZFcv4OJVgmtwL10M', '_gid': 'GA1.2.727616173.1553500820', '_gat_gtag_UA_109131120_1': '1'} Endpoint: add_signup View Args: {} Person: 496412816777936907 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'carmandor', 'name': 'Grozoth', 'decklist': "4 Agony Warp\r\n4 Arcane Sanctum\r\n1 Artisan of Kozilek\r\n1 Blazing Archon\r\n4 Choked Estuary\r\n4 Connive // Concoct\r\n2 Dimir Guildgate\r\n4 Fleet Swallower\r\n4 Frantic Search\r\n4 Grozoth\r\n9 Island\r\n1 Kuro, Pitlord\r\n1 Makeshift Mannequin\r\n4 Psychatog\r\n1 Reya Dawnbringer\r\n1 Sibsig Muckdraggers\r\n6 Swamp\r\n4 Volrath's Shapeshifter\r\n1 Zetalpa, Primal Dawn\r\n\r\nSideboard:\r\n1 Cremate\r\n2 Flaying Tendrils\r\n2 Jorubai Murk Lurker\r\n1 Nature's Ruin\r\n1 Necroplasm\r\n2 Negate\r\n1 Orbs of Warding\r\n4 Thought Erasure\r\n1 Witchbane Orb"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 185.67.237.178, 188.114.103.97 Cf-Ray: 4be1b6e688d23da1-MXP X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:65.0) Gecko/20100101 Firefox/65.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 Accept-Language: it-IT,it;q=0.8,en-US;q=0.5,en;q=0.3 Referer: https://pennydreadfulmagic.com/signup/ Content-Type: application/x-www-form-urlencoded Upgrade-Insecure-Requests: 1 Cookie: __cfduid=d83e7ab2c17db1acfa58acbd66c6fb29b1553068417; _ga=GA1.2.1687706292.1553068422; session=.eJx9UdFqwjAU_Zf7XEbaNI31cZtUi4IwcRtjlKxJ22xtokmKU_HflxacD4M9nnNvzjn35AzFTpiOKaEcTJ3pRQCMd1LBtGKt9YiLTnaa37C0pTa8kJ6COE3iMJqECaU0xUmKKATwz0QVdS9bfnVqdV0LPiSwWo2KEcVpAJ2rddFbYRTrhBcr2RCRa-M1NOtdExXWMTeO5nua461JV0sbnha9Uy-L1FbPh_3n-nV323f6S_ijzsDKUlh7xcDzQ5OzFmf3lqaZQskHXj8hKTdkc0pC_15876QRtmC-n5AQnFAcTdAdIRHBBN_mQ2UJiicIBWBE5anm18Qs3eqhySMyy6NqOZt38dpu0TGj2ZxHj97EV7rz17z57vxHyOroubEpC-8BjDKFOw4rcC-YEQYuAfypzTFTCx9T9W17-QHaLpeG.D30MPg.df_vXGCU1HrZFcv4OJVgmtwL10M; _gid=GA1.2.727616173.1553500820; _gat_gtag_UA_109131120_1=1 Cf-Connecting-Ip: 185.67.237.178 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 682 ```Location Hash: 23a3c78e5113b1e8eea1832ca135f476a680248d
Labels: decksite
[1553174828.4768844, 849, 3, 'https://pennydreadfulmagic.com/competitions/1528/', '["jenkin5630", 1528, "1553174828"]', 'probably 0-5', 1528, None, None, None, None, None, None, None](slow_query, 169.2, mysql)Reported on decksite by mysql-perf
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd718bb477bd1b89e959853a3fc5fbacb01540528458', 'deck_id': '43148', 'session': '.eJx9UctugkAU_Ze7Js3wBneCXahRa0piY9OQKVxwEAY6M7Ra4793ILEmXXR5Hvd17gXSDkVDOXIFEyV6NIDmDeMwKWgtNcqxYU2b3zGTWSvylGkKrNAhrhWYjm9Zoevbpg0G_KPwtOxZnd8m1W1Ga9TuisKAyhLzYR_Z8rF_4IQGNKps016i4LQZvciPjLueTXRNS3t1sFKpqBo0v9o8x580-i5mPcZfO9x3XvDYPSVJ5UbR3a_aI-oTL0CzDKW8YQimU29l0WxWxbnp7jfnaL1cN9vTKtnv-ErX46ljAmVKdVqm65qe6Vi2_2ASOyDBXR7y84gTEGKAwEJTh98Z79X2NHfi5fwlWzR-Mpt-kEVIXvpkcVp2pp6h8-30Ma86SP0VVpw1N8Ym4c2AsU2qzoMFIqQCBVwN-JuaoqJEvSTv6_r6A1PBmok.D3UiYQ.ghVqGhArhk7IJIVXKuvcIayCImk'} Endpoint: add_signup View Args: {} Person: 294052814722957313 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'jenkin5630', 'name': 'probably 0-5', 'decklist': "4 Form of the Dragon\r\n2 Chandra Nalaar\r\n4 Seething Song\r\n4 Wily Goblin\r\n2 Captain Lannery Storm\r\n4 Pirate's Pillage\r\n4 Ghitu Encampment\r\n3 Starstorm\r\n4 Boom/Bust\r\n4 Goblin Assault\r\n4 Chain Lightning\r\n2 Mizzium Mortars\r\n1 Kher Keep\r\n18 Mountain\r\n\r\n2 Orbs of Warding\r\n1 Witchbane Orb\r\n3 Scrabbling Claws\r\n2 Jester's Cap\r\n2 Muse Vessel\r\n4 Goblin Cratermaker\r\n1 Pyroclasm\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: JP X-Forwarded-For: 240f:7a:f5db:1:a9bc:ea5d:8ba5:6465, 103.22.200.62 Cf-Ray: 4bb042e9589094e1-NRT X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 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/72.0.3626.121 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: ja,en-US;q=0.9,en;q=0.8 Cookie: __cfduid=d718bb477bd1b89e959853a3fc5fbacb01540528458; deck_id=43148; session=.eJx9UctugkAU_Ze7Js3wBneCXahRa0piY9OQKVxwEAY6M7Ra4793ILEmXXR5Hvd17gXSDkVDOXIFEyV6NIDmDeMwKWgtNcqxYU2b3zGTWSvylGkKrNAhrhWYjm9Zoevbpg0G_KPwtOxZnd8m1W1Ga9TuisKAyhLzYR_Z8rF_4IQGNKps016i4LQZvciPjLueTXRNS3t1sFKpqBo0v9o8x580-i5mPcZfO9x3XvDYPSVJ5UbR3a_aI-oTL0CzDKW8YQimU29l0WxWxbnp7jfnaL1cN9vTKtnv-ErX46ljAmVKdVqm65qe6Vi2_2ASOyDBXR7y84gTEGKAwEJTh98Z79X2NHfi5fwlWzR-Mpt-kEVIXvpkcVp2pp6h8-30Ma86SP0VVpw1N8Ym4c2AsU2qzoMFIqQCBVwN-JuaoqJEvSTv6_r6A1PBmok.D3UiYQ.ghVqGhArhk7IJIVXKuvcIayCImk Cf-Connecting-Ip: 240f:7a:f5db:1:a9bc:ea5d:8ba5:6465 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 515 ```Location Hash: 23a3c78e5113b1e8eea1832ca135f476a680248d