Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Different delete_logs_older_than value for log tables #13610

Closed
luohui8891 opened this issue Oct 15, 2018 · 2 comments
Closed

Different delete_logs_older_than value for log tables #13610

luohui8891 opened this issue Oct 15, 2018 · 2 comments

Comments

@luohui8891
Copy link

Hi guys,
I set up 3.5.1 in my server and collect data for almost 60k+ sites.
I also set delete_logs_older_than to 35 days because we need monthly unique visitors.
But the database is still very big. It also effect query and backup.
So I need slim the database.
I fount that the biggest table is relationship table log_link_visit_action. There are almost 750+ million records in this table. (35 days data)

Because the monthly unique visitors is only need monthly data of log_visit, so can I just keep the 35 values for log_visit table and setup another value (like 5 days) for others?

@mattab
Copy link
Member

mattab commented Nov 13, 2018

Hi @luohui8891
We recommend to contact the professional support team @ http://matomo.org/support/ for getting the best possible help with your very high traffic instance. Thanks,

@luohui8891
Copy link
Author

Sure.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants