{"action":"created","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/42522","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/42522/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/42522/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/42522/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/42522","id":395016548,"node_id":"MDU6SXNzdWUzOTUwMTY1NDg=","number":42522,"title":"Exceeded slow_query limit (6.2 > 1.0) in mysql: ```SELECT bq.name FROM (","user":{"login":"vorpal-buildbot","id":23072004,"node_id":"MDQ6VXNlcjIzMDcyMDA0","avatar_url":"https://avatars2.githubusercontent.com/u/23072004?v=4","gravatar_id":"","url":"https://api.github.com/users/vorpal-buildbot","html_url":"https://github.com/vorpal-buildbot","followers_url":"https://api.github.com/users/vorpal-buildbot/followers","following_url":"https://api.github.com/users/vorpal-buildbot/following{/other_user}","gists_url":"https://api.github.com/users/vorpal-buildbot/gists{/gist_id}","starred_url":"https://api.github.com/users/vorpal-buildbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vorpal-buildbot/subscriptions","organizations_url":"https://api.github.com/users/vorpal-buildbot/orgs","repos_url":"https://api.github.com/users/vorpal-buildbot/repos","events_url":"https://api.github.com/users/vorpal-buildbot/events{/privacy}","received_events_url":"https://api.github.com/users/vorpal-buildbot/received_events","type":"User","site_admin":false},"labels":[{"id":959173750,"node_id":"MDU6TGFiZWw5NTkxNzM3NTA=","url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/labels/mysql","name":"mysql","color":"d4c5f9","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2018-12-31T18:25:27Z","updated_at":"2018-12-31T18:32:20Z","closed_at":null,"author_association":"NONE","body":"        SELECT\n            `u`.`id` AS `id`, \n        CASE\n        WHEN layout = 'transform' OR layout = 'flip' THEN\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN face_name ELSE '' END SEPARATOR '')\n        WHEN layout = 'meld' THEN\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN face_name ELSE '' END SEPARATOR '')\n        ELSE\n            GROUP_CONCAT(face_name SEPARATOR ' // ' )\n        END\n     AS name, \n        CASE\n        WHEN layout = 'flip' THEN\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN mana_cost ELSE '' END SEPARATOR '')\n        ELSE\n            GROUP_CONCAT(`u`.`mana_cost` SEPARATOR '|')\n        END\n     AS mana_cost, \n        CASE\n        WHEN layout = 'split' OR layout = 'aftermath' THEN\n            SUM(`u`.cmc)\n        WHEN layout = 'meld' THEN\n            SUM(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN cmc ELSE 0 END)\n        ELSE\n            SUM(CASE WHEN `u`.position = 1 THEN `u`.cmc ELSE 0 END)\n        END\n     AS cmc, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`power` ELSE '' END SEPARATOR '') AS `power`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`toughness` ELSE '' END SEPARATOR '') AS `toughness`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`loyalty` ELSE '' END SEPARATOR '') AS `loyalty`, \n        CASE\n        WHEN layout = 'meld' THEN\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN type_line ELSE '' END SEPARATOR '')\n        ELSE\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN type_line ELSE '' END SEPARATOR '')\n        END\n     AS type_line, GROUP_CONCAT(`u`.`oracle_text` SEPARATOR '\n-----\n') AS `oracle_text`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`image_name` ELSE '' END SEPARATOR '') AS `image_name`, SUM(CASE WHEN `u`.position = 1  OR (`u`.position = 2 AND `u`.layout = 'meld') THEN `u`.`hand` ELSE NULL END) AS `hand`, SUM(CASE WHEN `u`.position = 1  OR (`u`.position = 2 AND `u`.layout = 'meld') THEN `u`.`life` ELSE NULL END) AS `life`, SUM(CASE WHEN `u`.position = 1  OR (`u`.position = 2 AND `u`.layout = 'meld') THEN `u`.`starter` ELSE NULL END) AS `starter`, SUM(CASE WHEN `u`.position = 1  OR (`u`.position = 2 AND `u`.layout = 'meld') THEN `u`.`position` ELSE NULL END) AS `position`, SUM(CASE WHEN `u`.position = 1  OR (`u`.position = 2 AND `u`.layout = 'meld') THEN `u`.`card_id` ELSE NULL END) AS `card_id`, `u`.`layout` AS `layout`, legalities, GROUP_CONCAT(face_name SEPARATOR '|') AS names, `u`.`pd_legal` AS `pd_legal`, bugs\n        FROM (\n            SELECT c.id, c.layout, f.mana_cost, f.cmc, f.power, f.toughness, f.loyalty, f.type_line, f.oracle_text, f.image_name, f.hand, f.life, f.starter, f.position, f.card_id, f.name AS face_name,\n                pd_legal,\n                legalities\n            FROM\n                card AS c\n            INNER JOIN\n                face AS f ON c.id = f.card_id\n            LEFT JOIN (\n                SELECT\n                    cl.card_id,\n                    SUM(CASE WHEN cl.format_id = 13 THEN 1 ELSE 0 END) > 0 AS pd_legal,\n                    GROUP_CONCAT(CONCAT(fo.name, ':', cl.legality)) AS legalities\n                FROM\n                    card_legality AS cl\n                LEFT JOIN\n                    format AS fo ON cl.format_id = fo.id\n                GROUP BY\n                    cl.card_id\n            ) AS cl ON cl.card_id = c.id\n            GROUP BY\n                f.id\n            ORDER BY\n                f.card_id, f.position\n        ) AS u\n        LEFT JOIN (\n            SELECT\n                cb.card_id,\n                GROUP_CONCAT(CONCAT(cb.description, '|', cb.classification, '|', cb.last_confirmed, '|', cb.url, '|', cb.from_bug_blog, '|', cb.bannable) SEPARATOR '_SEPARATOR_') AS bugs\n            FROM\n                card_bug AS cb\n            GROUP BY\n                cb.card_id\n        ) AS bugs ON u.id = bugs.card_id\n        WHERE u.id IN (SELECT c.id FROM card AS c INNER JOIN face AS f ON c.id = f.card_id WHERE (1 = 1))\n        GROUP BY u.id\n    ) AS bq WHERE bq.id IN (SELECT card_id FROM card_legality WHERE format_id = 14)```\n\n```[]``` (slow_query, 6.2, mysql)\n\nReported on mysql by mysql-perf\n\nLocation Hash: 3c3430fdb767374f3a0fccf68e5a36409d83f0c1\n"},"comment":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/comments/450678165","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/42522#issuecomment-450678165","issue_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/42522","id":450678165,"node_id":"MDEyOklzc3VlQ29tbWVudDQ1MDY3ODE2NQ==","user":{"login":"vorpal-buildbot","id":23072004,"node_id":"MDQ6VXNlcjIzMDcyMDA0","avatar_url":"https://avatars2.githubusercontent.com/u/23072004?v=4","gravatar_id":"","url":"https://api.github.com/users/vorpal-buildbot","html_url":"https://github.com/vorpal-buildbot","followers_url":"https://api.github.com/users/vorpal-buildbot/followers","following_url":"https://api.github.com/users/vorpal-buildbot/following{/other_user}","gists_url":"https://api.github.com/users/vorpal-buildbot/gists{/gist_id}","starred_url":"https://api.github.com/users/vorpal-buildbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vorpal-buildbot/subscriptions","organizations_url":"https://api.github.com/users/vorpal-buildbot/orgs","repos_url":"https://api.github.com/users/vorpal-buildbot/repos","events_url":"https://api.github.com/users/vorpal-buildbot/events{/privacy}","received_events_url":"https://api.github.com/users/vorpal-buildbot/received_events","type":"User","site_admin":false},"created_at":"2018-12-31T18:32:20Z","updated_at":"2018-12-31T18:32:20Z","author_association":"NONE","body":"Exceeded slow_query limit (6.0 > 1.0) in mysql: ```SELECT bq.name FROM (\n\n        SELECT\n            `u`.`id` AS `id`, \n        CASE\n        WHEN layout = 'transform' OR layout = 'flip' THEN\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN face_name ELSE '' END SEPARATOR '')\n        WHEN layout = 'meld' THEN\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN face_name ELSE '' END SEPARATOR '')\n        ELSE\n            GROUP_CONCAT(face_name SEPARATOR ' // ' )\n        END\n     AS name, \n        CASE\n        WHEN layout = 'flip' THEN\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN mana_cost ELSE '' END SEPARATOR '')\n        ELSE\n            GROUP_CONCAT(`u`.`mana_cost` SEPARATOR '|')\n        END\n     AS mana_cost, \n        CASE\n        WHEN layout = 'split' OR layout = 'aftermath' THEN\n            SUM(`u`.cmc)\n        WHEN layout = 'meld' THEN\n            SUM(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN cmc ELSE 0 END)\n        ELSE\n            SUM(CASE WHEN `u`.position = 1 THEN `u`.cmc ELSE 0 END)\n        END\n     AS cmc, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`power` ELSE '' END SEPARATOR '') AS `power`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`toughness` ELSE '' END SEPARATOR '') AS `toughness`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`loyalty` ELSE '' END SEPARATOR '') AS `loyalty`, \n        CASE\n        WHEN layout = 'meld' THEN\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN type_line ELSE '' END SEPARATOR '')\n        ELSE\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN type_line ELSE '' END SEPARATOR '')\n        END\n     AS type_line, GROUP_CONCAT(`u`.`oracle_text` SEPARATOR '\n-----\n') AS `oracle_text`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`image_name` ELSE '' END SEPARATOR '') AS `image_name`, SUM(CASE WHEN `u`.position = 1  OR (`u`.position = 2 AND `u`.layout = 'meld') THEN `u`.`hand` ELSE NULL END) AS `hand`, SUM(CASE WHEN `u`.position = 1  OR (`u`.position = 2 AND `u`.layout = 'meld') THEN `u`.`life` ELSE NULL END) AS `life`, SUM(CASE WHEN `u`.position = 1  OR (`u`.position = 2 AND `u`.layout = 'meld') THEN `u`.`starter` ELSE NULL END) AS `starter`, SUM(CASE WHEN `u`.position = 1  OR (`u`.position = 2 AND `u`.layout = 'meld') THEN `u`.`position` ELSE NULL END) AS `position`, SUM(CASE WHEN `u`.position = 1  OR (`u`.position = 2 AND `u`.layout = 'meld') THEN `u`.`card_id` ELSE NULL END) AS `card_id`, `u`.`layout` AS `layout`, legalities, GROUP_CONCAT(face_name SEPARATOR '|') AS names, `u`.`pd_legal` AS `pd_legal`, bugs\n        FROM (\n            SELECT c.id, c.layout, f.mana_cost, f.cmc, f.power, f.toughness, f.loyalty, f.type_line, f.oracle_text, f.image_name, f.hand, f.life, f.starter, f.position, f.card_id, f.name AS face_name,\n                pd_legal,\n                legalities\n            FROM\n                card AS c\n            INNER JOIN\n                face AS f ON c.id = f.card_id\n            LEFT JOIN (\n                SELECT\n                    cl.card_id,\n                    SUM(CASE WHEN cl.format_id = 13 THEN 1 ELSE 0 END) > 0 AS pd_legal,\n                    GROUP_CONCAT(CONCAT(fo.name, ':', cl.legality)) AS legalities\n                FROM\n                    card_legality AS cl\n                LEFT JOIN\n                    format AS fo ON cl.format_id = fo.id\n                GROUP BY\n                    cl.card_id\n            ) AS cl ON cl.card_id = c.id\n            GROUP BY\n                f.id\n            ORDER BY\n                f.card_id, f.position\n        ) AS u\n        LEFT JOIN (\n            SELECT\n                cb.card_id,\n                GROUP_CONCAT(CONCAT(cb.description, '|', cb.classification, '|', cb.last_confirmed, '|', cb.url, '|', cb.from_bug_blog, '|', cb.bannable) SEPARATOR '_SEPARATOR_') AS bugs\n            FROM\n                card_bug AS cb\n            GROUP BY\n                cb.card_id\n        ) AS bugs ON u.id = bugs.card_id\n        WHERE u.id IN (SELECT c.id FROM card AS c INNER JOIN face AS f ON c.id = f.card_id WHERE (1 = 1))\n        GROUP BY u.id\n    ) AS bq WHERE bq.id IN (SELECT card_id FROM card_legality WHERE format_id = 20)```\n\n```[]``` (slow_query, 6.0, mysql)\n\nReported on mysql by mysql-perf\n\nLocation Hash: 3c3430fdb767374f3a0fccf68e5a36409d83f0c1\n\n\nLabels: mysql"}}
{"actor":{"display_login":"vorpal-buildbot"}}