Open vorpal-buildbot opened 5 months ago
Exceeded slow_query limit (3.6 > 2.0) in mysql: ```
CREATE TABLE IF NOT EXISTS _new_archetype_playability (
name VARCHAR(190) NOT NULL,
archetype_id INT NOT NULL,
playability DECIMAL(6,5) NOT NULL,
PRIMARY KEY (name, archetype_id),
FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE,
INDEX idx_archetype_id_playability_name (archetype_id, playability, name)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
SELECT
acc.name,
acc.archetype_id,
(
-- num decks playing this card in this archetype
acc.num_decks_maindeck
/
-- num decks in this archetype
ac.num_decks
)
*
(
1.0
-
(
-- num decks playing this card
cc.num_decks_maindeck
/
-- num decks
(SELECT COUNT(*) FROM deck WHERE archetype_id IS NOT NULL)
)
) AS playability
FROM
_archetype_card_count AS acc
INNER JOIN
_archetype_count AS ac ON ac.archetype_id = acc.archetype_id
INNER JOIN
_card_count AS cc ON cc.name = acc.name
```
[]
(slow_query, 3.6, mysql)
Reported on decksite by mysql-perf
Location Hash: b8db8cce70fb39f61a283136160f5d1effcfad48
Labels: decksite
Exceeded slow_query limit (3.8 > 2.0) in mysql: ```
CREATE TABLE IF NOT EXISTS _new_archetype_playability (
name VARCHAR(190) NOT NULL,
archetype_id INT NOT NULL,
playability DECIMAL(6,5) NOT NULL,
PRIMARY KEY (name, archetype_id),
FOREIGN KEY (archetype_id) REFERENCES archetype (id) ON UPDATE CASCADE ON DELETE CASCADE,
INDEX idx_archetype_id_playability_name (archetype_id, playability, name)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AS
SELECT
acc.name,
acc.archetype_id,
(
-- num decks playing this card in this archetype
acc.num_decks_maindeck
/
-- num decks in this archetype
ac.num_decks
)
*
(
1.0
-
(
-- num decks playing this card
cc.num_decks_maindeck
/
-- num decks
(SELECT COUNT(*) FROM deck WHERE archetype_id IS NOT NULL)
)
) AS playability
FROM
_archetype_card_count AS acc
INNER JOIN
_archetype_count AS ac ON ac.archetype_id = acc.archetype_id
INNER JOIN
_card_count AS cc ON cc.name = acc.name
```
[]
(slow_query, 3.8, mysql)
Reported on decksite by mysql-perf
Location Hash: b8db8cce70fb39f61a283136160f5d1effcfad48
Labels: decksite
[]
(slow_query, 10.6, mysql)Reported on decksite by mysql-perf
Location Hash: b8db8cce70fb39f61a283136160f5d1effcfad48