search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

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

Open vorpal-buildbot opened 1 year ago

vorpal-buildbot commented 1 year ago 
    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.6, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.6, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.9, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.8, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.9, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 2.3, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_count (
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (season_id, archetype_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE,
        FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        d.archetype_id IS NOT NULL
    GROUP BY
        season.season_id,
        d.archetype_id
```

[] (slow_query, 0.7, mysql)

Reported on decksite by mysql-perf

Location Hash: cf5f11c687282d6ff8fb33974237a85ec8bd90ee

Labels: decksite