search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (3.6 > 1.0) in mysql: ``` #63293

Open vorpal-buildbot opened 5 months ago

vorpal-buildbot commented 5 months ago 
    CREATE TABLE IF NOT EXISTS _new_playability (
        name VARCHAR(190) NOT NULL,
        playability DECIMAL(6,5) NOT NULL,
        PRIMARY KEY (name)
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        lc.name,
        SUM((IFNULL(scc.num_decks_maindeck, 0) + IFNULL(scc.num_decks_sideboard_only, 0) * 0.2)) / SUM(sc.num_decks) AS playability
    FROM
        _legal_cards AS lc
    LEFT JOIN
        _season_card_count AS scc ON lc.season_id = scc.season_id AND lc.name = scc.name
    INNER JOIN
        _season_count AS sc ON lc.season_id = sc.season_id
    GROUP BY
        lc.name;
```

[] (slow_query, 3.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 903bcf34ddb37361cf9ac81c2f603954c526604c

vorpal-buildbot commented 5 months ago

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

    CREATE TABLE IF NOT EXISTS _new_playability (
        name VARCHAR(190) NOT NULL,
        playability DECIMAL(6,5) NOT NULL,
        PRIMARY KEY (name)
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        lc.name,
        SUM((IFNULL(scc.num_decks_maindeck, 0) + IFNULL(scc.num_decks_sideboard_only, 0) * 0.2)) / SUM(sc.num_decks) AS playability
    FROM
        _legal_cards AS lc
    LEFT JOIN
        _season_card_count AS scc ON lc.season_id = scc.season_id AND lc.name = scc.name
    INNER JOIN
        _season_count AS sc ON lc.season_id = sc.season_id
    GROUP BY
        lc.name;
```

[] (slow_query, 2.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 903bcf34ddb37361cf9ac81c2f603954c526604c

Labels: decksite

vorpal-buildbot commented 5 months ago

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

    CREATE TABLE IF NOT EXISTS _new_playability (
        name VARCHAR(190) NOT NULL,
        playability DECIMAL(6,5) NOT NULL,
        PRIMARY KEY (name)
    ) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
    SELECT
        lc.name,
        SUM((IFNULL(scc.num_decks_maindeck, 0) + IFNULL(scc.num_decks_sideboard_only, 0) * 0.2)) / SUM(sc.num_decks) AS playability
    FROM
        _legal_cards AS lc
    LEFT JOIN
        _season_card_count AS scc ON lc.season_id = scc.season_id AND lc.name = scc.name
    INNER JOIN
        _season_count AS sc ON lc.season_id = sc.season_id
    GROUP BY
        lc.name;
```

[] (slow_query, 2.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 903bcf34ddb37361cf9ac81c2f603954c526604c

Labels: decksite