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

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (530.2 > 100.0) in mysql: ```INSERT INTO deck ( #49483

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
)```

[1558362091.1002636, 3111, 3, 'https://pennydreadfulmagic.com/competitions/2186/', '["tp0nt3", 2186, "1558362091"]', 'Mono White Heroic Rage =)', 2186, None, None, None, None, None, None, None] (slow_query, 530.2, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd00d91e86123a20ebfb7fa29eeeb215971546640810', '_ga': 'GA1.2.709864170.1546640816', 'session': '.eJx9kd1ugkAQhd9lrkkDLAh6p_WnaVoTbY22TUNWGAFld3F3UdT47l1IrBdNennOzJ6Z-fYCUYmSUY5cQ0_LCi2gCcs59Da0UEYlyHImkrvOVSxkEuXGAp-Qjmu7IQm8kIReEHTBgn8qPEqrvEhukwqRppg0GyjB20TiOI4FTKciqhRKThmaMF3aXBMTIGilMzdSmurGL-rx9vCJwSTTL_vR_LjoLqb70-I1SwYHt3Pv12KH5qIL0DhGpW4aivdgvJsvn0ZvSGb1cDIdPsaZPK-H_a0_mJn3WJe5RBVRA8fxvdDx_dAhD8RxXd-7lxtcHdsLbdsCiRtjZb8z9Op4Xq66aclwta2f-YyQfibGH-s-q0LbzDA4S3PMl-FmPiHfnIzXUlLwbUEbE-lT0wIDpBIlXC34g0xTmaLZkldFcf0BpBKXbg.D8RIuA.95kQYTPcEk69X1TaDBlxLxJhwzg', '_gid': 'GA1.2.78455097.1558290928', 'deck_id': '50018'} Endpoint: add_signup View Args: {} Person: 533620283748384779 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'tp0nt3', 'name': 'Mono White Heroic Rage =)', 'decklist': "3 Ajani's Presence\r\n4 Akroan Skyguard\r\n4 Cartouche of Solidarity\r\n4 Defiant Strike\r\n4 Emerge Unscathed\r\n3 Fabled Hero\r\n4 Favored Hoplite\r\n4 Gryff's Boon\r\n2 Guided Strike\r\n4 Lagonna-Band Trailblazer\r\n1 Ordeal of Heliod\r\n18 Plains\r\n1 Sandstone Bridge\r\n4 Center soul\r\n\r\n1 Isolate\r\n3 Nevermore\r\n2 Ordeal of Heliod\r\n3 Orim's Chant\r\n3 Purify the Grave\r\n1 Swift Justice\r\n2 Vanguard of Brimaz\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: PT X-Forwarded-For: 128.65.231.246, 162.158.158.129 Cf-Ray: 4d9ef50cc9e2ce87-LHR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:66.0) Gecko/20100101 Firefox/66.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: pt-PT,pt;q=0.8,en;q=0.5,en-US;q=0.3 Referer: https://pennydreadfulmagic.com/signup/ Content-Type: application/x-www-form-urlencoded Upgrade-Insecure-Requests: 1 Cookie: __cfduid=d00d91e86123a20ebfb7fa29eeeb215971546640810; _ga=GA1.2.709864170.1546640816; session=.eJx9kd1ugkAQhd9lrkkDLAh6p_WnaVoTbY22TUNWGAFld3F3UdT47l1IrBdNennOzJ6Z-fYCUYmSUY5cQ0_LCi2gCcs59Da0UEYlyHImkrvOVSxkEuXGAp-Qjmu7IQm8kIReEHTBgn8qPEqrvEhukwqRppg0GyjB20TiOI4FTKciqhRKThmaMF3aXBMTIGilMzdSmurGL-rx9vCJwSTTL_vR_LjoLqb70-I1SwYHt3Pv12KH5qIL0DhGpW4aivdgvJsvn0ZvSGb1cDIdPsaZPK-H_a0_mJn3WJe5RBVRA8fxvdDx_dAhD8RxXd-7lxtcHdsLbdsCiRtjZb8z9Op4Xq66aclwta2f-YyQfibGH-s-q0LbzDA4S3PMl-FmPiHfnIzXUlLwbUEbE-lT0wIDpBIlXC34g0xTmaLZkldFcf0BpBKXbg.D8RIuA.95kQYTPcEk69X1TaDBlxLxJhwzg; _gid=GA1.2.78455097.1558290928; deck_id=50018 Cf-Connecting-Ip: 128.65.231.246 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 545 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

vorpal-buildbot commented 5 years ago

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

