Exceeded slow_query limit (44.8 > 30.0) in mysql: ```INSERT INTO deck (

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (44.8 > 30.0) in mysql: ```INSERT INTO deck ( #53481

Closed vorpal-buildbot closed 4 years ago

vorpal-buildbot commented 4 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,
    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
)```

[1589120416.154525, 4251, 3, 'https://pennydreadfulmagic.com/competitions/3191/', '["balduvianbears", 3191, "1589120416"]', 'Nightmare Junk v05', 3191, None, None, None, None, None, None, None, '9d4193fb4814378d31627465446d50d981202f95'] (slow_query, 44.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('__cfduid', 'd8d88ec3ac04bfed066ffaa6f24f66a411586548324'), ('_ga', 'GA1.2.1654273530.1586548330'), ('page_size', '100'), ('_gid', 'GA1.2.241726465.1588798138'), ('deck_id', '75462'), ('session', '.eJx1kdtuwjAMht8l1x1qS9OmuwMJ2IGjgLExTVXapiXQJihJ2QDx7nORoBfT7mL_tn_7yxlFe6ZKKpgw6NGoilmIpiUX6DGjhYYoZSUvZdrEXCdSpRGHFHIIDh3fDR3shCRo2y5GTUUhE1owqGLiYTkH4f8WLqK84kV6W6GQec7SejUtxdXKc7FjodLkMqo0U4KW9eSYFml14FTEjCoNgyStzMaNtKGm1tWpz_ksTI5k-pKp4fNarF4774tyi9u97q6pN3LH4OQzoknCtL7FCG9GT1O5T_rzbq6r01iH4_lo8r0I42DQ_YB-9rPniumIAj0Hk4C0PTvwWy4h2Mak0Wugvu0R27aQYhmkNneTZDcYytUoXQ5oL1uv4443n71NqByXo9PBBxPAuYdrPgEgfBPPjpC74tL3R2srweLLQtehkTnWDagLVJhCFwv9IWmoyhksLaqiuPwCyNuoIQ.XrgNdA.XdaKLzzU_KZe6KYtqMcH3qAxWS4'), ('_gat_gtag_UA_109131120_1', '1')]) Endpoint: add_signup View Args: {} Person: 185916291519873025 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'balduvianbears', 'name': 'Nightmare Junk v05', 'decklist': '\r\n\r\n 0\r\n 0\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 73.4.19.163, 172.68.141.84 Cf-Ray: 59144cc7899be0ca-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/81.0.4044.138 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9,fr;q=0.8 Cookie: __cfduid=d8d88ec3ac04bfed066ffaa6f24f66a411586548324; _ga=GA1.2.1654273530.1586548330; page_size=100; _gid=GA1.2.241726465.1588798138; deck_id=75462; session=.eJx1kdtuwjAMht8l1x1qS9OmuwMJ2IGjgLExTVXapiXQJihJ2QDx7nORoBfT7mL_tn_7yxlFe6ZKKpgw6NGoilmIpiUX6DGjhYYoZSUvZdrEXCdSpRGHFHIIDh3fDR3shCRo2y5GTUUhE1owqGLiYTkH4f8WLqK84kV6W6GQec7SejUtxdXKc7FjodLkMqo0U4KW9eSYFml14FTEjCoNgyStzMaNtKGm1tWpz_ksTI5k-pKp4fNarF4774tyi9u97q6pN3LH4OQzoknCtL7FCG9GT1O5T_rzbq6r01iH4_lo8r0I42DQ_YB-9rPniumIAj0Hk4C0PTvwWy4h2Mak0Wugvu0R27aQYhmkNneTZDcYytUoXQ5oL1uv4443n71NqByXo9PBBxPAuYdrPgEgfBPPjpC74tL3R2srweLLQtehkTnWDagLVJhCFwv9IWmoyhksLaqiuPwCyNuoIQ.XrgNdA.XdaKLzzU_KZe6KYtqMcH3qAxWS4; _gat_gtag_UA_109131120_1=1 Cf-Request-Id: 02a08e50b60000e0ca332bc200000001 Cf-Connecting-Ip: 73.4.19.163 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 4163 Connection: Keep-Alive ```

vorpal-buildbot commented 4 years ago

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

