@fengzhibin opened this Issue on November 1st 2016

qq 20161101174726

I saw a very slow SQL through show processlist mysql. Seems to be piwik's monthly statistics sql. The execution of more than 19 hours. And our MySQL server only 1G memory.

@mattab commented on November 3rd 2016 Member

This particular query is caused by the Unique Visitors and Unique Users metrics. you can disable it for your Piwik (for all periods) as documented in: http://piwik.org/faq/how-to/faq_113/

This Issue was closed on November 3rd 2016
Powered by GitHub Issue Mirror