vorpal-buildbot
commented
4 years ago Exceeded slow_query limit (34.5 > 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
)```[1587997054.2049313, 1813, 3, 'https://pennydreadfulmagic.com/competitions/3191/', '["sami8s", 3191, "1587997054"]', 'T5 All Lands', 3191, None, None, None, None, None, None, None] (slow_query, 34.5, mysql)
Reported on decksite by mysql-perf
Location Hash: 15cdd0c109b2006f7f986d3d0021ddfb9206e7ce
Request Data
``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('__cfduid', 'da19335d12d391b0315ff16842787b0951587240627'), ('_ga', 'GA1.2.1660111718.1587240631'), ('session', '.eJx1UctuwjAQ_BefUxSCTUxvFKpGpVIPQB9UVeQmSzDENvWD8hD_3g0ScKh688zu7OyODyRfg1VCg_bk1tsAERGlkprczkXtEJWgpDLlFUtXGFvmEinSSVhKKWVJymIeJz1KybWjNoWoAbtA30zHWPhfInVeBVmX5xVqU1VQNqs5o09Wbd7uRET5yuTBgdVCNZOdUJI7HGBE8Iskd174hh8-9vl2Kjnrv-qnUXgo7c9AzlQmMkOHs2u_NyvAUw9EFAU4d8ZkNrHP_UlgnfeXn2_dF5vx6D7EOlvSVf02RD1s19KCywWm1mY85ZR1251Wj_Nu3E2v9SbIbkx5HEfEwhypxcXk9YsVRcHCfrrn2WQzHGyXKwXJgKU2267QBGNc4zUfGBx-j5zvkDvF5C6P1tKgxWdETkNzv2sE5A6EBUuOEfmToBe2Alxah7o-_gJx0qTH.XqbpdQ.t8gqB81jY5gpW9Qb1TgmeDVQ_SI'), ('page_size', '100'), ('deck_id', '72580'), ('_gid', 'GA1.2.149428456.1587987425'), ('_gat_gtag_UA_109131120_1', '1')]) Endpoint: add_signup View Args: {} Person: 325744452750802944 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'sami8s', 'name': 'T5 All Lands', 'decklist': "4 Nissa's Revelation\r\n4 Stone-Seeder Hierophant\r\n2 Thawing Glaciers\r\n4 Sylvan Scrying\r\n21 Forest\r\n4 Scute Mob\r\n3 Pelakka Wurm\r\n2 Sylvan Library\r\n4 Nature's Lore\r\n4 Arboreal Grazer\r\n4 Beanstalk Giant\r\n1 Urza's Factory\r\n3 Rofellos, Llanowar Emissary\r\n\r\n3 Wall of Blossoms\r\n3 Return to Nature\r\n2 Orbs of Warding\r\n1 God-Pharaoh's Statue\r\n3 Scrabbling Claws\r\n3 Dragon's Claw\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: SE X-Forwarded-For: 62.220.164.185, 172.68.132.219 Cf-Ray: 58a92af3798efa1c-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:75.0) Gecko/20100101 Firefox/75.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 Accept-Language: sv-SE,sv;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=da19335d12d391b0315ff16842787b0951587240627; _ga=GA1.2.1660111718.1587240631; session=.eJx1UctuwjAQ_BefUxSCTUxvFKpGpVIPQB9UVeQmSzDENvWD8hD_3g0ScKh688zu7OyODyRfg1VCg_bk1tsAERGlkprczkXtEJWgpDLlFUtXGFvmEinSSVhKKWVJymIeJz1KybWjNoWoAbtA30zHWPhfInVeBVmX5xVqU1VQNqs5o09Wbd7uRET5yuTBgdVCNZOdUJI7HGBE8Iskd174hh8-9vl2Kjnrv-qnUXgo7c9AzlQmMkOHs2u_NyvAUw9EFAU4d8ZkNrHP_UlgnfeXn2_dF5vx6D7EOlvSVf02RD1s19KCywWm1mY85ZR1251Wj_Nu3E2v9SbIbkx5HEfEwhypxcXk9YsVRcHCfrrn2WQzHGyXKwXJgKU2267QBGNc4zUfGBx-j5zvkDvF5C6P1tKgxWdETkNzv2sE5A6EBUuOEfmToBe2Alxah7o-_gJx0qTH.XqbpdQ.t8gqB81jY5gpW9Qb1TgmeDVQ_SI; page_size=100; deck_id=72580; _gid=GA1.2.149428456.1587987425; _gat_gtag_UA_109131120_1=1 Cf-Request-Id: 025d992c2c0000fa1c97b8e200000001 Cf-Connecting-Ip: 62.220.164.185 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 511 Connection: Keep-Alive ```Labels: decksite
[1587712797.5524302, 3905, 3, 'https://pennydreadfulmagic.com/competitions/3191/', '["r0ck3t-g1rl", 3191, "1587712798"]', 'Foreshadow Control', 3191, None, None, None, None, None, None, None](slow_query, 278.5, mysql)Reported on decksite by mysql-perf
Location Hash: 15cdd0c109b2006f7f986d3d0021ddfb9206e7ce
Request Data
``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1047272783.1577670812'), ('hide_intro', 'True'), ('__cfduid', 'd099f199fe5a3b86346443f79ac94748c1587333544'), ('_gid', 'GA1.2.1489932964.1587708529'), ('page_size', '20'), ('session', '.eJx1UctOwzAQ_BefQ2XHTZpwA6RWUCEqtQEhhCLX2aRpHTu1nT5A_DubSpAD4ubZmd3ZHX-SvAXbCA3ak2tvOwiIKJpak-tSKIeogKZuTDHg2klji7zGEomSKGRJkqaMTWIaUUbJoFBGCgWoAn2VLZH4v6XWedXVqvhZQZmqgqJfzRl9seIpjQLS-MrknQOrRdNPtlTuuL-qmFU4xYjOb8LceeF7sprvZ-c2ZWJ9kDC-7zrz5DZhdkxWcEz0oPdmB3jvJxFSgnM_mFCRPcYQdfPF_KZZjk9PUk_CQzZlzzP9eMJ-OLW1BZcLjI5FySTlCU_5iE94GPN44Ps0YzpOKA2IhRJLm1-TlWJT-rJ-KZl8levtR1SUe94eZbraPtwt0ASzbPGaN0wP_6guz1i7ZOV-H6OtQYv3gFyG5v7cN5BbEBYs-QrInxi9sBXg0rpT6usbnyemGg.XqKS3A.0eX7dc5KOAtzQmRds34rqOkZ1_w')]) Endpoint: add_signup View Args: {} Person: 585218899117605010 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'r0ck3t-g1rl', 'name': 'Foreshadow Control', 'decklist': '\r\n