search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (146.0 > 60.0) in mysql: ``` #59631

Open vorpal-buildbot opened 1 year ago

vorpal-buildbot commented 1 year ago 
    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 146.0, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (128.2 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 128.2, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (129.2 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 129.2, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (135.4 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 135.4, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (157.1 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 157.1, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (169.2 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 169.2, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (136.6 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 136.6, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (213.6 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 213.6, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (132.8 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 132.8, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (151.1 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 151.1, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (173.6 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 173.6, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (147.1 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 147.1, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (122.3 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 122.3, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (111.3 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 111.3, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (138.7 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 138.7, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (129.1 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 129.1, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (122.2 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 122.2, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (123.3 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 123.3, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (120.6 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 120.6, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (117.8 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 117.8, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (117.4 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 117.4, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (148.1 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 148.1, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (124.8 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 124.8, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (191.2 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 191.2, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (150.4 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 150.4, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (129.8 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 129.8, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (116.8 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 116.8, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (117.7 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 117.7, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (125.1 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 125.1, mysql)

Reported on decksite by mysql-perf

Location Hash: e38607f09ae7f226e843aaabb73e09e8b8c9eda8

Labels: decksite