search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (248.5 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) #59248

Open vorpal-buildbot opened 2 years ago

vorpal-buildbot commented 2 years ago 
    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1056
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1056
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 248.5, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '186209'), ('views', '16031'), ('session', '.eJx1UctuwjAQ_BefU5SkJsTcCn1ARegBpUCrKjLJ4hgSO7KdUkD8e51UQFWpN8_ujGd39oiSClRJBQiD-kbV4CCalVycQQYlL2V2gVynUmUJtxXkkW6AMfF6buhh7PpBF10ZhUxpAZYF4iae2cb_Ei4SVvPiYvJLihrEGGTNmFqK1tjDtw4qDZNJrUEJWjbcFd2CMoRYhaS1yf1EG2qazpiN62quOfOZ7xdesRNkMq04WYZxtKFXvpFba9g_IpqmoPUZI3WfVUU0DA4uGc330-g5iuqH1QJitf58u7N6-Kq4Ap1QG6EX4JDYxQjudHsh9v1ruwk1cHHoug5SsLal_OKRL_N6F4_kYDFdHTzxctg89l6f2HBSyXAmrYcNtbLLvKM2KW0rP4_ORnLRpmsvyNd79OGg9tPE7BsBGgBVoNDJQX8TNFQxsCOLuihO36z7qMg.Ys3oNQ.EKbGXY-q18pBqbriohHpRSdegjg')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1056', 'include': '4 Kiln Fiend\r\n2 Festival Crasher\r\n1 Ancestral Anger', 'exclude': '1 Swamp\r\n1 Island\r\n1 Sulfur Falls\r\n1 Temple of Epiphany\r\n1 Shivan Reef\r\n1 Forest\r\n1 Plains\r\n1 Deeproot Champion'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 160.72.30.84, 172.68.132.168 Cf-Ray: 729ce43138b26841-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=186209; views=16031; session=.eJx1UctuwjAQ_BefU5SkJsTcCn1ARegBpUCrKjLJ4hgSO7KdUkD8e51UQFWpN8_ujGd39oiSClRJBQiD-kbV4CCalVycQQYlL2V2gVynUmUJtxXkkW6AMfF6buhh7PpBF10ZhUxpAZYF4iae2cb_Ei4SVvPiYvJLihrEGGTNmFqK1tjDtw4qDZNJrUEJWjbcFd2CMoRYhaS1yf1EG2qazpiN62quOfOZ7xdesRNkMq04WYZxtKFXvpFba9g_IpqmoPUZI3WfVUU0DA4uGc330-g5iuqH1QJitf58u7N6-Kq4Ap1QG6EX4JDYxQjudHsh9v1ruwk1cHHoug5SsLal_OKRL_N6F4_kYDFdHTzxctg89l6f2HBSyXAmrYcNtbLLvKM2KW0rP4_ORnLRpmsvyNd79OGg9tPE7BsBGgBVoNDJQX8TNFQxsCOLuihO36z7qMg.Ys3oNQ.EKbGXY-q18pBqbriohHpRSdegjg Cf-Connecting-Ip: 160.72.30.84 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 228 Connection: Keep-Alive ```
vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (126.7 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1060
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1060
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 126.7, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '186209'), ('views', '16052'), ('session', '.eJx1UctuwjAQ_BefU5SkJsTcCn1ARegBpUCrKjLJ4hgSO7KdUkD8e51UQFWpN8_ujGd39oiSClRJBQiD-kbV4CCalVycQQYlL2V2gVynUmUJtxXkkW6AMfF6buhh7PpBF10ZhUxpAZYF4iae2cb_Ei4SVvPiYvJLihrEGGTNmFqK1tjDtw4qDZNJrUEJWjbcFd2CMoRYhaS1yf1EG2qazpiN62quOfOZ7xdesRNkMq04WYZxtKFXvpFba9g_IpqmoPUZI3WfVUU0DA4uGc330-g5iuqH1QJitf58u7N6-Kq4Ap1QG6EX4JDYxQjudHsh9v1ruwk1cHHoug5SsLal_OKRL_N6F4_kYDFdHTzxctg89l6f2HBSyXAmrYcNtbLLvKM2KW0rP4_ORnLRpmsvyNd79OGg9tPE7BsBGgBVoNDJQX8TNFQxsCOLuihO36z7qMg.Ys3shg.Blsp9za88u7bJVCyWfXyyAp4j8g')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1060', 'include': "4 Seething Song\r\n4 Mind's Desire", 'exclude': '1 Plains\r\n1 Swamp\r\n1 Forest\r\n1 Dragonstorm\r\n1 Tendrils of Agony'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 160.72.30.84, 172.68.132.172 Cf-Ray: 729cff80cfb05ffe-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=186209; views=16052; session=.eJx1UctuwjAQ_BefU5SkJsTcCn1ARegBpUCrKjLJ4hgSO7KdUkD8e51UQFWpN8_ujGd39oiSClRJBQiD-kbV4CCalVycQQYlL2V2gVynUmUJtxXkkW6AMfF6buhh7PpBF10ZhUxpAZYF4iae2cb_Ei4SVvPiYvJLihrEGGTNmFqK1tjDtw4qDZNJrUEJWjbcFd2CMoRYhaS1yf1EG2qazpiN62quOfOZ7xdesRNkMq04WYZxtKFXvpFba9g_IpqmoPUZI3WfVUU0DA4uGc330-g5iuqH1QJitf58u7N6-Kq4Ap1QG6EX4JDYxQjudHsh9v1ruwk1cHHoug5SsLal_OKRL_N6F4_kYDFdHTzxctg89l6f2HBSyXAmrYcNtbLLvKM2KW0rP4_ORnLRpmsvyNd79OGg9tPE7BsBGgBVoNDJQX8TNFQxsCOLuihO36z7qMg.Ys3shg.Blsp9za88u7bJVCyWfXyyAp4j8g Cf-Connecting-Ip: 160.72.30.84 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 145 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (197.9 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1060
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1060
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 197.9, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '186209'), ('views', '16052'), ('session', '.eJx1UctuwjAQ_BefU5SkJsTcCn1ARegBpUCrKjLJ4hgSO7KdUkD8e51UQFWpN8_ujGd39oiSClRJBQiD-kbV4CCalVycQQYlL2V2gVynUmUJtxXkkW6AMfF6buhh7PpBF10ZhUxpAZYF4iae2cb_Ei4SVvPiYvJLihrEGGTNmFqK1tjDtw4qDZNJrUEJWjbcFd2CMoRYhaS1yf1EG2qazpiN62quOfOZ7xdesRNkMq04WYZxtKFXvpFba9g_IpqmoPUZI3WfVUU0DA4uGc330-g5iuqH1QJitf58u7N6-Kq4Ap1QG6EX4JDYxQjudHsh9v1ruwk1cHHoug5SsLal_OKRL_N6F4_kYDFdHTzxctg89l6f2HBSyXAmrYcNtbLLvKM2KW0rP4_ORnLRpmsvyNd79OGg9tPE7BsBGgBVoNDJQX8TNFQxsCOLuihO36z7qMg.Ys3shg.Blsp9za88u7bJVCyWfXyyAp4j8g')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1060', 'include': "4 Seething Song\r\n4 Mind's Desire", 'exclude': '1 Plains\r\n1 Swamp\r\n1 Forest\r\n1 Dragonstorm\r\n1 Tendrils of Agony'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 160.72.30.84, 172.68.133.167 Cf-Ray: 729d0982cf216841-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=186209; views=16052; session=.eJx1UctuwjAQ_BefU5SkJsTcCn1ARegBpUCrKjLJ4hgSO7KdUkD8e51UQFWpN8_ujGd39oiSClRJBQiD-kbV4CCalVycQQYlL2V2gVynUmUJtxXkkW6AMfF6buhh7PpBF10ZhUxpAZYF4iae2cb_Ei4SVvPiYvJLihrEGGTNmFqK1tjDtw4qDZNJrUEJWjbcFd2CMoRYhaS1yf1EG2qazpiN62quOfOZ7xdesRNkMq04WYZxtKFXvpFba9g_IpqmoPUZI3WfVUU0DA4uGc330-g5iuqH1QJitf58u7N6-Kq4Ap1QG6EX4JDYxQjudHsh9v1ruwk1cHHoug5SsLal_OKRL_N6F4_kYDFdHTzxctg89l6f2HBSyXAmrYcNtbLLvKM2KW0rP4_ORnLRpmsvyNd79OGg9tPE7BsBGgBVoNDJQX8TNFQxsCOLuihO36z7qMg.Ys3shg.Blsp9za88u7bJVCyWfXyyAp4j8g Cf-Connecting-Ip: 160.72.30.84 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 145 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (71.8 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1060
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1060
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 71.8, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('views', '7'), ('session', '.eJx1Ue9PwjAQ_V_6eZLuBxvzm4QIzKDBRSUYs5TuGN3WdradOgj_ux0JkJj48d29e-_u3QFlDShOBAiDbo1qwUEk50ycQQ6ccZlfINNUqjxjtoLceBgGQexGeOQGAfbCIboyaklJDZYF4uYltY3_R5jIipbVF5NaFgXk_WJaipOVG_gO4qaQWatBCcJ74Q2pQJk4tgqStGbnZdoQ03f8NK2kDj89XqqS1l21pHS9H68ePX_95l75RlZgLz0gQilofcbojuFUlItyS5P57L77Gn11VCVetWTPSflt5-GnYQp0RmxobjgceWHshXjgxyGO_Wu7jzHEwQhjBynY2tLu4qHSKJnxOcwXzXS_6iL34XU6m2ymk6fYRL2HjbGxx7zb4Oxz2LaztVNMelBKq3xG6MNBJ9HMdP0AGgNRoNDRQX8TNEQVYFcWbV0ffwFehqRG.Ys3z0g.vevRz-0LV-pdDHatKtlAJ57Dpoo')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1060', 'include': "4 Seething Song\r\n4 Mind's Desire", 'exclude': '1 Plains\r\n1 Swamp\r\n1 Forest\r\n1 Dragonstorm\r\n1 Tendrils of Agony\r\n1 Pyromancer Ascension'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 160.72.30.84, 172.68.132.168 Cf-Ray: 729d2c461c503089-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: views=7; session=.eJx1Ue9PwjAQ_V_6eZLuBxvzm4QIzKDBRSUYs5TuGN3WdradOgj_ux0JkJj48d29e-_u3QFlDShOBAiDbo1qwUEk50ycQQ6ccZlfINNUqjxjtoLceBgGQexGeOQGAfbCIboyaklJDZYF4uYltY3_R5jIipbVF5NaFgXk_WJaipOVG_gO4qaQWatBCcJ74Q2pQJk4tgqStGbnZdoQ03f8NK2kDj89XqqS1l21pHS9H68ePX_95l75RlZgLz0gQilofcbojuFUlItyS5P57L77Gn11VCVetWTPSflt5-GnYQp0RmxobjgceWHshXjgxyGO_Wu7jzHEwQhjBynY2tLu4qHSKJnxOcwXzXS_6iL34XU6m2ymk6fYRL2HjbGxx7zb4Oxz2LaztVNMelBKq3xG6MNBJ9HMdP0AGgNRoNDRQX8TNEQVYFcWbV0ffwFehqRG.Ys3z0g.vevRz-0LV-pdDHatKtlAJ57Dpoo Cf-Connecting-Ip: 160.72.30.84 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 173 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (63.6 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1060
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1060
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 63.6, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('session', '.eJx1Ue9PwjAQ_V_6eZLuBxvzm4QIzKDBRSUYs5TuGN3WdradOgj_ux0JkJj48d29e-_u3QFlDShOBAiDbo1qwUEk50ycQQ6ccZlfINNUqjxjtoLceBgGQexGeOQGAfbCIboyaklJDZYF4uYltY3_R5jIipbVF5NaFgXk_WJaipOVG_gO4qaQWatBCcJ74Q2pQJk4tgqStGbnZdoQ03f8NK2kDj89XqqS1l21pHS9H68ePX_95l75RlZgLz0gQilofcbojuFUlItyS5P57L77Gn11VCVetWTPSflt5-GnYQp0RmxobjgceWHshXjgxyGO_Wu7jzHEwQhjBynY2tLu4qHSKJnxOcwXzXS_6iL34XU6m2ymk6fYRL2HjbGxx7zb4Oxz2LaztVNMelBKq3xG6MNBJ9HMdP0AGgNRoNDRQX8TNEQVYFcWbV0ffwFehqRG.Ys30uQ.Sb3SciUyVCMzxksEmD3sS9zUYJo'), ('views', '19')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1060', 'include': "4 Seething Song\r\n4 Mind's Desire", 'exclude': '1 Plains\r\n1 Swamp\r\n1 Forest\r\n1 Dragonstorm\r\n1 Tendrils of Agony\r\n1 Pyromancer Ascension\r\n1 Nightscape Familiar'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 160.72.30.84, 172.68.133.131 Cf-Ray: 729d31aaf915e46a-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: session=.eJx1Ue9PwjAQ_V_6eZLuBxvzm4QIzKDBRSUYs5TuGN3WdradOgj_ux0JkJj48d29e-_u3QFlDShOBAiDbo1qwUEk50ycQQ6ccZlfINNUqjxjtoLceBgGQexGeOQGAfbCIboyaklJDZYF4uYltY3_R5jIipbVF5NaFgXk_WJaipOVG_gO4qaQWatBCcJ74Q2pQJk4tgqStGbnZdoQ03f8NK2kDj89XqqS1l21pHS9H68ePX_95l75RlZgLz0gQilofcbojuFUlItyS5P57L77Gn11VCVetWTPSflt5-GnYQp0RmxobjgceWHshXjgxyGO_Wu7jzHEwQhjBynY2tLu4qHSKJnxOcwXzXS_6iL34XU6m2ymk6fYRL2HjbGxx7zb4Oxz2LaztVNMelBKq3xG6MNBJ9HMdP0AGgNRoNDRQX8TNEQVYFcWbV0ffwFehqRG.Ys30uQ.Sb3SciUyVCMzxksEmD3sS9zUYJo; views=19 Cf-Connecting-Ip: 160.72.30.84 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 200 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (67.2 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1065
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1065
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 67.2, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('views', '47'), ('session', '.eJx1UV1PwjAU_S99nqQr3Ud9Y0oUIUGiEIIxS2GXUba1S9tFJuG_22GAxMS3nnPvPefe0yNKa9AVlyAture6AQ_xrBLyAjKoRKWyKxRmo3SWCscgnwUhpcyPcOxTikkYoFtHqTa8BNcF8m7-5gr_jwiZ5o0oryalynPIusWMkmcrn_Y9VNlcpY0BLXnVCa95Adoy5hQUb-yOpMZy21UWo6IaliSJZu2gwMta73fJ0h6mRrA4Gdz6rSrAXXpEfLMBYy4YzfpDSwL6EH5Nvh-f5ovkeTzW8oX1Xyl5j908HGqhwaTcheaHAcM0oH3SixiJgpjc6l2OIaYxxh7SsHXU7moCLV6RGiZ4TXZNvMejOKfTbRu3qyoZ7p2Jy7F213ygczjGMb-P3l453S5Q92li26JPD51FU9t2AygBrkGjk4f-Rmi5zsHtLJuyPP0A-aeiXw.YtnPgg.m0MyxcwBzgQpulk9yxHD1ViQy24')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1065', 'include': '4 Weaver of Harmony\r\n1 Doomwake Giant', 'exclude': '1 Hateful Eidolon'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 64.125.252.70, 172.69.22.225 Cf-Ray: 72e7494a99af139a-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; views=47; session=.eJx1UV1PwjAU_S99nqQr3Ud9Y0oUIUGiEIIxS2GXUba1S9tFJuG_22GAxMS3nnPvPefe0yNKa9AVlyAture6AQ_xrBLyAjKoRKWyKxRmo3SWCscgnwUhpcyPcOxTikkYoFtHqTa8BNcF8m7-5gr_jwiZ5o0oryalynPIusWMkmcrn_Y9VNlcpY0BLXnVCa95Adoy5hQUb-yOpMZy21UWo6IaliSJZu2gwMta73fJ0h6mRrA4Gdz6rSrAXXpEfLMBYy4YzfpDSwL6EH5Nvh-f5ovkeTzW8oX1Xyl5j908HGqhwaTcheaHAcM0oH3SixiJgpjc6l2OIaYxxh7SsHXU7moCLV6RGiZ4TXZNvMejOKfTbRu3qyoZ7p2Jy7F213ygczjGMb-P3l453S5Q92li26JPD51FU9t2AygBrkGjk4f-Rmi5zsHtLJuyPP0A-aeiXw.YtnPgg.m0MyxcwBzgQpulk9yxHD1ViQy24 Cf-Connecting-Ip: 64.125.252.70 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 88 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (93.7 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1065
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1065
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 93.7, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('views', '47'), ('session', '.eJx1UV1PwjAU_S99nqQr3Ud9Y0oUIUGiEIIxS2GXUba1S9tFJuG_22GAxMS3nnPvPefe0yNKa9AVlyAture6AQ_xrBLyAjKoRKWyKxRmo3SWCscgnwUhpcyPcOxTikkYoFtHqTa8BNcF8m7-5gr_jwiZ5o0oryalynPIusWMkmcrn_Y9VNlcpY0BLXnVCa95Adoy5hQUb-yOpMZy21UWo6IaliSJZu2gwMta73fJ0h6mRrA4Gdz6rSrAXXpEfLMBYy4YzfpDSwL6EH5Nvh-f5ovkeTzW8oX1Xyl5j908HGqhwaTcheaHAcM0oH3SixiJgpjc6l2OIaYxxh7SsHXU7moCLV6RGiZ4TXZNvMejOKfTbRu3qyoZ7p2Jy7F213ygczjGMb-P3l453S5Q92li26JPD51FU9t2AygBrkGjk4f-Rmi5zsHtLJuyPP0A-aeiXw.YtnPgg.m0MyxcwBzgQpulk9yxHD1ViQy24')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1065', 'include': '4 Weaver of Harmony\r\n1 Doomwake Giant', 'exclude': '1 Hateful Eidolon'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 64.125.252.70, 172.69.22.223 Cf-Ray: 72e7525bfdfd13a6-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.114 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; views=47; session=.eJx1UV1PwjAU_S99nqQr3Ud9Y0oUIUGiEIIxS2GXUba1S9tFJuG_22GAxMS3nnPvPefe0yNKa9AVlyAture6AQ_xrBLyAjKoRKWyKxRmo3SWCscgnwUhpcyPcOxTikkYoFtHqTa8BNcF8m7-5gr_jwiZ5o0oryalynPIusWMkmcrn_Y9VNlcpY0BLXnVCa95Adoy5hQUb-yOpMZy21UWo6IaliSJZu2gwMta73fJ0h6mRrA4Gdz6rSrAXXpEfLMBYy4YzfpDSwL6EH5Nvh-f5ovkeTzW8oX1Xyl5j908HGqhwaTcheaHAcM0oH3SixiJgpjc6l2OIaYxxh7SsHXU7moCLV6RGiZ4TXZNvMejOKfTbRu3qyoZ7p2Jy7F213ygczjGMb-P3l453S5Q92li26JPD51FU9t2AygBrkGjk4f-Rmi5zsHtLJuyPP0A-aeiXw.YtnPgg.m0MyxcwBzgQpulk9yxHD1ViQy24 Cf-Connecting-Ip: 64.125.252.70 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 88 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (64.6 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1068
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1068
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 64.6, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '187480'), ('views', '1145'), ('session', '.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YuBu9g.BPWylbwWWq3WK2mDumIkMiXhZ40')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1068', 'include': "3 Dwynen's Elite\r\n4 Elvish Archdruid", 'exclude': '1 Umbral Mantle'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 160.72.30.84, 172.69.22.57 Cf-Ray: 7310adf58e746834-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=187480; views=1145; session=.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YuBu9g.BPWylbwWWq3WK2mDumIkMiXhZ40 Cf-Connecting-Ip: 160.72.30.84 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 85 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (72.7 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 514
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 514
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 72.7, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '187480'), ('views', '1158'), ('session', '.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YuBv3g.SUA0R2G8D9mZDdQ1c690xhvb-U8')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '514', 'include': "3 Walk the Aeons\r\n2 Karn's Temporal Sundering", 'exclude': ''} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 160.72.30.84, 172.69.22.229 Cf-Ray: 7310b6fa7f57683e-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=187480; views=1158; session=.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YuBv3g.SUA0R2G8D9mZDdQ1c690xhvb-U8 Cf-Connecting-Ip: 160.72.30.84 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 78 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (62.5 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1073
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1073
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 62.5, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', ''), ('views', '1871'), ('session', '.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YuhyNA.R1Ye48IPAu6Q2gA2WOfmsqqACz4')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1073', 'include': '4 Animate Dead\r\n3 Faithful Mending\r\n4 Champion of Wits', 'exclude': ''} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 160.72.30.84, 172.69.22.131 Cf-Ray: 7342c207df5330d1-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=; views=1871; session=.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YuhyNA.R1Ye48IPAu6Q2gA2WOfmsqqACz4 Cf-Connecting-Ip: 160.72.30.84 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 92 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (105.6 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1072
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1072
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 105.6, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', ''), ('session', '.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.Yuhzkw.3Gkw2HcagQoskGyr3-gT3OhTbN8'), ('views', '1897')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1072', 'include': '4 Wall of Omens\r\n2 Dawn of Hope\r\n15 Plains', 'exclude': '1 Island\r\n1 Swamp\r\n1 Mountain\r\n1 Forest\r\n4 Revitalize'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 160.72.30.84, 172.69.22.57 Cf-Ray: 7342ca6fca68c361-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=; session=.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.Yuhzkw.3Gkw2HcagQoskGyr3-gT3OhTbN8; views=1897 Cf-Connecting-Ip: 160.72.30.84 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 149 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (80.6 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1072
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1072
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 80.6, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', ''), ('views', '1906'), ('session', '.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.Yuhz2g.anEL0TtUImWyQsm6aZVVjagmIe0')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1072', 'include': '4 Wall of Omens\r\n2 Dawn of Hope\r\n15 Plains', 'exclude': '1 Island\r\n1 Swamp\r\n1 Mountain\r\n1 Forest\r\n4 Revitalize'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 160.72.30.84, 172.69.22.57 Cf-Ray: 7342cc1c7feec361-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: ".Not/A)Brand";v="99", "Google Chrome";v="103", "Chromium";v="103" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=; views=1906; session=.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.Yuhz2g.anEL0TtUImWyQsm6aZVVjagmIe0 Cf-Connecting-Ip: 160.72.30.84 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 149 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (81.6 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 729
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 729
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 81.6, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '190211'), ('cf_use_ob', '0'), ('views', '2953'), ('session', '.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YvRAyQ.Mbp6zFP-vwogT2mYqF2lCoaRGaQ')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '729', 'include': '2 Tendrils of Agony\r\n1 Mountain\r\n1 Island', 'exclude': "2 Hazoret's Undying Fury\r\n3 Dragonstorm\r\n3 Jeskai Ascendancy\r\n4 Warp World\r\n1 Plains\r\n1 Forest\r\n1 Silence\r\n1 Orim's Chant\r\n1 Teyo, the Shieldmage\r\n1 Invoke Calamity\r\n4 Polymorph\r\n"} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 64.125.252.70, 172.69.22.45 Cf-Ray: 738c8cef1bcac386-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=190211; cf_use_ob=0; views=2953; session=.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YvRAyQ.Mbp6zFP-vwogT2mYqF2lCoaRGaQ Cf-Connecting-Ip: 64.125.252.70 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 303 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (61.7 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1086
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1086
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 61.7, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '191525'), ('page_size', '500'), ('session', '.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.Ywj7Tg.2TUMOsUODP_HMxvXyAVXLVSFDC4'), ('views', '4776')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1086', 'include': '4 Smallpox\r\n4 Shrieking Affliction', 'exclude': '1 Doom Foretold\r\n1 Smokestack\r\n1 Death Cloud'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 160.72.30.84, 172.69.22.211 Cf-Ray: 740e1ac01c75dbc6-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Chromium";v="104", " Not A;Brand";v="99", "Google Chrome";v="104" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; deck_id=191525; page_size=500; session=.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.Ywj7Tg.2TUMOsUODP_HMxvXyAVXLVSFDC4; views=4776 Cf-Connecting-Ip: 160.72.30.84 Cf-Ipcountry: US Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 120 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (67.9 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1019
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1019
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 67.9, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('deck_id', '191985'), ('page_size', '20'), ('views', '5364'), ('session', '.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YxiXXw.VRQ-zUsYu82LULO1CkX6yazxUHs')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1019', 'include': '4 Hateful Eidolon\r\n3 Aphemia, the Cacophony', 'exclude': "4 Enchantress's Presence"} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 82.3.190.140, 172.69.22.211 Cf-Ray: 746faad03a897755-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="105", "Not)A;Brand";v="8", "Chromium";v="105" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; deck_id=191985; page_size=20; views=5364; session=.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YxiXXw.VRQ-zUsYu82LULO1CkX6yazxUHs Priority: u=1 Cf-Connecting-Ip: 82.3.190.140 Cf-Ipcountry: GB Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 103 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (72.9 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1095
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1095
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 72.9, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '195150'), ('views', '6875'), ('session', '.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YzAjRg.u7-i9BCRhldCNq4dCV0mB_TSWkk')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1095', 'include': '4 Recurring Nightmare\r\n3 Woodfall Primus', 'exclude': '2 Yosei, the Morning Star'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2a01:cb18:b2f:1d00:c4a:bbb6:693a:b331, 172.69.22.149 Cf-Ray: 7502d4771fde99bc-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="105", "Not)A;Brand";v="8", "Chromium";v="105" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=195150; views=6875; session=.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YzAjRg.u7-i9BCRhldCNq4dCV0mB_TSWkk Priority: u=1 Cf-Connecting-Ip: 2a01:cb18:b2f:1d00:c4a:bbb6:693a:b331 Cf-Ipcountry: FR Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 101 Connection: Keep-Alive ```

