search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (5.7 > 0.5) in mysql: ``` #61080

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, 5.7, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.4 > 0.5) 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, 5.4, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.5 > 0.5) 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, 5.5, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.4 > 0.5) 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, 5.4, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.4 > 0.5) 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, 5.4, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.7 > 0.5) 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, 5.7, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.4 > 0.5) 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, 5.4, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.4 > 0.5) 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, 5.4, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (9.2 > 0.5) 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, 9.2, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.6 > 0.5) 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, 5.6, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.5 > 0.5) 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, 5.5, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.5 > 0.5) 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, 5.5, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.6 > 0.5) 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, 5.6, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.3 > 0.5) 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, 5.3, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.6 > 0.5) 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, 5.6, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.4 > 0.5) 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, 5.4, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.5 > 0.5) 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, 5.5, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.5 > 0.5) 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, 5.5, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.3 > 0.5) 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, 5.3, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.4 > 0.5) 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, 5.4, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (7.2 > 0.5) 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, 7.2, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.3 > 0.5) 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, 5.3, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (5.3 > 0.5) 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, 5.3, mysql)

Reported on decksite by mysql-perf

Location Hash: bed7c4d111e96757b450f2025d38dc1f657fa4bd

Labels: decksite