search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (1.2 > 1.0) in mysql: ``` #63361

Open vorpal-buildbot opened 6 months ago

vorpal-buildbot commented 6 months 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,
        COUNT(*) OVER () AS total
    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, 1.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 005bf57dad8309e697e3437c0b04494cb813d697

Request Data ``` Request Method: GET Path: /matchups/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', ''), ('page_size', '20'), ('session', '.eJx1UV1PwjAU_S99nmTfG7yNZShqcAE1ojFL2e7GZG2XthsQwn-3xeAejG-999x7zrmnJ5S1wAmmQCWaSN6BgXBBaoomJW6EqgogNWHFUNciZ7zIatVCrmPZtmmHwdgcm6Zjhx4aJhqW4wbUFNCbl5UC_l-paVZ1dVNcLTSsqqDQ1gSjFykrsC0DEVmxrBPAKSaaGe8wwVJ0ioLhTm7tTEgsNfK4T_ar6HjYPuRvs3SJY8dr-3Q-Xke2w6bDvGQ7UMeeEM5zEOJao_tNEiSLWVwt3bSfdtBLv81f02i-76tbbRkObc1BZFhqc5bnOWEQBCPfMV3fsQZcR-mbbmiaBuJQqtb2V4SR9R1tF2X4VD2XfipWcWQ5GyzfySKeJUpEBdmqaz7QJR0x-mKKTgepvqsuj-r5A6BPA11IM3nUC2gKmANHZwP9yVBiXoEyTbumOX8DbsOkvg.ZknFuQ.Jss2tzNFnEusL9dCOuEHiQKmV_8'), ('views', '125')]) Endpoint: matchups View Args: {} Person: 431220287909003285 Referrer: https://pennydreadfulmagic.com/seasons/8/cards/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 2603:6010:ad03:f823:7857:d3fa:a3b6:f7f6 Cf-Ray: 88630b7e6bca0843-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Chromium";v="124", "Microsoft Edge";v="124", "Not-A.Brand";v="99" 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/124.0.0.0 Safari/537.36 Edg/124.0.0.0 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/seasons/8/cards/ Accept-Language: en-US,en;q=0.9 Priority: u=0, i Cookie: hide_intro=True; deck_id=; page_size=20; session=.eJx1UV1PwjAU_S99nmTfG7yNZShqcAE1ojFL2e7GZG2XthsQwn-3xeAejG-999x7zrmnJ5S1wAmmQCWaSN6BgXBBaoomJW6EqgogNWHFUNciZ7zIatVCrmPZtmmHwdgcm6Zjhx4aJhqW4wbUFNCbl5UC_l-paVZ1dVNcLTSsqqDQ1gSjFykrsC0DEVmxrBPAKSaaGe8wwVJ0ioLhTm7tTEgsNfK4T_ar6HjYPuRvs3SJY8dr-3Q-Xke2w6bDvGQ7UMeeEM5zEOJao_tNEiSLWVwt3bSfdtBLv81f02i-76tbbRkObc1BZFhqc5bnOWEQBCPfMV3fsQZcR-mbbmiaBuJQqtb2V4SR9R1tF2X4VD2XfipWcWQ5GyzfySKeJUpEBdmqaz7QJR0x-mKKTgepvqsuj-r5A6BPA11IM3nUC2gKmANHZwP9yVBiXoEyTbumOX8DbsOkvg.ZknFuQ.Jss2tzNFnEusL9dCOuEHiQKmV_8; views=125 Cf-Connecting-Ip: 2603:6010:ad03:f823:7857:d3fa:a3b6:f7f6 Cdn-Loop: cloudflare Cf-Ipcountry: US ```
vorpal-buildbot commented 6 months ago

Exceeded slow_query limit (1.1 > 1.0) 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,
        COUNT(*) OVER () AS total
    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, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 005bf57dad8309e697e3437c0b04494cb813d697