[1589828691.6435544, 4210, 3, 'https://pennydreadfulmagic.com/competitions/3191/', '["arcoverde", 3191, "1589828692"]', 'Reanimator', 3191, None, None, None, None, None, None, None, '551a20918045787f4776022087dbe22f473d9416'] (slow_query, 47.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('__cfduid', 'd451c64d6a02073ed7bffc024fe233e721587341446'), ('_ga', 'GA1.2.334814167.1587341451'), ('_gid', 'GA1.2.1392520910.1589578348'), ('page_size', '20'), ('deck_id', '76659'), ('_gat_gtag_UA_109131120_1', '1'), ('session', '.eJx1UctOwzAQ_BefQ5X3o7cWqU_RVkVtAwhFJtmkKXEcbKcQqv47m0glB8TNszu7Mzu-kKgCwWgJpSJDJWrQCE1YXpJhSguJKAGWM570OJcxF0mUY4lYhuWbjm7aTuA5jme6OukZBY9pAciq1N14i43_R_Iyyuq8SG4WCp5lkLTWJC87Kds0dI0wlfGoliBKytrNVMT8DCIB3MFprY5mJBVVnSh7DA2_mTWz_duhkntvdzwztwmbzYo3s56v-DvgtRdC4xikvGFyyu5H6_J551snPUzkJ1_Pl_Nqki6nqi4WOA9fVS5ARhSDM5xAt2zTCuyBE_iBY5t9v83S1W1fR_8CUiwdf0XS0Y5u2dRb1J7FdjR1Hw5h9TTZjCT7WH2jCCZZ4TUvmB3-UJ42WOuSkr-PwYmjxKtGuqWRatoBMgYqQJCrRv6EqKjIAE2XdVFcfwCva6bD.XsLcQg.gaPilHASRIxkyF3sExeZmUKOnx8')]) Endpoint: add_signup View Args: {} Person: 313825024597557260 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'arcoverde', 'name': 'Reanimator', 'decklist': '\r\n\r\n 0\r\n 0\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 179.186.137.249, 172.68.142.19 Cf-Ray: 5957d8a8efeff73c-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/81.0.4044.138 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7,es;q=0.6,cy;q=0.5 Cookie: __cfduid=d451c64d6a02073ed7bffc024fe233e721587341446; _ga=GA1.2.334814167.1587341451; _gid=GA1.2.1392520910.1589578348; page_size=20; deck_id=76659; _gat_gtag_UA_109131120_1=1; session=.eJx1UctOwzAQ_BefQ5X3o7cWqU_RVkVtAwhFJtmkKXEcbKcQqv47m0glB8TNszu7Mzu-kKgCwWgJpSJDJWrQCE1YXpJhSguJKAGWM570OJcxF0mUY4lYhuWbjm7aTuA5jme6OukZBY9pAciq1N14i43_R_Iyyuq8SG4WCp5lkLTWJC87Kds0dI0wlfGoliBKytrNVMT8DCIB3MFprY5mJBVVnSh7DA2_mTWz_duhkntvdzwztwmbzYo3s56v-DvgtRdC4xikvGFyyu5H6_J551snPUzkJ1_Pl_Nqki6nqi4WOA9fVS5ARhSDM5xAt2zTCuyBE_iBY5t9v83S1W1fR_8CUiwdf0XS0Y5u2dRb1J7FdjR1Hw5h9TTZjCT7WH2jCCZZ4TUvmB3-UJ42WOuSkr-PwYmjxKtGuqWRatoBMgYqQJCrRv6EqKjIAE2XdVFcfwCva6bD.XsLcQg.gaPilHASRIxkyF3sExeZmUKOnx8 Cf-Request-Id: 02cac5bd8e0000f73c8ab02200000001 Cf-Connecting-Ip: 179.186.137.249 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 2315 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1589828704.4146504, 4210, 3, 'https://pennydreadfulmagic.com/competitions/3191/', '["arcoverde", 3191, "1589828704"]', 'Reanimator', 3191, None, None, None, None, None, None, None, '551a20918045787f4776022087dbe22f473d9416'] (slow_query, 34.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('__cfduid', 'd451c64d6a02073ed7bffc024fe233e721587341446'), ('_ga', 'GA1.2.334814167.1587341451'), ('_gid', 'GA1.2.1392520910.1589578348'), ('page_size', '20'), ('deck_id', '76659'), ('session', '.eJx1UctOwzAQ_BefQ5X3o7cWqU_RVkVtAwhFJtmkKXEcbKcQqv47m0glB8TNszu7Mzu-kKgCwWgJpSJDJWrQCE1YXpJhSguJKAGWM570OJcxF0mUY4lYhuWbjm7aTuA5jme6OukZBY9pAciq1N14i43_R_Iyyuq8SG4WCp5lkLTWJC87Kds0dI0wlfGoliBKytrNVMT8DCIB3MFprY5mJBVVnSh7DA2_mTWz_duhkntvdzwztwmbzYo3s56v-DvgtRdC4xikvGFyyu5H6_J551snPUzkJ1_Pl_Nqki6nqi4WOA9fVS5ARhSDM5xAt2zTCuyBE_iBY5t9v83S1W1fR_8CUiwdf0XS0Y5u2dRb1J7FdjR1Hw5h9TTZjCT7WH2jCCZZ4TUvmB3-UJ42WOuSkr-PwYmjxKtGuqWRatoBMgYqQJCrRv6EqKjIAE2XdVFcfwCva6bD.XsLcQg.gaPilHASRIxkyF3sExeZmUKOnx8')]) Endpoint: add_signup View Args: {} Person: 313825024597557260 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'arcoverde', 'name': 'Reanimator', 'decklist': '\r\n\r\n 0\r\n 0\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 179.186.137.249, 172.68.142.19 Cf-Ray: 5957d8f8a82ef73c-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/81.0.4044.138 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7,es;q=0.6,cy;q=0.5 Cookie: __cfduid=d451c64d6a02073ed7bffc024fe233e721587341446; _ga=GA1.2.334814167.1587341451; _gid=GA1.2.1392520910.1589578348; page_size=20; deck_id=76659; session=.eJx1UctOwzAQ_BefQ5X3o7cWqU_RVkVtAwhFJtmkKXEcbKcQqv47m0glB8TNszu7Mzu-kKgCwWgJpSJDJWrQCE1YXpJhSguJKAGWM570OJcxF0mUY4lYhuWbjm7aTuA5jme6OukZBY9pAciq1N14i43_R_Iyyuq8SG4WCp5lkLTWJC87Kds0dI0wlfGoliBKytrNVMT8DCIB3MFprY5mJBVVnSh7DA2_mTWz_duhkntvdzwztwmbzYo3s56v-DvgtRdC4xikvGFyyu5H6_J551snPUzkJ1_Pl_Nqki6nqi4WOA9fVS5ARhSDM5xAt2zTCuyBE_iBY5t9v83S1W1fR_8CUiwdf0XS0Y5u2dRb1J7FdjR1Hw5h9TTZjCT7WH2jCCZZ4TUvmB3-UJ42WOuSkr-PwYmjxKtGuqWRatoBMgYqQJCrRv6EqKjIAE2XdVFcfwCva6bD.XsLcQg.gaPilHASRIxkyF3sExeZmUKOnx8 Cf-Request-Id: 02cac5ef650000f73c8aa8a200000001 Cf-Connecting-Ip: 179.186.137.249 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 2315 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1589829568.0542414, 2683, 3, 'https://pennydreadfulmagic.com/competitions/3191/', '["wizzardofoz", 3191, "1589829568"]', 'Turns', 3191, None, None, None, None, None, None, None, '110f9db8724ccfba0d8c3972c68c264880ca275b'] (slow_query, 45.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('deck_id', '76665'), ('session', '.eJx1kV1vgjAUhv9Lr5kp5UP0boaNZQmZIS7OLQtpaIHKR7EtmWD87zuYqBfL7vqer_ecpyeUdlw1tOWtQUujem4hyhrRomVOaw2K8UY0kt210JlULBUQQo7rBsR3HMf157bteQ5G94paZrTmUMXbh2gFif9bRJsWvajZdYVaFgVn02pathcr4geOhRpTyLTXXLW0mSb_iHGkislcjjBF0t6UJNWGmilZZSRxNmHZqYgFXZnH1Xjc4bVjr5quKu_1RlYc7j0hmmVc66tG8Wt4KMfPeB3F0ZZ5b3If7hOyTcjCj3aP0M-PnVBcpxTQ2d4CEzgGk9k8CPCC2Pf8RNPHboCxhRTPIVTeTJ4_3KEcRb85YP_9JXe1PuahflKMJfUwoQGWHVzzBfTgj0Q-QOzCSt8es70Ei28LXYamZpga0IpTxRU6W-gPRkNVwWHptq_r8y9Iwqbm.XsLfuQ.bP5SAbct_b7GLRJ75WIugGYt1xs'), ('_gid', 'GA1.2.1487811327.1589820731'), ('hide_intro', 'True'), ('_ga', 'GA1.2.915914215.1555618071'), ('__cfduid', 'db96d68d3949c47dc785a6e1c7e15cd161588423425'), ('_gat_gtag_UA_109131120_1', '1'), ('page_size', '20')]) Endpoint: add_signup View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'wizzardofoz', 'name': 'Turns', 'decklist': "4 Arboreal Grazer\r\n4 Evolving Wilds\r\n15 Forest\r\n3 Garruk Wildspeaker\r\n4 Howling Mine\r\n4 Island\r\n4 Karn's Temporal Sundering\r\n1 Kefnet the Mindful\r\n2 Mirari\r\n1 Mystic Sanctuary\r\n2 Primal Command\r\n4 Prophetic Prism\r\n4 Rites of Flourishing\r\n4 Rofellos, Llanowar Emissary\r\n4 Walk the Aeons\r\n\r\nSideboard:\r\n2 Gaea's Revenge\r\n2 Negate\r\n2 Return to Nature\r\n3 Soul-Guide Lantern\r\n3 Tangle\r\n1 Thryx, the Sudden Storm\r\n2 Vexing Shusher"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 89.153.251.176, 172.68.189.111 Cf-Ray: 5957ee0d2f1cda82-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Referer: https://pennydreadfulmagic.com/signup/ Cache-Control: max-age=0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-GB,en-US;q=0.7,en;q=0.3 Content-Type: application/x-www-form-urlencoded 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 Edge/18.18363 Cookie: deck_id=76665; session=.eJx1kV1vgjAUhv9Lr5kp5UP0boaNZQmZIS7OLQtpaIHKR7EtmWD87zuYqBfL7vqer_ecpyeUdlw1tOWtQUujem4hyhrRomVOaw2K8UY0kt210JlULBUQQo7rBsR3HMf157bteQ5G94paZrTmUMXbh2gFif9bRJsWvajZdYVaFgVn02pathcr4geOhRpTyLTXXLW0mSb_iHGkislcjjBF0t6UJNWGmilZZSRxNmHZqYgFXZnH1Xjc4bVjr5quKu_1RlYc7j0hmmVc66tG8Wt4KMfPeB3F0ZZ5b3If7hOyTcjCj3aP0M-PnVBcpxTQ2d4CEzgGk9k8CPCC2Pf8RNPHboCxhRTPIVTeTJ4_3KEcRb85YP_9JXe1PuahflKMJfUwoQGWHVzzBfTgj0Q-QOzCSt8es70Ei28LXYamZpga0IpTxRU6W-gPRkNVwWHptq_r8y9Iwqbm.XsLfuQ.bP5SAbct_b7GLRJ75WIugGYt1xs; _gid=GA1.2.1487811327.1589820731; hide_intro=True; _ga=GA1.2.915914215.1555618071; __cfduid=db96d68d3949c47dc785a6e1c7e15cd161588423425; _gat_gtag_UA_109131120_1=1; page_size=20 Cf-Request-Id: 02cad31c380000da82e832f200000001 Cf-Connecting-Ip: 89.153.251.176 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 572 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1590157317.1928592, 4229, 3, 'https://pennydreadfulmagic.com/competitions/3191/', '["luizpaulo_19", 3191, "1590157317"]', 'Mdt', 3191, None, None, None, None, None, None, None, 'd9402f854170f23fa502d1d2ace4c0f0cbc8c176'] (slow_query, 37.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1001850507.1586723681'), ('__cfduid', 'd4a0ddbcdcd531aac17eb9be372bc4d761589580619'), ('_gid', 'GA1.2.1964725890.1590157275'), ('_gat_gtag_UA_109131120_1', '1'), ('session', '.eJx1UV1PwjAU_S99nmTrPlh5Y0aMGkUXTUBjlma7jMLWLv1AkPDfvSORPRj71HPuOT3t6ZEUHeiWS5CWTKx24BFetUKSyYo3BlEFrWhVNWBhSqWrQiBFEsZCRgPGxv44jWkaBWRQNKrkDaCqs1dZjoP_LUIWtRPNkHLxgiQ9qmuo-psaJc_JEaXMI62tVeEMaMnbXtw48d1x16giYGhT3Nk1LYzltp--ZKxlb4-btMx1J5ZBHN9O4yCaL-5Cnu0GvVVbTJ0cCS9LMOYXE-Fm8HCfls_Jdm02dP-VLZPVUwCzLdh5hH7Yd0KDKThWGcTpOKIhrtE49f2ApsO8bzfxI6Q9omGF1PoScpALsVk6euPyeLrL1_yVhsvptZ_7_uw9wRDstsPXfGCb-GdidUDu3J25bEYbhRGfHjkfWthDbyAZcA2anDzyp0fLdQ14aema5vQD0wOprw.Xsff3w.SPyYghQ4kKP7wl2IekqwVbtz_jI')]) Endpoint: add_signup View Args: {} Person: 699392199707852841 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'luizpaulo_19', 'name': 'Mdt', 'decklist': "3 Anticipate\r\n3 Bad River\r\n1 Cling to Dust\r\n4 Dark Ritual\r\n2 Deep Analysis\r\n4 Dismal Backwater\r\n4 Frantic Search\r\n8 Island\r\n4 Mind's Desire\r\n4 Nightscape Familiar\r\n4 Primal Amulet\r\n4 Scour All Possibilities\r\n4 Shimmer of Possibility\r\n1 Sins of the Past\r\n4 Swamp\r\n2 Tendrils of Agony\r\n4 Turnabout\r\n\r\nSideboard:\r\n2 Cling to Dust\r\n4 Duress\r\n2 Murmuring Mystic\r\n4 Pteramander\r\n3 Winds of Rebuke"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 187.109.146.172, 172.68.142.103 Cf-Ray: 59772fbe6c5ef613-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/81.0.4044.138 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: _ga=GA1.2.1001850507.1586723681; __cfduid=d4a0ddbcdcd531aac17eb9be372bc4d761589580619; _gid=GA1.2.1964725890.1590157275; _gat_gtag_UA_109131120_1=1; session=.eJx1UV1PwjAU_S99nmTrPlh5Y0aMGkUXTUBjlma7jMLWLv1AkPDfvSORPRj71HPuOT3t6ZEUHeiWS5CWTKx24BFetUKSyYo3BlEFrWhVNWBhSqWrQiBFEsZCRgPGxv44jWkaBWRQNKrkDaCqs1dZjoP_LUIWtRPNkHLxgiQ9qmuo-psaJc_JEaXMI62tVeEMaMnbXtw48d1x16giYGhT3Nk1LYzltp--ZKxlb4-btMx1J5ZBHN9O4yCaL-5Cnu0GvVVbTJ0cCS9LMOYXE-Fm8HCfls_Jdm02dP-VLZPVUwCzLdh5hH7Yd0KDKThWGcTpOKIhrtE49f2ApsO8bzfxI6Q9omGF1PoScpALsVk6euPyeLrL1_yVhsvptZ_7_uw9wRDstsPXfGCb-GdidUDu3J25bEYbhRGfHjkfWthDbyAZcA2anDzyp0fLdQ14aema5vQD0wOprw.Xsff3w.SPyYghQ4kKP7wl2IekqwVbtz_jI Cf-Request-Id: 02de5c2b000000f613b8bfd200000001 Cf-Connecting-Ip: 187.109.146.172 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 531 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1590675506.7268567, 2642, 3, 'https://pennydreadfulmagic.com/competitions/3191/', '["fox-zillion", 3191, "1590675507"]', 'wb Cats', 3191, None, None, None, None, None, None, None, '3f67e1c3d3029cdae68eb7f47975d7af5a7f0693'] (slow_query, 44.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.377762734.1531921437'), ('hide_intro', 'True'), ('__cfduid', 'da1feef37f34408b2b974669ee2c686a41563458545'), ('_gid', 'GA1.2.1412268087.1590591555'), ('page_size', '20'), ('session', '.eJx1UdluwjAQ_Bc_pygXweGtkUoPzpZCq1ZVZJJNMHXiyHYQBPHv3SABqqq-eWdnPLuzBxJXoApWQmlI36gaLMLSgpeknzGhsUqh4IVMrzXXiVRpzBEifhA6Xs_pUZu6jk-90CVXhpAJE4CsDUP0fz4v47zmIj37_9YJmeeQtlNqWZ5c3cB3LVKYXMa1BlWyoiVncnfTcCG4LFElWW3WbqwNM20z2K5gN_aGjM7nYVV5d4sZHw-awbwb7Ru48o38Blz9QFiSgNbnmoyePLXKH6qBnJpmdptMXtPJ44sxbPDuLreoh13FFeiYYYpOl_ZoSJ3A7gS90A6da7vNNbB9atsWUZAhtL54bJxkqWaZ2gh7mkJklP08ul8Eo-hjPVy-oQemWuEynxglXotne8ROwenLo7ORaPFlkdOnsdm3AhIBU6DI0SJ_UjRM5YAzl7UQxx-jP6n0.Xs_HCg.Z2aLxVhtv_g5Lqb33Gcua-ZL8SM')]) Endpoint: add_signup View Args: {} Person: 469137178082148392 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'fox-zillion', 'name': 'wb Cats', 'decklist': "4 King of the Pride\r\n2 Linden, the Steadfast Queen\r\n4 Charmed Stray\r\n4 Maned Serval\r\n4 Leonin Skyhunter\r\n4 Cubwarden\r\n3 Mirrorweave\r\n4 Forsaken Sanctuary\r\n15 Plains\r\n3 Honor of the Pure\r\n4 Ajani's Pridemate\r\n3 Twilight Panther\r\n2 Necropanther\r\n4 Scoured Barrens\r\n\r\n2 Orim's Chant\r\n3 Soul-Guide Lantern\r\n2 Celestial Purge\r\n3 Deafening Silence\r\n3 Vindicate\r\n2 Sunlance\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: JP X-Forwarded-For: 126.81.45.161, 172.68.142.103 Cf-Ray: 59a89ada9ed5af27-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/83.0.4103.61 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: ja,en-US;q=0.9,en;q=0.8 Cookie: _ga=GA1.2.377762734.1531921437; hide_intro=True; __cfduid=da1feef37f34408b2b974669ee2c686a41563458545; _gid=GA1.2.1412268087.1590591555; page_size=20; session=.eJx1UdluwjAQ_Bc_pygXweGtkUoPzpZCq1ZVZJJNMHXiyHYQBPHv3SABqqq-eWdnPLuzBxJXoApWQmlI36gaLMLSgpeknzGhsUqh4IVMrzXXiVRpzBEifhA6Xs_pUZu6jk-90CVXhpAJE4CsDUP0fz4v47zmIj37_9YJmeeQtlNqWZ5c3cB3LVKYXMa1BlWyoiVncnfTcCG4LFElWW3WbqwNM20z2K5gN_aGjM7nYVV5d4sZHw-awbwb7Ru48o38Blz9QFiSgNbnmoyePLXKH6qBnJpmdptMXtPJ44sxbPDuLreoh13FFeiYYYpOl_ZoSJ3A7gS90A6da7vNNbB9atsWUZAhtL54bJxkqWaZ2gh7mkJklP08ul8Eo-hjPVy-oQemWuEynxglXotne8ROwenLo7ORaPFlkdOnsdm3AhIBU6DI0SJ_UjRM5YAzl7UQxx-jP6n0.Xs_HCg.Z2aLxVhtv_g5Lqb33Gcua-ZL8SM Cf-Request-Id: 02fd3f1c9d0000af27cd96e200000001 Cf-Connecting-Ip: 126.81.45.161 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 506 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1591453294.129827, 4120, 3, 'https://pennydreadfulmagic.com/competitions/3227/', '["dr_jimathy", 3227, "1591453294"]', 'Samurai!', 3227, None, None, None, None, None, None, None, '5b31d989392b120304e3a3f51be52ef152d8f59d'] (slow_query, 41.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('page_size', '20'), ('deck_id', '78447'), ('session', '.eJx1UV1PwkAQ_C_3jKSlX1feRMUEiPJh0cSY5tJu24PeHbm7Kkj4725JoCbGt5vdmZvd2SNJd6AFkyAtGVrdQI-wXHBJhgWrDaIcBBcq7zA3mdJ5yrFEwtilnjNwaBz7kUfdKCQdo1YZqwFZIG-SFTb-l3CZlg2v88sIv6SkRWUJeTuoUfJs7LsDp0eELVXaGNCSiZac63TDBbPVAUWKNbYapMYy2_YSpg_Pq3JpRtPKWc-Tz8n4bbb-2mv3waVxx7dqi57DI2FZBsZcMNkqoIP1_fK2WlT1SzEv7srpNpy9qiife2PUw37HNZiUYY5uQGngxtSL-57vB0Hgd_022tDxqYMLaCiwVF1NQpFF34kMaBF40ZOG9aPTwILJiWnmsUATDHaH27xjlHgwXrSLnoMz10d_o9Dio0fOn6b20ArICJgGTU498idFy3QJOLRs6vr0A_b4qgo.XtumUA.b8g4mNJLP8SP3ebtA4XvNRUBMv8'), ('_gid', 'GA1.2.84235675.1590786777'), ('_gat_gtag_UA_109131120_1', '1'), ('hide_intro', 'True'), ('_ga', 'GA1.2.949334596.1585581640'), ('__cfduid', 'd7689c6eacecdd9b14595d0a7f8b8a7241590786769')]) Endpoint: add_signup View Args: {} Person: 691830208994738176 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'dr_jimathy', 'name': 'Samurai!', 'decklist': "2 Blackblade Reforged\r\n4 Brothers Yamazaki\r\n1 Evolving Wilds\r\n2 Forebear's Blade\r\n1 Forgotten Cave\r\n2 Fumiko the Lowblood\r\n2 Iizuka the Ruthless\r\n3 Kentaro, the Smiling Cat\r\n2 Konda, Lord of Eiganjo\r\n2 Kor Outfitter\r\n2 Loxodon Warhammer\r\n3 Mentor of the Meek\r\n7 Mountain\r\n1 Oathkeeper, Takeno's Daisho\r\n2 Opal-Eye, Konda's Yojimbo\r\n10 Plains\r\n1 Secluded Steppe\r\n2 Sensei Golden-Tail\r\n2 Tajic, Blade of the Legion\r\n2 Takeno, Samurai General\r\n1 Teshar, Ancestor's Apostle\r\n2 Urza's Ruinous Blast\r\n4 Wind-Scarred Crag\r\n\r\n2 Angel's Feather\r\n3 Banishing Light\r\n2 Daybreak Chimera\r\n2 Dragon's Claw\r\n3 Soul-Guide Lantern\r\n3 Stabilizer\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: CA X-Forwarded-For: 65.92.207.22, 172.68.133.4 Cf-Ray: 59f2c7ce3e6a9f09-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Referer: https://pennydreadfulmagic.com/signup/ Cache-Control: max-age=0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-US,en;q=0.5 Content-Type: application/x-www-form-urlencoded 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 Edge/18.18363 Cookie: page_size=20; deck_id=78447; session=.eJx1UV1PwkAQ_C_3jKSlX1feRMUEiPJh0cSY5tJu24PeHbm7Kkj4725JoCbGt5vdmZvd2SNJd6AFkyAtGVrdQI-wXHBJhgWrDaIcBBcq7zA3mdJ5yrFEwtilnjNwaBz7kUfdKCQdo1YZqwFZIG-SFTb-l3CZlg2v88sIv6SkRWUJeTuoUfJs7LsDp0eELVXaGNCSiZac63TDBbPVAUWKNbYapMYy2_YSpg_Pq3JpRtPKWc-Tz8n4bbb-2mv3waVxx7dqi57DI2FZBsZcMNkqoIP1_fK2WlT1SzEv7srpNpy9qiife2PUw37HNZiUYY5uQGngxtSL-57vB0Hgd_022tDxqYMLaCiwVF1NQpFF34kMaBF40ZOG9aPTwILJiWnmsUATDHaH27xjlHgwXrSLnoMz10d_o9Dio0fOn6b20ArICJgGTU498idFy3QJOLRs6vr0A_b4qgo.XtumUA.b8g4mNJLP8SP3ebtA4XvNRUBMv8; _gid=GA1.2.84235675.1590786777; _gat_gtag_UA_109131120_1=1; hide_intro=True; _ga=GA1.2.949334596.1585581640; __cfduid=d7689c6eacecdd9b14595d0a7f8b8a7241590786769 Cf-Request-Id: 032b9b34de00009f091110f200000001 Cf-Connecting-Ip: 65.92.207.22 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 827 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1591626032.446547, 4442, 3, 'https://pennydreadfulmagic.com/competitions/3227/', '["notgood", 3227, "1591626032"]', 'Hive Post', 3227, None, None, None, None, None, None, None, 'f700f937283b0bbe4666a5329828a51c8e1152f8'] (slow_query, 30.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1083870108.1575770293'), ('__cfduid', 'd0867a36100614453b4ac397358261d821589891994'), ('hide_intro', 'True'), ('_gid', 'GA1.2.808884028.1590445207'), ('session', '.eJx1UV1PgzAU_S99xoWPUmBv4rKQLGhQTHTGkA46hoMW2jLZlv13L0scD8a3nnM_zrmnZ5S1TDaUM67RXMueGYgWTcXRfEtrBahgTdWIYsKVyoUssgoo5Pi24zoBwZ7nWJgQ20VTRy1yWjPoYvzu9QUK_49UPCv7qp5UalGWrBi9KcGvWhhj20CNLkXWKyY5bcbVXAAB7gwkaK93dqY01WMhT8JlvknXzw_4GCff0bH1ki7q9lG41Jt-6tdiz-DYM6J5zpT6xeiwoiEZujSx1zVdDHEaPvpPWliDjuLQg3k2tJVkKqOQm-UGlkMCYnszB7umS6bymCQxsW-aBpJsC9TuptH67313f-JmussPZpsG3mL1tvRDE594_AYakGMLx3xAcvA_1fYI3DUndXvMvgRIfBroujTTx3EAhYxKJtHFQH8S1FSWDDzzvq4vP5qWpRA.Xt5JHA.jW3VIRMlzUYKPs3UyJNY5tOidjk'), ('page_size', '20'), ('deck_id', '78877'), ('_gat_gtag_UA_109131120_1', '1')]) Endpoint: add_signup View Args: {} Person: 382353964773146625 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'notgood', 'name': 'Hive Post', 'decklist': "4 Omen of the Sea\r\n4 Prophetic Prism\r\n4 Fact or Fiction\r\n4 Fumigate\r\n2 Pact of the Titan\r\n2 Syncopate\r\n2 Pull from Tomorrow\r\n4 Intervention Pact\r\n4 Cloudpost\r\n4 Glimmerpost\r\n4 Hive Mind\r\n2 Memory Lapse\r\n4 Tranquil Cove\r\n6 Island\r\n6 Plains\r\n4 Orim's Chant\r\n\r\n4 Teyo, the Shieldmage\r\n3 Deafening Silence\r\n3 Silent Gravestone\r\n3 Flashfreeze\r\n2 Whirlwind Denial\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 68.102.118.78, 172.68.132.241 Cf-Ray: 5a03410cf81eec96-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:77.0) Gecko/20100101 Firefox/77.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 Accept-Language: en-US,en;q=0.5 Content-Type: application/x-www-form-urlencoded Origin: https://pennydreadfulmagic.com Referer: https://pennydreadfulmagic.com/signup/ Upgrade-Insecure-Requests: 1 Cookie: _ga=GA1.2.1083870108.1575770293; __cfduid=d0867a36100614453b4ac397358261d821589891994; hide_intro=True; _gid=GA1.2.808884028.1590445207; session=.eJx1UV1PgzAU_S99xoWPUmBv4rKQLGhQTHTGkA46hoMW2jLZlv13L0scD8a3nnM_zrmnZ5S1TDaUM67RXMueGYgWTcXRfEtrBahgTdWIYsKVyoUssgoo5Pi24zoBwZ7nWJgQ20VTRy1yWjPoYvzu9QUK_49UPCv7qp5UalGWrBi9KcGvWhhj20CNLkXWKyY5bcbVXAAB7gwkaK93dqY01WMhT8JlvknXzw_4GCff0bH1ki7q9lG41Jt-6tdiz-DYM6J5zpT6xeiwoiEZujSx1zVdDHEaPvpPWliDjuLQg3k2tJVkKqOQm-UGlkMCYnszB7umS6bymCQxsW-aBpJsC9TuptH67313f-JmussPZpsG3mL1tvRDE594_AYakGMLx3xAcvA_1fYI3DUndXvMvgRIfBroujTTx3EAhYxKJtHFQH8S1FSWDDzzvq4vP5qWpRA.Xt5JHA.jW3VIRMlzUYKPs3UyJNY5tOidjk; page_size=20; deck_id=78877; _gat_gtag_UA_109131120_1=1 Cf-Request-Id: 0335e6fc1a0000ec96b3309200000001 Cf-Connecting-Ip: 68.102.118.78 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 497 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1591971725.9277713, 4432, 3, 'https://pennydreadfulmagic.com/competitions/3227/', '["fzad", 3227, "1591971726"]', 'Weenie Hammer 3', 3227, None, None, None, None, None, None, None, 'e8379fe9cb5061a197d323b535906f6cb4b345e6'] (slow_query, 37.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('__cfduid', 'd28bdc0b3c4628aec076db7c7e55c179a1590370801'), ('_ga', 'GA1.2.810083055.1590370805'), ('session', '.eJx1UctuwjAQ_BefU5SHcRJuPNOWVi2teEhVFZnEBIfEprZDA4h_7wap5FD15pnd2dkdn1G8Z6qkggmDekZVzEI0LblAvQ0tNKCUlbyUaYu5TqRKYw4U8h3ieCHuujbGxPdsn6C2o5AJLRh0MXE3f4fC_xIu4qziRetSyCxjabObluLqhbHnWqg0mYwrzZSgZTN6c6Ip6CWtzNaNtaGmYfsvfee4XNWvUaSD8fBtggf1yhb-eHuqT49tv5E7BpeeEU0SpvUvRg_uPc4TWwy3eVRF1erw7fN1Ns2L6eLwtQc9q_dcMR1TCM3phg72u07odkKP-CQI2nqTI7FxYNsWUmwD1PZmsl7M3Z1Xk2cvG5GZGM2W4fBplUxIP3eCNZhAinu45gNyg9_hmyNw15T07dHJJVh8Wug6NDbHRoAGjCqm0MVCf_IzVGUMlhZVUVx-AC6mozI.XuOPew.RlQBKKUBiQZwlAls3Ko4apWoS2c'), ('_gid', 'GA1.2.1854388044.1591822980'), ('page_size', '20')]) Endpoint: add_signup View Args: {} Person: 716139452044673076 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'fzad', 'name': 'Weenie Hammer 3', 'decklist': '\r\n\r\n 0\r\n 0\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 71.181.111.147, 172.68.142.31 Cf-Ray: 5a2438d50f190dba-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:77.0) Gecko/20100101 Firefox/77.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 Accept-Language: en-US,en;q=0.5 Content-Type: application/x-www-form-urlencoded Origin: https://pennydreadfulmagic.com Referer: https://pennydreadfulmagic.com/signup/ Upgrade-Insecure-Requests: 1 Cookie: __cfduid=d28bdc0b3c4628aec076db7c7e55c179a1590370801; _ga=GA1.2.810083055.1590370805; session=.eJx1UctuwjAQ_BefU5SHcRJuPNOWVi2teEhVFZnEBIfEprZDA4h_7wap5FD15pnd2dkdn1G8Z6qkggmDekZVzEI0LblAvQ0tNKCUlbyUaYu5TqRKYw4U8h3ieCHuujbGxPdsn6C2o5AJLRh0MXE3f4fC_xIu4qziRetSyCxjabObluLqhbHnWqg0mYwrzZSgZTN6c6Ip6CWtzNaNtaGmYfsvfee4XNWvUaSD8fBtggf1yhb-eHuqT49tv5E7BpeeEU0SpvUvRg_uPc4TWwy3eVRF1erw7fN1Ns2L6eLwtQc9q_dcMR1TCM3phg72u07odkKP-CQI2nqTI7FxYNsWUmwD1PZmsl7M3Z1Xk2cvG5GZGM2W4fBplUxIP3eCNZhAinu45gNyg9_hmyNw15T07dHJJVh8Wug6NDbHRoAGjCqm0MVCf_IzVGUMlhZVUVx-AC6mozI.XuOPew.RlQBKKUBiQZwlAls3Ko4apWoS2c; _gid=GA1.2.1854388044.1591822980; page_size=20 Cf-Request-Id: 034a81d92700000dbad33d8200000001 Cf-Connecting-Ip: 71.181.111.147 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 3134 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1592403705.2328014, 4314, 3, 'https://pennydreadfulmagic.com/competitions/3227/', '["shredmorten", 3227, "1592403705"]', 'Clouds and Tell', 3227, None, None, None, None, None, None, None, 'f631fa17de696f5c731b983a2b6ec28535d75baa'] (slow_query, 45.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1407044299.1588100192'), ('__cfduid', 'd4eeda90be191e8fe15a50e6bab89e3e11590908788'), ('_gid', 'GA1.2.587677611.1592331267'), ('deck_id', '79854'), ('page_size', '20'), ('_gat_gtag_UA_109131120_1', '1'), ('session', '.eJx1UctuwjAQ_BefI-Q8MRxpRCsoAtFWRa2qyMRLCI3tYDs8WvHv3SCVHKrePLOzO7vjb5LVYCRXoBwZOtOAR7iQpSLDDa8sIgGylFp0uLS5NiIrkSIJixPKAkYZ88Mkpv2QdIpK57wCVAmO7P_6UmVFU1adRaWLAkS7mNXqahSFfuQR6QqdNRaM4rKda7cGhNTGgcIxmjduG2TWcdcW9X0d7dTTpv82EaP8oT4sabiC_jGdrYtR2umd_sT24TfheQ7W_mKy3wtau5wtuQwWd8vp8fByDKQ9jZ9l2kyxH051acBmHIPzY8b6MfMHrDcIQxr5XbmNMqERo9QjBjZIbW8esyCdv87X-foUT_OJCVZfbLwKFvvt4zFMJuiBQdZ4zDumhx9Ubs7IXbOyt0dvp9HiwyPXoZk7tw1kBNyAIReP_EnRcVMA7qyaqrr8AO1PpgI.Xuom6w.5QwwF31TJZXKt9j-eRjlUEK2WGI')]) Endpoint: add_signup View Args: {} Person: 685608280881365073 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'shredmorten', 'name': 'Clouds and Tell', 'decklist': '\r\n\r\n 0\r\n 0\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: DK X-Forwarded-For: 188.177.26.29, 172.69.22.208 Cf-Ray: 5a4d6b337cedd88d-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/83.0.4103.106 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: da-DK,da;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: _ga=GA1.2.1407044299.1588100192; __cfduid=d4eeda90be191e8fe15a50e6bab89e3e11590908788; _gid=GA1.2.587677611.1592331267; deck_id=79854; page_size=20; _gat_gtag_UA_109131120_1=1; session=.eJx1UctuwjAQ_BefI-Q8MRxpRCsoAtFWRa2qyMRLCI3tYDs8WvHv3SCVHKrePLOzO7vjb5LVYCRXoBwZOtOAR7iQpSLDDa8sIgGylFp0uLS5NiIrkSIJixPKAkYZ88Mkpv2QdIpK57wCVAmO7P_6UmVFU1adRaWLAkS7mNXqahSFfuQR6QqdNRaM4rKda7cGhNTGgcIxmjduG2TWcdcW9X0d7dTTpv82EaP8oT4sabiC_jGdrYtR2umd_sT24TfheQ7W_mKy3wtau5wtuQwWd8vp8fByDKQ9jZ9l2kyxH051acBmHIPzY8b6MfMHrDcIQxr5XbmNMqERo9QjBjZIbW8esyCdv87X-foUT_OJCVZfbLwKFvvt4zFMJuiBQdZ4zDumhx9Ubs7IXbOyt0dvp9HiwyPXoZk7tw1kBNyAIReP_EnRcVMA7qyaqrr8AO1PpgI.Xuom6w.5QwwF31TJZXKt9j-eRjlUEK2WGI Cf-Request-Id: 036441542d0000d88db11f0200000001 Cf-Connecting-Ip: 188.177.26.29 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 2661 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1592490049.0041687, 3903, 3, 'https://pennydreadfulmagic.com/competitions/3227/', '["kronosoma87", 3227, "1592490049"]', 'Mono Black Control 2', 3227, None, None, None, None, None, None, None, '98e9295ef530bdb50b5596de8994793ed3e929ec'] (slow_query, 31.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.837180075.1575643247'), ('hide_intro', 'True'), ('page_size', '100'), ('__cfduid', 'd6cbded42400aade41c511d3e73de1b321591498547'), ('_gid', 'GA1.2.1522220285.1592310616'), ('deck_id', '79786'), ('_gat_gtag_UA_109131120_1', '1'), ('session', '.eJx1UVFvwiAY_C88N0tbaIu-bdkeuhh1ma7RZWlYwUotoECnxvjf99VEfVj2xt13x30cJ1RuhVVMC-3R0NtOBIhxJTUarljrAHGhpDL8jqWrjOWlBArFOM1IikOKaUriOKME3RWtqVgrQCU9sP_rpS7rTrb8mn_zcYZ6VNeC91s6oy-peBDiAClfm7JzwmqmevHGGm2cUYxm4DKs8-u4dJ75fphPZsdptC_mi31B8jDXb4vsvV7wZi7VwN_13mwEPP2EWFUJ564YLT_UeKLykXkeY75rlu1s1xSvxW5zWIx-xuAXh620wpUMWowSmmKSRSR5SJJ4kCbkPu-LTUNCwzBAVqyAWt9CjtNGkvDxJWloRKm3czbHisdJMV5-QzsBglq38JpP6BK-S66OwF2ac7fDQ2Mg4itAl0tLf-wN6EkwKyw6B-hPjZ7ZWsDSumvb8y85iKny.Xut4JA.RberOWO9hm07o3nVHlumflnnT8g')]) Endpoint: add_signup View Args: {} Person: 236746308386422784 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'kronosoma87', 'name': 'Mono Black Control 2', 'decklist': "4 Vampire Nighthawk\r\n4 Desecration Demon\r\n2 Oona, Queen of the Fae\r\n2 Cling to Dust\r\n4 Defile\r\n4 Agonizing Remorse\r\n3 Grasp of Darkness\r\n4 Mesmeric Fiend\r\n4 Pharika's Libation\r\n3 Underworld Connections\r\n20 Swamp\r\n2 Urza's Factory\r\n2 Witch's Cottage\r\n2 Duress\r\n\r\n2 Duress\r\n4 Soul-Guide Lantern\r\n4 Memoricide\r\n3 Mutilate\r\n2 Thought Distortion\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: MO X-Forwarded-For: 149.102.104.115, 172.68.132.251 Cf-Ray: 5a55a733eddb197f-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/83.0.4103.106 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9,it-IT;q=0.8,it;q=0.7 Cookie: _ga=GA1.2.837180075.1575643247; hide_intro=True; page_size=100; __cfduid=d6cbded42400aade41c511d3e73de1b321591498547; _gid=GA1.2.1522220285.1592310616; deck_id=79786; _gat_gtag_UA_109131120_1=1; session=.eJx1UVFvwiAY_C88N0tbaIu-bdkeuhh1ma7RZWlYwUotoECnxvjf99VEfVj2xt13x30cJ1RuhVVMC-3R0NtOBIhxJTUarljrAHGhpDL8jqWrjOWlBArFOM1IikOKaUriOKME3RWtqVgrQCU9sP_rpS7rTrb8mn_zcYZ6VNeC91s6oy-peBDiAClfm7JzwmqmevHGGm2cUYxm4DKs8-u4dJ75fphPZsdptC_mi31B8jDXb4vsvV7wZi7VwN_13mwEPP2EWFUJ564YLT_UeKLykXkeY75rlu1s1xSvxW5zWIx-xuAXh620wpUMWowSmmKSRSR5SJJ4kCbkPu-LTUNCwzBAVqyAWt9CjtNGkvDxJWloRKm3czbHisdJMV5-QzsBglq38JpP6BK-S66OwF2ac7fDQ2Mg4itAl0tLf-wN6EkwKyw6B-hPjZ7ZWsDSumvb8y85iKny.Xut4JA.RberOWO9hm07o3nVHlumflnnT8g Cf-Request-Id: 036966d4740000197fda9ad200000001 Cf-Connecting-Ip: 149.102.104.115 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 491 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1592490038.3346696, 3903, 3, 'https://pennydreadfulmagic.com/competitions/3227/', '["kronosoma87", 3227, "1592490038"]', 'Mono Black Control', 3227, None, None, None, None, None, None, None, '98e9295ef530bdb50b5596de8994793ed3e929ec'] (slow_query, 41.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.837180075.1575643247'), ('hide_intro', 'True'), ('page_size', '100'), ('__cfduid', 'd6cbded42400aade41c511d3e73de1b321591498547'), ('_gid', 'GA1.2.1522220285.1592310616'), ('deck_id', '79786'), ('_gat_gtag_UA_109131120_1', '1'), ('session', '.eJx1UVFvwiAY_C88N0tbaIu-bdkeuhh1ma7RZWlYwUotoECnxvjf99VEfVj2xt13x30cJ1RuhVVMC-3R0NtOBIhxJTUarljrAHGhpDL8jqWrjOWlBArFOM1IikOKaUriOKME3RWtqVgrQCU9sP_rpS7rTrb8mn_zcYZ6VNeC91s6oy-peBDiAClfm7JzwmqmevHGGm2cUYxm4DKs8-u4dJ75fphPZsdptC_mi31B8jDXb4vsvV7wZi7VwN_13mwEPP2EWFUJ564YLT_UeKLykXkeY75rlu1s1xSvxW5zWIx-xuAXh620wpUMWowSmmKSRSR5SJJ4kCbkPu-LTUNCwzBAVqyAWt9CjtNGkvDxJWloRKm3czbHisdJMV5-QzsBglq38JpP6BK-S66OwF2ac7fDQ2Mg4itAl0tLf-wN6EkwKyw6B-hPjZ7ZWsDSumvb8y85iKny.Xut4JA.RberOWO9hm07o3nVHlumflnnT8g')]) Endpoint: add_signup View Args: {} Person: 236746308386422784 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'kronosoma87', 'name': 'Mono Black Control', 'decklist': "4 Vampire Nighthawk\r\n4 Desecration Demon\r\n2 Oona, Queen of the Fae\r\n2 Cling to Dust\r\n4 Defile\r\n4 Agonizing Remorse\r\n3 Grasp of Darkness\r\n4 Mesmeric Fiend\r\n4 Pharika's Libation\r\n3 Underworld Connections\r\n20 Swamp\r\n2 Urza's Factory\r\n2 Witch's Cottage\r\n2 Duress\r\n\r\n2 Duress\r\n4 Soul-Guide Lantern\r\n4 Memoricide\r\n3 Mutilate\r\n2 Thought Distortion\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: MO X-Forwarded-For: 149.102.104.115, 172.68.132.251 Cf-Ray: 5a55a6f10a37197f-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/83.0.4103.106 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9,it-IT;q=0.8,it;q=0.7 Cookie: _ga=GA1.2.837180075.1575643247; hide_intro=True; page_size=100; __cfduid=d6cbded42400aade41c511d3e73de1b321591498547; _gid=GA1.2.1522220285.1592310616; deck_id=79786; _gat_gtag_UA_109131120_1=1; session=.eJx1UVFvwiAY_C88N0tbaIu-bdkeuhh1ma7RZWlYwUotoECnxvjf99VEfVj2xt13x30cJ1RuhVVMC-3R0NtOBIhxJTUarljrAHGhpDL8jqWrjOWlBArFOM1IikOKaUriOKME3RWtqVgrQCU9sP_rpS7rTrb8mn_zcYZ6VNeC91s6oy-peBDiAClfm7JzwmqmevHGGm2cUYxm4DKs8-u4dJ75fphPZsdptC_mi31B8jDXb4vsvV7wZi7VwN_13mwEPP2EWFUJ564YLT_UeKLykXkeY75rlu1s1xSvxW5zWIx-xuAXh620wpUMWowSmmKSRSR5SJJ4kCbkPu-LTUNCwzBAVqyAWt9CjtNGkvDxJWloRKm3czbHisdJMV5-QzsBglq38JpP6BK-S66OwF2ac7fDQ2Mg4itAl0tLf-wN6EkwKyw6B-hPjZ7ZWsDSumvb8y85iKny.Xut4JA.RberOWO9hm07o3nVHlumflnnT8g Cf-Request-Id: 036966aaa60000197fda9f3200000001 Cf-Connecting-Ip: 149.102.104.115 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 489 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1593181242.2782092, 3121, 3, 'https://pennydreadfulmagic.com/competitions/3227/', '["murpady", 3227, "1593181242"]', 'Mopey Green-Brown', 3227, None, None, None, None, None, None, None, 'f12c2ec2a10f7a79316eb8b0c6eb8808b593e3de'] (slow_query, 49.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('_ga', 'GA1.2.1036860742.1578119328'), ('session', '.eJx1UdtugkAQ_Zd9pmZBFhffaiLphVgvtdE2DVlhQRRY3EsjNf57BxOlSdO3PTPn7Jk5c0JRzWXJKl5pNNTScAuxpMwrNExZoQAlvMxLkXQ4V7GQSZRDCZE-xY47oJ5PMPZdSijqGIWIWcGBxau75QIa_0vyKspMXiTXEX5JUYuyjCftoEpUF-O-7dgWKnUmIqO4rFjZkksja5Y0oBDM6K0TKc102zBNQZ9LMg2X4yDAy4DpoJmkr_hoUxbPO74WezAcnhCLY67UFaOmP_-6Dw9iH_hP62zvbeuxfpHFemMmo5qAnh_rXHIVMQjRJrDbgDg-6Tmu73mka7exetilGFtI8hRK25uHrldmNaWLtwccksfZxllQ-_3bSWe7cH2IwQNCrWGZD4gRjpWn7Z6X0NTt0dsJsPi00OXTSDetAI04k1yis4X-JKiZzDjMXJmiOP8AbeCo8Q.XvYEHQ._2dUzWMBsP1TojS57cwd49174go'), ('_gid', 'GA1.2.1038416644.1590435186'), ('__cfduid', 'd3b8930ee29f6b046e0b8fd937eaa8f311591235730'), ('page_size', '100'), ('deck_id', '80690'), ('_gat_gtag_UA_109131120_1', '1')]) Endpoint: add_signup View Args: {} Person: 538024786950094858 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'murpady', 'name': 'Mopey Green-Brown', 'decklist': '\r\n\r\n 0\r\n 0\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 73.227.39.252, 172.68.132.27 Cf-Ray: 5a979208bb70f039-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:77.0) Gecko/20100101 Firefox/77.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 Accept-Language: en-US,en;q=0.5 Content-Type: application/x-www-form-urlencoded Origin: https://pennydreadfulmagic.com Referer: https://pennydreadfulmagic.com/signup/ Upgrade-Insecure-Requests: 1 Cookie: _ga=GA1.2.1036860742.1578119328; session=.eJx1UdtugkAQ_Zd9pmZBFhffaiLphVgvtdE2DVlhQRRY3EsjNf57BxOlSdO3PTPn7Jk5c0JRzWXJKl5pNNTScAuxpMwrNExZoQAlvMxLkXQ4V7GQSZRDCZE-xY47oJ5PMPZdSijqGIWIWcGBxau75QIa_0vyKspMXiTXEX5JUYuyjCftoEpUF-O-7dgWKnUmIqO4rFjZkksja5Y0oBDM6K0TKc102zBNQZ9LMg2X4yDAy4DpoJmkr_hoUxbPO74WezAcnhCLY67UFaOmP_-6Dw9iH_hP62zvbeuxfpHFemMmo5qAnh_rXHIVMQjRJrDbgDg-6Tmu73mka7exetilGFtI8hRK25uHrldmNaWLtwccksfZxllQ-_3bSWe7cH2IwQNCrWGZD4gRjpWn7Z6X0NTt0dsJsPi00OXTSDetAI04k1yis4X-JKiZzDjMXJmiOP8AbeCo8Q.XvYEHQ._2dUzWMBsP1TojS57cwd49174go; _gid=GA1.2.1038416644.1590435186; __cfduid=d3b8930ee29f6b046e0b8fd937eaa8f311591235730; page_size=100; deck_id=80690; _gat_gtag_UA_109131120_1=1 Cf-Request-Id: 039299996f0000f03905178200000001 Cf-Connecting-Ip: 73.227.39.252 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 2676 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1594045199.4437997, 4536, 3, 'https://pennydreadfulmagic.com/competitions/3227/', '["firespitinkitten", 3227, "1594045199"]', 'ninjas', 3227, None, None, None, None, None, None, None, '7c81881eba9b8a4ec9e6fe1ff36547e30087f63d'] (slow_query, 45.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('__cfduid', 'd233f2652d27e0e00097450e29a03f3a11593923579'), ('_ga', 'GA1.2.68129304.1593923576'), ('_gid', 'GA1.2.452037310.1593923576'), ('deck_id', '81363'), ('page_size', '20'), ('_gat_gtag_UA_109131120_1', '1'), ('session', '.eJx1UVtvgjAU_i99ZqYgN30TdzGZm8vURV0W0sABO6BlbXESs_--g4nysOyt5_S79euJxDWoigkQhoyNasAiLK24IOOMlRqnFCpeybSfuU6kSmOOKxI41A9t2w-C0PED1_Uc0iNKmbASEAXiZr3Ei_8pXMR5w8v0EqGUeQ5pF01LcbZyvaFvkcrkMm40KMGqTjnjCnTNDRcFNwYESknWmL0Ta8NMh5hv1DdqHVhAxUbdl3lRhMNV-3JrgiqKeryRBdLHJ8KSBLS-zER-rVOmVhNnueIPbbQ47ITQYjuF7d1R75APx7oLETPsz_ZGrm9Tl_qDER3Ztuf3912lPnVDSi2iIMPV_moyrWf1mzdJ7XzeLiL2KOjGaWcL_qqf86cjmmChNb7mHSvEj-JZi7tzYfp6GHxKtPiwyFk0Nm1HIBEwBYr8WORPl4apHDC0aMry5xeWdaos.XwMy_g.SwuRlNZmRWsphvRObHt3CM6grXE')]) Endpoint: add_signup View Args: {} Person: 720681167782674452 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'firespitinkitten', 'name': 'ninjas', 'decklist': "4 Changeling Outcast\r\n4 Faerie Seer\r\n2 Hypnotic Sprite\r\n3 Watcher for Tomorrow\r\n2 Man-o'-War\r\n3 Mist-Syndicate Naga\r\n4 Ingenious Infiltrator\r\n2 Tasigur, the Golden Fang\r\n2 Bonesplitter\r\n3 Stern Dismissal\r\n3 Anticipate\r\n3 Mana Leak\r\n4 Memory Lapse\r\n4 Dismal Backwater\r\n10 Island\r\n7 Swamp\r\n\r\n4 Cerulean Drake\r\n1 Hostage Taker\r\n3 Silent Gravestone\r\n3 Marsh Casualties\r\n1 Smother\r\n2 Trickbind\r\n1 Nature's Ruin"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: AU X-Forwarded-For: 112.141.2.33, 172.68.132.251 Cf-Ray: 5ae9f6bebbf7df28-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/83.0.4103.116 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-AU,en-GB;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: __cfduid=d233f2652d27e0e00097450e29a03f3a11593923579; _ga=GA1.2.68129304.1593923576; _gid=GA1.2.452037310.1593923576; deck_id=81363; page_size=20; _gat_gtag_UA_109131120_1=1; session=.eJx1UVtvgjAU_i99ZqYgN30TdzGZm8vURV0W0sABO6BlbXESs_--g4nysOyt5_S79euJxDWoigkQhoyNasAiLK24IOOMlRqnFCpeybSfuU6kSmOOKxI41A9t2w-C0PED1_Uc0iNKmbASEAXiZr3Ei_8pXMR5w8v0EqGUeQ5pF01LcbZyvaFvkcrkMm40KMGqTjnjCnTNDRcFNwYESknWmL0Ta8NMh5hv1DdqHVhAxUbdl3lRhMNV-3JrgiqKeryRBdLHJ8KSBLS-zER-rVOmVhNnueIPbbQ47ITQYjuF7d1R75APx7oLETPsz_ZGrm9Tl_qDER3Ztuf3912lPnVDSi2iIMPV_moyrWf1mzdJ7XzeLiL2KOjGaWcL_qqf86cjmmChNb7mHSvEj-JZi7tzYfp6GHxKtPiwyFk0Nm1HIBEwBYr8WORPl4apHDC0aMry5xeWdaos.XwMy_g.SwuRlNZmRWsphvRObHt3CM6grXE Cf-Request-Id: 03c6188b2f0000df282db52200000001 Cf-Connecting-Ip: 112.141.2.33 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 555 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1595427573.9767857, 4724, 3, 'https://pennydreadfulmagic.com/competitions/3269/', '["criolynxsovereign", 3269, "1595427574"]', 'Thryx Wildfire', 3269, None, None, None, None, None, None, None, '1e415285bd8b3760c0be11dcf88290b829492613'] (slow_query, 49.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('__cfduid', 'de2563c78db5e0f6e2ef527701d683d6f1595361524'), ('_ga', 'GA1.2.1209319266.1595361529'), ('_gid', 'GA1.2.1993578116.1595361529'), ('page_size', '20'), ('session', '.eJx1UctuwjAQ_BefU5SHEwK3Uri0ElAejaqqikyyBBfHDrZDkyL-vRsk4FD15tmd3Zkdn0hagS6ZBGnJ0OoaHMLykksy3DJhEOVQ8lLld8xNpnSeciwRj_o09qPAo54f0n4YU3JnCJUxAcgC-bBeYuP_ES7TouYiv1oQqigg76wZJS9StO9Th5S2UGltQEtWdpszzZVoZWPUETTwQuIuxWq781Njme0oXETxXIxfeThdrNgiMEGymc7eN9P8mPwc7nyr9oBXnwjLMjDmislTk9c64UqvluWqCaxd2KN225UdV22yx3loKq7BpAwD9MJB5AbeIAp6fRoMwvDe7iKNXBq7rkM0bLG0u2l4y9lhPRnpWs2Tt-_lY_Oy1oei3Dw3vpr0UQMDrfCYD4wQP4pvW6xdAjO3R-9LocSnQy5LU9t2A2QETIMmZ4f8ydIyXQB6lrUQ518Ux6st.XxhKtQ.LGljgrRVjwWID6Imv2eUIMA-kEc')]) Endpoint: add_signup View Args: {} Person: 142482631412547584 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'criolynxsovereign', 'name': 'Thryx Wildfire', 'decklist': '\r\n\r\n 0\r\n 0\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: NL X-Forwarded-For: 86.82.131.22, 172.68.132.217 Cf-Ray: 5b6dcc207f85065e-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/84.0.4147.89 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: nl-NL,nl;q=0.9,en-NL;q=0.8,en;q=0.7,en-US;q=0.6 Cookie: __cfduid=de2563c78db5e0f6e2ef527701d683d6f1595361524; _ga=GA1.2.1209319266.1595361529; _gid=GA1.2.1993578116.1595361529; page_size=20; session=.eJx1UctuwjAQ_BefU5SHEwK3Uri0ElAejaqqikyyBBfHDrZDkyL-vRsk4FD15tmd3Zkdn0hagS6ZBGnJ0OoaHMLykksy3DJhEOVQ8lLld8xNpnSeciwRj_o09qPAo54f0n4YU3JnCJUxAcgC-bBeYuP_ES7TouYiv1oQqigg76wZJS9StO9Th5S2UGltQEtWdpszzZVoZWPUETTwQuIuxWq781Njme0oXETxXIxfeThdrNgiMEGymc7eN9P8mPwc7nyr9oBXnwjLMjDmislTk9c64UqvluWqCaxd2KN225UdV22yx3loKq7BpAwD9MJB5AbeIAp6fRoMwvDe7iKNXBq7rkM0bLG0u2l4y9lhPRnpWs2Tt-_lY_Oy1oei3Dw3vpr0UQMDrfCYD4wQP4pvW6xdAjO3R-9LocSnQy5LU9t2A2QETIMmZ4f8ydIyXQB6lrUQ518Ux6st.XxhKtQ.LGljgrRVjwWID6Imv2eUIMA-kEc Cf-Request-Id: 04187de8470000065e6b29f200000001 Cf-Connecting-Ip: 86.82.131.22 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 3809 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1595514007.8017714, 4713, 3, 'https://pennydreadfulmagic.com/competitions/3269/', '["akke", 3269, "1595514008"]', 'Menace Tribal', 3269, None, None, None, None, None, None, None, 'd813f3358e35af839126567e4a970104f880f442'] (slow_query, 45.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('__cfduid', 'd560d44f80612c226883f1ab78bd8b7761595408773'), ('_ga', 'GA1.2.1381509536.1595408779'), ('_gid', 'GA1.2.798343445.1595408779'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '83799'), ('session', '.eJx1UV1vgjAU_S99ZgakIvg2dX6LbixmH1lIpRdkAmVtWeaM_30XE2XJsreec8_puT09krAEmbMCCk16WlZgEMbztCC9mGUKEYc8zQVvcKoiIXmYIkWo69heu2vbjue5pmWZJmkUmYhYBqiC4mbcx8H_lrQIkyrN-GWFX1ZSoyQBXi-qRHEOpl3LNkiuExFWCmTB8lrM9ntAuWCV3rVDpZmuWbGdTadynAR3Q_d50p7nE7GyPvzFxp-V2Wej12KPab0jYVEESl0w8TZ8vWWL24EbLWlQ3U_Wg84y6fNoHtBtgH74KlMJKmTYoNXxHNOina7dchxqU7cZ1506JnVN0yASYqR214zxdFTtVr7_DUNJRy8xOE-DjXjQthXD4wozsNESH_OKHeJPpfEBuXNj6npovQuMeDPI-dJQH2oD6QOTIMnJIH_q00wmgDsXVZadfgDLcaZ7.XxmcVg.nxm8LBgL8My8DskM5pSiGf46EKQ')]) Endpoint: add_signup View Args: {} Person: 486392733699801100 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'akke', 'name': 'Menace Tribal', 'decklist': "3 Dark Ritual\r\n4 Chain Lightning\r\n1 Cut // Ribbons\r\n4 Dragonskull Summit\r\n9 Swamp\r\n8 Mountain\r\n4 Sin Prodder\r\n2 Sonorous Howlbonder\r\n4 Labyrinth Raptor\r\n4 Hunted Nightmare\r\n4 Insolent Neonate\r\n2 Call of the Death-Dweller\r\n2 Piper of the Swarm\r\n2 Sign in Blood\r\n3 Stormblood Berserker\r\n4 Dreadmalkin\r\n\r\n3 Duress\r\n3 Soul-Guide Lantern\r\n2 Pharika's Libation\r\n1 Sweltering Suns\r\n2 Angrath's Rampage\r\n3 Rain of Gore\r\n1 Massacre Girl"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: FI X-Forwarded-For: 2001:999:40:ef3f:1c9e:529a:7e9e:84e0, 172.68.141.180 Cf-Ray: 5b760a540cb2fe34-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/84.0.4147.89 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: fi-FI,fi;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: __cfduid=d560d44f80612c226883f1ab78bd8b7761595408773; _ga=GA1.2.1381509536.1595408779; _gid=GA1.2.798343445.1595408779; hide_intro=True; page_size=20; deck_id=83799; session=.eJx1UV1vgjAU_S99ZgakIvg2dX6LbixmH1lIpRdkAmVtWeaM_30XE2XJsreec8_puT09krAEmbMCCk16WlZgEMbztCC9mGUKEYc8zQVvcKoiIXmYIkWo69heu2vbjue5pmWZJmkUmYhYBqiC4mbcx8H_lrQIkyrN-GWFX1ZSoyQBXi-qRHEOpl3LNkiuExFWCmTB8lrM9ntAuWCV3rVDpZmuWbGdTadynAR3Q_d50p7nE7GyPvzFxp-V2Wej12KPab0jYVEESl0w8TZ8vWWL24EbLWlQ3U_Wg84y6fNoHtBtgH74KlMJKmTYoNXxHNOina7dchxqU7cZ1506JnVN0yASYqR214zxdFTtVr7_DUNJRy8xOE-DjXjQthXD4wozsNESH_OKHeJPpfEBuXNj6npovQuMeDPI-dJQH2oD6QOTIMnJIH_q00wmgDsXVZadfgDLcaZ7.XxmcVg.nxm8LBgL8My8DskM5pSiGf46EKQ Cf-Request-Id: 041da4c8800000fe343ea11200000001 Cf-Connecting-Ip: 2001:999:40:ef3f:1c9e:529a:7e9e:84e0 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 574 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 4 years ago

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

