Exceeded slow_query limit (1524.2 > 100.0) in mysql: ```INSERT INTO deck (

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (1524.2 > 100.0) in mysql: ```INSERT INTO deck ( #42457

Closed vorpal-buildbot closed 5 years ago

vorpal-buildbot commented 5 years 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,
    reviewed
) VALUES (
     IFNULL(%s, UNIX_TIMESTAMP()), UNIX_TIMESTAMP(), %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, FALSE
)```

[1545184019.9314392, 1769, 3, 'https://pennydreadfulmagic.com/competitions/736/', '["karnonthebcob", 736, "1545184020"]', 'Herioc', 736, None, None, None, None, None, None, None] (slow_query, 1524.2, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'_gid': 'GA1.2.807109645.1545180217', '_ga': 'GA1.2.1029774821.1545010414', '__cfduid': 'd7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408'}
            Endpoint: add_signup
            View Args: {}
            Person: logged_out
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'karnonthebcob', 'name': 'Herioc', 'decklist': "4 Battlewise Hoplite\r\n4 Favored Hoplite\r\n2 Fabled Hero\r\n2 Wingsteed Rider\r\n2 Triton Fortune Hunter\r\n2 Indestructibility\r\n2 Curiosity\r\n1 Eel Umbra\r\n2 Spectra Ward\r\n3 On Serra's Wings\r\n2 Defiant Strike\r\n4 Gods Willing\r\n3 Sheltering Light\r\n3 Aqueous Form\r\n3 Mystic Monastery\r\n10 Plains\r\n3 Evolving Wilds\r\n8 Island\r\n\r\n3 Demystify\r\n"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 108.4.108.102, 162.158.78.144
Cf-Ray: 48b632d9fc99578f-IAD
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Referer: https://pennydreadfulmagic.com/signup/
Cache-Control: max-age=0
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/64.0.3282.140 Safari/537.36 Edge/17.17134
Accept-Language: en-US,en;q=0.7,ja;q=0.3
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Upgrade-Insecure-Requests: 1
Cookie: _gid=GA1.2.807109645.1545180217; _ga=GA1.2.1029774821.1545010414; __cfduid=d7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408
Cf-Connecting-Ip: 108.4.108.102
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 458

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

vorpal-buildbot commented 5 years ago

Exceeded slow_query limit (1628.5 > 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
)```

[1545183917.0064034, 1769, 3, 'https://pennydreadfulmagic.com/competitions/736/', '["karnonthebcob", 736, "1545183917"]', 'Herioc', 736, None, None, None, None, None, None, None] (slow_query, 1628.5, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'_gid': 'GA1.2.807109645.1545180217', '_ga': 'GA1.2.1029774821.1545010414', '__cfduid': 'd7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408', '_gat_gtag_UA_109131120_1': '1'}
            Endpoint: add_signup
            View Args: {}
            Person: logged_out
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'karnonthebcob', 'name': 'Herioc', 'decklist': "4 Battlewise Hoplite\r\n4 Favored Hoplite\r\n2 Fabled Hero\r\n2 Wingsteed Rider\r\n2 Triton Fortune Hunter\r\n2 Indestructibility\r\n2 Curiosity\r\n1 Eel Umbra\r\n2 Spectra Ward\r\n3 On Serra's Wings\r\n2 Defiant Strike\r\n4 Gods Willing\r\n3 Sheltering Light\r\n3 Aqueous Form\r\n3 Mystic Monastery\r\n10 Plains\r\n3 Evolving Wilds\r\n8 Island\r\n\r\n3 Demystify\r\n"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 108.4.108.102, 162.158.78.144
Cf-Ray: 48b63056ec26578f-IAD
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Referer: https://pennydreadfulmagic.com/signup/
Cache-Control: max-age=0
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/64.0.3282.140 Safari/537.36 Edge/17.17134
Accept-Language: en-US,en;q=0.7,ja;q=0.3
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Upgrade-Insecure-Requests: 1
Cookie: _gid=GA1.2.807109645.1545180217; _ga=GA1.2.1029774821.1545010414; __cfduid=d7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408; _gat_gtag_UA_109131120_1=1
Cf-Connecting-Ip: 108.4.108.102
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 458

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

Labels: decksite

vorpal-buildbot commented 5 years ago

