Exceeded slow_query limit (0.6 > 0.5) in mysql: ```

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (0.6 > 0.5) in mysql: ``` #61541

Open vorpal-buildbot opened 1 year ago

vorpal-buildbot commented 1 year ago

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.6, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff7005fd1b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff71f39d5b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.6 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.6, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff7368cefb72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff73f0fa2b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff740da00b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff7422bd1b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff7497c84b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff74b4ecfb72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff74ce885b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.8 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff74f8b7db72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.9 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.9, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff74e3a04b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff75beac1b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff75d1c16b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '287'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff75e0d3fb72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=287; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTMqg.7282f2rGmdVf4M8gc9vB23VfBmo Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.6 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.6, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '300'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTNAA.K-XKUBLul33Ncx1st5txGKwpPkw')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff940ee04b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=300; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTNAA.K-XKUBLul33Ncx1st5txGKwpPkw Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.6 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.6, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '300'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTNAA.K-XKUBLul33Ncx1st5txGKwpPkw')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff94bb9e5b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=300; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTNAA.K-XKUBLul33Ncx1st5txGKwpPkw Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('views', '300'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTNAA.K-XKUBLul33Ncx1st5txGKwpPkw')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceff9603987b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; views=300; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTNAA.K-XKUBLul33Ncx1st5txGKwpPkw Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.6 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.6, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTNQg.RQjSMTuod3v85d8ca1d0KFHbnGU'), ('views', '314')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceffb451b1cb72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTNQg.RQjSMTuod3v85d8ca1d0KFHbnGU; views=314 Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: GET Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '217073'), ('session', '.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTNZQ.Cy72rbMB1CNe3EaZD7MGtihbmUI'), ('views', '317')]) Endpoint: matchups View Args: {} Person: 343361125699813376 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 178.85.220.176 Cf-Ray: 7ceffb7d9c41b72b-AMS X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9,nl;q=0.8 Cookie: hide_intro=True; hide_intro=True; page_size=20; deck_id=217073; session=.eJx1UctuwjAQ_BefUxTHwcTcoEhQiQoKVR9UVWQlm2BI7GA7lIf49zpUNIeqx9nZnZ2dPaO4Al1yCdKivtU1eIinpZCon_HCOJRCKUqVtliYROk0Fq6ESEgIxTjoUsYiTEiPorajUAkvwHWBvBsPHfH_iJBxXosivVkoVJ5D2lgzSl5XRRQzD5U2V3FtQEteNsoOZ1xixhoRxWu7DmJjuW24Gu8B5lP1bKA33Wbv1exhfqgmmc6DyebY9lu1BXfuGfEkAWNuGC1OwHeLld533-Yvo-UqCV6z2SGsiNg8TlI3D4dKaDAxd8lhSlnY8wPMOgz7UchoyzdhUj-MfN9DGjJXWv8uYZP5YCfI6WtpRvmY-iRI6lFIgvu8HFRPbomLsnLXfKBrPqazUU6uidI9TGTNGT8E-vTQVTS2x2YADYFr0OjioT8pWq5zcKZlXRSXb05dpcs.ZHTNZQ.Cy72rbMB1CNe3EaZD7MGtihbmUI; views=317 Priority: u=0, i Cf-Connecting-Ip: 178.85.220.176 Cf-Ipcountry: NL Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.6 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.6, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: HEAD Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([]) Endpoint: matchups View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 51.15.164.30 Cf-Ray: 7cf0014b7d0799b4-CDG X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36 Cf-Connecting-Ip: 51.15.164.30 Cf-Ipcountry: FR Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.6 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.6, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: HEAD Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([]) Endpoint: matchups View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 51.15.164.30 Cf-Ray: 7cf0015f7cf8020e-CDG X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36 Cf-Connecting-Ip: 51.15.164.30 Cf-Ipcountry: FR Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.6 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.6, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: HEAD Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([]) Endpoint: matchups View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 51.15.164.30 Cf-Ray: 7cf0016d5e4e0076-CDG X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36 Cf-Connecting-Ip: 51.15.164.30 Cf-Ipcountry: FR Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.7 > 0.5) in mysql: ```

    SELECT
        p.id,
        LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
        p.mtgo_username,
        p.tappedout_username,
        p.mtggoldfish_username,
        p.discord_id,
        p.elo,
        p.locale,
        p.banned,
        SUM(1) AS num_decks,
        SUM(dc.wins) AS wins,
        SUM(dc.losses) AS losses,
        SUM(dc.draws) AS draws,
        SUM(dc.wins - dc.losses) AS record,
        SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
        SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
        SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
        IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
        SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
    FROM
        person AS p
    LEFT JOIN
        deck AS d ON d.person_id = p.id
    LEFT JOIN
        deck_cache AS dc ON d.id = dc.deck_id

    WHERE
        (p.mtgo_username IS NOT NULL) AND (TRUE)
    GROUP BY
        p.id
    ORDER BY
        num_decks DESC, p.name

```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cd4b1e49731066455c4d420e4d958e1a5ada37d6

Request Data

``` Request Method: HEAD Path: /matchups/?season_id=&hero_archetype_id=450&hero_person_id=&hero_card=&enemy_archetype_id=&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([]) Endpoint: matchups View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 217.182.175.162 Cf-Ray: 7cf00179ec29040d-CDG X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36 Cf-Connecting-Ip: 217.182.175.162 Cf-Ipcountry: FR Cdn-Loop: cloudflare ```

Labels: decksite