{"action":"closed","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/28939","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/28939/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/28939/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/28939/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/28939","id":339831646,"node_id":"MDU6SXNzdWUzMzk4MzE2NDY=","number":28939,"title":"Exceeded slow_query limit (13.3 > 10.0) in mysql: ```","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},{"id":763867617,"node_id":"MDU6TGFiZWw3NjM4Njc2MTc=","url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/labels/wontfix","name":"wontfix","color":"ffffff","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-10T13:00:31Z","updated_at":"2018-09-15T14:30:22Z","closed_at":"2018-09-15T14:30:22Z","author_association":"NONE","body":"        SELECT\n            `u`.`id` AS `id`, `u`.`layout` AS `layout`,\n            `u`.`id` AS face_id, \n        CASE\n        WHEN layout = 'double-faced' 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, GROUP_CONCAT(`u`.`mana_cost` SEPARATOR '|') 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 ELSE '' END SEPARATOR '')\n        ELSE\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN type ELSE '' END SEPARATOR '')\n        END\n     AS type, GROUP_CONCAT(`u`.`text` SEPARATOR '\n-----\n') AS `text`, GROUP_CONCAT(`u`.`search_text` SEPARATOR '\n-----\n') AS `search_text`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`image_name` ELSE '' END SEPARATOR '') AS `image_name`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`hand` ELSE '' END SEPARATOR '') AS `hand`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`life` ELSE '' END SEPARATOR '') AS `life`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`starter` ELSE '' END SEPARATOR '') AS `starter`, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`position` ELSE '' END SEPARATOR '') AS `position`, \n        CASE\n        WHEN layout = 'double-faced' OR layout = 'flip' THEN\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN name_ascii ELSE '' END SEPARATOR '')\n        WHEN layout = 'meld' THEN\n            GROUP_CONCAT(CASE WHEN `u`.position = 1 OR `u`.position = 2 THEN name_ascii ELSE '' END SEPARATOR '')\n        ELSE\n            GROUP_CONCAT(name_ascii SEPARATOR ' // ' )\n        END\n     AS name_ascii, GROUP_CONCAT(CASE WHEN `u`.position = 1 THEN `u`.`card_id` ELSE '' END SEPARATOR '') AS `card_id`,\n            GROUP_CONCAT(face_name SEPARATOR '|') AS names,\n            legalities,\n            pd_legal,\n            bugs\n            FROM (\n                SELECT c.id, c.layout, f.mana_cost, f.cmc, f.power, f.toughness, f.loyalty, f.type, f.text, f.search_text, f.image_name, f.hand, f.life, f.starter, f.position, f.name_ascii, 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 = 34 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    ```\n\n```[]``` (slow_query, 13.3, mysql)\n\nReported on mysql by mysql-perf"}}
{"actor":{"display_login":"stale"}}