Hello everyone, this is my first post, so please be kind.
I’ve been using Piwik for about two months now, to track usage on a single website (wow, piwik is amazing did you know that?). Anyway, things are running smoothly and without problems, but I did notice something interesting.
While testing the performance of my site, I discovered that page loads with disabled cache are timed at 12 seconds! Debugging further, I found out that the entire home page loads in 2 seconds and and extra 10 seconds just for piwik’s URL to load. That is quite a considerable amount of time to spend on loading piwik!
I went to look at the server (which runs on a Linode server, CentOS 7) and the server seems to have plenty of ram, lots of disk space and nearly zero cpu usage (90% of my site is pre-cached anyway, very optimized). So that didn’t give me any clues as to what is going on.
Next I looked at the database, which runs on MariaDB, tests show that its fast and responsive to general queries, also MySQLTuner reports that almost everything is optimized (but it wants me to raise the table_open_cache parameter).
In case it helps, the piwik database is a bit over 300MB and it has been running for nearly 2 months.
I’m also using “Piwik Proxy Hide URL”, in case that makes a difference.
So here I am, asking for your help, in case you have any pointers on what I should do next. Any help would be appreciated.
Delete old visitor logs is: Yes
Delete logs older than: 7 days
Delete old archived reports: No
Geolocation set to: GeoIP (Php)
Archive reports when viewed from the browser: Yes
Archive reports at most every X seconds: 150