Labels: decksite

vorpal-buildbot commented 2 years ago

Exceeded slow_query limit (61.3 > 60.0) in mysql: ```INSERT INTO _applied_rules (deck_id, rule_id, archetype_id, archetype_name) 

    WITH rule_card_count AS
    (
        SELECT
            rule.id, COUNT(card) AS card_count
        FROM
            rule
        JOIN
            rule_card
        ON
            rule.id = rule_card.rule_id
        WHERE
            rule_card.include AND rule.id = 1095
        GROUP BY
            rule.id
    ),
    candidates AS
    (
        SELECT
            deck.id AS deck_id,
            COUNT(DISTINCT REPLACE(deck_card.card, 'Snow-Covered ', '')) AS included_count,
            MAX(rule_card_count.card_count) AS required_count,-- fake MAX due to aggregate function
            rule.id AS rule_id
        FROM
            deck
        JOIN
            deck_card
        ON
            deck.id = deck_card.deck_id
        JOIN
            (
                SELECT
                    *
                FROM
                    rule_card
                WHERE
                    include
            ) AS inclusions
        ON
            REPLACE(deck_card.card, 'Snow-Covered ', '') = inclusions.card
        JOIN
            rule
        ON
            rule.id = inclusions.rule_id
        JOIN
            rule_card_count
        ON
            rule.id = rule_card_count.id
        WHERE
            NOT deck_card.sideboard AND deck_card.n >= inclusions.n AND TRUE AND rule.id = 1095
        GROUP BY
            deck.id, rule.id
        HAVING
            included_count = required_count
    )
    SELECT
        candidates.deck_id,
        rule.id AS rule_id,
        suggested_archetype.id AS archetype_id,
        suggested_archetype.name AS archetype_name
    FROM
        candidates
    INNER JOIN
        rule
    ON
        candidates.rule_id = rule.id
    JOIN
        archetype AS suggested_archetype
    ON
        rule.archetype_id = suggested_archetype.id
    LEFT JOIN
        (
            SELECT
                *
            FROM
                rule_card
            WHERE
                NOT include
        ) AS exclusions
    ON
        candidates.rule_id = exclusions.rule_id
    LEFT JOIN
        deck_card
    ON
        candidates.deck_id = deck_card.deck_id AND exclusions.card = REPLACE(deck_card.card, 'Snow-Covered ', '') AND deck_card.n >= exclusions.n
    GROUP BY
        candidates.deck_id, rule_id
    HAVING
        COUNT(REPLACE(deck_card.card, 'Snow-Covered ', '')) = 0
```

