vorpal-buildbot
commented
5 years ago Exceeded slow_query limit (587.6 > 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
)```[1567175887.9093645, 3685, 3, 'https://pennydreadfulmagic.com/competitions/2976/', '["AAmikasa", 2976, "1567175888"]', 'Enchantress', 2976, None, None, None, None, None, None, None] (slow_query, 587.6, mysql)
Reported on decksite by mysql-perf
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd92cf47f7bbc4bd99fd53dc9289bbe7921557758901', '_ga': 'GA1.2.1538831700.1557758900', '_gid': 'GA1.2.1933496207.1567175566'} Endpoint: add_signup View Args: {} Person: logged_out Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'AAmikasa', 'name': 'Enchantress', 'decklist': '\r\nLocation Hash: d26c2f837afa9a93e3eab3aca5985a0f1bd7e816
Labels: decksite
[1567176307.0436444, 193, 3, 'https://pennydreadfulmagic.com/competitions/2976/', '["bobthebalder", 2976, "1567176307"]', 'Chandra', 2976, None, None, None, None, None, None, None](slow_query, 168.5, mysql)Reported on decksite by mysql-perf
Request Data
``` Request Method: POST Path: /signup/? Cookies: {'_ga': 'GA1.2.327908335.1515347658', 'hide_intro': 'True', '__cfduid': 'd6f2bce2f71a1431cb4414f48314d44b31548531395', 'deck_id': '56941', 'session': '.eJx1kVtPwjAUx79LnyfZRjcubyLjomIQg4LGLN12GJVunW1HGITv7hkJLjEx6cO5_8_59UTCAlTGcsgN6RtVgkVYkvGc9DdMaPQSyHgmk8bnOpYqCTmGiENtfK7jtn3as11q26SpEDJmArAK8pvxABP_t_A8TEsukusKQqYpJPVqWuYXKafXtkhmUhmWGlTOsnpwJCOzhYiJBBROkaw0WzfUhpk6Wzz76n1kjtPOfbQeeuJpkXaWj8HkYeeU5bqpN3IHeO-JsDgGra8-mQ-LVVz5wYQuR29J9V0cwJN3nXnVPc6hwH44FFyBDhmiczzf86hN270W9Z1u16dNvqbp27Rr2xZRsMHQ9ldkMXt92R95sJfTcWfgeGmw3Y1nQyY897ZcoQiyLPCaD6SHf8Q3FcYurPSv0fqSKPFpkcvQ0FR1AxkAU4jlbJG_GA1TKeDOeSnE-QctpqYO.EErH5A.TG000xWcJcbBOyasW0_z1P8CEyw'} Endpoint: add_signup View Args: {} Person: 140140212364902400 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'bobthebalder', 'name': 'Chandra', 'decklist': "3 Chandra's Regulator\r\n3 Chandra, Fire of Kaladesh\r\n3 Chandra, Novice Pyromancer\r\n3 Chandra, the Firebrand\r\n2 Chandra Nalaar\r\n4 Chandra's Embercat\r\n1 Oath of Chandra\r\n4 Firebolt\r\n4 Chandra's Triumph\r\n2 Pyromancer's Gauntlet\r\n24 Mountain\r\n3 Prismatic Lens\r\n4 Chandra's Phoenix\r\n\r\n3 Vulshok Refugee\r\n4 Slagstorm\r\n4 Scab-Clan Berserker\r\n4 Rampaging Ferocidon\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: NO X-Forwarded-For: 77.222.222.251, 172.69.22.46 Cf-Ray: 50e78be208dfd899-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 Dnt: 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/76.0.3809.100 Safari/537.36 Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3 Sec-Fetch-Site: same-origin Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: nb-NO,nb;q=0.9,no;q=0.8,nn;q=0.7,en-US;q=0.6,en;q=0.5,da;q=0.4 Cookie: _ga=GA1.2.327908335.1515347658; hide_intro=True; __cfduid=d6f2bce2f71a1431cb4414f48314d44b31548531395; deck_id=56941; session=.eJx1kVtPwjAUx79LnyfZRjcubyLjomIQg4LGLN12GJVunW1HGITv7hkJLjEx6cO5_8_59UTCAlTGcsgN6RtVgkVYkvGc9DdMaPQSyHgmk8bnOpYqCTmGiENtfK7jtn3as11q26SpEDJmArAK8pvxABP_t_A8TEsukusKQqYpJPVqWuYXKafXtkhmUhmWGlTOsnpwJCOzhYiJBBROkaw0WzfUhpk6Wzz76n1kjtPOfbQeeuJpkXaWj8HkYeeU5bqpN3IHeO-JsDgGra8-mQ-LVVz5wYQuR29J9V0cwJN3nXnVPc6hwH44FFyBDhmiczzf86hN270W9Z1u16dNvqbp27Rr2xZRsMHQ9ldkMXt92R95sJfTcWfgeGmw3Y1nQyY897ZcoQiyLPCaD6SHf8Q3FcYurPSv0fqSKPFpkcvQ0FR1AxkAU4jlbJG_GA1TKeDOeSnE-QctpqYO.EErH5A.TG000xWcJcbBOyasW0_z1P8CEyw Cf-Connecting-Ip: 77.222.222.251 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 494 ```Location Hash: d26c2f837afa9a93e3eab3aca5985a0f1bd7e816