Exceeded slow_query limit (1875.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
)```

[1545183669.8444083, 1769, 3, 'https://pennydreadfulmagic.com/competitions/736/', '["karnonthebcob", 736, "1545183668"]', 'Herioc', 736, None, None, None, None, None, None, None] (slow_query, 1875.0, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'_gid': 'GA1.2.807109645.1545180217', '_ga': 'GA1.2.1029774821.1545010414', '__cfduid': 'd7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408', '_gat_gtag_UA_109131120_1': '1'}
            Endpoint: add_signup
            View Args: {}
            Person: logged_out
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'karnonthebcob', 'name': 'Herioc', 'decklist': "4 Battlewise Hoplite\r\n4 Favored Hoplite\r\n2 Fabled Hero\r\n2 Wingsteed Rider\r\n2 Triton Fortune Hunter\r\n2 Indestructibility\r\n2 Curiosity\r\n1 Eel Umbra\r\n2 Spectra Ward\r\n3 On Serra's Wings\r\n2 Defiant Strike\r\n4 Gods Willing\r\n3 Sheltering Light\r\n3 Aqueous Form\r\n3 Mystic Monastery\r\n10 Plains\r\n3 Evolving Wilds\r\n8 Island\r\n\r\n3 Demystify\r\n"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 108.4.108.102, 162.158.78.144
Cf-Ray: 48b62a408b03578f-IAD
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Referer: https://pennydreadfulmagic.com/signup/
Cache-Control: max-age=0
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/64.0.3282.140 Safari/537.36 Edge/17.17134
Accept-Language: en-US,en;q=0.7,ja;q=0.3
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Upgrade-Insecure-Requests: 1
Cookie: _gid=GA1.2.807109645.1545180217; _ga=GA1.2.1029774821.1545010414; __cfduid=d7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408; _gat_gtag_UA_109131120_1=1
Cf-Connecting-Ip: 108.4.108.102
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 458

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

Labels: decksite

vorpal-buildbot commented 5 years ago

Exceeded slow_query limit (1654.2 > 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
)```

[1545183891.3978367, 1769, 3, 'https://pennydreadfulmagic.com/competitions/736/', '["karnonthebcob", 736, "1545183891"]', 'Herioc', 736, None, None, None, None, None, None, None] (slow_query, 1654.2, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'_gid': 'GA1.2.807109645.1545180217', '_ga': 'GA1.2.1029774821.1545010414', '__cfduid': 'd7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408', 'cf_use_ob': '0'}
            Endpoint: add_signup
            View Args: {}
            Person: logged_out
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'karnonthebcob', 'name': 'Herioc', 'decklist': "4 Battlewise Hoplite\r\n4 Favored Hoplite\r\n2 Fabled Hero\r\n2 Wingsteed Rider\r\n2 Triton Fortune Hunter\r\n2 Indestructibility\r\n2 Curiosity\r\n1 Eel Umbra\r\n2 Spectra Ward\r\n3 On Serra's Wings\r\n2 Defiant Strike\r\n4 Gods Willing\r\n3 Sheltering Light\r\n3 Aqueous Form\r\n3 Mystic Monastery\r\n10 Plains\r\n3 Evolving Wilds\r\n8 Island\r\n\r\n3 Demystify\r\n"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 108.4.108.102, 162.158.78.144
Cf-Ray: 48b62fb3eb69578f-IAD
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Referer: https://pennydreadfulmagic.com/signup/
Cache-Control: max-age=0
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/64.0.3282.140 Safari/537.36 Edge/17.17134
Accept-Language: en-US,en;q=0.7,ja;q=0.3
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Upgrade-Insecure-Requests: 1
Cookie: _gid=GA1.2.807109645.1545180217; _ga=GA1.2.1029774821.1545010414; __cfduid=d7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408; cf_use_ob=0
Cf-Connecting-Ip: 108.4.108.102
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 458

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

Labels: decksite

vorpal-buildbot commented 5 years ago