[1595514305.9682555, 4757, 3, 'https://pennydreadfulmagic.com/competitions/3269/', '["jetblast64", 3269, "1595514306"]', 'Coins', 3269, None, None, None, None, None, None, None, '08e84bab303f5b5edd514ca55b76a43ce9912dbb'] (slow_query, 47.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 5d9cbec5364abf85df47cca93e75b36b1e43708a

Request Data

``` Request Method: POST Path: /signup/? Cookies: ImmutableMultiDict([('__cfduid', 'd4b8cf3b27fbc8290acf64c36ed085fea1595386675'), ('_ga', 'GA1.2.1574682213.1595386677'), ('page_size', '20'), ('deck_id', '83689'), ('_gid', 'GA1.2.951778832.1595514091'), ('session', '.eJx1UctuwjAQ_Bef0yoJiUm4UVS15SFRFdKKqoqcZAkmjg22IxEQ_94NEnCoevPszO7sjk8k3YGumQRpycDqBhzCippLMlgzYRAVUPNaFXfMTa50kXIskX4UxkHPc2nohV4U9ym5C4TKmQAUgXxYfiDxbweXadlwUVwXEKosoegWM0pejIJ-2HdIbUuVNga0ZHU3eAs2E8xYGuAQxRq78VNjme24qb9y5SiWYW_VfiUVU5NkVmXjJtqHooG73qoK8NgTYXkOxlwxUfNqvgye8-Tt2I7fX4_efHlIPld7mgzZbIv9cNhxDSZlmJsXxtSltOf6j73I96OQ3vkuSuoGkes6RMMaS5ubSZYtFrOaL7w4G7ovR-NN5qPGK6ZVrMudRhNMcofXfGN2-EF83WLtEpW5PR63Ci1-HHIZmtq2ayBPwDRocnbInxQt0yXg0rIR4vwLa7ilrg.XxmdXA.Uis2eyCXhuhbfnQwt6tqWprMjXA')]) Endpoint: add_signup View Args: {} Person: 78594310651518976 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'jetblast64', 'name': 'Coins', 'decklist': "4 Electrolyze\r\n4 Fiery Gambit\r\n16 Island\r\n4 Krark's Thumb\r\n8 Mountain\r\n4 Power Sink\r\n4 Quench\r\n4 Squee's Revenge\r\n4 Stitch in Time\r\n4 Syncopate\r\n4 Tribute Mage"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 2600:1700:ca00:2d40:2585:cff2:e565:139a, 172.69.22.4 Cf-Ray: 5b76119bef54ecaa-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 Origin: https://pennydreadfulmagic.com 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/84.0.4147.89 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9 Cookie: __cfduid=d4b8cf3b27fbc8290acf64c36ed085fea1595386675; _ga=GA1.2.1574682213.1595386677; page_size=20; deck_id=83689; _gid=GA1.2.951778832.1595514091; session=.eJx1UctuwjAQ_Bef0yoJiUm4UVS15SFRFdKKqoqcZAkmjg22IxEQ_94NEnCoevPszO7sjk8k3YGumQRpycDqBhzCippLMlgzYRAVUPNaFXfMTa50kXIskX4UxkHPc2nohV4U9ym5C4TKmQAUgXxYfiDxbweXadlwUVwXEKosoegWM0pejIJ-2HdIbUuVNga0ZHU3eAs2E8xYGuAQxRq78VNjme24qb9y5SiWYW_VfiUVU5NkVmXjJtqHooG73qoK8NgTYXkOxlwxUfNqvgye8-Tt2I7fX4_efHlIPld7mgzZbIv9cNhxDSZlmJsXxtSltOf6j73I96OQ3vkuSuoGkes6RMMaS5ubSZYtFrOaL7w4G7ovR-NN5qPGK6ZVrMudRhNMcofXfGN2-EF83WLtEpW5PR63Ci1-HHIZmtq2ayBPwDRocnbInxQt0yXg0rIR4vwLa7ilrg.XxmdXA.Uis2eyCXhuhbfnQwt6tqWprMjXA Cf-Request-Id: 041da955720000ecaa03267200000001 Cf-Connecting-Ip: 2600:1700:ca00:2d40:2585:cff2:e565:139a Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 248 Connection: Keep-Alive ```

Labels: decksite