Hi All,
My dashboard on Visitor > Visitor Log take forever to load until I got Ops too many data bla bla bla…
any help?
I did increase fastcgi_read_timeout to 300 and it doest not help.
Notes:
I deployed Piwik using NGINX + PHP-FPM and my traffic about 1,3 million visits monthly and about 14 million page views
update:
I think it is a memory leak?
I try to increate php max mem limit to 16GB and still got this
Before was 8GB:
[27-Apr-2017 11:11:59 UTC] PHP Fatal error: Allowed memory size of 8589934592 bytes exhausted (tried to allocate 32 bytes) in /usr/share/nginx/html/piwik/libs/Zend/Db/Statement/Pdo.php on line 228
After set with 16GB:
[27-Apr-2017 11:15:32 UTC] PHP Fatal error: Allowed memory size of 17179869184 bytes exhausted (tried to allocate 97 bytes) in /usr/share/nginx/html/piwik/libs/Zend/Db/Statement/Pdo.php on line 290
Cheers,
Anung