Exceeded slow_query limit (1567.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
)```

[1545183976.9779882, 1769, 3, 'https://pennydreadfulmagic.com/competitions/736/', '["karnonthebcob", 736, "1545183977"]', 'Herioc', 736, None, None, None, None, None, None, None] (slow_query, 1567.9, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'_gid': 'GA1.2.807109645.1545180217', '_ga': 'GA1.2.1029774821.1545010414', '__cfduid': 'd7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408', 'cf_use_ob': '0'}
            Endpoint: add_signup
            View Args: {}
            Person: logged_out
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'karnonthebcob', 'name': 'Herioc', 'decklist': "4 Battlewise Hoplite\r\n4 Favored Hoplite\r\n2 Fabled Hero\r\n2 Wingsteed Rider\r\n2 Triton Fortune Hunter\r\n2 Indestructibility\r\n2 Curiosity\r\n1 Eel Umbra\r\n2 Spectra Ward\r\n3 On Serra's Wings\r\n2 Defiant Strike\r\n4 Gods Willing\r\n3 Sheltering Light\r\n3 Aqueous Form\r\n3 Mystic Monastery\r\n10 Plains\r\n3 Evolving Wilds\r\n8 Island\r\n\r\n3 Demystify\r\n"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 108.4.108.102, 162.158.78.144
Cf-Ray: 48b631cfbdda578f-IAD
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Referer: https://pennydreadfulmagic.com/signup/
Cache-Control: max-age=0
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/64.0.3282.140 Safari/537.36 Edge/17.17134
Accept-Language: en-US,en;q=0.7,ja;q=0.3
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Upgrade-Insecure-Requests: 1
Cookie: _gid=GA1.2.807109645.1545180217; _ga=GA1.2.1029774821.1545010414; __cfduid=d7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408; cf_use_ob=0
Cf-Connecting-Ip: 108.4.108.102
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 458

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

Labels: decksite

vorpal-buildbot commented 5 years ago

Exceeded slow_query limit (1736.2 > 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
)```

[1545183808.6804242, 1769, 3, 'https://pennydreadfulmagic.com/competitions/736/', '["karnonthebcob", 736, "1545183809"]', 'Herioc', 736, None, None, None, None, None, None, None] (slow_query, 1736.2, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'_gid': 'GA1.2.807109645.1545180217', '_ga': 'GA1.2.1029774821.1545010414', '__cfduid': 'd7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408', 'cf_use_ob': '0'}
            Endpoint: add_signup
            View Args: {}
            Person: logged_out
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'karnonthebcob', 'name': 'Herioc', 'decklist': "4 Battlewise Hoplite\r\n4 Favored Hoplite\r\n2 Fabled Hero\r\n2 Wingsteed Rider\r\n2 Triton Fortune Hunter\r\n2 Indestructibility\r\n2 Curiosity\r\n1 Eel Umbra\r\n2 Spectra Ward\r\n3 On Serra's Wings\r\n2 Defiant Strike\r\n4 Gods Willing\r\n3 Sheltering Light\r\n3 Aqueous Form\r\n3 Mystic Monastery\r\n10 Plains\r\n3 Evolving Wilds\r\n8 Island\r\n\r\n3 Demystify\r\n"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 108.4.108.102, 162.158.78.144
Cf-Ray: 48b62db35b60578f-IAD
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Referer: https://pennydreadfulmagic.com/signup/
Cache-Control: max-age=0
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/64.0.3282.140 Safari/537.36 Edge/17.17134
Accept-Language: en-US,en;q=0.7,ja;q=0.3
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Upgrade-Insecure-Requests: 1
Cookie: _gid=GA1.2.807109645.1545180217; _ga=GA1.2.1029774821.1545010414; __cfduid=d7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408; cf_use_ob=0
Cf-Connecting-Ip: 108.4.108.102
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 458

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

Labels: decksite

vorpal-buildbot commented 5 years ago

Exceeded slow_query limit (1813.5 > 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
)```

[1545183731.9729743, 1769, 3, 'https://pennydreadfulmagic.com/competitions/736/', '["karnonthebcob", 736, "1545183732"]', 'Herioc', 736, None, None, None, None, None, None, None] (slow_query, 1813.5, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'_gid': 'GA1.2.807109645.1545180217', '_ga': 'GA1.2.1029774821.1545010414', '__cfduid': 'd7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408', 'cf_use_ob': '0'}
            Endpoint: add_signup
            View Args: {}
            Person: logged_out
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'karnonthebcob', 'name': 'Herioc', 'decklist': "4 Battlewise Hoplite\r\n4 Favored Hoplite\r\n2 Fabled Hero\r\n2 Wingsteed Rider\r\n2 Triton Fortune Hunter\r\n2 Indestructibility\r\n2 Curiosity\r\n1 Eel Umbra\r\n2 Spectra Ward\r\n3 On Serra's Wings\r\n2 Defiant Strike\r\n4 Gods Willing\r\n3 Sheltering Light\r\n3 Aqueous Form\r\n3 Mystic Monastery\r\n10 Plains\r\n3 Evolving Wilds\r\n8 Island\r\n\r\n3 Demystify\r\n"}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 108.4.108.102, 162.158.78.144
Cf-Ray: 48b62bd21a87578f-IAD
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Referer: https://pennydreadfulmagic.com/signup/
Cache-Control: max-age=0
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/64.0.3282.140 Safari/537.36 Edge/17.17134
Accept-Language: en-US,en;q=0.7,ja;q=0.3
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Upgrade-Insecure-Requests: 1
Cookie: _gid=GA1.2.807109645.1545180217; _ga=GA1.2.1029774821.1545010414; __cfduid=d7adafffc7b5ce7b5b75a1fad4ce0ec6a1545010408; cf_use_ob=0
Cf-Connecting-Ip: 108.4.108.102
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 458

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

Labels: decksite

vorpal-buildbot commented 5 years ago

Exceeded slow_query limit (266.4 > 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
)```

