{"action":"created","issue":{"url":"https://api.github.com/repos/zestedesavoir/zds-site/issues/2085","labels_url":"https://api.github.com/repos/zestedesavoir/zds-site/issues/2085/labels{/name}","comments_url":"https://api.github.com/repos/zestedesavoir/zds-site/issues/2085/comments","events_url":"https://api.github.com/repos/zestedesavoir/zds-site/issues/2085/events","html_url":"https://github.com/zestedesavoir/zds-site/issues/2085","id":54811071,"number":2085,"title":"Slow queries : requêtes sans limites !","user":{"login":"SpaceFox","id":5786268,"avatar_url":"https://avatars.githubusercontent.com/u/5786268?v=3","gravatar_id":"","url":"https://api.github.com/users/SpaceFox","html_url":"https://github.com/SpaceFox","followers_url":"https://api.github.com/users/SpaceFox/followers","following_url":"https://api.github.com/users/SpaceFox/following{/other_user}","gists_url":"https://api.github.com/users/SpaceFox/gists{/gist_id}","starred_url":"https://api.github.com/users/SpaceFox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SpaceFox/subscriptions","organizations_url":"https://api.github.com/users/SpaceFox/orgs","repos_url":"https://api.github.com/users/SpaceFox/repos","events_url":"https://api.github.com/users/SpaceFox/events{/privacy}","received_events_url":"https://api.github.com/users/SpaceFox/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/zestedesavoir/zds-site/labels/Back","name":"Back","color":"207de5"},{"url":"https://api.github.com/repos/zestedesavoir/zds-site/labels/BUG","name":"BUG","color":"e11d21"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-19T20:54:28Z","updated_at":"2015-01-19T21:14:45Z","closed_at":null,"body":"Je fais une passe sur le slow-query-log de prod. Contrairement à ce que son nom indique, ce log stocke aussi les requêtes qui nécessitent des tables temporaires.\r\n\r\nIl y a pas mal de monde puisque depuis ce matin environ 03h, j'ai déjà 7462 entrées dans ce log...\r\n\r\nQu'est-ce qu'on y trouve ?\r\n\r\nUne requête qui récupère **tous** les MP sans aucun critère de sélection !\r\n\r\nElle n'est pas lancée très souvent, mais c'est une garantie de péter à plus ou moins moyen terme.\r\n\r\n```\r\nSELECT \r\n    `mp_privatetopic`.`id`,\r\n    `mp_privatetopic`.`title`,\r\n    `mp_privatetopic`.`subtitle`,\r\n    `mp_privatetopic`.`author_id`,\r\n    `mp_privatetopic`.`last_message_id`,\r\n    `mp_privatetopic`.`pubdate`\r\nFROM\r\n    `mp_privatetopic`;\r\n```"},"comment":{"url":"https://api.github.com/repos/zestedesavoir/zds-site/issues/comments/70562001","html_url":"https://github.com/zestedesavoir/zds-site/issues/2085#issuecomment-70562001","issue_url":"https://api.github.com/repos/zestedesavoir/zds-site/issues/2085","id":70562001,"user":{"login":"SpaceFox","id":5786268,"avatar_url":"https://avatars.githubusercontent.com/u/5786268?v=3","gravatar_id":"","url":"https://api.github.com/users/SpaceFox","html_url":"https://github.com/SpaceFox","followers_url":"https://api.github.com/users/SpaceFox/followers","following_url":"https://api.github.com/users/SpaceFox/following{/other_user}","gists_url":"https://api.github.com/users/SpaceFox/gists{/gist_id}","starred_url":"https://api.github.com/users/SpaceFox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SpaceFox/subscriptions","organizations_url":"https://api.github.com/users/SpaceFox/orgs","repos_url":"https://api.github.com/users/SpaceFox/repos","events_url":"https://api.github.com/users/SpaceFox/events{/privacy}","received_events_url":"https://api.github.com/users/SpaceFox/received_events","type":"User","site_admin":false},"created_at":"2015-01-19T21:14:45Z","updated_at":"2015-01-19T21:14:45Z","body":"Exactement !"}}