I have problem to load Visitor Log more then 1 Day. If i take one week or more, it’s running out to max. execution time or more then allowed Memory (php error Log). I don’t find a another Report where have a Problem.
My Matomo 3.3.0 running on dedicated virtual Server (Ubuntu) with 4 CPU and archiving cronjob.
I try to give php7 20GB RAM and 900 seconds execution Time. I tuned MySQL with mysqltuner. But all no success.
We have daily ~90k visitors with a lot of not-uniq-URL from a Shop. I think, that is the Problem.
Have everyone suggestion what i can do?