[1547299111.5079625, 3097, 3, 'https://pennydreadfulmagic.com/competitions/756/', '["NASCA", 756, "1547299107"]', 'Tempered Steel', 756, None, None, None, None, None, None, None] (slow_query, 266.4, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'__cfduid': 'df05fcdee203a0d8150f4491a36f946301542818278', '_ga': 'GA1.2.799752258.1542818280', '_gid': 'GA1.2.788110339.1547149134'}
            Endpoint: add_signup
            View Args: {}
            Person: logged_out
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'NASCA', 'name': 'Tempered Steel', 'decklist': '<?xml version="1.0" encoding="utf-8"?>\r\n<Deck xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">\r\n  <NetDeckID>0</NetDeckID>\r\n  <PreconstructedDeckID>0</PreconstructedDeckID>\r\n  <Cards CatID="31819" Quantity="4" Sideboard="false" Name="Court Homunculus" />\r\n  <Cards CatID="59878" Quantity="2" Sideboard="false" Name="Declaration in Stone" />\r\n  <Cards CatID="61879" Quantity="4" Sideboard="false" Name="Toolcraft Exemplar" />\r\n  <Cards CatID="61569" Quantity="4" Sideboard="false" Name="Chief of the Foundry" />\r\n  <Cards CatID="39776" Quantity="4" Sideboard="false" Name="Spined Thopter" />\r\n  <Cards CatID="37965" Quantity="4" Sideboard="false" Name="Glint Hawk Idol" />\r\n  <Cards CatID="61891" Quantity="4" Sideboard="false" Name="Servo Exhibition" />\r\n  <Cards CatID="38103" Quantity="4" Sideboard="false" Name="Tempered Steel" />\r\n  <Cards CatID="62071" Quantity="3" Sideboard="false" Name="Fleetwheel Cruiser" />\r\n  <Cards CatID="62609" Quantity="3" Sideboard="false" Name="Sram\'s Expertise" />\r\n  <Cards CatID="35797" Quantity="3" Sideboard="false" Name="Dread Statuary" />\r\n  <Cards CatID="64138" Quantity="2" Sideboard="false" Name="Watchers of the Dead" />\r\n  <Cards CatID="69347" Quantity="19" Sideboard="false" Name="Plains" />\r\n  <Cards CatID="39930" Quantity="1" Sideboard="true" Name="Marrow Shards" />\r\n  <Cards CatID="65042" Quantity="1" Sideboard="true" Name="Inspiring Cleric" />\r\n  <Cards CatID="26245" Quantity="2" Sideboard="true" Name="Sunlance" />\r\n  <Cards CatID="59878" Quantity="2" Sideboard="true" Name="Declaration in Stone" />\r\n  <Cards CatID="59493" Quantity="2" Sideboard="true" Name="Make a Stand" />\r\n  <Cards CatID="64138" Quantity="2" Sideboard="true" Name="Watchers of the Dead" />\r\n  <Cards CatID="57122" Quantity="3" Sideboard="true" Name="Celestial Purge" />\r\n  <Cards CatID="63395" Quantity="2" Sideboard="true" Name="Sundering Growth" />\r\n</Deck>'}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: JP
X-Forwarded-For: 2403:7800:b481:d400:bc92:5832:a63c:a6e6, 162.158.6.48
Cf-Ray: 497fe8b9afe0ae99-KIX
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 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 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=df05fcdee203a0d8150f4491a36f946301542818278; _ga=GA1.2.799752258.1542818280; _gid=GA1.2.788110339.1547149134
Cf-Connecting-Ip: 2403:7800:b481:d400:bc92:5832:a63c:a6e6
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 2805

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