[1558535148.419354, 3410, 3, 'https://pennydreadfulmagic.com/competitions/2186/', '["crandar", 2186, "1558535148"]', 'Mardu Dark Dwellers', 2186, None, None, None, None, None, None, None] (slow_query, 537.0, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd7eafe569062cd5510c2325b6581aa7b11557991999', '_ga': 'GA1.2.1258938939.1557991515', 'deck_id': '49725', '_gid': 'GA1.2.1392629148.1558333952', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UV1rwjAU_S95LtKmTT98nFOG4nROt8EYIWvTGNcmJUmlKv733Qrqw2CQh9xzc8859-SEaMNNzRRXDg2dabmHWFFLhYYlqyxUBa9lrYt7LW2uTUElQChI_ASTNCSRn8IhSYI89E9HUdHKqrgqVVoIXvQOrFYXxjAKfA_VTmjaWm4UqzmQ5Yapghlg0Kx1W0ytY65vhPVj12W4IWuDzUKsY7J8H3ci8MsyXM3v753-4bDSCbE859ZeazSfHfcbuS2ne9Gt1OZ1FM3cZMQmz_HyOF7CPO8aabilDNIJCElJFqc4GwQk87Po3u7ziv0o9cG84SVA25uGJCacil3CMF68RB_l21Owippxk3XfeCdBA_JsYJlPCA5-QZYHwC4x2dtlsNMg8eWhCyl1h34APXBmuEFnD_1J0DEjOHhWbVWdfwH_35uB.D8btSw.-OAg1MLqZppVIBEshCp1AlVQtpM'} Endpoint: add_signup View Args: {} Person: 170725835408408577 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'crandar', 'name': 'Mardu Dark Dwellers ', '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'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: GR X-Forwarded-For: 84.254.28.215, 172.68.63.85 Cf-Ray: 4daf76139ad05ceb-ATH 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/74.0.3729.157 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: el-GR,el;q=0.9,en;q=0.8 Cookie: __cfduid=d7eafe569062cd5510c2325b6581aa7b11557991999; _ga=GA1.2.1258938939.1557991515; deck_id=49725; _gid=GA1.2.1392629148.1558333952; _gat_gtag_UA_109131120_1=1; session=.eJx9UV1rwjAU_S95LtKmTT98nFOG4nROt8EYIWvTGNcmJUmlKv733Qrqw2CQh9xzc8859-SEaMNNzRRXDg2dabmHWFFLhYYlqyxUBa9lrYt7LW2uTUElQChI_ASTNCSRn8IhSYI89E9HUdHKqrgqVVoIXvQOrFYXxjAKfA_VTmjaWm4UqzmQ5Yapghlg0Kx1W0ytY65vhPVj12W4IWuDzUKsY7J8H3ci8MsyXM3v753-4bDSCbE859ZeazSfHfcbuS2ne9Gt1OZ1FM3cZMQmz_HyOF7CPO8aabilDNIJCElJFqc4GwQk87Po3u7ziv0o9cG84SVA25uGJCacil3CMF68RB_l21Owippxk3XfeCdBA_JsYJlPCA5-QZYHwC4x2dtlsNMg8eWhCyl1h34APXBmuEFnD_1J0DEjOHhWbVWdfwH_35uB.D8btSw.-OAg1MLqZppVIBEshCp1AlVQtpM Cf-Connecting-Ip: 84.254.28.215 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 3544 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1558535569.5763063, 3410, 3, 'https://pennydreadfulmagic.com/competitions/2186/', '["crandar", 2186, "1558535570"]', 'Mardu Dark Dwellers', 2186, None, None, None, None, None, None, None] (slow_query, 115.8, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd7eafe569062cd5510c2325b6581aa7b11557991999', '_ga': 'GA1.2.1258938939.1557991515', 'deck_id': '49725', '_gid': 'GA1.2.1392629148.1558333952', 'session': '.eJx9UV1rwjAU_S95LtKmTT98nFOG4nROt8EYIWvTGNcmJUmlKv733Qrqw2CQh9xzc8859-SEaMNNzRRXDg2dabmHWFFLhYYlqyxUBa9lrYt7LW2uTUElQChI_ASTNCSRn8IhSYI89E9HUdHKqrgqVVoIXvQOrFYXxjAKfA_VTmjaWm4UqzmQ5Yapghlg0Kx1W0ytY65vhPVj12W4IWuDzUKsY7J8H3ci8MsyXM3v753-4bDSCbE859ZeazSfHfcbuS2ne9Gt1OZ1FM3cZMQmz_HyOF7CPO8aabilDNIJCElJFqc4GwQk87Po3u7ziv0o9cG84SVA25uGJCacil3CMF68RB_l21Owippxk3XfeCdBA_JsYJlPCA5-QZYHwC4x2dtlsNMg8eWhCyl1h34APXBmuEFnD_1J0DEjOHhWbVWdfwH_35uB.D8buoA.ZSrcBH8unDZJQFk6BOcBQkezAes'} Endpoint: add_signup View Args: {} Person: 170725835408408577 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'crandar', 'name': 'Mardu Dark Dwellers ', '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'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: GR X-Forwarded-For: 84.254.28.215, 172.68.62.156 Cf-Ray: 4daf805add1f5caf-ATH X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.157 Safari/537.36 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,application/signed-exchange;v=b3 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: el-GR,el;q=0.9,en;q=0.8 Cookie: __cfduid=d7eafe569062cd5510c2325b6581aa7b11557991999; _ga=GA1.2.1258938939.1557991515; deck_id=49725; _gid=GA1.2.1392629148.1558333952; session=.eJx9UV1rwjAU_S95LtKmTT98nFOG4nROt8EYIWvTGNcmJUmlKv733Qrqw2CQh9xzc8859-SEaMNNzRRXDg2dabmHWFFLhYYlqyxUBa9lrYt7LW2uTUElQChI_ASTNCSRn8IhSYI89E9HUdHKqrgqVVoIXvQOrFYXxjAKfA_VTmjaWm4UqzmQ5Yapghlg0Kx1W0ytY65vhPVj12W4IWuDzUKsY7J8H3ci8MsyXM3v753-4bDSCbE859ZeazSfHfcbuS2ne9Gt1OZ1FM3cZMQmz_HyOF7CPO8aabilDNIJCElJFqc4GwQk87Po3u7ziv0o9cG84SVA25uGJCacil3CMF68RB_l21Owippxk3XfeCdBA_JsYJlPCA5-QZYHwC4x2dtlsNMg8eWhCyl1h34APXBmuEFnD_1J0DEjOHhWbVWdfwH_35uB.D8buoA.ZSrcBH8unDZJQFk6BOcBQkezAes Cf-Connecting-Ip: 84.254.28.215 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 3544 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1559399028.5426033, 1639, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["mtgxman", 2902, "1559399028"]', 'Grade = A-', 2902, None, None, None, None, None, None, None] (slow_query, 532.5, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'session': '.eJx1UF1PwjAU_S_3eTHdWrbBm5simIigkmCMWQrtRsO2zraDoeG_e0eiPBgf7z333PPxBVkjTcVrWTsYOdNKD7ioVA2jnJcWJ6HsRhuRKQEjYEFISOAPhiFhAaEDSsCD_5FSF4UUvYLV9fmDH9KhB5UrdNZaaWpeSSTj3KEHZGjeum2QWcddDyy7gWKCfqwYjWePk2Wzv2-rh-liFiSS68u90zuJlr-AbzbS2p8ZKNlbd7gxr8Po9pC3acLW4-6Q0rt4Ffhz5MuuUUbajGN6H00HNIpidkX80I8YveB9IZgsJsQDI3NcbX9FptvrZ2bSccKTJyEWZKdews_1PFykEWETFMECG0zzhk1hzSo_4q5oVSksvHtwfpO5Y38CGMtIAycP_pTmuCkk2qzbsjx9A74fipg.D9Qb0A.xBfWHNHJMKmxkyfN2xG29I8-Pog', '_gid': 'GA1.2.1982286289.1559351224', '_ga': 'GA1.2.359825018.1529632419', '__cfduid': 'd8fb7a27419b4e3e1404940ef22708bf81529632407', '_gat_gtag_UA_109131120_1': '1'} Endpoint: add_signup View Args: {} Person: 426002159604203530 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'mtgxman', 'name': 'Grade = A-', 'decklist': '4 Skinrender\r\n4 Banewhip Punisher\r\n2 Flourishing Defenses\r\n4 Nest of Scarabs\r\n4 Sinking Feeling\r\n4 Opulent Palace\r\n4 Grind/Dust\r\n4 Sandsteppe Citadel\r\n4 Virulent Wound\r\n4 Swamp\r\n4 Crumbling Vestige\r\n1 Plains\r\n2 Forest\r\n1 Island\r\n4 Splendid Agony\r\n4 Evolving Wilds\r\n4 Channeler Initiate\r\n2 Hapatra, Vizier of Poisons\r\n\r\n4 Putrefy\r\n4 Orbs of Warding\r\n4 Scrabbling Claws\r\n3 Naturalize\r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 68.103.180.176, 172.69.70.91 Cf-Ray: 4e01d8edebee57ff-DFW 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 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/64.0.3282.140 Safari/537.36 Edge/18.17763 Cookie: session=.eJx1UF1PwjAU_S_3eTHdWrbBm5simIigkmCMWQrtRsO2zraDoeG_e0eiPBgf7z333PPxBVkjTcVrWTsYOdNKD7ioVA2jnJcWJ6HsRhuRKQEjYEFISOAPhiFhAaEDSsCD_5FSF4UUvYLV9fmDH9KhB5UrdNZaaWpeSSTj3KEHZGjeum2QWcddDyy7gWKCfqwYjWePk2Wzv2-rh-liFiSS68u90zuJlr-AbzbS2p8ZKNlbd7gxr8Po9pC3acLW4-6Q0rt4Ffhz5MuuUUbajGN6H00HNIpidkX80I8YveB9IZgsJsQDI3NcbX9FptvrZ2bSccKTJyEWZKdews_1PFykEWETFMECG0zzhk1hzSo_4q5oVSksvHtwfpO5Y38CGMtIAycP_pTmuCkk2qzbsjx9A74fipg.D9Qb0A.xBfWHNHJMKmxkyfN2xG29I8-Pog; _gid=GA1.2.1982286289.1559351224; _ga=GA1.2.359825018.1529632419; __cfduid=d8fb7a27419b4e3e1404940ef22708bf81529632407; _gat_gtag_UA_109131120_1=1 Cf-Connecting-Ip: 68.103.180.176 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 528 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1559658571.6621413, 2997, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["ehslasheh", 2902, "1559658572"]', 'Red Counters', 2902, None, None, None, None, None, None, None] (slow_query, 258.2, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd365da5e623c70a3212000f582b75421c1540931186', '_ga': 'GA1.2.353720548.1540931207', '_gid': 'GA1.2.452902033.1559658495', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UWFvgjAQ_S_9TAxQ0OLHDZJNmdlMTJYtC-nggE5otS0baPzvO0zUD0v2re_e3Xt3r0eS7UC3XIK0ZG51Bw7hRSskmZe8MYgKaEWrihsWJle6yASWCHWZH0595tGIMhb5jBKH_MPIrOpEU1ycGlVVUIwbGCXPin4UzRzS2kplnQEteQsoBrVpuKmhRg3FO1v7mbHcjlRUe2m6mOX74S6Mt699mD-lFWfxT-Am_vLWb9UW8Kgj4XkOxlwweXDDjtO0TsS3WA-bQ1ya-8NKxRyMlAuch34nNJiMYz5eGDKfua7vTqYBo8HsRo-JTd0ASYdoKLFUXz32cdCEL3TVJ8X6cRNGq09vmTDK3_rnaMvRAxPd4THvGB3-gygHrJ2DMtfH5EuhxYdDzqKZHcYBcgdcgyYnh_zJ0HJdAe4su6Y5_QJwm5xT.D9gRvA.qGU66Vgjh6-xaM-Uxfa40lIDQHg'} Endpoint: add_signup View Args: {} Person: 308256281393889283 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'ehslasheh', 'name': 'Red Counters', 'decklist': "10 Mountain\r\n4 Stromkirk Noble\r\n4 Burst Lightning\r\n4 Slumbering Dragon\r\n4 Pollenbright Druid\r\n4 Courage in Crisis\r\n4 Bloodhall Ooze\r\n4 Pinecrest Ridge\r\n4 Mogg Hollows\r\n4 Rakdos Cackler\r\n2 Domri's Ambush\r\n4 Rigging Runner\r\n4 Boggart Ram-Gang\r\n4 Zhur-Taa Goblin\r\n\r\n3 Inspiring Call\r\n2 Domri's Ambush\r\n2 Great Sable Stag\r\n2 Mistcutter Hydra\r\n3 Destructive Revelry\r\n1 Bow of Nylea\r\n2 Kavu Predator\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: CA X-Forwarded-For: 134.190.205.124, 162.158.62.71 Cf-Ray: 4e1a99657ed69234-EWR 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/74.0.3729.169 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9 Cookie: __cfduid=d365da5e623c70a3212000f582b75421c1540931186; _ga=GA1.2.353720548.1540931207; _gid=GA1.2.452902033.1559658495; _gat_gtag_UA_109131120_1=1; session=.eJx9UWFvgjAQ_S_9TAxQ0OLHDZJNmdlMTJYtC-nggE5otS0baPzvO0zUD0v2re_e3Xt3r0eS7UC3XIK0ZG51Bw7hRSskmZe8MYgKaEWrihsWJle6yASWCHWZH0595tGIMhb5jBKH_MPIrOpEU1ycGlVVUIwbGCXPin4UzRzS2kplnQEteQsoBrVpuKmhRg3FO1v7mbHcjlRUe2m6mOX74S6Mt699mD-lFWfxT-Am_vLWb9UW8Kgj4XkOxlwweXDDjtO0TsS3WA-bQ1ya-8NKxRyMlAuch34nNJiMYz5eGDKfua7vTqYBo8HsRo-JTd0ASYdoKLFUXz32cdCEL3TVJ8X6cRNGq09vmTDK3_rnaMvRAxPd4THvGB3-gygHrJ2DMtfH5EuhxYdDzqKZHcYBcgdcgyYnh_zJ0HJdAe4su6Y5_QJwm5xT.D9gRvA.qGU66Vgjh6-xaM-Uxfa40lIDQHg Cf-Connecting-Ip: 134.190.205.124 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 538 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1559658660.4323397, 2997, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["ehslasheh", 2902, "1559658660"]', 'Red Counters', 2902, None, None, None, None, None, None, None] (slow_query, 169.4, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd365da5e623c70a3212000f582b75421c1540931186', '_ga': 'GA1.2.353720548.1540931207', '_gid': 'GA1.2.452902033.1559658495', 'cf_use_ob': '0', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UWFvgjAQ_S_9TAxQ0OLHDZJNmdlMTJYtC-nggE5otS0baPzvO0zUD0v2re_e3Xt3r0eS7UC3XIK0ZG51Bw7hRSskmZe8MYgKaEWrihsWJle6yASWCHWZH0595tGIMhb5jBKH_MPIrOpEU1ycGlVVUIwbGCXPin4UzRzS2kplnQEteQsoBrVpuKmhRg3FO1v7mbHcjlRUe2m6mOX74S6Mt699mD-lFWfxT-Am_vLWb9UW8Kgj4XkOxlwweXDDjtO0TsS3WA-bQ1ya-8NKxRyMlAuch34nNJiMYz5eGDKfua7vTqYBo8HsRo-JTd0ASYdoKLFUXz32cdCEL3TVJ8X6cRNGq09vmTDK3_rnaMvRAxPd4THvGB3-gygHrJ2DMtfH5EuhxYdDzqKZHcYBcgdcgyYnh_zJ0HJdAe4su6Y5_QJwm5xT.D9gSDw.qR3NblXtQVzymi8t8li5nPW8HzE'} Endpoint: add_signup View Args: {} Person: 308256281393889283 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'ehslasheh', 'name': 'Red Counters', 'decklist': "10 Mountain\r\n4 Stromkirk Noble\r\n4 Burst Lightning\r\n4 Slumbering Dragon\r\n4 Pollenbright Druid\r\n4 Courage in Crisis\r\n4 Bloodhall Ooze\r\n4 Pinecrest Ridge\r\n4 Mogg Hollows\r\n4 Rakdos Cackler\r\n2 Domri's Ambush\r\n4 Rigging Runner\r\n4 Boggart Ram-Gang\r\n4 Zhur-Taa Goblin\r\n\r\n3 Inspiring Call\r\n2 Domri's Ambush\r\n2 Great Sable Stag\r\n2 Mistcutter Hydra\r\n3 Destructive Revelry\r\n1 Bow of Nylea\r\n2 Kavu Predator\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: CA X-Forwarded-For: 134.190.205.124, 173.245.52.135 Cf-Ray: 4e1a9b938bba21ea-EWR 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/74.0.3729.169 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9 Cookie: __cfduid=d365da5e623c70a3212000f582b75421c1540931186; _ga=GA1.2.353720548.1540931207; _gid=GA1.2.452902033.1559658495; cf_use_ob=0; _gat_gtag_UA_109131120_1=1; session=.eJx9UWFvgjAQ_S_9TAxQ0OLHDZJNmdlMTJYtC-nggE5otS0baPzvO0zUD0v2re_e3Xt3r0eS7UC3XIK0ZG51Bw7hRSskmZe8MYgKaEWrihsWJle6yASWCHWZH0595tGIMhb5jBKH_MPIrOpEU1ycGlVVUIwbGCXPin4UzRzS2kplnQEteQsoBrVpuKmhRg3FO1v7mbHcjlRUe2m6mOX74S6Mt699mD-lFWfxT-Am_vLWb9UW8Kgj4XkOxlwweXDDjtO0TsS3WA-bQ1ya-8NKxRyMlAuch34nNJiMYz5eGDKfua7vTqYBo8HsRo-JTd0ASYdoKLFUXz32cdCEL3TVJ8X6cRNGq09vmTDK3_rnaMvRAxPd4THvGB3-gygHrJ2DMtfH5EuhxYdDzqKZHcYBcgdcgyYnh_zJ0HJdAe4su6Y5_QJwm5xT.D9gSDw.qR3NblXtQVzymi8t8li5nPW8HzE Cf-Connecting-Ip: 134.190.205.124 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 538 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1560090454.22297, 2246, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["guse_84", 2902, "1560090454"]', 'UW Blink', 2902, None, None, None, None, None, None, None] (slow_query, 499.7, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd09f3a270a8e5e9e2bc42b482abfe12671560090104', '_ga': 'GA1.2.676045645.1560090109', '_gid': 'GA1.2.1107246278.1560090109', 'hide_intro': 'True', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UdtuwjAM_Zc8Vyht0wu8bSuIIYYGG-ymqQpNWgJtUiVpxUD8-1wk4GHS3mwf-xz7-IjSmuuKSi4tGljdcAdRVgmJBjktDWSMV6JS7JYLkynNUgElREIS-0EceST0It_3XR856B9EpkUjSnZRKlVRcNZtYJQ8M3rQ76DKFiptDNeSVhzICojTmACDoo3deKmx1HaAtzTyQHErSfMSPT0uFonYrNusGE7pqE1u_VbtOJx0RDTLuDGXHL3ns3a5juKd23f1_OF5eHj79PJVGLGPufVgnu9roblJKbjjBiEO-wHGpBd7AfFx_4Z3hoWYxBg7SPMcSpurCDachvUhGasmDpPpeD8ZzbbjCVu94jm5AxEwtIZrvsA5eIPIf6B29slcg95WgcS3g86kqf3pBtA9p5prdHLQHwst1QWHpWVTlqdfS3-bYA.D96oug.9y7V77f_XRa9jYzzI55jOawNlOM'} Endpoint: add_signup View Args: {} Person: 464835872462733313 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'guse_84', 'name': 'UW Blink', 'decklist': '3 Lone Missionary\r\n1 Champion of Wits\r\n1 Filigree Familiar\r\n4 Sea Gate Oracle\r\n4 Nevermaker\r\n4 Cloudblazer\r\n4 Elder Deep-Fiend\r\n2 Hallowed Moonlight\r\n4 Prismatic Lens\r\n4 Prophetic Prism\r\n4 Parallax Wave\r\n1 Calciform Pools\r\n4 Cloudpost\r\n4 Glimmerpost\r\n5 Island\r\n7 Plains\r\n4 Tranquil Cove\r\n\r\n1 War Priest of Thune\r\n1 Artisan of Kozilek\r\n1 Chill\r\n2 Gainsay\r\n1 Hallowed Moonlight\r\n2 Seal of Cleansing\r\n1 Arcane Laboratory\r\n1 Rule of Law\r\n1 Ivory Mask\r\n1 Sphere of Law\r\n3 Planar Outburst'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 151.82.22.146, 188.114.103.199 Cf-Ray: 4e43c96d7cfcbe19-MXP 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/74.0.3729.169 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: it-IT,it;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: __cfduid=d09f3a270a8e5e9e2bc42b482abfe12671560090104; _ga=GA1.2.676045645.1560090109; _gid=GA1.2.1107246278.1560090109; hide_intro=True; _gat_gtag_UA_109131120_1=1; session=.eJx9UdtuwjAM_Zc8Vyht0wu8bSuIIYYGG-ymqQpNWgJtUiVpxUD8-1wk4GHS3mwf-xz7-IjSmuuKSi4tGljdcAdRVgmJBjktDWSMV6JS7JYLkynNUgElREIS-0EceST0It_3XR856B9EpkUjSnZRKlVRcNZtYJQ8M3rQ76DKFiptDNeSVhzICojTmACDoo3deKmx1HaAtzTyQHErSfMSPT0uFonYrNusGE7pqE1u_VbtOJx0RDTLuDGXHL3ns3a5juKd23f1_OF5eHj79PJVGLGPufVgnu9roblJKbjjBiEO-wHGpBd7AfFx_4Z3hoWYxBg7SPMcSpurCDachvUhGasmDpPpeD8ZzbbjCVu94jm5AxEwtIZrvsA5eIPIf6B29slcg95WgcS3g86kqf3pBtA9p5prdHLQHwst1QWHpWVTlqdfS3-bYA.D96oug.9y7V77f_XRa9jYzzI55jOawNlOM Cf-Connecting-Ip: 151.82.22.146 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 639 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1560090771.6242447, 2246, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["guse_84", 2902, "1560090772"]', 'UW Blink', 2902, None, None, None, None, None, None, None] (slow_query, 182.4, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd09f3a270a8e5e9e2bc42b482abfe12671560090104', '_ga': 'GA1.2.676045645.1560090109', '_gid': 'GA1.2.1107246278.1560090109', 'hide_intro': 'True', 'cf_use_ob': '0', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UdtuwjAM_Zc8Vyht0wu8bSuIIYYGG-ymqQpNWgJtUiVpxUD8-1wk4GHS3mwf-xz7-IjSmuuKSi4tGljdcAdRVgmJBjktDWSMV6JS7JYLkynNUgElREIS-0EceST0It_3XR856B9EpkUjSnZRKlVRcNZtYJQ8M3rQ76DKFiptDNeSVhzICojTmACDoo3deKmx1HaAtzTyQHErSfMSPT0uFonYrNusGE7pqE1u_VbtOJx0RDTLuDGXHL3ns3a5juKd23f1_OF5eHj79PJVGLGPufVgnu9roblJKbjjBiEO-wHGpBd7AfFx_4Z3hoWYxBg7SPMcSpurCDachvUhGasmDpPpeD8ZzbbjCVu94jm5AxEwtIZrvsA5eIPIf6B29slcg95WgcS3g86kqf3pBtA9p5prdHLQHwst1QWHpWVTlqdfS3-bYA.D96qEA.ZCFYwafgUPJqAR8jRiPoaboLK2o'} Endpoint: add_signup View Args: {} Person: 464835872462733313 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'guse_84', 'name': 'UW Blink', 'decklist': '3 Lone Missionary\r\n1 Champion of Wits\r\n1 Filigree Familiar\r\n4 Sea Gate Oracle\r\n4 Nevermaker\r\n4 Cloudblazer\r\n4 Elder Deep-Fiend\r\n2 Hallowed Moonlight\r\n4 Prismatic Lens\r\n4 Prophetic Prism\r\n4 Parallax Wave\r\n1 Calciform Pools\r\n4 Cloudpost\r\n4 Glimmerpost\r\n5 Island\r\n7 Plains\r\n4 Tranquil Cove\r\n\r\n1 War Priest of Thune\r\n1 Artisan of Kozilek\r\n1 Chill\r\n2 Gainsay\r\n1 Hallowed Moonlight\r\n2 Seal of Cleansing\r\n1 Arcane Laboratory\r\n1 Rule of Law\r\n1 Ivory Mask\r\n1 Sphere of Law\r\n3 Planar Outburst'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 151.82.22.146, 188.114.103.199 Cf-Ray: 4e43d12d8ff2be19-MXP 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/74.0.3729.169 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: it-IT,it;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: __cfduid=d09f3a270a8e5e9e2bc42b482abfe12671560090104; _ga=GA1.2.676045645.1560090109; _gid=GA1.2.1107246278.1560090109; hide_intro=True; cf_use_ob=0; _gat_gtag_UA_109131120_1=1; session=.eJx9UdtuwjAM_Zc8Vyht0wu8bSuIIYYGG-ymqQpNWgJtUiVpxUD8-1wk4GHS3mwf-xz7-IjSmuuKSi4tGljdcAdRVgmJBjktDWSMV6JS7JYLkynNUgElREIS-0EceST0It_3XR856B9EpkUjSnZRKlVRcNZtYJQ8M3rQ76DKFiptDNeSVhzICojTmACDoo3deKmx1HaAtzTyQHErSfMSPT0uFonYrNusGE7pqE1u_VbtOJx0RDTLuDGXHL3ns3a5juKd23f1_OF5eHj79PJVGLGPufVgnu9roblJKbjjBiEO-wHGpBd7AfFx_4Z3hoWYxBg7SPMcSpurCDachvUhGasmDpPpeD8ZzbbjCVu94jm5AxEwtIZrvsA5eIPIf6B29slcg95WgcS3g86kqf3pBtA9p5prdHLQHwst1QWHpWVTlqdfS3-bYA.D96qEA.ZCFYwafgUPJqAR8jRiPoaboLK2o Cf-Connecting-Ip: 151.82.22.146 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 639 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1560090698.7361321, 2246, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["guse_84", 2902, "1560090699"]', 'UW Blink', 2902, None, None, None, None, None, None, None] (slow_query, 255.3, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd09f3a270a8e5e9e2bc42b482abfe12671560090104', '_ga': 'GA1.2.676045645.1560090109', '_gid': 'GA1.2.1107246278.1560090109', 'hide_intro': 'True', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UdtuwjAM_Zc8Vyht0wu8bSuIIYYGG-ymqQpNWgJtUiVpxUD8-1wk4GHS3mwf-xz7-IjSmuuKSi4tGljdcAdRVgmJBjktDWSMV6JS7JYLkynNUgElREIS-0EceST0It_3XR856B9EpkUjSnZRKlVRcNZtYJQ8M3rQ76DKFiptDNeSVhzICojTmACDoo3deKmx1HaAtzTyQHErSfMSPT0uFonYrNusGE7pqE1u_VbtOJx0RDTLuDGXHL3ns3a5juKd23f1_OF5eHj79PJVGLGPufVgnu9roblJKbjjBiEO-wHGpBd7AfFx_4Z3hoWYxBg7SPMcSpurCDachvUhGasmDpPpeD8ZzbbjCVu94jm5AxEwtIZrvsA5eIPIf6B29slcg95WgcS3g86kqf3pBtA9p5prdHLQHwst1QWHpWVTlqdfS3-bYA.D96pwA.vwEhoPlGzXrP7POHLdhs-Z0Xb5g'} Endpoint: add_signup View Args: {} Person: 464835872462733313 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'guse_84', 'name': 'UW Blink', 'decklist': '3 Lone Missionary\r\n1 Champion of Wits\r\n1 Filigree Familiar\r\n4 Sea Gate Oracle\r\n4 Nevermaker\r\n4 Cloudblazer\r\n4 Elder Deep-Fiend\r\n2 Hallowed Moonlight\r\n4 Prismatic Lens\r\n4 Prophetic Prism\r\n4 Parallax Wave\r\n1 Calciform Pools\r\n4 Cloudpost\r\n4 Glimmerpost\r\n5 Island\r\n7 Plains\r\n4 Tranquil Cove\r\n\r\n1 War Priest of Thune\r\n1 Artisan of Kozilek\r\n1 Chill\r\n2 Gainsay\r\n1 Hallowed Moonlight\r\n2 Seal of Cleansing\r\n1 Arcane Laboratory\r\n1 Rule of Law\r\n1 Ivory Mask\r\n1 Sphere of Law\r\n3 Planar Outburst'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: IT X-Forwarded-For: 151.82.22.146, 188.114.103.199 Cf-Ray: 4e43cf681b12be19-MXP 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/74.0.3729.169 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: it-IT,it;q=0.9,en-US;q=0.8,en;q=0.7 Cookie: __cfduid=d09f3a270a8e5e9e2bc42b482abfe12671560090104; _ga=GA1.2.676045645.1560090109; _gid=GA1.2.1107246278.1560090109; hide_intro=True; _gat_gtag_UA_109131120_1=1; session=.eJx9UdtuwjAM_Zc8Vyht0wu8bSuIIYYGG-ymqQpNWgJtUiVpxUD8-1wk4GHS3mwf-xz7-IjSmuuKSi4tGljdcAdRVgmJBjktDWSMV6JS7JYLkynNUgElREIS-0EceST0It_3XR856B9EpkUjSnZRKlVRcNZtYJQ8M3rQ76DKFiptDNeSVhzICojTmACDoo3deKmx1HaAtzTyQHErSfMSPT0uFonYrNusGE7pqE1u_VbtOJx0RDTLuDGXHL3ns3a5juKd23f1_OF5eHj79PJVGLGPufVgnu9roblJKbjjBiEO-wHGpBd7AfFx_4Z3hoWYxBg7SPMcSpurCDachvUhGasmDpPpeD8ZzbbjCVu94jm5AxEwtIZrvsA5eIPIf6B29slcg95WgcS3g86kqf3pBtA9p5prdHLQHwst1QWHpWVTlqdfS3-bYA.D96pwA.vwEhoPlGzXrP7POHLdhs-Z0Xb5g Cf-Connecting-Ip: 151.82.22.146 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 639 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1561040994.6698978, 2683, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["wizzardofoz", 2902, "1561040994"]', 'Simic Desire', 2902, None, None, None, None, None, None, None] (slow_query, 114.5, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd63b5d7c015853123c363c84c13b940b91555687535', 'hide_intro': 'True', 'deck_id': '52628', 'session': '.eJx9UctuwjAQ_BefIxTixAGOBVpVAkppVSqqKjKx8wAnTvxQmiD-vRsk4FCpN8_O7szu-ISiiquClrw0aGKU5Q6irMhLNEmo0IAYL_JCsjvOdSwVi3IoIez7I49gjH0SDodBgF3koH-YMkptLtjVScg05azfQMvyouiREXZQYVIZWc1VSQsOYk3edVQxmcgOVCS1JvMibajpyVXzNmvilu6L7EnUr--bz4WqhV0SOw6bxb3fyCOHs06IxjHX-orRfO7baiYZWa5ZOF37B5FU7UbQ-kUV-xTm-U-VK64jCgnBJQQH4xCTwZi4BA_Jne9DI64_cl0HKZ5AKbuZdPUza48f_uqBzQPlrbcyk2K3baaP2NtlYAKhVnDNF6QHX5EnLdQuWenbY3CQYPHtoItoZNp-AD1wqrhCZwf9idFQlXJYurRCnH8BsC-gAA.D-0pxQ.xdx-visLfen4oUiSL-IkQ0xplPo'} Endpoint: add_signup View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'wizzardofoz', 'name': 'Simic Desire', '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: PT X-Forwarded-For: 2001:8a0:feec:5500:849d:a726:149d:5805, 172.68.102.24 Cf-Ray: 4e9e6ffa8b9e6252-LIS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 Dnt: 1 Content-Type: application/x-www-form-urlencoded User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-GB,en;q=0.9,pt-PT;q=0.8,pt;q=0.7,fr;q=0.6,nl;q=0.5 Cookie: __cfduid=d63b5d7c015853123c363c84c13b940b91555687535; hide_intro=True; deck_id=52628; session=.eJx9UctuwjAQ_BefIxTixAGOBVpVAkppVSqqKjKx8wAnTvxQmiD-vRsk4FCpN8_O7szu-ISiiquClrw0aGKU5Q6irMhLNEmo0IAYL_JCsjvOdSwVi3IoIez7I49gjH0SDodBgF3koH-YMkptLtjVScg05azfQMvyouiREXZQYVIZWc1VSQsOYk3edVQxmcgOVCS1JvMibajpyVXzNmvilu6L7EnUr--bz4WqhV0SOw6bxb3fyCOHs06IxjHX-orRfO7baiYZWa5ZOF37B5FU7UbQ-kUV-xTm-U-VK64jCgnBJQQH4xCTwZi4BA_Jne9DI64_cl0HKZ5AKbuZdPUza48f_uqBzQPlrbcyk2K3baaP2NtlYAKhVnDNF6QHX5EnLdQuWenbY3CQYPHtoItoZNp-AD1wqrhCZwf9idFQlXJYurRCnH8BsC-gAA.D-0pxQ.xdx-visLfen4oUiSL-IkQ0xplPo Cf-Connecting-Ip: 2001:8a0:feec:5500:849d:a726:149d:5805 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 3080 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1561040978.6894536, 2683, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["wizzardofoz", 2902, "1561040978"]', 'Simic Desire', 2902, None, None, None, None, None, None, None] (slow_query, 130.4, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd63b5d7c015853123c363c84c13b940b91555687535', 'hide_intro': 'True', 'deck_id': '52628', 'session': '.eJx9UctuwjAQ_BefIxTixAGOBVpVAkppVSqqKjKx8wAnTvxQmiD-vRsk4FCpN8_O7szu-ISiiquClrw0aGKU5Q6irMhLNEmo0IAYL_JCsjvOdSwVi3IoIez7I49gjH0SDodBgF3koH-YMkptLtjVScg05azfQMvyouiREXZQYVIZWc1VSQsOYk3edVQxmcgOVCS1JvMibajpyVXzNmvilu6L7EnUr--bz4WqhV0SOw6bxb3fyCOHs06IxjHX-orRfO7baiYZWa5ZOF37B5FU7UbQ-kUV-xTm-U-VK64jCgnBJQQH4xCTwZi4BA_Jne9DI64_cl0HKZ5AKbuZdPUza48f_uqBzQPlrbcyk2K3baaP2NtlYAKhVnDNF6QHX5EnLdQuWenbY3CQYPHtoItoZNp-AD1wqrhCZwf9idFQlXJYurRCnH8BsC-gAA.D-0pxQ.xdx-visLfen4oUiSL-IkQ0xplPo'} Endpoint: add_signup View Args: {} Person: 344826333467115530 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'wizzardofoz', 'name': 'Simic Desire', '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: PT X-Forwarded-For: 2001:8a0:feec:5500:849d:a726:149d:5805, 172.68.102.24 Cf-Ray: 4e9e6f90eb2f6252-LIS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Origin: https://pennydreadfulmagic.com Upgrade-Insecure-Requests: 1 Dnt: 1 Content-Type: application/x-www-form-urlencoded User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-GB,en;q=0.9,pt-PT;q=0.8,pt;q=0.7,fr;q=0.6,nl;q=0.5 Cookie: __cfduid=d63b5d7c015853123c363c84c13b940b91555687535; hide_intro=True; deck_id=52628; session=.eJx9UctuwjAQ_BefIxTixAGOBVpVAkppVSqqKjKx8wAnTvxQmiD-vRsk4FCpN8_O7szu-ISiiquClrw0aGKU5Q6irMhLNEmo0IAYL_JCsjvOdSwVi3IoIez7I49gjH0SDodBgF3koH-YMkptLtjVScg05azfQMvyouiREXZQYVIZWc1VSQsOYk3edVQxmcgOVCS1JvMibajpyVXzNmvilu6L7EnUr--bz4WqhV0SOw6bxb3fyCOHs06IxjHX-orRfO7baiYZWa5ZOF37B5FU7UbQ-kUV-xTm-U-VK64jCgnBJQQH4xCTwZi4BA_Jne9DI64_cl0HKZ5AKbuZdPUza48f_uqBzQPlrbcyk2K3baaP2NtlYAKhVnDNF6QHX5EnLdQuWenbY3CQYPHtoItoZNp-AD1wqrhCZwf9idFQlXJYurRCnH8BsC-gAA.D-0pxQ.xdx-visLfen4oUiSL-IkQ0xplPo Cf-Connecting-Ip: 2001:8a0:feec:5500:849d:a726:149d:5805 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 3080 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1561127243.5121543, 2739, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["carmandor", 2902, "1561127243"]', 'bant dynos', 2902, None, None, None, None, None, None, None] (slow_query, 223.5, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd83e7ab2c17db1acfa58acbd66c6fb29b1553068417', '_ga': 'GA1.2.1687706292.1553068422', 'session': '.eJx9UdFqwjAU_Zf7XEbaNI31cZtUi4IwcRtjlKxJ22xtokmKU_HflxacD4M9nnNvzjn35AzFTpiOKaEcTJ3pRQCMd1LBtGKt9YiLTnaa37C0pTa8kJ6COE3iMJqECaU0xUmKKATwz0QVdS9bfnVqdV0LPiSwWo2KEcVpAJ2rddFbYRTrhBcr2RCRa-M1NOtdExXWMTeO5nua461JV0sbnha9Uy-L1FbPh_3n-nV323f6S_ijzsDKUlh7xcDzQ5OzFmf3lqaZQskHXj8hKTdkc0pC_15876QRtmC-n5AQnFAcTdAdIRHBBN_mQ2UJiicIBWBE5anm18Qs3eqhySMyy6NqOZt38dpu0TGj2ZxHj97EV7rz17z57vxHyOroubEpC-8BjDKFOw4rcC-YEQYuAfypzTFTCx9T9W17-QHaLpeG.D-56uQ.z1_eup7t6AD5gG_W6rZmluN3i3s', '_gid': 'GA1.2.1842450573.1560758708', 'deck_id': '52858', '_gat_gtag_UA_109131120_1': '1'} Endpoint: add_signup View Args: {} Person: 496412816777936907 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'carmandor', 'name': 'bant dynos', '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: IT X-Forwarded-For: 185.67.237.178, 188.114.102.180 Cf-Ray: 4ea6a9a7cc92be55-MXP X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:67.0) Gecko/20100101 Firefox/67.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: it-IT,it;q=0.8,en-US;q=0.5,en;q=0.3 Referer: https://pennydreadfulmagic.com/signup/ Content-Type: application/x-www-form-urlencoded Upgrade-Insecure-Requests: 1 Cookie: __cfduid=d83e7ab2c17db1acfa58acbd66c6fb29b1553068417; _ga=GA1.2.1687706292.1553068422; session=.eJx9UdFqwjAU_Zf7XEbaNI31cZtUi4IwcRtjlKxJ22xtokmKU_HflxacD4M9nnNvzjn35AzFTpiOKaEcTJ3pRQCMd1LBtGKt9YiLTnaa37C0pTa8kJ6COE3iMJqECaU0xUmKKATwz0QVdS9bfnVqdV0LPiSwWo2KEcVpAJ2rddFbYRTrhBcr2RCRa-M1NOtdExXWMTeO5nua461JV0sbnha9Uy-L1FbPh_3n-nV323f6S_ijzsDKUlh7xcDzQ5OzFmf3lqaZQskHXj8hKTdkc0pC_15876QRtmC-n5AQnFAcTdAdIRHBBN_mQ2UJiicIBWBE5anm18Qs3eqhySMyy6NqOZt38dpu0TGj2ZxHj97EV7rz17z57vxHyOroubEpC-8BjDKFOw4rcC-YEQYuAfypzTFTCx9T9W17-QHaLpeG.D-56uQ.z1_eup7t6AD5gG_W6rZmluN3i3s; _gid=GA1.2.1842450573.1560758708; deck_id=52858; _gat_gtag_UA_109131120_1=1 Cf-Connecting-Ip: 185.67.237.178 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 3800 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1561214160.7756102, 3372, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["jonny_kasa", 2902, "1561214161"]', 'U PD Pauper', 2902, None, None, None, None, None, None, None] (slow_query, 318.1, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'db0589c69a4d17868f0ba688b188a6ab51556984111', 'deck_id': '52904', 'session': '.eJx9UctuwjAQ_BefI5Rg8uIIlQCVtmqRAqWqIivZBENsB9vhKf69G6SSQ6XKF8-Md3Z3fCVpDVowCdKSodUNOITlgksyLFhlEOUguFB5h7nJlM5TjhTxgzigeFwvjrzApZFPHPKPItOy4VVnVqmyhLwdwSh5t6Q07DtE2FKljQEtmQB02yopz-mOGYYuijV200-NZbbV5lP1BvqSybG3PC73Ylms1sXrh_uZLGaDS_feqh3gWlfCsgyM-cUkkWwlJmWwX4RJyV8Ok-So4maz3O6P7rPGejjVXINJGSbk-X7oR1FM414UhXEQ0k5vQwvcQeS6DtFQILV5NNGTd1eO_BlN7IEmcxvlQdOcvOnTuq7FGJtgqDVu84Xp4Vfw4ozcPSvzuPS2Clt8O-RumtpzW0BGwDRocnPInxQt0yXg0LKpqtsPK_GfdA.D-_OCA.-P0NyQi3w-u2OKVVWYPPyHt2NT8'} Endpoint: add_signup View Args: {} Person: 569636360198160385 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'jonny_kasa', 'name': 'U PD Pauper', 'decklist': '4 Looter il-Kor\r\n4 Bonesplitter\r\n3 Darksteel Axe\r\n3 Ornithopter\r\n3 Clout of the Dominus\r\n4 Mist-Cloaked Herald\r\n3 Sigil of Sleep\r\n4 Slither Blade\r\n4 Essence Scatter\r\n3 Waterfront Bouncer\r\n3 Turn Aside\r\n21 Island\r\n1 Anticipate\r\n\r\n1 Anticipate\r\n4 Annul\r\n2 Nullify\r\n4 Piracy Charm\r\n2 Narcolepsy\r\n1 Lonely Sandbar\r\n1 Waterfront Bouncer\r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: JP X-Forwarded-For: 2001:268:c1c2:17f9:d1b:771e:a487:44d4, 162.158.6.120 Cf-Ray: 4eaef3ad0f53db10-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/75.0.3770.100 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: ja,en-US;q=0.9,en;q=0.8,es;q=0.7 Cookie: __cfduid=db0589c69a4d17868f0ba688b188a6ab51556984111; deck_id=52904; session=.eJx9UctuwjAQ_BefI5Rg8uIIlQCVtmqRAqWqIivZBENsB9vhKf69G6SSQ6XKF8-Md3Z3fCVpDVowCdKSodUNOITlgksyLFhlEOUguFB5h7nJlM5TjhTxgzigeFwvjrzApZFPHPKPItOy4VVnVqmyhLwdwSh5t6Q07DtE2FKljQEtmQB02yopz-mOGYYuijV200-NZbbV5lP1BvqSybG3PC73Ylms1sXrh_uZLGaDS_feqh3gWlfCsgyM-cUkkWwlJmWwX4RJyV8Ok-So4maz3O6P7rPGejjVXINJGSbk-X7oR1FM414UhXEQ0k5vQwvcQeS6DtFQILV5NNGTd1eO_BlN7IEmcxvlQdOcvOnTuq7FGJtgqDVu84Xp4Vfw4ozcPSvzuPS2Clt8O-RumtpzW0BGwDRocnPInxQt0yXg0LKpqtsPK_GfdA.D-_OCA.-P0NyQi3w-u2OKVVWYPPyHt2NT8 Cf-Connecting-Ip: 2001:268:c1c2:17f9:d1b:771e:a487:44d4 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 468 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1561214341.7135928, 3372, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["jonny_kasa", 2902, "1561214342"]', 'U PD Pauper', 2902, None, None, None, None, None, None, None] (slow_query, 137.1, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'db0589c69a4d17868f0ba688b188a6ab51556984111', 'deck_id': '52904', 'session': '.eJx9UctuwjAQ_BefI5Rg8uIIlQCVtmqRAqWqIivZBENsB9vhKf69G6SSQ6XKF8-Md3Z3fCVpDVowCdKSodUNOITlgksyLFhlEOUguFB5h7nJlM5TjhTxgzigeFwvjrzApZFPHPKPItOy4VVnVqmyhLwdwSh5t6Q07DtE2FKljQEtmQB02yopz-mOGYYuijV200-NZbbV5lP1BvqSybG3PC73Ylms1sXrh_uZLGaDS_feqh3gWlfCsgyM-cUkkWwlJmWwX4RJyV8Ok-So4maz3O6P7rPGejjVXINJGSbk-X7oR1FM414UhXEQ0k5vQwvcQeS6DtFQILV5NNGTd1eO_BlN7IEmcxvlQdOcvOnTuq7FGJtgqDVu84Xp4Vfw4ozcPSvzuPS2Clt8O-RumtpzW0BGwDRocnPInxQt0yXg0LKpqtsPK_GfdA.D-_O7A.AaCYVieEEW9fdGBhAYdZlInw3H8'} Endpoint: add_signup View Args: {} Person: 569636360198160385 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'jonny_kasa', 'name': 'U PD Pauper', 'decklist': '4 Looter il-Kor\r\n4 Bonesplitter\r\n3 Darksteel Axe\r\n3 Ornithopter\r\n3 Clout of the Dominus\r\n4 Mist-Cloaked Herald\r\n3 Sigil of Sleep\r\n4 Slither Blade\r\n4 Essence Scatter\r\n3 Waterfront Bouncer\r\n3 Turn Aside\r\n21 Island\r\n1 Anticipate\r\n\r\n1 Anticipate\r\n4 Annul\r\n2 Nullify\r\n4 Piracy Charm\r\n2 Narcolepsy\r\n1 Lonely Sandbar\r\n1 Waterfront Bouncer\r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: JP X-Forwarded-For: 2001:268:c1c2:17f9:d1b:771e:a487:44d4, 162.158.6.120 Cf-Ray: 4eaef811fd4cdb10-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/75.0.3770.100 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: ja,en-US;q=0.9,en;q=0.8,es;q=0.7 Cookie: __cfduid=db0589c69a4d17868f0ba688b188a6ab51556984111; deck_id=52904; session=.eJx9UctuwjAQ_BefI5Rg8uIIlQCVtmqRAqWqIivZBENsB9vhKf69G6SSQ6XKF8-Md3Z3fCVpDVowCdKSodUNOITlgksyLFhlEOUguFB5h7nJlM5TjhTxgzigeFwvjrzApZFPHPKPItOy4VVnVqmyhLwdwSh5t6Q07DtE2FKljQEtmQB02yopz-mOGYYuijV200-NZbbV5lP1BvqSybG3PC73Ylms1sXrh_uZLGaDS_feqh3gWlfCsgyM-cUkkWwlJmWwX4RJyV8Ok-So4maz3O6P7rPGejjVXINJGSbk-X7oR1FM414UhXEQ0k5vQwvcQeS6DtFQILV5NNGTd1eO_BlN7IEmcxvlQdOcvOnTuq7FGJtgqDVu84Xp4Vfw4ozcPSvzuPS2Clt8O-RumtpzW0BGwDRocnPInxQt0yXg0LKpqtsPK_GfdA.D-_O7A.AaCYVieEEW9fdGBhAYdZlInw3H8 Cf-Connecting-Ip: 2001:268:c1c2:17f9:d1b:771e:a487:44d4 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 468 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1561214228.5065627, 3372, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["jonny_kasa", 2902, "1561214228"]', 'U PD Pauper', 2902, None, None, None, None, None, None, None] (slow_query, 250.3, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'db0589c69a4d17868f0ba688b188a6ab51556984111', 'deck_id': '52904', 'session': '.eJx9UctuwjAQ_BefI5Rg8uIIlQCVtmqRAqWqIivZBENsB9vhKf69G6SSQ6XKF8-Md3Z3fCVpDVowCdKSodUNOITlgksyLFhlEOUguFB5h7nJlM5TjhTxgzigeFwvjrzApZFPHPKPItOy4VVnVqmyhLwdwSh5t6Q07DtE2FKljQEtmQB02yopz-mOGYYuijV200-NZbbV5lP1BvqSybG3PC73Ylms1sXrh_uZLGaDS_feqh3gWlfCsgyM-cUkkWwlJmWwX4RJyV8Ok-So4maz3O6P7rPGejjVXINJGSbk-X7oR1FM414UhXEQ0k5vQwvcQeS6DtFQILV5NNGTd1eO_BlN7IEmcxvlQdOcvOnTuq7FGJtgqDVu84Xp4Vfw4ozcPSvzuPS2Clt8O-RumtpzW0BGwDRocnPInxQt0yXg0LKpqtsPK_GfdA.D-_Oiw.UI13RT3bfaraN1FovJkvTrADHL0', 'cf_use_ob': '0'} Endpoint: add_signup View Args: {} Person: 569636360198160385 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'jonny_kasa', 'name': 'U PD Pauper', 'decklist': '4 Looter il-Kor\r\n4 Bonesplitter\r\n3 Darksteel Axe\r\n3 Ornithopter\r\n3 Clout of the Dominus\r\n4 Mist-Cloaked Herald\r\n3 Sigil of Sleep\r\n4 Slither Blade\r\n4 Essence Scatter\r\n3 Waterfront Bouncer\r\n3 Turn Aside\r\n21 Island\r\n1 Anticipate\r\n\r\n1 Anticipate\r\n4 Annul\r\n2 Nullify\r\n4 Piracy Charm\r\n2 Narcolepsy\r\n1 Lonely Sandbar\r\n1 Waterfront Bouncer\r\n'} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: JP X-Forwarded-For: 2001:268:c1c2:17f9:d1b:771e:a487:44d4, 162.158.6.120 Cf-Ray: 4eaef5482a90db10-KIX X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: max-age=0 Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36 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,application/signed-exchange;v=b3 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: ja,en-US;q=0.9,en;q=0.8,es;q=0.7 Cookie: __cfduid=db0589c69a4d17868f0ba688b188a6ab51556984111; deck_id=52904; session=.eJx9UctuwjAQ_BefI5Rg8uIIlQCVtmqRAqWqIivZBENsB9vhKf69G6SSQ6XKF8-Md3Z3fCVpDVowCdKSodUNOITlgksyLFhlEOUguFB5h7nJlM5TjhTxgzigeFwvjrzApZFPHPKPItOy4VVnVqmyhLwdwSh5t6Q07DtE2FKljQEtmQB02yopz-mOGYYuijV200-NZbbV5lP1BvqSybG3PC73Ylms1sXrh_uZLGaDS_feqh3gWlfCsgyM-cUkkWwlJmWwX4RJyV8Ok-So4maz3O6P7rPGejjVXINJGSbk-X7oR1FM414UhXEQ0k5vQwvcQeS6DtFQILV5NNGTd1eO_BlN7IEmcxvlQdOcvOnTuq7FGJtgqDVu84Xp4Vfw4ozcPSvzuPS2Clt8O-RumtpzW0BGwDRocnPInxQt0yXg0LKpqtsPK_GfdA.D-_Oiw.UI13RT3bfaraN1FovJkvTrADHL0; cf_use_ob=0 Cf-Connecting-Ip: 2001:268:c1c2:17f9:d1b:771e:a487:44d4 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 468 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1561386378.815761, 3313, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["mtgdavis", 2902, "1561386379"]', 'Ooze Combo', 2902, None, None, None, None, None, None, None] (slow_query, 325.7, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd9d1887332dbaa73ec29cfaa30ea6c5a11553469324', '_ga': 'GA1.2.2121679503.1553469329', '_gid': 'GA1.2.173153895.1561385719', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UWFPwjAQ_S_3eTFbR2HyTXCJwRhBIQLGLHW9jcLaYtsNF8J_tyNBPpj4pcm7d33v7t0Rsj0ayRQqB0NnagyAcSkUDAtWWY84SiE1v2Jhc214JnwJ4ts4JDSKekkY9ikhSQIB_MOorKxFxS9OlS5L5N0EVquzYhxHcQDSlTqrLRrFJHoxjzlrhPUSmtVuQzLrmOuYLUkU_VrhxLULmb7ePQ4qJ0gjFb4hSa_9Tu_Q73QEludo7QVDNFs-HdJGT9JU9vrbVTzFdcPV6uUwX8yW_j9-74VBmzEfT0RpL-qe5IZQGpPB4Mp3ifXDbtsADBa-tPk1ef4cT9oil3R3rx4W5XqcoxnN66kqZ4e89SY-0b3f5t1H5-8giq52DsrCRwBnmcy1XQuMkBk0cArgT2qOmRL9mKquqtMP7luZSA.D_Ju3A.8tZV4IB_7qfq4aebO9vBIohOiuk'} Endpoint: add_signup View Args: {} Person: 393025114800652288 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'mtgdavis', 'name': 'Ooze Combo', 'decklist': "4 Hermit Druid\r\n4 Hapless Researcher\r\n1 Centaur Garden\r\n3 Satyr Wayfinder\r\n4 Champion of Wits\r\n1 Whip of Erebos\r\n2 Haunted Dead\r\n4 Necrotic Ooze\r\n2 Phyrexian Devourer\r\n2 Triskelion\r\n4 Llanowar Wastes\r\n1 Memory's Journey\r\n2 Dread Return\r\n4 Aether Hub\r\n4 Pathrazer of Ulamog\r\n3 Hashep Oasis\r\n4 Reanimate\r\n1 Okina, Temple to the Grandfathers\r\n4 Opulent Palace\r\n4 Vivid Grove\r\n1 Forest\r\n1 Necrotic Wound\r\n\r\n2 Scrabbling Claws\r\n1 Go for the Throat\r\n2 Seal of Primordium\r\n1 Aethersphere Harvester\r\n2 Lost Legacy\r\n2 Repudiate/Replicate\r\n1 Golden Demise\r\n3 Aetherize\r\n1 Blink of an Eye\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: GB X-Forwarded-For: 79.75.239.41, 162.158.34.84 Cf-Ray: 4ebf603689993639-MAN 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/75.0.3770.100 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9 Cookie: __cfduid=d9d1887332dbaa73ec29cfaa30ea6c5a11553469324; _ga=GA1.2.2121679503.1553469329; _gid=GA1.2.173153895.1561385719; _gat_gtag_UA_109131120_1=1; session=.eJx9UWFPwjAQ_S_3eTFbR2HyTXCJwRhBIQLGLHW9jcLaYtsNF8J_tyNBPpj4pcm7d33v7t0Rsj0ayRQqB0NnagyAcSkUDAtWWY84SiE1v2Jhc214JnwJ4ts4JDSKekkY9ikhSQIB_MOorKxFxS9OlS5L5N0EVquzYhxHcQDSlTqrLRrFJHoxjzlrhPUSmtVuQzLrmOuYLUkU_VrhxLULmb7ePQ4qJ0gjFb4hSa_9Tu_Q73QEludo7QVDNFs-HdJGT9JU9vrbVTzFdcPV6uUwX8yW_j9-74VBmzEfT0RpL-qe5IZQGpPB4Mp3ifXDbtsADBa-tPk1ef4cT9oil3R3rx4W5XqcoxnN66kqZ4e89SY-0b3f5t1H5-8giq52DsrCRwBnmcy1XQuMkBk0cArgT2qOmRL9mKquqtMP7luZSA.D_Ju3A.8tZV4IB_7qfq4aebO9vBIohOiuk Cf-Connecting-Ip: 79.75.239.41 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 761 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1561386545.029557, 3313, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["mtgdavis", 2902, "1561386545"]', 'Ooze Combo', 2902, None, None, None, None, None, None, None] (slow_query, 159.5, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd9d1887332dbaa73ec29cfaa30ea6c5a11553469324', '_ga': 'GA1.2.2121679503.1553469329', '_gid': 'GA1.2.173153895.1561385719', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UWFPwjAQ_S_3eTFbR2HyTXCJwRhBIQLGLHW9jcLaYtsNF8J_tyNBPpj4pcm7d33v7t0Rsj0ayRQqB0NnagyAcSkUDAtWWY84SiE1v2Jhc214JnwJ4ts4JDSKekkY9ikhSQIB_MOorKxFxS9OlS5L5N0EVquzYhxHcQDSlTqrLRrFJHoxjzlrhPUSmtVuQzLrmOuYLUkU_VrhxLULmb7ePQ4qJ0gjFb4hSa_9Tu_Q73QEludo7QVDNFs-HdJGT9JU9vrbVTzFdcPV6uUwX8yW_j9-74VBmzEfT0RpL-qe5IZQGpPB4Mp3ifXDbtsADBa-tPk1ef4cT9oil3R3rx4W5XqcoxnN66kqZ4e89SY-0b3f5t1H5-8giq52DsrCRwBnmcy1XQuMkBk0cArgT2qOmRL9mKquqtMP7luZSA.D_Jvpg.JQtQiJFztkejHMZc8mGDXV2-pI4'} Endpoint: add_signup View Args: {} Person: 393025114800652288 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'mtgdavis', 'name': 'Ooze Combo', 'decklist': "4 Hermit Druid\r\n4 Hapless Researcher\r\n1 Centaur Garden\r\n3 Satyr Wayfinder\r\n4 Champion of Wits\r\n1 Whip of Erebos\r\n2 Haunted Dead\r\n4 Necrotic Ooze\r\n2 Phyrexian Devourer\r\n2 Triskelion\r\n4 Llanowar Wastes\r\n1 Memory's Journey\r\n2 Dread Return\r\n4 Aether Hub\r\n4 Pathrazer of Ulamog\r\n3 Hashep Oasis\r\n4 Reanimate\r\n1 Okina, Temple to the Grandfathers\r\n4 Opulent Palace\r\n4 Vivid Grove\r\n1 Forest\r\n1 Necrotic Wound\r\n\r\n2 Scrabbling Claws\r\n1 Go for the Throat\r\n2 Seal of Primordium\r\n1 Aethersphere Harvester\r\n2 Lost Legacy\r\n2 Repudiate/Replicate\r\n1 Golden Demise\r\n3 Aetherize\r\n1 Blink of an Eye\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: GB X-Forwarded-For: 79.75.239.41, 162.158.34.84 Cf-Ray: 4ebf64449e503639-MAN 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/75.0.3770.100 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9 Cookie: __cfduid=d9d1887332dbaa73ec29cfaa30ea6c5a11553469324; _ga=GA1.2.2121679503.1553469329; _gid=GA1.2.173153895.1561385719; _gat_gtag_UA_109131120_1=1; session=.eJx9UWFPwjAQ_S_3eTFbR2HyTXCJwRhBIQLGLHW9jcLaYtsNF8J_tyNBPpj4pcm7d33v7t0Rsj0ayRQqB0NnagyAcSkUDAtWWY84SiE1v2Jhc214JnwJ4ts4JDSKekkY9ikhSQIB_MOorKxFxS9OlS5L5N0EVquzYhxHcQDSlTqrLRrFJHoxjzlrhPUSmtVuQzLrmOuYLUkU_VrhxLULmb7ePQ4qJ0gjFb4hSa_9Tu_Q73QEludo7QVDNFs-HdJGT9JU9vrbVTzFdcPV6uUwX8yW_j9-74VBmzEfT0RpL-qe5IZQGpPB4Mp3ifXDbtsADBa-tPk1ef4cT9oil3R3rx4W5XqcoxnN66kqZ4e89SY-0b3f5t1H5-8giq52DsrCRwBnmcy1XQuMkBk0cArgT2qOmRL9mKquqtMP7luZSA.D_Jvpg.JQtQiJFztkejHMZc8mGDXV2-pI4 Cf-Connecting-Ip: 79.75.239.41 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 761 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1561386483.8981924, 3313, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["mtgdavis", 2902, "1561386484"]', 'Ooze Combo', 2902, None, None, None, None, None, None, None] (slow_query, 220.6, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd9d1887332dbaa73ec29cfaa30ea6c5a11553469324', '_ga': 'GA1.2.2121679503.1553469329', '_gid': 'GA1.2.173153895.1561385719', 'session': '.eJx9UWFPwjAQ_S_3eTFbR2HyTXCJwRhBIQLGLHW9jcLaYtsNF8J_tyNBPpj4pcm7d33v7t0Rsj0ayRQqB0NnagyAcSkUDAtWWY84SiE1v2Jhc214JnwJ4ts4JDSKekkY9ikhSQIB_MOorKxFxS9OlS5L5N0EVquzYhxHcQDSlTqrLRrFJHoxjzlrhPUSmtVuQzLrmOuYLUkU_VrhxLULmb7ePQ4qJ0gjFb4hSa_9Tu_Q73QEludo7QVDNFs-HdJGT9JU9vrbVTzFdcPV6uUwX8yW_j9-74VBmzEfT0RpL-qe5IZQGpPB4Mp3ifXDbtsADBa-tPk1ef4cT9oil3R3rx4W5XqcoxnN66kqZ4e89SY-0b3f5t1H5-8giq52DsrCRwBnmcy1XQuMkBk0cArgT2qOmRL9mKquqtMP7luZSA.D_JvRQ.h8mrc5pKMiwZr9TkV4thhcRvFaI'} Endpoint: add_signup View Args: {} Person: 393025114800652288 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'mtgdavis', 'name': 'Ooze Combo', 'decklist': "4 Hermit Druid\r\n4 Hapless Researcher\r\n1 Centaur Garden\r\n3 Satyr Wayfinder\r\n4 Champion of Wits\r\n1 Whip of Erebos\r\n2 Haunted Dead\r\n4 Necrotic Ooze\r\n2 Phyrexian Devourer\r\n2 Triskelion\r\n4 Llanowar Wastes\r\n1 Memory's Journey\r\n2 Dread Return\r\n4 Aether Hub\r\n4 Pathrazer of Ulamog\r\n3 Hashep Oasis\r\n4 Reanimate\r\n1 Okina, Temple to the Grandfathers\r\n4 Opulent Palace\r\n4 Vivid Grove\r\n1 Forest\r\n1 Necrotic Wound\r\n\r\n2 Scrabbling Claws\r\n1 Go for the Throat\r\n2 Seal of Primordium\r\n1 Aethersphere Harvester\r\n2 Lost Legacy\r\n2 Repudiate/Replicate\r\n1 Golden Demise\r\n3 Aetherize\r\n1 Blink of an Eye\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: GB X-Forwarded-For: 79.75.239.41, 162.158.34.84 Cf-Ray: 4ebf62c5cd323639-MAN 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/75.0.3770.100 Safari/537.36 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,application/signed-exchange;v=b3 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9 Cookie: __cfduid=d9d1887332dbaa73ec29cfaa30ea6c5a11553469324; _ga=GA1.2.2121679503.1553469329; _gid=GA1.2.173153895.1561385719; session=.eJx9UWFPwjAQ_S_3eTFbR2HyTXCJwRhBIQLGLHW9jcLaYtsNF8J_tyNBPpj4pcm7d33v7t0Rsj0ayRQqB0NnagyAcSkUDAtWWY84SiE1v2Jhc214JnwJ4ts4JDSKekkY9ikhSQIB_MOorKxFxS9OlS5L5N0EVquzYhxHcQDSlTqrLRrFJHoxjzlrhPUSmtVuQzLrmOuYLUkU_VrhxLULmb7ePQ4qJ0gjFb4hSa_9Tu_Q73QEludo7QVDNFs-HdJGT9JU9vrbVTzFdcPV6uUwX8yW_j9-74VBmzEfT0RpL-qe5IZQGpPB4Mp3ifXDbtsADBa-tPk1ef4cT9oil3R3rx4W5XqcoxnN66kqZ4e89SY-0b3f5t1H5-8giq52DsrCRwBnmcy1XQuMkBk0cArgT2qOmRL9mKquqtMP7luZSA.D_JvRQ.h8mrc5pKMiwZr9TkV4thhcRvFaI Cf-Connecting-Ip: 79.75.239.41 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 761 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite

