search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (1.1 > 0.5) in mysql: ``` #60992

Open vorpal-buildbot opened 1 year ago

vorpal-buildbot commented 1 year ago 
    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 66.249.75.100 Cf-Ray: 7c6bd8cb3a8a218b-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: text/html,application/xhtml+xml,application/signed-exchange;v=b3,application/xml;q=0.9,*/*;q=0.8 From: googlebot(at)googlebot.com User-Agent: Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) Cf-Connecting-Ip: 66.249.75.100 Cf-Ipcountry: US Cdn-Loop: cloudflare ```
vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: https://www.google.be/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 2a02:1808:86:728a:3835:d83:2277:9e0a Cf-Ray: 7c6bea23ca4283de-BRU X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Sec-Fetch-Site: cross-site Sec-Fetch-Dest: document Accept-Language: en-GB,en;q=0.9 Sec-Fetch-Mode: navigate User-Agent: Mozilla/5.0 (iPhone; CPU iPhone OS 16_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.4 Mobile/15E148 Safari/604.1 Referer: https://www.google.be/ Cf-Connecting-Ip: 2a02:1808:86:728a:3835:d83:2277:9e0a Cf-Ipcountry: BE Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: https://www.google.be/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 2a02:1808:86:728a:3835:d83:2277:9e0a Cf-Ray: 7c6bea2fdfec83de-BRU X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Sec-Fetch-Site: cross-site Sec-Fetch-Dest: document Accept-Language: en-GB,en;q=0.9 Sec-Fetch-Mode: navigate User-Agent: Mozilla/5.0 (iPhone; CPU iPhone OS 16_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.4 Mobile/15E148 Safari/604.1 Referer: https://www.google.be/ Cf-Connecting-Ip: 2a02:1808:86:728a:3835:d83:2277:9e0a Cf-Ipcountry: BE Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: https://www.google.be/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 2a02:1808:86:728a:3835:d83:2277:9e0a Cf-Ray: 7c6bea394fbc83de-BRU X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Sec-Fetch-Site: cross-site Sec-Fetch-Dest: document Accept-Language: en-GB,en;q=0.9 Sec-Fetch-Mode: navigate User-Agent: Mozilla/5.0 (iPhone; CPU iPhone OS 16_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.4 Mobile/15E148 Safari/604.1 Referer: https://www.google.be/ Cf-Connecting-Ip: 2a02:1808:86:728a:3835:d83:2277:9e0a Cf-Ipcountry: BE Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 66.249.75.127 Cf-Ray: 7c6bf194fba6e1ad-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Amp-Cache-Transform: google;v="1..8" Accept: text/html,application/xhtml+xml,application/signed-exchange;v=b3,application/xml;q=0.9,*/*;q=0.8 From: googlebot(at)googlebot.com User-Agent: Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.5672.92 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) If-Modified-Since: Sun, 30 Apr 2023 22:54:36 GMT Cf-Connecting-Ip: 66.249.75.127 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: None Request Data: {} Cache-Control: no-cache Connection: Keep-Alive Pragma: no-cache Accept: */* Accept-Encoding: gzip, deflate From: bingbot(at)microsoft.com Host: s403061797.initial-website.com User-Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/103.0.5060.134 Safari/537.36 ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 136.25.106.188 Cf-Ray: 7c6f9d471e1d1601-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: none Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "macOS" Accept-Language: en-US,en;q=0.9 Cf-Connecting-Ip: 136.25.106.188 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 95.108.213.119 Cf-Ray: 7c70222caeaa37cb-FRA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) From: support@search.yandex.ru Accept: text/html Accept-Language: en, *;q=0.01 Cf-Connecting-Ip: 95.108.213.119 Cf-Ipcountry: RU Cdn-Loop: cloudflare ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: https://www.google.com/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 2001:4860:7:407::fa Cf-Ray: 7c71a4037ee99e35-SIN X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Purpose: prefetch Sec-Purpose: prefetch;anonymous-client-ip 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 Upgrade-Insecure-Requests: 1 Sec-Fetch-Site: none Sec-Fetch-Mode: no-cors Sec-Fetch-Dest: empty Referer: https://www.google.com/ User-Agent: Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Mobile Safari/537.36 Accept-Language: en-US,en;q=0.9 Cf-Connecting-Ip: 2001:4860:7:407::fa Cf-Ipcountry: JP Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: https://www.google.com/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 2400:2200:7f7:e8f4::6057:8ce2 Cf-Ray: 7c71a42aba7a8355-KIX X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?1 Sec-Ch-Ua-Platform: "Android" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Mobile 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: cross-site Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://www.google.com/ Accept-Language: en-US,en;q=0.9 Cf-Connecting-Ip: 2400:2200:7f7:e8f4::6057:8ce2 Cf-Ipcountry: JP Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 66.249.75.98 Cf-Ray: 7c7256516c471419-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: text/html,application/xhtml+xml,application/signed-exchange;v=b3,application/xml;q=0.9,*/*;q=0.8 From: googlebot(at)googlebot.com User-Agent: Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) Cf-Connecting-Ip: 66.249.75.98 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 66.249.75.100 Cf-Ray: 7c7269a319e286e7-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Amp-Cache-Transform: google;v="1..8" Accept: text/html,application/xhtml+xml,application/signed-exchange;v=b3,application/xml;q=0.9,*/*;q=0.8 From: googlebot(at)googlebot.com User-Agent: Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.5672.92 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) If-Modified-Since: Sun, 30 Apr 2023 22:54:36 GMT Cf-Connecting-Ip: 66.249.75.100 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([]) Endpoint: prizes View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 66.249.75.127 Cf-Ray: 7c74c1870a8a1158-ORD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: text/html,application/xhtml+xml,application/signed-exchange;v=b3,application/xml;q=0.9,*/*;q=0.8 From: googlebot(at)googlebot.com User-Agent: Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) Cf-Connecting-Ip: 66.249.75.127 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        d.competition_id,
        c.start_date AS `date`,
        c.name AS competition_name,
        p.mtgo_username
    FROM
        person AS p
    INNER JOIN
        deck AS d ON d.person_id = p.id
    INNER JOIN
        competition AS c ON c.id = d.competition_id
    INNER JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    INNER JOIN (
        SELECT
            d.person_id,
            MIN(c.start_date) AS start_date
        FROM
            deck AS d
        INNER JOIN
            competition AS c ON d.competition_id = c.id
        INNER JOIN
            competition_series AS cs ON cs.id = c.competition_series_id
        INNER JOIN
            deck_match AS dm ON dm.deck_id = d.id
        WHERE
            cs.competition_type_id IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
        GROUP BY
            d.person_id
        HAVING
            COUNT(DISTINCT dm.match_id) >= 5
    ) AS fr ON fr.person_id = p.id AND c.start_date = fr.start_date
    GROUP BY
        d.competition_id, p.id
    ORDER BY
        c.start_date DESC,
        p.mtgo_username