Labels: decksite

vorpal-buildbot commented 5 years ago

Exceeded slow_query limit (138.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
)```

[1547299238.9425304, 3097, 3, 'https://pennydreadfulmagic.com/competitions/756/', '["NASCA", 756, "1547299238"]', 'Tempered Steel', 756, None, None, None, None, None, None, None] (slow_query, 138.9, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'__cfduid': 'df05fcdee203a0d8150f4491a36f946301542818278', '_ga': 'GA1.2.799752258.1542818280', '_gid': 'GA1.2.788110339.1547149134', '_gat_gtag_UA_109131120_1': '1'}
            Endpoint: add_signup
            View Args: {}
            Person: logged_out
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'NASCA', 'name': 'Tempered Steel', 'decklist': '<?xml version="1.0" encoding="utf-8"?>\r\n<Deck xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">\r\n  <NetDeckID>0</NetDeckID>\r\n  <PreconstructedDeckID>0</PreconstructedDeckID>\r\n  <Cards CatID="31819" Quantity="4" Sideboard="false" Name="Court Homunculus" />\r\n  <Cards CatID="59878" Quantity="2" Sideboard="false" Name="Declaration in Stone" />\r\n  <Cards CatID="61879" Quantity="4" Sideboard="false" Name="Toolcraft Exemplar" />\r\n  <Cards CatID="61569" Quantity="4" Sideboard="false" Name="Chief of the Foundry" />\r\n  <Cards CatID="39776" Quantity="4" Sideboard="false" Name="Spined Thopter" />\r\n  <Cards CatID="37965" Quantity="4" Sideboard="false" Name="Glint Hawk Idol" />\r\n  <Cards CatID="61891" Quantity="4" Sideboard="false" Name="Servo Exhibition" />\r\n  <Cards CatID="38103" Quantity="4" Sideboard="false" Name="Tempered Steel" />\r\n  <Cards CatID="62071" Quantity="3" Sideboard="false" Name="Fleetwheel Cruiser" />\r\n  <Cards CatID="62609" Quantity="3" Sideboard="false" Name="Sram\'s Expertise" />\r\n  <Cards CatID="35797" Quantity="3" Sideboard="false" Name="Dread Statuary" />\r\n  <Cards CatID="64138" Quantity="2" Sideboard="false" Name="Watchers of the Dead" />\r\n  <Cards CatID="69347" Quantity="19" Sideboard="false" Name="Plains" />\r\n  <Cards CatID="39930" Quantity="1" Sideboard="true" Name="Marrow Shards" />\r\n  <Cards CatID="65042" Quantity="1" Sideboard="true" Name="Inspiring Cleric" />\r\n  <Cards CatID="26245" Quantity="2" Sideboard="true" Name="Sunlance" />\r\n  <Cards CatID="59878" Quantity="2" Sideboard="true" Name="Declaration in Stone" />\r\n  <Cards CatID="59493" Quantity="2" Sideboard="true" Name="Make a Stand" />\r\n  <Cards CatID="64138" Quantity="2" Sideboard="true" Name="Watchers of the Dead" />\r\n  <Cards CatID="57122" Quantity="3" Sideboard="true" Name="Celestial Purge" />\r\n  <Cards CatID="63395" Quantity="2" Sideboard="true" Name="Sundering Growth" />\r\n</Deck>'}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: JP
X-Forwarded-For: 2403:7800:b481:d400:bc92:5832:a63c:a6e6, 162.158.6.48
Cf-Ray: 497febedac93ae99-KIX
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 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 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=df05fcdee203a0d8150f4491a36f946301542818278; _ga=GA1.2.799752258.1542818280; _gid=GA1.2.788110339.1547149134; _gat_gtag_UA_109131120_1=1
Cf-Connecting-Ip: 2403:7800:b481:d400:bc92:5832:a63c:a6e6
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 2805

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

Labels: decksite

vorpal-buildbot commented 5 years ago

Exceeded slow_query limit (588.7 > 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
)```

