-
-
Notifications
You must be signed in to change notification settings - Fork 2.7k
Closed
Description
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?
Metadata
Metadata
Assignees
Labels
No labels