{"action":"opened","issue":{"url":"https://api.github.com/repos/piwik/piwik/issues/9769","repository_url":"https://api.github.com/repos/piwik/piwik","labels_url":"https://api.github.com/repos/piwik/piwik/issues/9769/labels{/name}","comments_url":"https://api.github.com/repos/piwik/piwik/issues/9769/comments","events_url":"https://api.github.com/repos/piwik/piwik/issues/9769/events","html_url":"https://github.com/piwik/piwik/issues/9769","id":133275472,"number":9769,"title":"Provide a way to cancel queries running","user":{"login":"gaumondp","id":5972510,"avatar_url":"https://avatars.githubusercontent.com/u/5972510?v=3","gravatar_id":"","url":"https://api.github.com/users/gaumondp","html_url":"https://github.com/gaumondp","followers_url":"https://api.github.com/users/gaumondp/followers","following_url":"https://api.github.com/users/gaumondp/following{/other_user}","gists_url":"https://api.github.com/users/gaumondp/gists{/gist_id}","starred_url":"https://api.github.com/users/gaumondp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gaumondp/subscriptions","organizations_url":"https://api.github.com/users/gaumondp/orgs","repos_url":"https://api.github.com/users/gaumondp/repos","events_url":"https://api.github.com/users/gaumondp/events{/privacy}","received_events_url":"https://api.github.com/users/gaumondp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-02-12T15:55:31Z","updated_at":"2016-02-12T15:55:31Z","closed_at":null,"body":"When switching from a small site report to the All Websites pages, it's possible to make Piwik overload and unresponsive. We should have some kind of \"stop all queries\" / \"panic button\" available.\r\n\r\nUse case : On a small site I had a Date range Jan 2014-November 2015, 10k visits but once done with it clicked on \"All Websites\". Piwik keeps the Date Range (that's expected) but with 80 millions lines in my Piwik DB and just 15 sites, Piwik became unresponsive. I closed the page and login back but it took 3 minutes to finally have something showed (I login to \"today\" by default)."}}