[1547742532.579286, 2530, 3, 'https://pennydreadfulmagic.com/competitions/756/', '["ambienceinvoker", 756, "1547742532"]', 'Reddish', 756, None, None, None, None, None, None, None] (slow_query, 588.7, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'__cfduid': 'd1d7e6f7824eaffc5bc73eb493e8483981547151850', '_ga': 'GA1.2.783013179.1547151852', '_gid': 'GA1.2.116284842.1547663867', 'deck_id': '31256', 'session': '.eJx9kdtqwzAMht_F12HYOba9a2kLPW6DMcbGCG6sJG5ju9hOD5S--5RC14vBLiX9-iV9upB8D1ZxDdqTgbctBIQLJTUZlLxxGAlQUhnxiKUrjBW5xBRhSRr2wl6U0jDusX7GQhKQfyo6r1rZiPukxlQViG4DZ_TNMUwiGhDlK5O3DqzmCtCMq40EXYDUB7MDi06Gt74Oc-e57wT1QlMb08PxyJizIoaDHY_CYVaOWXmuH3qP7XjahfCiAOfuMfkQq-28_iiH46lX3p3epsto1U6WId3Jd4n9cNpLCy7nSIklcZYlacbiJ0rTlNH-o96BS2nco3iFhRJT9e-QzeT1eSuG65fPQs3W-2TGFqmZT0S0NsrscAiC3eM1X0gQ3yHLM-ZuvBz5DsjNJvfnTkJGwC2CuAbkDzzPbQW4pm6b5voDP2-a8A.DyI-fQ.zfEmmVszSrHw6Y6X05EPRcPbWrs'}
            Endpoint: add_signup
            View Args: {}
            Person: 156282836024819712
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'ambienceinvoker', 'name': 'Reddish', 'decklist': '2 Blighted Gorge\r\n1 Brimstone Volley\r\n3 Browbeat\r\n3 Chain of Plasma\r\n4 Falkenrath Gorger\r\n2 Goldnight Castigator\r\n2 Implement of Combustion\r\n3 Incendiary Flow\r\n1 Keldon Necropolis\r\n17 Mountain\r\n4 Perilous Myr\r\n4 Quest for Pure Flame\r\n4 Scourge Wolf\r\n4 Sin Prodder\r\n2 Staggershock\r\n4 Village Messenger\r\n\r\nSideboard:\r\n4 Blood Knight\r\n3 Brimstone Volley\r\n4 Granulate\r\n4 Skullscorch'}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 96.31.208.171, 172.69.69.234
Cf-Ray: 49aa3287cb2ac81c-DFW
X-Forwarded-Proto: https
Cf-Visitor: {"scheme":"https"}
Cache-Control: max-age=0
Upgrade-Insecure-Requests: 1
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 OPR/57.0.3098.116
Origin: https://pennydreadfulmagic.com
Content-Type: application/x-www-form-urlencoded
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: en-US,en;q=0.9
Cookie: __cfduid=d1d7e6f7824eaffc5bc73eb493e8483981547151850; _ga=GA1.2.783013179.1547151852; _gid=GA1.2.116284842.1547663867; deck_id=31256; session=.eJx9kdtqwzAMht_F12HYOba9a2kLPW6DMcbGCG6sJG5ju9hOD5S--5RC14vBLiX9-iV9upB8D1ZxDdqTgbctBIQLJTUZlLxxGAlQUhnxiKUrjBW5xBRhSRr2wl6U0jDusX7GQhKQfyo6r1rZiPukxlQViG4DZ_TNMUwiGhDlK5O3DqzmCtCMq40EXYDUB7MDi06Gt74Oc-e57wT1QlMb08PxyJizIoaDHY_CYVaOWXmuH3qP7XjahfCiAOfuMfkQq-28_iiH46lX3p3epsto1U6WId3Jd4n9cNpLCy7nSIklcZYlacbiJ0rTlNH-o96BS2nco3iFhRJT9e-QzeT1eSuG65fPQs3W-2TGFqmZT0S0NsrscAiC3eM1X0gQ3yHLM-ZuvBz5DsjNJvfnTkJGwC2CuAbkDzzPbQW4pm6b5voDP2-a8A.DyI-fQ.zfEmmVszSrHw6Y6X05EPRcPbWrs
Cf-Connecting-Ip: 96.31.208.171
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 516

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

Labels: decksite

vorpal-buildbot commented 5 years ago

