I have a site that does about 3 million page views per day, and I recently installed Matomo on another server to measure the site’s audience, in order to completely remove google analytics afterwards.
However I realize that although the server is powerful, the ram used does not cease increasing from day to day. The CPU is used at 10% on average and does not increase, but the ram can go from 10% to 50% in 5-6 days. I also realize that when I restart mysql, the ram used drops.
Hello,
No I don’t use it because it seems that my server doesn’t have any trouble accepting/handling requests (in any case there are no errors in particular).
Okay I just installed it and activated it. I set it up for mysql, I filled in 8 workers and 25 requests that are processed in one batch. What do you think of this configuration ?
As your CPU is 6 cores, I would suggest use 6 queues…
If you have multiple CPUs available on your server you can add more workers. You can do this by going in the Piwik Admin interface to “Plugin Settings”. There will be a setting “Number of queue workers”. Increase this number to the number of CPUs you want to dedeciate for processing requests.
[From Queued Tracking plugin FAQ]
25 requests seems OK
Tell us (and mention myself) in a couple of day if yhe MySQL RAM is changing or not…
Unfortunately the RAM keeps growing, 20% at the time I installed the Queued plugin, currently at 37% of the used RAM. Would you have another suggestion?
I’m using mariadb:
root@server:~# mysql -V
mysql Ver 15.1 Distrib 10.5.18-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper
I’m not sure I understand the question, but I would tend to say that the database is where the ram is used. I’ll let you judge for yourself via the following screen:
Would it at all be possible for you to test using a MySQL database server temporarily to see if the same issue is present? This is the second report of higher memory usage we’ve received in the last 12 months and in both cases the database server used was MariaDB.
It’s possible that certain queries used by Matomo might trigger a memory related bug that is present in MariaDB, the only way to confirm this is to either:
Switch to using MySQL or
Update to a much newer version of MariaDB and see if the same issue persists
It seems that the RAM has stabilized at 45% of its usage, it doesn’t seem to go beyond that anymore. I’ll keep an eye on it for another 2 weeks to see if it stays stable, I’ll keep you posted.