search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (73.2 > 60.0) in mysql: ```INSERT INTO deck ( #63857

Open vorpal-buildbot opened 6 days ago

vorpal-buildbot commented 6 days ago 
    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,
    decklist_hash,
    reviewed
) VALUES (
     IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE
)```

[1732309822.5584471, 911, 3, 'https://pennydreadfulmagic.com/competitions/4813/', '["_onecurlyboy", 4813, "1732309823"]', 'Falcon Punch', 4813, None, None, None, None, None, None, None, 'faedbe970354c7bfb7bf8524fd70415c7de9c855'] (slow_query, 73.2, mysql)

Reported on decksite by mysql-perf

Location Hash: c45e421fa648a80c4c962ea63a210517c080de73

Request Data ``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UdluwjAQ_Bc_pyinE3gDiUMgteEKSFUVmWQJpokdbAcIiH-vgwRUlfrm2Z3x7M5eUVyCKAgDplBHiQoMRNKCMtTZklxqlEJBC56-MJUJF2lMdQm1se_a2AksBzuu6_kYvQg5T0gOmgTsbTnXjX8VlMVZRfP0McAvJWpQlkHajCk5u9u2LctAhcp4XEkQjBQNN-YMkkrk9YbXWsVJpXZ2LBVRTXc_uhTlxIrcfjSii0EY2aPTwh0fhlAP6vOLr_i3Nu1cEUkSkPKB0aa7UqvjNDh99MeHSxitpxMcLLvnle0dRan1cC6pABkTHaPl29gzXc9pt7Dd9p3g1W6CxaYbmKaBBGx1aff0ULO1ysMp7a1gHrwf5NDrm8fwYJ23M3wZag-da6mX-dRJ6nPRbbPnPTj5fLT2XFt8Gej-aazqRoB6QAQIdDPQ3xQVERnokVmV57cffIKqsA.ZzNuZw.zOvk1s3mKUMESQWMQXvg9j6ck5E'), ('session', '.eJx1UdluwjAQ_Bc_pyinE3gDiUMgteEKSFUVmWQJpokdbAcIiH-vgwRUlfrm2Z3x7M5eUVyCKAgDplBHiQoMRNKCMtTZklxqlEJBC56-MJUJF2lMdQm1se_a2AksBzuu6_kYvQg5T0gOmgTsbTnXjX8VlMVZRfP0McAvJWpQlkHajCk5u9u2LctAhcp4XEkQjBQNN-YMkkrk9YbXWsVJpXZ2LBVRTXc_uhTlxIrcfjSii0EY2aPTwh0fhlAP6vOLr_i3Nu1cEUkSkPKB0aa7UqvjNDh99MeHSxitpxMcLLvnle0dRan1cC6pABkTHaPl29gzXc9pt7Dd9p3g1W6CxaYbmKaBBGx1aff0ULO1ysMp7a1gHrwf5NDrm8fwYJ23M3wZag-da6mX-dRJ6nPRbbPnPTj5fLT2XFt8Gej-aazqRoB6QAQIdDPQ3xQVERnokVmV57cffIKqsA.Z0DzOg.hiBTubJfnwU3i5i0STtnPoKuuDk'), ('views', '1372'), ('deck_id', ''), ('page_size', '20')]) Endpoint: add_signup View Args: {} Person: 96742638136344576 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': '_onecurlyboy', 'name': 'Falcon Punch', 'decklist': "1 Castle Vantress\r\n1 Cave of the Frost Dragon\r\n2 Celestial Colonnade\r\n2 Cleansing Nova\r\n3 Condemn\r\n4 Coveted Falcon\r\n2 Detention Sphere\r\n2 Devastating Mastery\r\n1 Dig Through Time\r\n2 Dragon Turtle\r\n2 Fact or Fiction\r\n2 Glacial Fortress\r\n3 Irrigated Farmland\r\n6 Island\r\n3 Mystic Gate\r\n4 Nine Lives\r\n3 Orator of Ojutai\r\n5 Plains\r\n1 Prairie Stream\r\n3 Render Silent\r\n1 Settle the Wreckage\r\n2 Thassa's Intervention\r\n3 Timeless Dragon\r\n1 Timely Reinforcements\r\n1 Wrath of God\r\n\r\nSIDEBOARD:\r\n2 Detention Sphere\r\n2 Forbid\r\n1 Gainsay\r\n3 Sorcerous Spyglass\r\n1 Stroke of Midnight\r\n3 Timely Reinforcements\r\n2 Vedalken Shackles\r\n1 Wrath of God"} Content-Type: application/x-www-form-urlencoded Content-Length: 823 Cf-Ray: 8e6be7e69f0b42e3-EWR Cookie: hide_intro=True; session=.eJx1UdluwjAQ_Bc_pyinE3gDiUMgteEKSFUVmWQJpokdbAcIiH-vgwRUlfrm2Z3x7M5eUVyCKAgDplBHiQoMRNKCMtTZklxqlEJBC56-MJUJF2lMdQm1se_a2AksBzuu6_kYvQg5T0gOmgTsbTnXjX8VlMVZRfP0McAvJWpQlkHajCk5u9u2LctAhcp4XEkQjBQNN-YMkkrk9YbXWsVJpXZ2LBVRTXc_uhTlxIrcfjSii0EY2aPTwh0fhlAP6vOLr_i3Nu1cEUkSkPKB0aa7UqvjNDh99MeHSxitpxMcLLvnle0dRan1cC6pABkTHaPl29gzXc9pt7Dd9p3g1W6CxaYbmKaBBGx1aff0ULO1ysMp7a1gHrwf5NDrm8fwYJ23M3wZag-da6mX-dRJ6nPRbbPnPTj5fLT2XFt8Gej-aazqRoB6QAQIdDPQ3xQVERnokVmV57cffIKqsA.ZzNuZw.zOvk1s3mKUMESQWMQXvg9j6ck5E; session=.eJx1UdluwjAQ_Bc_pyinE3gDiUMgteEKSFUVmWQJpokdbAcIiH-vgwRUlfrm2Z3x7M5eUVyCKAgDplBHiQoMRNKCMtTZklxqlEJBC56-MJUJF2lMdQm1se_a2AksBzuu6_kYvQg5T0gOmgTsbTnXjX8VlMVZRfP0McAvJWpQlkHajCk5u9u2LctAhcp4XEkQjBQNN-YMkkrk9YbXWsVJpXZ2LBVRTXc_uhTlxIrcfjSii0EY2aPTwh0fhlAP6vOLr_i3Nu1cEUkSkPKB0aa7UqvjNDh99MeHSxitpxMcLLvnle0dRan1cC6pABkTHaPl29gzXc9pt7Dd9p3g1W6CxaYbmKaBBGx1aff0ULO1ysMp7a1gHrwf5NDrm8fwYJ23M3wZag-da6mX-dRJ6nPRbbPnPTj5fLT2XFt8Gej-aazqRoB6QAQIdDPQ3xQVERnokVmV57cffIKqsA.Z0DzOg.hiBTubJfnwU3i5i0STtnPoKuuDk; views=1372; deck_id=; page_size=20 Host: pennydreadfulmagic.com Cf-Ipcountry: US Accept-Encoding: gzip, br X-Forwarded-For: 146.115.169.40 X-Forwarded-Proto: https Priority: u=0, i Sec-Fetch-User: ?1 Cf-Visitor: {"scheme":"https"} Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Cf-Connecting-Ip: 146.115.169.40 Cdn-Loop: cloudflare; loops=1 Sec-Fetch-Dest: document Connection: Keep-Alive Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:132.0) Gecko/20100101 Firefox/132.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-US,en;q=0.5 Origin: https://pennydreadfulmagic.com Dnt: 1 Referer: https://pennydreadfulmagic.com/signup/ ```