Exceeded slow_query limit (522.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
)```

[1547742598.4237723, 2530, 3, 'https://pennydreadfulmagic.com/competitions/756/', '["ambienceinvoker", 756, "1547742598"]', 'Reddish', 756, None, None, None, None, None, None, None] (slow_query, 522.9, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'__cfduid': 'd1d7e6f7824eaffc5bc73eb493e8483981547151850', '_ga': 'GA1.2.783013179.1547151852', '_gid': 'GA1.2.116284842.1547663867', 'deck_id': '31256', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9kdtqwzAMht_F12HYOba9a2kLPW6DMcbGCG6sJG5ju9hOD5S--5RC14vBLiX9-iV9upB8D1ZxDdqTgbctBIQLJTUZlLxxGAlQUhnxiKUrjBW5xBRhSRr2wl6U0jDusX7GQhKQfyo6r1rZiPukxlQViG4DZ_TNMUwiGhDlK5O3DqzmCtCMq40EXYDUB7MDi06Gt74Oc-e57wT1QlMb08PxyJizIoaDHY_CYVaOWXmuH3qP7XjahfCiAOfuMfkQq-28_iiH46lX3p3epsto1U6WId3Jd4n9cNpLCy7nSIklcZYlacbiJ0rTlNH-o96BS2nco3iFhRJT9e-QzeT1eSuG65fPQs3W-2TGFqmZT0S0NsrscAiC3eM1X0gQ3yHLM-ZuvBz5DsjNJvfnTkJGwC2CuAbkDzzPbQW4pm6b5voDP2-a8A.DyI_AQ.-q1vdTTuamX-XNrNLNGHp6RbCRg'}
            Endpoint: add_signup
            View Args: {}
            Person: 156282836024819712
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'ambienceinvoker', 'name': 'Reddish', 'decklist': '2 Blighted Gorge\r\n1 Brimstone Volley\r\n3 Browbeat\r\n3 Chain of Plasma\r\n4 Falkenrath Gorger\r\n2 Goldnight Castigator\r\n2 Implement of Combustion\r\n3 Incendiary Flow\r\n1 Keldon Necropolis\r\n17 Mountain\r\n4 Perilous Myr\r\n4 Quest for Pure Flame\r\n4 Scourge Wolf\r\n4 Sin Prodder\r\n2 Staggershock\r\n4 Village Messenger\r\n\r\nSideboard:\r\n4 Blood Knight\r\n3 Brimstone Volley\r\n4 Granulate\r\n4 Skullscorch'}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 96.31.208.171, 172.69.69.234
Cf-Ray: 49aa3427dd92c81c-DFW
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/70.0.3538.102 Safari/537.36 OPR/57.0.3098.116
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: en-US,en;q=0.9
Cookie: __cfduid=d1d7e6f7824eaffc5bc73eb493e8483981547151850; _ga=GA1.2.783013179.1547151852; _gid=GA1.2.116284842.1547663867; deck_id=31256; _gat_gtag_UA_109131120_1=1; session=.eJx9kdtqwzAMht_F12HYOba9a2kLPW6DMcbGCG6sJG5ju9hOD5S--5RC14vBLiX9-iV9upB8D1ZxDdqTgbctBIQLJTUZlLxxGAlQUhnxiKUrjBW5xBRhSRr2wl6U0jDusX7GQhKQfyo6r1rZiPukxlQViG4DZ_TNMUwiGhDlK5O3DqzmCtCMq40EXYDUB7MDi06Gt74Oc-e57wT1QlMb08PxyJizIoaDHY_CYVaOWXmuH3qP7XjahfCiAOfuMfkQq-28_iiH46lX3p3epsto1U6WId3Jd4n9cNpLCy7nSIklcZYlacbiJ0rTlNH-o96BS2nco3iFhRJT9e-QzeT1eSuG65fPQs3W-2TGFqmZT0S0NsrscAiC3eM1X0gQ3yHLM-ZuvBz5DsjNJvfnTkJGwC2CuAbkDzzPbQW4pm6b5voDP2-a8A.DyI_AQ.-q1vdTTuamX-XNrNLNGHp6RbCRg
Cf-Connecting-Ip: 96.31.208.171
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 516

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

Labels: decksite

vorpal-buildbot commented 5 years ago

Exceeded slow_query limit (720.2 > 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
)```

[1547742401.0910914, 2530, 3, 'https://pennydreadfulmagic.com/competitions/756/', '["ambienceinvoker", 756, "1547742401"]', 'Reddish', 756, None, None, None, None, None, None, None] (slow_query, 720.2, mysql)