[] (slow_query, 61.3, mysql)

Reported on decksite by mysql-perf

Location Hash: ed5717d781a584b0b7bb71a2187e0e056dda70ff

Request Data ``` Request Method: POST Path: /api/rule/update? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('deck_id', '195150'), ('cf_use_ob', '0'), ('views', '6881'), ('session', '.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YzAjoQ.CPtOdPYRgrgPWwacmbw0bpM_R94')]) Endpoint: post_rule_update View Args: {} Person: 195644917081440265 Referrer: https://pennydreadfulmagic.com/admin/rules/ Request Data: {'rule_id': '1095', 'include': '4 Recurring Nightmare\r\n3 Woodfall Primus', 'exclude': '2 Yosei, the Morning Star'} Host: pennydreadfulmagic.com Accept-Encoding: gzip X-Forwarded-For: 2a01:cb18:b2f:1d00:c4a:bbb6:693a:b331, 172.69.22.149 Cf-Ray: 7502d6892ca199bc-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="105", "Not)A;Brand";v="8", "Chromium";v="105" Accept: */* Content-Type: application/x-www-form-urlencoded; charset=UTF-8 X-Requested-With: XMLHttpRequest Sec-Ch-Ua-Mobile: ?0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36 Sec-Ch-Ua-Platform: "macOS" Origin: https://pennydreadfulmagic.com Sec-Fetch-Site: same-origin Sec-Fetch-Mode: cors Sec-Fetch-Dest: empty Referer: https://pennydreadfulmagic.com/admin/rules/ Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; deck_id=195150; cf_use_ob=0; views=6881; session=.eJx1UV1PwjAU_S99nqT7YGO8SYzADBpcVIIxS-kuo_toZ9uhg_Df7UgYxsTHc-45PfeeHlFSg6wIB67RWMsGLETSivELSKFilUh7yBQVMk2YYZAdDn3PC-0Aj2zPw44_RFdFKSgpwaiA37zEZvC_hfEka1jZh_yyog5lGaTdmkrwc7DtuRaqdCaSRoHkpOq0G1KA1GFoHII0euckShPdTdw4LoTyP50qlzkt22JJ6fowWT067vrNvuq1KEzg-IgIpaDUBaNbhmOeL_Itjeaz-3Y_2rdURk6xZM9R_mX88F0zCSohpkLbH44cP3R8PHBDH4fuddyV6mNvhLGFJGwNteszZBxEs2oO80U9PazawH54nc7uNtO7p1AHXYYptTbHvJsazVexbWu4c2lqkAvGe4Q-LHR-NNFtZ0ATIBIkOlnob4OayAzMyrwpy9MP1d6odw.YzAjoQ.CPtOdPYRgrgPWwacmbw0bpM_R94 Priority: u=1 Cf-Connecting-Ip: 2a01:cb18:b2f:1d00:c4a:bbb6:693a:b331 Cf-Ipcountry: FR Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Content-Length: 101 Connection: Keep-Alive ```

Labels: decksite