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

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

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

Open vorpal-buildbot opened 1 year ago

vorpal-buildbot commented 1 year ago

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        TRUE
    ORDER BY
        c.start_date DESC,
        c.name

```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: cfbcfc1475010c408f7a0d55488355b4dd3ef501

Request Data

``` Request Method: GET Path: /seasons/all/competitions/?locale=pl Cookies: ImmutableMultiDict([]) Endpoint: seasons.competitions View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 207.46.13.209 Cf-Ray: 7c8aef6f4fa927ab-SEA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: no-cache Pragma: no-cache Accept: */* From: bingbot(at)microsoft.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 Cf-Connecting-Ip: 207.46.13.209 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

vorpal-buildbot commented 1 year ago

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

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        TRUE
    ORDER BY
        c.start_date DESC,
        c.name

```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: cfbcfc1475010c408f7a0d55488355b4dd3ef501

Request Data

``` Request Method: GET Path: /seasons/all/competitions/?locale=pl Cookies: ImmutableMultiDict([]) Endpoint: seasons.competitions View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 157.55.39.210 Cf-Ray: 7c915ed81befec08-SEA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: no-cache Pragma: no-cache Accept: */* From: bingbot(at)microsoft.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 Cf-Connecting-Ip: 157.55.39.210 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        TRUE
    ORDER BY
        c.start_date DESC,
        c.name

```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: cfbcfc1475010c408f7a0d55488355b4dd3ef501

Request Data

``` Request Method: GET Path: /seasons/all/competitions/?locale=pl Cookies: ImmutableMultiDict([]) Endpoint: seasons.competitions View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 52.167.144.172 Cf-Ray: 7caa01b92e751fda-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: no-cache Pragma: no-cache Accept: */* From: bingbot(at)microsoft.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 Cf-Connecting-Ip: 52.167.144.172 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        TRUE
    ORDER BY
        c.start_date DESC,
        c.name

```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: cfbcfc1475010c408f7a0d55488355b4dd3ef501

Request Data

``` Request Method: GET Path: /seasons/all/competitions/?locale=pl Cookies: ImmutableMultiDict([]) Endpoint: seasons.competitions View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 157.55.39.213 Cf-Ray: 7cbf9d9f4ad1eb3b-SEA X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: no-cache Pragma: no-cache Accept: */* From: bingbot(at)microsoft.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 Cf-Connecting-Ip: 157.55.39.213 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        TRUE
    ORDER BY
        c.start_date DESC,
        c.name

```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: cfbcfc1475010c408f7a0d55488355b4dd3ef501

Request Data

``` Request Method: GET Path: /seasons/all/competitions/?locale=pl Cookies: ImmutableMultiDict([]) Endpoint: seasons.competitions View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 40.77.167.115 Cf-Ray: 7cdaa86a980f177e-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: no-cache Pragma: no-cache Accept: */* From: bingbot(at)microsoft.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 Cf-Connecting-Ip: 40.77.167.115 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        TRUE
    ORDER BY
        c.start_date DESC,
        c.name

```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: cfbcfc1475010c408f7a0d55488355b4dd3ef501

Request Data

``` Request Method: GET Path: /seasons/all/competitions/?locale=pl Cookies: ImmutableMultiDict([]) Endpoint: seasons.competitions View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 40.77.167.115 Cf-Ray: 7cec9c5f3c55396a-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: no-cache Pragma: no-cache Accept: */* From: bingbot(at)microsoft.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 Cf-Connecting-Ip: 40.77.167.115 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        TRUE
    ORDER BY
        c.start_date DESC,
        c.name

```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: cfbcfc1475010c408f7a0d55488355b4dd3ef501

Request Data

``` Request Method: GET Path: /seasons/all/competitions/?locale=pl Cookies: ImmutableMultiDict([]) Endpoint: seasons.competitions View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 40.77.167.115 Cf-Ray: 7cf530c19f4b82ea-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: no-cache Pragma: no-cache Accept: */* From: bingbot(at)microsoft.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 Cf-Connecting-Ip: 40.77.167.115 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        TRUE
    ORDER BY
        c.start_date DESC,
        c.name

```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: cfbcfc1475010c408f7a0d55488355b4dd3ef501

Request Data

``` Request Method: GET Path: /seasons/all/competitions/?locale=pl Cookies: ImmutableMultiDict([]) Endpoint: seasons.competitions View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 40.77.167.189 Cf-Ray: 7d08d33a5cea1ff4-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: no-cache Pragma: no-cache Accept: */* From: bingbot(at)microsoft.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 Cdn-Loop: cloudflare Cf-Connecting-Ip: 40.77.167.189 Cf-Ipcountry: US ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        TRUE
    ORDER BY
        c.start_date DESC,
        c.name

```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: cfbcfc1475010c408f7a0d55488355b4dd3ef501

Request Data

``` Request Method: GET Path: /seasons/all/competitions/?locale=pl Cookies: ImmutableMultiDict([]) Endpoint: seasons.competitions View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 52.167.144.46 Cf-Ray: 7d14c41708ff0801-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: no-cache Pragma: no-cache Accept: */* From: bingbot(at)microsoft.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 Cdn-Loop: cloudflare Cf-Connecting-Ip: 52.167.144.46 Cf-Ipcountry: US ```

Labels: Search Engine; decksite

vorpal-buildbot commented 1 year ago

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

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        TRUE
    ORDER BY
        c.start_date DESC,
        c.name

```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: cfbcfc1475010c408f7a0d55488355b4dd3ef501

Request Data

``` Request Method: GET Path: /seasons/all/competitions/?locale=pl Cookies: ImmutableMultiDict([]) Endpoint: seasons.competitions View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 40.77.167.164 Cf-Ray: 7d31cc896b363b83-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Cache-Control: no-cache Pragma: no-cache Accept: */* From: bingbot(at)microsoft.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 Cdn-Loop: cloudflare Cf-Connecting-Ip: 40.77.167.164 Cf-Ipcountry: US ```

Labels: Search Engine; decksite