search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (3.3 > 1.0) in mysql: ``` #63290

Open vorpal-buildbot opened 5 months ago

vorpal-buildbot commented 5 months ago 
    CREATE TABLE IF NOT EXISTS _new_season_playability (
        name VARCHAR(190) NOT NULL,
        season_id INT NOT NULL,
        playability DECIMAL(6,5) NOT NULL,
        PRIMARY KEY (name, season_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        scc.name,
        scc.season_id,
        (
            (scc.num_decks_maindeck + scc.num_decks_sideboard_only * 0.2)
                /
            (SELECT COUNT(*) FROM deck_cache WHERE season_id = scc.season_id)
        ) AS playability
    FROM
        _season_card_count AS scc
```

[] (slow_query, 3.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 17e29e8e4f48007920143446e51d75dbd516da32

vorpal-buildbot commented 5 months ago

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

    CREATE TABLE IF NOT EXISTS _new_season_playability (
        name VARCHAR(190) NOT NULL,
        season_id INT NOT NULL,
        playability DECIMAL(6,5) NOT NULL,
        PRIMARY KEY (name, season_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        scc.name,
        scc.season_id,
        (
            (scc.num_decks_maindeck + scc.num_decks_sideboard_only * 0.2)
                /
            (SELECT COUNT(*) FROM deck_cache WHERE season_id = scc.season_id)
        ) AS playability
    FROM
        _season_card_count AS scc
```

[] (slow_query, 2.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 17e29e8e4f48007920143446e51d75dbd516da32

Labels: decksite

vorpal-buildbot commented 5 months ago

Exceeded slow_query limit (2.1 > 2.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_season_playability (
        name VARCHAR(190) NOT NULL,
        season_id INT NOT NULL,
        playability DECIMAL(6,5) NOT NULL,
        PRIMARY KEY (name, season_id),
        FOREIGN KEY (season_id) REFERENCES season (id) ON UPDATE CASCADE ON DELETE CASCADE
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        scc.name,
        scc.season_id,
        (
            (scc.num_decks_maindeck + scc.num_decks_sideboard_only * 0.2)
                /
            (SELECT COUNT(*) FROM deck_cache WHERE season_id = scc.season_id)
        ) AS playability
    FROM
        _season_card_count AS scc
```

[] (slow_query, 2.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 17e29e8e4f48007920143446e51d75dbd516da32

Labels: decksite