vorpal-buildbot
commented
5 years ago Exceeded slow_query limit (286.0 > 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
)```[1558535399.4439929, 3410, 3, 'https://pennydreadfulmagic.com/competitions/2186/', '["crandar", 2186, "1558535399"]', 'Mardu Dark Dwellers', 2186, None, None, None, None, None, None, None] (slow_query, 286.0, mysql)
Reported on decksite by mysql-perf
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd7eafe569062cd5510c2325b6581aa7b11557991999', '_ga': 'GA1.2.1258938939.1557991515', 'deck_id': '49725', '_gid': 'GA1.2.1392629148.1558333952', 'session': '.eJx9UV1rwjAU_S95LtKmTT98nFOG4nROt8EYIWvTGNcmJUmlKv733Qrqw2CQh9xzc8859-SEaMNNzRRXDg2dabmHWFFLhYYlqyxUBa9lrYt7LW2uTUElQChI_ASTNCSRn8IhSYI89E9HUdHKqrgqVVoIXvQOrFYXxjAKfA_VTmjaWm4UqzmQ5Yapghlg0Kx1W0ytY65vhPVj12W4IWuDzUKsY7J8H3ci8MsyXM3v753-4bDSCbE859ZeazSfHfcbuS2ne9Gt1OZ1FM3cZMQmz_HyOF7CPO8aabilDNIJCElJFqc4GwQk87Po3u7ziv0o9cG84SVA25uGJCacil3CMF68RB_l21Owippxk3XfeCdBA_JsYJlPCA5-QZYHwC4x2dtlsNMg8eWhCyl1h34APXBmuEFnD_1J0DEjOHhWbVWdfwH_35uB.D8btpQ.O-WzUdS0GRwkeHxZNLu7Mf-rFx4'} Endpoint: add_signup View Args: {} Person: 170725835408408577 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'crandar', 'name': 'Mardu Dark Dwellers ', 'decklist': '\r\nLocation Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86
Labels: decksite
[1558362407.3184037, 3111, 3, 'https://pennydreadfulmagic.com/competitions/2186/', '["tp0nt3", 2186, "1558362407"]', 'Mono White Heroic Rage', 2186, None, None, None, None, None, None, None](slow_query, 213.9, mysql)Reported on decksite by mysql-perf
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd00d91e86123a20ebfb7fa29eeeb215971546640810', '_ga': 'GA1.2.709864170.1546640816', 'session': '.eJx9kd1ugkAQhd9lrkkDLAh6p_WnaVoTbY22TUNWGAFld3F3UdT47l1IrBdNennOzJ6Z-fYCUYmSUY5cQ0_LCi2gCcs59Da0UEYlyHImkrvOVSxkEuXGAp-Qjmu7IQm8kIReEHTBgn8qPEqrvEhukwqRppg0GyjB20TiOI4FTKciqhRKThmaMF3aXBMTIGilMzdSmurGL-rx9vCJwSTTL_vR_LjoLqb70-I1SwYHt3Pv12KH5qIL0DhGpW4aivdgvJsvn0ZvSGb1cDIdPsaZPK-H_a0_mJn3WJe5RBVRA8fxvdDx_dAhD8RxXd-7lxtcHdsLbdsCiRtjZb8z9Op4Xq66aclwta2f-YyQfibGH-s-q0LbzDA4S3PMl-FmPiHfnIzXUlLwbUEbE-lT0wIDpBIlXC34g0xTmaLZkldFcf0BpBKXbg.D8RKnQ.PTfDk0Ip3fIO8xsge-L0zfWxTXI', '_gid': 'GA1.2.78455097.1558290928', 'deck_id': '50018', '_gat_gtag_UA_109131120_1': '1'} Endpoint: add_signup View Args: {} Person: 533620283748384779 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'tp0nt3', 'name': 'Mono White Heroic Rage', 'decklist': "3 Ajani's Presence\r\n4 Akroan Skyguard\r\n4 Cartouche of Solidarity\r\n4 Defiant Strike\r\n4 Emerge Unscathed\r\n3 Fabled Hero\r\n4 Favored Hoplite\r\n4 Gryff's Boon\r\n2 Guided Strike\r\n4 Lagonna-Band Trailblazer\r\n1 Ordeal of Heliod\r\n18 Plains\r\n1 Sandstone Bridge\r\n4 Center soul\r\n\r\n1 Isolate\r\n3 Nevermore\r\n2 Ordeal of Heliod\r\n3 Orim's Chant\r\n3 Purify the Grave\r\n1 Swift Justice\r\n2 Vanguard of Brimaz\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 128.65.231.246, 141.101.98.168 Cf-Ray: 4d9efcc1de0cbba0-LHR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:66.0) Gecko/20100101 Firefox/66.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: pt-PT,pt;q=0.8,en;q=0.5,en-US;q=0.3 Referer: https://pennydreadfulmagic.com/signup/ Content-Type: application/x-www-form-urlencoded Upgrade-Insecure-Requests: 1 Cookie: __cfduid=d00d91e86123a20ebfb7fa29eeeb215971546640810; _ga=GA1.2.709864170.1546640816; session=.eJx9kd1ugkAQhd9lrkkDLAh6p_WnaVoTbY22TUNWGAFld3F3UdT47l1IrBdNennOzJ6Z-fYCUYmSUY5cQ0_LCi2gCcs59Da0UEYlyHImkrvOVSxkEuXGAp-Qjmu7IQm8kIReEHTBgn8qPEqrvEhukwqRppg0GyjB20TiOI4FTKciqhRKThmaMF3aXBMTIGilMzdSmurGL-rx9vCJwSTTL_vR_LjoLqb70-I1SwYHt3Pv12KH5qIL0DhGpW4aivdgvJsvn0ZvSGb1cDIdPsaZPK-H_a0_mJn3WJe5RBVRA8fxvdDx_dAhD8RxXd-7lxtcHdsLbdsCiRtjZb8z9Op4Xq66aclwta2f-YyQfibGH-s-q0LbzDA4S3PMl-FmPiHfnIzXUlLwbUEbE-lT0wIDpBIlXC34g0xTmaLZkldFcf0BpBKXbg.D8RKnQ.PTfDk0Ip3fIO8xsge-L0zfWxTXI; _gid=GA1.2.78455097.1558290928; deck_id=50018; _gat_gtag_UA_109131120_1=1 Cf-Connecting-Ip: 128.65.231.246 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 538 ```Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86