Request Data ``` Request Method: GET Path: /matchups/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('session', '.eJx1UctOwzAQ_BefA3LSNna4UVSJqqU8KkCAUOQm28RJbAfboUDFv7MpantA3Lw7uzM74y1JW7BKaNCenHnbQUBErqQmZ2vROKxyUFKZfA_m0mXG5qnEDmGMshGP6CgJk2EcDnhMjhONyUQDOAX65H6JwP8rUqdFJ5uDSGOKAvL-Mmf0ToozHgdE-cKknQOrheqZfQkb4bNyI3QOFomM6HwZpc4L3-MfF3Xl8_fnx4G5XnEznwhTf9nrerVYzJ6647w3NaDjLRFZBs7ta1IP2Gw6DWt6uZTtcr66etZeDcrNw5gl4wnuw0crLbhUYHghOuNsSCk_jaKIh2F0xPs8YzrklAbEwhpb5UFk1cS0uqtCFb3BJpuyc7O-Ubdwp1mdzCoUwThbdPNCdhk57Pw-TiuDvH2u-Hly_UleA7IjTf1nv0DGICzG8h2QP0l6YQvAo3XXNN8_xU6oLw.Ziv_Cg.AC_lL2I-F9Dj54IdcerOTUCKsCc'), ('session', '.eJx1UctOwzAQ_BefA3LSNna4UVSJqqU8KkCAUOQm28RJbAfboUDFv7MpantA3Lw7uzM74y1JW7BKaNCenHnbQUBErqQmZ2vROKxyUFKZfA_m0mXG5qnEDmGMshGP6CgJk2EcDnhMjhONyUQDOAX65H6JwP8rUqdFJ5uDSGOKAvL-Mmf0ToozHgdE-cKknQOrheqZfQkb4bNyI3QOFomM6HwZpc4L3-MfF3Xl8_fnx4G5XnEznwhTf9nrerVYzJ6647w3NaDjLRFZBs7ta1IP2Gw6DWt6uZTtcr66etZeDcrNw5gl4wnuw0crLbhUYHghOuNsSCk_jaKIh2F0xPs8YzrklAbEwhpb5UFk1cS0uqtCFb3BJpuyc7O-Ubdwp1mdzCoUwThbdPNCdhk57Pw-TiuDvH2u-Hly_UleA7IjTf1nv0DGICzG8h2QP0l6YQvAo3XXNN8_xU6oLw.ZknPzQ.x20XUubKl54CGK1lFieUmBV2N3A'), ('page_size', '20'), ('views', '714')]) Endpoint: matchups View Args: {} Person: 770758205919461386 Referrer: https://pennydreadfulmagic.com/people/catacuio/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 47.26.243.253 Cf-Ray: 88634ab6ccf3e270-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Chromium";v="124", "Google Chrome";v="124", "Not-A.Brand";v="99" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 Dnt: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.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/people/catacuio/ Accept-Language: en-US,en;q=0.9 Priority: u=0, i Cookie: hide_intro=True; hide_intro=True; session=.eJx1UctOwzAQ_BefA3LSNna4UVSJqqU8KkCAUOQm28RJbAfboUDFv7MpantA3Lw7uzM74y1JW7BKaNCenHnbQUBErqQmZ2vROKxyUFKZfA_m0mXG5qnEDmGMshGP6CgJk2EcDnhMjhONyUQDOAX65H6JwP8rUqdFJ5uDSGOKAvL-Mmf0ToozHgdE-cKknQOrheqZfQkb4bNyI3QOFomM6HwZpc4L3-MfF3Xl8_fnx4G5XnEznwhTf9nrerVYzJ6647w3NaDjLRFZBs7ta1IP2Gw6DWt6uZTtcr66etZeDcrNw5gl4wnuw0crLbhUYHghOuNsSCk_jaKIh2F0xPs8YzrklAbEwhpb5UFk1cS0uqtCFb3BJpuyc7O-Ubdwp1mdzCoUwThbdPNCdhk57Pw-TiuDvH2u-Hly_UleA7IjTf1nv0DGICzG8h2QP0l6YQvAo3XXNN8_xU6oLw.Ziv_Cg.AC_lL2I-F9Dj54IdcerOTUCKsCc; page_size=20; session=.eJx1UctOwzAQ_BefA3LSNna4UVSJqqU8KkCAUOQm28RJbAfboUDFv7MpantA3Lw7uzM74y1JW7BKaNCenHnbQUBErqQmZ2vROKxyUFKZfA_m0mXG5qnEDmGMshGP6CgJk2EcDnhMjhONyUQDOAX65H6JwP8rUqdFJ5uDSGOKAvL-Mmf0ToozHgdE-cKknQOrheqZfQkb4bNyI3QOFomM6HwZpc4L3-MfF3Xl8_fnx4G5XnEznwhTf9nrerVYzJ6647w3NaDjLRFZBs7ta1IP2Gw6DWt6uZTtcr66etZeDcrNw5gl4wnuw0crLbhUYHghOuNsSCk_jaKIh2F0xPs8YzrklAbEwhpb5UFk1cS0uqtCFb3BJpuyc7O-Ubdwp1mdzCoUwThbdPNCdhk57Pw-TiuDvH2u-Hly_UleA7IjTf1nv0DGICzG8h2QP0l6YQvAo3XXNN8_xU6oLw.ZknPzQ.x20XUubKl54CGK1lFieUmBV2N3A; views=714 Cf-Connecting-Ip: 47.26.243.253 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 6 months ago

Exceeded slow_query limit (1.1 > 1.0) 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,
        COUNT(*) OVER () AS total
    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, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 005bf57dad8309e697e3437c0b04494cb813d697

Request Data ``` Request Method: GET Path: /matchups/? Cookies: ImmutableMultiDict([]) Endpoint: matchups View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 52.167.144.223 Cf-Ray: 886357897fcc824a-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36 Accept: */* From: bingbot(at)microsoft.com Cf-Connecting-Ip: 52.167.144.223 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: Search Engine; decksite

vorpal-buildbot commented 6 months ago

Exceeded slow_query limit (1.0 > 1.0) 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,
        COUNT(*) OVER () AS total
    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, 1.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 005bf57dad8309e697e3437c0b04494cb813d697

Request Data ``` Request Method: GET Path: /matchups/? Cookies: ImmutableMultiDict([]) Endpoint: matchups View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 79.40.163.173 Cf-Ray: 8864a2479db24d8f-FRA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36 Accept: */* Sec-Fetch-Site: none Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Accept-Language: it-IT,it;q=0.9,en-US;q=0.8,en;q=0.7 Priority: u=1, i Cf-Connecting-Ip: 79.40.163.173 Cdn-Loop: cloudflare Cf-Ipcountry: IT ```

Labels: decksite

vorpal-buildbot commented 6 months ago

Exceeded slow_query limit (1.0 > 1.0) 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,
        COUNT(*) OVER () AS total
    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, 1.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 005bf57dad8309e697e3437c0b04494cb813d697

Request Data ``` Request Method: GET Path: /matchups/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('hide_intro', 'True'), ('session', '.eJx1UctOwzAQ_BefA3LSNna4UVSJqqU8KkCAUOQm28RJbAfboUDFv7MpantA3Lw7uzM74y1JW7BKaNCenHnbQUBErqQmZ2vROKxyUFKZfA_m0mXG5qnEDmGMshGP6CgJk2EcDnhMjhONyUQDOAX65H6JwP8rUqdFJ5uDSGOKAvL-Mmf0ToozHgdE-cKknQOrheqZfQkb4bNyI3QOFomM6HwZpc4L3-MfF3Xl8_fnx4G5XnEznwhTf9nrerVYzJ6647w3NaDjLRFZBs7ta1IP2Gw6DWt6uZTtcr66etZeDcrNw5gl4wnuw0crLbhUYHghOuNsSCk_jaKIh2F0xPs8YzrklAbEwhpb5UFk1cS0uqtCFb3BJpuyc7O-Ubdwp1mdzCoUwThbdPNCdhk57Pw-TiuDvH2u-Hly_UleA7IjTf1nv0DGICzG8h2QP0l6YQvAo3XXNN8_xU6oLw.Ziv_Cg.AC_lL2I-F9Dj54IdcerOTUCKsCc'), ('session', '.eJx1UctOwzAQ_BefA3LSNna4UVSJqqU8KkCAUOQm28RJbAfboUDFv7MpantA3Lw7uzM74y1JW7BKaNCenHnbQUBErqQmZ2vROKxyUFKZfA_m0mXG5qnEDmGMshGP6CgJk2EcDnhMjhONyUQDOAX65H6JwP8rUqdFJ5uDSGOKAvL-Mmf0ToozHgdE-cKknQOrheqZfQkb4bNyI3QOFomM6HwZpc4L3-MfF3Xl8_fnx4G5XnEznwhTf9nrerVYzJ6647w3NaDjLRFZBs7ta1IP2Gw6DWt6uZTtcr66etZeDcrNw5gl4wnuw0crLbhUYHghOuNsSCk_jaKIh2F0xPs8YzrklAbEwhpb5UFk1cS0uqtCFb3BJpuyc7O-Ubdwp1mdzCoUwThbdPNCdhk57Pw-TiuDvH2u-Hly_UleA7IjTf1nv0DGICzG8h2QP0l6YQvAo3XXNN8_xU6oLw.Zko_Ug.RUagze_dTC-KV2KLzEoTmhQhIHY'), ('page_size', '20'), ('views', '159')]) Endpoint: matchups View Args: {} Person: 770758205919461386 Referrer: https://pennydreadfulmagic.com/people/id/8786/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 47.26.243.253 Cf-Ray: 8866038ab95e2aba-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Chromium";v="124", "Google Chrome";v="124", "Not-A.Brand";v="99" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 Dnt: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.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/people/id/8786/ Accept-Language: en-US,en;q=0.9 Priority: u=0, i Cookie: hide_intro=True; hide_intro=True; session=.eJx1UctOwzAQ_BefA3LSNna4UVSJqqU8KkCAUOQm28RJbAfboUDFv7MpantA3Lw7uzM74y1JW7BKaNCenHnbQUBErqQmZ2vROKxyUFKZfA_m0mXG5qnEDmGMshGP6CgJk2EcDnhMjhONyUQDOAX65H6JwP8rUqdFJ5uDSGOKAvL-Mmf0ToozHgdE-cKknQOrheqZfQkb4bNyI3QOFomM6HwZpc4L3-MfF3Xl8_fnx4G5XnEznwhTf9nrerVYzJ6647w3NaDjLRFZBs7ta1IP2Gw6DWt6uZTtcr66etZeDcrNw5gl4wnuw0crLbhUYHghOuNsSCk_jaKIh2F0xPs8YzrklAbEwhpb5UFk1cS0uqtCFb3BJpuyc7O-Ubdwp1mdzCoUwThbdPNCdhk57Pw-TiuDvH2u-Hly_UleA7IjTf1nv0DGICzG8h2QP0l6YQvAo3XXNN8_xU6oLw.Ziv_Cg.AC_lL2I-F9Dj54IdcerOTUCKsCc; page_size=20; views=159; session=.eJx1UctOwzAQ_BefA3LSNna4UVSJqqU8KkCAUOQm28RJbAfboUDFv7MpantA3Lw7uzM74y1JW7BKaNCenHnbQUBErqQmZ2vROKxyUFKZfA_m0mXG5qnEDmGMshGP6CgJk2EcDnhMjhONyUQDOAX65H6JwP8rUqdFJ5uDSGOKAvL-Mmf0ToozHgdE-cKknQOrheqZfQkb4bNyI3QOFomM6HwZpc4L3-MfF3Xl8_fnx4G5XnEznwhTf9nrerVYzJ6647w3NaDjLRFZBs7ta1IP2Gw6DWt6uZTtcr66etZeDcrNw5gl4wnuw0crLbhUYHghOuNsSCk_jaKIh2F0xPs8YzrklAbEwhpb5UFk1cS0uqtCFb3BJpuyc7O-Ubdwp1mdzCoUwThbdPNCdhk57Pw-TiuDvH2u-Hly_UleA7IjTf1nv0DGICzG8h2QP0l6YQvAo3XXNN8_xU6oLw.Zko_Ug.RUagze_dTC-KV2KLzEoTmhQhIHY Cf-Connecting-Ip: 47.26.243.253 Cdn-Loop: cloudflare Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 6 months ago

Exceeded slow_query limit (1.0 > 1.0) 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,
        COUNT(*) OVER () AS total
    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, 1.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 005bf57dad8309e697e3437c0b04494cb813d697

Request Data ``` Request Method: HEAD Path: /matchups/? Cookies: ImmutableMultiDict([]) Endpoint: matchups View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 217.182.175.162 Cf-Ray: 88660b793f3e2a2f-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 Cdn-Loop: cloudflare Cf-Ipcountry: FR ```

Labels: decksite

vorpal-buildbot commented 6 months ago

Exceeded slow_query limit (1.3 > 1.0) 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,
        COUNT(*) OVER () AS total
    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, 1.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 005bf57dad8309e697e3437c0b04494cb813d697

Request Data ``` Request Method: HEAD Path: /matchups/? Cookies: ImmutableMultiDict([]) Endpoint: matchups View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip, br X-Forwarded-For: 217.182.175.162 Cf-Ray: 88660b88edc46f7c-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 Cdn-Loop: cloudflare Cf-Ipcountry: FR ```

Labels: decksite