```

[] (slow_query, 1.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 25848f8febfd4cc6251899b1a0528f62c75292dc

Request Data ``` Request Method: GET Path: /admin/prizes/? Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('page_size', '20'), ('session', '.eJx1UVFvgjAY_C99ZoYiVPHNmeh0RjMdzmxZSIUPqEBL2uLmjP99hUVdluyt991d7-v1hMIKZEk5cI0GWtZgIRqXjF9ADCUrRXyFTEVCxiEzE4R9j7iuj3t2H7uu7RAP3RSFiGgBRgX8Llgb4n8L42Fas-Ia8suKGpSmEDdrKsHbYOx2LVTqVIS1Aslp2Wh3NAepfd84BK115oRKU90wy6dsOx0eJrN5vl8Eo9Uwg49sVKvdJmV6ftNrkZvAwQnRKAKlLhhNvxI7yqTzGsjAe3E263Fve8gevAInc_ls_PBZMQkqpKZCTHo-8buEOB1sTg6-0U2pxHb7tm0hCYkZZdcMm1SRG894PJG5GO9klWESL_ePKztYrI4mw5Ramce8obYp1fZp_owlDfkz6-yFiXi3UHtpqI-NAd0DlSDR2UJ_G9RUpmBW5nVRnL8Bj0-oYA.ZF2VkQ.PVNyIpxDj5xaHb0c2oZ_Xh2EmGA'), ('session', '.eJx1UVFvgjAY_C99ZoYiVPHNmeh0RjMdzmxZSIUPqEBL2uLmjP99hUVdluyt991d7-v1hMIKZEk5cI0GWtZgIRqXjF9ADCUrRXyFTEVCxiEzE4R9j7iuj3t2H7uu7RAP3RSFiGgBRgX8Llgb4n8L42Fas-Ia8suKGpSmEDdrKsHbYOx2LVTqVIS1Aslp2Wh3NAepfd84BK115oRKU90wy6dsOx0eJrN5vl8Eo9Uwg49sVKvdJmV6ftNrkZvAwQnRKAKlLhhNvxI7yqTzGsjAe3E263Fve8gevAInc_ls_PBZMQkqpKZCTHo-8buEOB1sTg6-0U2pxHb7tm0hCYkZZdcMm1SRG894PJG5GO9klWESL_ePKztYrI4mw5Ramce8obYp1fZp_owlDfkz6-yFiXi3UHtpqI-NAd0DlSDR2UJ_G9RUpmBW5nVRnL8Bj0-oYA.ZGEnhg.MF2l-IheoMA_iu14XfsWR7Ka2iI'), ('deck_id', '215983'), ('views', '10058')]) Endpoint: prizes View Args: {} Person: 195644917081440265 Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 136.25.106.188 Cf-Ray: 7c752fe52d55cec9-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: none Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Sec-Ch-Ua: "Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "macOS" Accept-Language: en-US,en;q=0.9,es;q=0.8 Cookie: hide_intro=True; page_size=20; session=.eJx1UVFvgjAY_C99ZoYiVPHNmeh0RjMdzmxZSIUPqEBL2uLmjP99hUVdluyt991d7-v1hMIKZEk5cI0GWtZgIRqXjF9ADCUrRXyFTEVCxiEzE4R9j7iuj3t2H7uu7RAP3RSFiGgBRgX8Llgb4n8L42Fas-Ia8suKGpSmEDdrKsHbYOx2LVTqVIS1Aslp2Wh3NAepfd84BK115oRKU90wy6dsOx0eJrN5vl8Eo9Uwg49sVKvdJmV6ftNrkZvAwQnRKAKlLhhNvxI7yqTzGsjAe3E263Fve8gevAInc_ls_PBZMQkqpKZCTHo-8buEOB1sTg6-0U2pxHb7tm0hCYkZZdcMm1SRG894PJG5GO9klWESL_ePKztYrI4mw5Ramce8obYp1fZp_owlDfkz6-yFiXi3UHtpqI-NAd0DlSDR2UJ_G9RUpmBW5nVRnL8Bj0-oYA.ZF2VkQ.PVNyIpxDj5xaHb0c2oZ_Xh2EmGA; deck_id=215983; session=.eJx1UVFvgjAY_C99ZoYiVPHNmeh0RjMdzmxZSIUPqEBL2uLmjP99hUVdluyt991d7-v1hMIKZEk5cI0GWtZgIRqXjF9ADCUrRXyFTEVCxiEzE4R9j7iuj3t2H7uu7RAP3RSFiGgBRgX8Llgb4n8L42Fas-Ia8suKGpSmEDdrKsHbYOx2LVTqVIS1Aslp2Wh3NAepfd84BK115oRKU90wy6dsOx0eJrN5vl8Eo9Uwg49sVKvdJmV6ftNrkZvAwQnRKAKlLhhNvxI7yqTzGsjAe3E263Fve8gevAInc_ls_PBZMQkqpKZCTHo-8buEOB1sTg6-0U2pxHb7tm0hCYkZZdcMm1SRG894PJG5GO9klWESL_ePKztYrI4mw5Ramce8obYp1fZp_owlDfkz6-yFiXi3UHtpqI-NAd0DlSDR2UJ_G9RUpmBW5nVRnL8Bj0-oYA.ZGEnhg.MF2l-IheoMA_iu14XfsWR7Ka2iI; views=10058 Priority: u=0, i Cf-Connecting-Ip: 136.25.106.188 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite