{"action":"created","issue":{"url":"https://api.github.com/repos/PowerDNS/pdns/issues/2709","labels_url":"https://api.github.com/repos/PowerDNS/pdns/issues/2709/labels{/name}","comments_url":"https://api.github.com/repos/PowerDNS/pdns/issues/2709/comments","events_url":"https://api.github.com/repos/PowerDNS/pdns/issues/2709/events","html_url":"https://github.com/PowerDNS/pdns/issues/2709","id":103466481,"number":2709,"title":"MySQL backend performance with stored procedures","user":{"login":"rage4","id":7872189,"avatar_url":"https://avatars.githubusercontent.com/u/7872189?v=3","gravatar_id":"","url":"https://api.github.com/users/rage4","html_url":"https://github.com/rage4","followers_url":"https://api.github.com/users/rage4/followers","following_url":"https://api.github.com/users/rage4/following{/other_user}","gists_url":"https://api.github.com/users/rage4/gists{/gist_id}","starred_url":"https://api.github.com/users/rage4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rage4/subscriptions","organizations_url":"https://api.github.com/users/rage4/orgs","repos_url":"https://api.github.com/users/rage4/repos","events_url":"https://api.github.com/users/rage4/events{/privacy}","received_events_url":"https://api.github.com/users/rage4/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2015-08-27T09:24:54Z","updated_at":"2015-08-27T11:40:09Z","closed_at":null,"body":"We have noticed strange issue related to MySQL backend performance when using stored procedures. \r\n\r\nTest setup:\r\n1. specify default query for \"gmysql-any-id-query-auth\" \r\n(SELECT content, ttl, prio, type, domain_id, name, auth FROM records WHERE name = '%s' AND domain_id = %d) and run dnsperf \r\n2. wrap the query from step 1 with simple stored procedure and run dnsperf\r\nResults: dnsperf results from .1 will be around 10 times better than .2\r\n\r\nPowerDNS Auth 3.3.1 on Ubuntu 12.04 LTS x64 with Percona 5.1 \r\n\r\nCheers\r\nPeter"},"comment":{"url":"https://api.github.com/repos/PowerDNS/pdns/issues/comments/135395640","html_url":"https://github.com/PowerDNS/pdns/issues/2709#issuecomment-135395640","issue_url":"https://api.github.com/repos/PowerDNS/pdns/issues/2709","id":135395640,"user":{"login":"rage4","id":7872189,"avatar_url":"https://avatars.githubusercontent.com/u/7872189?v=3","gravatar_id":"","url":"https://api.github.com/users/rage4","html_url":"https://github.com/rage4","followers_url":"https://api.github.com/users/rage4/followers","following_url":"https://api.github.com/users/rage4/following{/other_user}","gists_url":"https://api.github.com/users/rage4/gists{/gist_id}","starred_url":"https://api.github.com/users/rage4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rage4/subscriptions","organizations_url":"https://api.github.com/users/rage4/orgs","repos_url":"https://api.github.com/users/rage4/repos","events_url":"https://api.github.com/users/rage4/events{/privacy}","received_events_url":"https://api.github.com/users/rage4/received_events","type":"User","site_admin":false},"created_at":"2015-08-27T11:40:09Z","updated_at":"2015-08-27T11:40:09Z","body":"See the results from test with stored procedure above, the pdns crashes when trying to query"}}