vorpal-buildbot commented 5 years ago

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

[1561386344.0369956, 3313, 3, 'https://pennydreadfulmagic.com/competitions/2902/', '["mtgdavis", 2902, "1561386344"]', 'Ooze Combo', 2902, None, None, None, None, None, None, None] (slow_query, 360.5, mysql)

Reported on decksite by mysql-perf

Request Data

``` Request Method: POST Path: /signup/? Cookies: {'__cfduid': 'd9d1887332dbaa73ec29cfaa30ea6c5a11553469324', '_ga': 'GA1.2.2121679503.1553469329', '_gid': 'GA1.2.173153895.1561385719', '_gat_gtag_UA_109131120_1': '1', 'session': '.eJx9UWFPwjAQ_S_3eTFbR2HyTXCJwRhBIQLGLHW9jcLaYtsNF8J_tyNBPpj4pcm7d33v7t0Rsj0ayRQqB0NnagyAcSkUDAtWWY84SiE1v2Jhc214JnwJ4ts4JDSKekkY9ikhSQIB_MOorKxFxS9OlS5L5N0EVquzYhxHcQDSlTqrLRrFJHoxjzlrhPUSmtVuQzLrmOuYLUkU_VrhxLULmb7ePQ4qJ0gjFb4hSa_9Tu_Q73QEludo7QVDNFs-HdJGT9JU9vrbVTzFdcPV6uUwX8yW_j9-74VBmzEfT0RpL-qe5IZQGpPB4Mp3ifXDbtsADBa-tPk1ef4cT9oil3R3rx4W5XqcoxnN66kqZ4e89SY-0b3f5t1H5-8giq52DsrCRwBnmcy1XQuMkBk0cArgT2qOmRL9mKquqtMP7luZSA.D_Ju3A.8tZV4IB_7qfq4aebO9vBIohOiuk'} Endpoint: add_signup View Args: {} Person: 393025114800652288 Referrer: https://pennydreadfulmagic.com/signup/ Request Data: {'mtgo_username': 'mtgdavis', 'name': 'Ooze Combo', 'decklist': "4 Hermit Druid\r\n4 Hapless Researcher\r\n1 Centaur Garden\r\n3 Satyr Wayfinder\r\n4 Champion of Wits\r\n1 Whip of Erebos\r\n2 Haunted Dead\r\n4 Necrotic Ooze\r\n2 Phyrexian Devourer\r\n2 Triskelion\r\n4 Llanowar Wastes\r\n1 Memory's Journey\r\n2 Dread Return\r\n4 Aether Hub\r\n4 Pathrazer of Ulamog\r\n3 Hashep Oasis\r\n4 Reanimate\r\n1 Okina, Temple to the Grandfathers\r\n4 Opulent Palace\r\n4 Vivid Grove\r\n1 Forest\r\n1 Necrotic Wound\r\n\r\n2 Scrabbling Claws\r\n1 Go for the Throat\r\n2 Seal of Primordium\r\n1 Aethersphere Harvester\r\n2 Lost Legacy\r\n2 Repudiate/Replicate\r\n1 Golden Demise\r\n3 Aetherize\r\n1 Blink of an Eye\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: GB X-Forwarded-For: 79.75.239.41, 162.158.34.84 Cf-Ray: 4ebf5f5afa273639-MAN 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/75.0.3770.100 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 Referer: https://pennydreadfulmagic.com/signup/ Accept-Language: en-US,en;q=0.9 Cookie: __cfduid=d9d1887332dbaa73ec29cfaa30ea6c5a11553469324; _ga=GA1.2.2121679503.1553469329; _gid=GA1.2.173153895.1561385719; _gat_gtag_UA_109131120_1=1; session=.eJx9UWFPwjAQ_S_3eTFbR2HyTXCJwRhBIQLGLHW9jcLaYtsNF8J_tyNBPpj4pcm7d33v7t0Rsj0ayRQqB0NnagyAcSkUDAtWWY84SiE1v2Jhc214JnwJ4ts4JDSKekkY9ikhSQIB_MOorKxFxS9OlS5L5N0EVquzYhxHcQDSlTqrLRrFJHoxjzlrhPUSmtVuQzLrmOuYLUkU_VrhxLULmb7ePQ4qJ0gjFb4hSa_9Tu_Q73QEludo7QVDNFs-HdJGT9JU9vrbVTzFdcPV6uUwX8yW_j9-74VBmzEfT0RpL-qe5IZQGpPB4Mp3ifXDbtsADBa-tPk1ef4cT9oil3R3rx4W5XqcoxnN66kqZ4e89SY-0b3f5t1H5-8giq52DsrCRwBnmcy1XQuMkBk0cArgT2qOmRL9mKquqtMP7luZSA.D_Ju3A.8tZV4IB_7qfq4aebO9vBIohOiuk Cf-Connecting-Ip: 79.75.239.41 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 761 ```

Location Hash: 93c669e857d27fbe0444700a101cbe0efd0ceb86

Labels: decksite