Reported on decksite by mysql-perf

            --------------------------------------------------------------------------------
            Request Method: POST
            Path: /signup/?
            Cookies: {'__cfduid': 'd1d7e6f7824eaffc5bc73eb493e8483981547151850', '_ga': 'GA1.2.783013179.1547151852', '_gid': 'GA1.2.116284842.1547663867', 'deck_id': '31256', 'session': '.eJx9kdtqwzAMht_F12HYOba9a2kLPW6DMcbGCG6sJG5ju9hOD5S--5RC14vBLiX9-iV9upB8D1ZxDdqTgbctBIQLJTUZlLxxGAlQUhnxiKUrjBW5xBRhSRr2wl6U0jDusX7GQhKQfyo6r1rZiPukxlQViG4DZ_TNMUwiGhDlK5O3DqzmCtCMq40EXYDUB7MDi06Gt74Oc-e57wT1QlMb08PxyJizIoaDHY_CYVaOWXmuH3qP7XjahfCiAOfuMfkQq-28_iiH46lX3p3epsto1U6WId3Jd4n9cNpLCy7nSIklcZYlacbiJ0rTlNH-o96BS2nco3iFhRJT9e-QzeT1eSuG65fPQs3W-2TGFqmZT0S0NsrscAiC3eM1X0gQ3yHLM-ZuvBz5DsjNJvfnTkJGwC2CuAbkDzzPbQW4pm6b5voDP2-a8A.DyI-Jg.Ga0xtfo_VXY5EC0aM_kX8cM8KWU'}
            Endpoint: add_signup
            View Args: {}
            Person: 156282836024819712
            Referrer: https://pennydreadfulmagic.com/signup/
            Request Data: {'mtgo_username': 'ambienceinvoker', 'name': 'Reddish', 'decklist': '2 Blighted Gorge\r\n1 Brimstone Volley\r\n3 Browbeat\r\n3 Chain of Plasma\r\n4 Falkenrath Gorger\r\n2 Goldnight Castigator\r\n2 Implement of Combustion\r\n3 Incendiary Flow\r\n1 Keldon Necropolis\r\n17 Mountain\r\n4 Perilous Myr\r\n4 Quest for Pure Flame\r\n4 Scourge Wolf\r\n4 Sin Prodder\r\n2 Staggershock\r\n4 Village Messenger\r\n\r\nSideboard:\r\n4 Blood Knight\r\n3 Brimstone Volley\r\n4 Granulate\r\n4 Skullscorch'}
Host: pennydreadfulmagic.com
Accept-Encoding: gzip
Cf-Ipcountry: US
X-Forwarded-For: 96.31.208.171, 172.69.69.216
Cf-Ray: 49aa2f561c82c7e4-DFW
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/70.0.3538.102 Safari/537.36 OPR/57.0.3098.116
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: en-US,en;q=0.9
Cookie: __cfduid=d1d7e6f7824eaffc5bc73eb493e8483981547151850; _ga=GA1.2.783013179.1547151852; _gid=GA1.2.116284842.1547663867; deck_id=31256; session=.eJx9kdtqwzAMht_F12HYOba9a2kLPW6DMcbGCG6sJG5ju9hOD5S--5RC14vBLiX9-iV9upB8D1ZxDdqTgbctBIQLJTUZlLxxGAlQUhnxiKUrjBW5xBRhSRr2wl6U0jDusX7GQhKQfyo6r1rZiPukxlQViG4DZ_TNMUwiGhDlK5O3DqzmCtCMq40EXYDUB7MDi06Gt74Oc-e57wT1QlMb08PxyJizIoaDHY_CYVaOWXmuH3qP7XjahfCiAOfuMfkQq-28_iiH46lX3p3epsto1U6WId3Jd4n9cNpLCy7nSIklcZYlacbiJ0rTlNH-o96BS2nco3iFhRJT9e-QzeT1eSuG65fPQs3W-2TGFqmZT0S0NsrscAiC3eM1X0gQ3yHLM-ZuvBz5DsjNJvfnTkJGwC2CuAbkDzzPbQW4pm6b5voDP2-a8A.DyI-Jg.Ga0xtfo_VXY5EC0aM_kX8cM8KWU
Cf-Connecting-Ip: 96.31.208.171
Cdn-Loop: cloudflare
X-Forwarded-Host: pennydreadfulmagic.com
X-Forwarded-Server: pennydreadfulmagic.com
Connection: Keep-Alive
Content-Length: 516

Location Hash: 69352633394792f239bea225a28b186c8955c8ab

Labels: decksite