search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

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

Open vorpal-buildbot opened 1 year ago

vorpal-buildbot commented 1 year ago 
    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 32.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 33.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 33.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 33.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 35.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 33.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 50.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 35.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite

vorpal-buildbot commented 1 year ago

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

    CREATE TABLE IF NOT EXISTS _new_season_archetype_card_count (
        name VARCHAR(190),
        season_id INT,
        archetype_id INT,
        num_decks INT,
        PRIMARY KEY (name, 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
        card AS name,
        season.season_id,
        d.archetype_id,
        COUNT(*) AS num_decks
    FROM
        deck AS d
    INNER JOIN
        deck_card AS dc ON d.id = dc.deck_id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        NOT dc.sideboard
    AND
        d.archetype_id IS NOT NULL
    GROUP BY
        dc.card,
        d.archetype_id,
        season.season_id
    ORDER BY
        NULL
```

[] (slow_query, 34.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 1820c0b8dcdbc237cf1ce036c0021ff3b31575c9

Labels: decksite