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

Comments

Projects
None yet
2 participants
@luohui8891

luohui8891 commented Oct 15, 2018

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

This comment has been minimized.

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

This comment has been minimized.

luohui8891 commented Nov 14, 2018

Sure.

@luohui8891 luohui8891 closed this Nov 14, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment